FINAL fetching grid view data and converting into xml

November 23, 2021

FINAL fetching grid view data and converting into xml

using DL_PUBLIC;

using ProudMonkey.Common.Controls;

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.IO;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

//private object msgbox;

public partial class Settings_SmsServiceCharge : System.Web.UI.Page

{

ProudMonkey.Common.Controls.MessageBox msgbox;

protected void Page_Init(object sender, EventArgs e)

{

msgbox = new MessageBox()

{

};

this.pnlMsgBox.Controls.Clear();

this.pnlMsgBox.Controls.Add(msgbox);

}

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

FillddlBranch();

btnUpdate.Visible = false;

}

private void FillddlBranch()

{

ddlBranch = FillDropDown.FillddlBranch(ddlBranch);

ddlBranch.SelectedValue = M_Session.GetSession().BranchId.ToString();

ddlBranch.Enabled = M_Session.GetSession().IsMainBranch;

FillddlCenter();

}

private void FillddlCenter()

{

ddlCenter = FillDropDown.FillddlCenter(ddlCenter, Convert.ToInt32(ddlBranch.SelectedValue)).Select();

ddlCenter.Items.RemoveAt(1);

}

protected void ddlBranch_SelectedIndexChanged(object sender, EventArgs e)

{

FillddlCenter();

}

protected void btnView_Click(object sender, EventArgs e)

{

GetShowData();

}

protected void GetShowData()

{

DataTable dt2 = new DataTable();

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "sp_SmsServiceCharge";

cmd.Connection = DL_CCommon.Connection();

cmd.Parameters.AddWithValue("@FLAG", 'S');

cmd.Parameters.AddWithValue("@Branch", ddlBranch.SelectedValue);

cmd.Parameters.AddWithValue("@Center", ddlCenter.SelectedValue);

cmd.Parameters.AddWithValue("@OP_DATE", M_Session.GetSession().OP_Date);

IDataReader dm = cmd.ExecuteReader();

dt2.Load(dm);

cmd.Dispose();

if (dt2.Rows.Count > 0)

{

gvsmscharge.DataSource = dt2;

gvsmscharge.DataBind();

btnUpdate.Visible = true;

}

else

{

gvsmscharge.DataSource = null;

gvsmscharge.DataBind();

gvsmscharge.EmptyDataText = "<center>No Record Found</center>";

btnUpdate.Visible = false;

}

protected void gvLoanInterest_RowDataBound(object sender, GridViewRowEventArgs e)

{

}

protected void btnsave_Click(object sender, EventArgs e)

{

}

protected void btnUpdate_Click(object sender, EventArgs e)

{

UpdateSms();

}

private void UpdateSms()

{

DataTable ds = new DataTable();

try

{

int cnt = 0;

DataTable dt = new DataTable("Temp");

StringWriter sw = new StringWriter();

dt.Rows.Clear();

dt.Columns.Add("MemberNo");

dt.Columns.Add("AccountNo");

dt.Columns.Add("PhoneNo");

dt.Columns.Add("EnrolledDate");

dt.Columns.Add("ExpiryDate");

dt.Columns.Add("Balance");

dt.Columns.Add("Charge");

foreach (GridViewRow row in gvsmscharge.Rows)

{

CheckBox chk = (CheckBox)row.FindControl("chk");

if (chk.Checked)

{

cnt++;

Label MemberNo = (Label)row.FindControl("lblMemberNo");

Label AccountNo = (Label)row.FindControl("MemberId");

Label PhoneNo = (Label)row.FindControl("PhoneNo");

Label EnrolledDate = (Label)row.FindControl("EnrolledDate");

Label ExpiryDate = (Label)row.FindControl("ExpiryDate");

Label Balance = (Label)row.FindControl("Balance");

Label Charge = (Label)row.FindControl("Charge");

//DropDownList ddlaccounttype = row.FindControl("ddlaccounttype") as DropDownList;

var dr = dt.NewRow();

dr["MemberNo"] = MemberNo.Text;

dr["AccountNo"] = AccountNo.Text;

dr["PhoneNo"] = PhoneNo.Text;

dr["EnrolledDate"] = EnrolledDate.Text;

dr["ExpiryDate"] = ExpiryDate.Text;

dr["Balance"] = Balance.Text;

dr["Charge"] = Charge.Text;

dt.Rows.Add(dr);

}

dt.WriteXml(sw);

string xm = sw.ToString();

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "S_PostSmsCharge";

cmd.Connection = DL_CCommon.Connection();

cmd.Parameters.AddWithValue("@XMLDATA", xm);

cmd.Parameters.AddWithValue("@BranchId", ddlBranch.SelectedValue);

cmd.Parameters.AddWithValue("@CenterId", ddlCenter.SelectedValue);

cmd.Parameters.AddWithValue("@UserId", M_Session.GetSession().UserId);

cmd.Parameters.AddWithValue("@Withdrawdate", M_Session.GetSession().OP_Date);

IDataReader dk = cmd.ExecuteReader();

ds.Load(dk);

cmd.Dispose();

if (ds.Rows.Count > 0)

{

if(ds.Rows[0]["status"].ToString() == "1")

{

msgbox.ShowSuccess(ds.Rows[0]["msg"].ToString());

GetShowData();

return;

}

if (ds.Rows[0]["status"].ToString() == "2")

{

msgbox.ShowError(ds.Rows[0]["msg"].ToString());

return;

}

//object msg = cmd.Parameters[outparameter.ParameterName].Value;

//string msg1 = Convert.ToString(msg);

}

catch (Exception ex)

{

msgbox.ShowWarning(ex.Message);

}

--------------------

design

<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/Main.Master" CodeFile="SmsServiceCharge.aspx.cs" Inherits="Settings_SmsServiceCharge" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

function SelectAllCheckboxes(spanChk) {

var oItem = spanChk.children;

var theBox = (spanChk.type == "checkbox") ?

spanChk : spanChk.children.item[0];

xState = theBox.checked;

elm = theBox.form.elements;

for (i = 0; i < elm.length; i++)

if (elm[i].type == "checkbox" &&

elm[i].id != theBox.id) {

if (elm[i].checked != xState)

elm[i].click();

}

</script>

$(document).ready(function () {

$('.datePicker').nepaliDatePicker({ changeYear: true });

});

function pageLoad() {

$(".js-example-basic-single").select2({

placeholder: "Select"

});

$('.datePicker').nepaliDatePicker({ changeYear: true });

$('.filter').filter_input({ regex: '[0-9]', events: 'keypress paste' });

}

function printDiv() {

document.getElementById('gvDiv').style.display = "block";

var gridInsideDiv = document.getElementById('gvDiv');

var printWindow = window.open('about:blank', 'Statement', 'left=0,top=0,width=1024,height=768,toolbar=1,scrollbars=1,menubar=1,status=1');

printWindow.document.write(gridInsideDiv.innerHTML);

printWindow.document.close();

printWindow.focus();

printWindow.print();

}

function printToExcel() {

document.getElementById('gvDiv').style.display = "block";

window.open('data:application/vnd.ms-excel,' + encodeURIComponent($('div[id$=gvDiv]').html()));

}

</script>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">

<asp:UpdatePanel ID="updForm" runat="server">

<asp:UpdateProgress ID="updProgress" runat="server" AssociatedUpdatePanelID="updForm">

</div>

Processing...

</div>

</ProgressTemplate>

</asp:UpdateProgress>

<asp:Panel ID="pnlMsgBox" runat="server">

</asp:Panel>

</div>

<ul>

<li>

<label>

Branch *

</label>

<asp:DropDownList ID="ddlBranch" runat="server" AutoPostBack="true" CssClass="js-example-basic-single form-control" OnSelectedIndexChanged="ddlBranch_SelectedIndexChanged">

</asp:DropDownList>

</li>

<li>

<label>

Center *

</label>

<asp:DropDownList ID="ddlCenter" runat="server" CssClass="js-example-basic-single form-control">

</asp:DropDownList>

</li>

<asp:Button ID="Button1" CssClass="button" runat="server" Text="View" ValidationGroup="v"

OnClick="btnView_Click" />

<input type="button" id="Button2" value="Print" class="button" onclick="printDiv();"

visible="false" runat="server" />

<input type="button" id="Button3" value="Export to Excel" class="button"

onclick="printToExcel();" runat="server" visible="false" />

</div>

</ul>

<div>

<asp:Button ID="btnUpdate" CssClass="button" runat="server" Text="Submit" ValidationGroup="v" OnClick="btnUpdate_Click"/>

</div>

<asp:GridView ID="gvsmscharge" runat="server" CssClass="table1" AutoGenerateColumns="false"

HeaderStyle-HorizontalAlign="Center" EmptyDataText="No Record Found"

Width="100%" Font-Size="12px" ShowHeader="true">

<asp:TemplateField HeaderText="" ItemStyle-HorizontalAlign="Center">

<asp:Label ID="lblAll" runat="server" Text="All"></asp:Label>

</HeaderTemplate>

<asp:CheckBox ID="chk" runat="server" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="SN">

<asp:Label ID="lblSn" runat="server" Text='<%#Bind("SN") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="MemberNo">

<asp:Label ID="lblMemberNo" runat="server" Text='<%#Bind("MemberNo") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="AccountNo">

<asp:Label ID="MemberId" runat="server" Text='<%#Bind("AccountNo") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="PhoneNo">

<asp:Label ID="PhoneNo" runat="server" Text='<%#Bind("PhoneNo") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="EnrolledDate">

<asp:Label ID="EnrolledDate" runat="server" Text='<%#Bind("EnrolledDate") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="ExpiryDate">

<asp:Label ID="ExpiryDate" runat="server" Text='<%#Bind("ExpiryDate") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Balance">

<asp:Label ID="Balance" runat="server" Text='<%#Bind("Balance") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Charge">

<asp:Label ID="Charge" runat="server" Text='<%#Bind("Charge") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

</ContentTemplate>

<%--<Triggers>

<asp:PostBackTrigger ControlID="btnView" />

</Triggers>--%>

</asp:UpdatePanel>

</asp:Content>

Search This Blog

Code - Snippet

FINAL fetching grid view data and converting into xml

Comments

Post a Comment

Popular Posts

[Fundamentals of dot net core 1] SERVICES OF DOT NET CORE - CORE SERVICES

Unique things in C# -- new for me(left for implementation at work)