Wednesday, July 28, 2010

Bind the DropDownList On Selected IndexChanged based on the ID


Output :
Bind the DropDownList On Selected IndexChanged based on the ID





Table Design :
MASTERSITE
SELECT SITE_SITEID_ID, SITE_SITECODE_ID, STATE_STATEID_ID,
FROM MASTERSITE

MASTERSTATE
SELECT STATE_STATEID_ID, STATE_STATENAME_NM, STATE_SHORTNAME_CD
FROM MASTERSTATE



Stored Procedure :
Alter Procedure SelectSite
(
@STATE_STATEID_ID int
)
As
Select * from MASTERSITE where STATE_STATEID_ID = @STATE_STATEID_ID



CODE:
Default.aspx

StateName:
SiteCode:
::Select


Default.aspx.cs

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class Default3 : System.Web.UI.Page
{

#region Declare
BOMaster objbomaster;
BLLMaster objbllmaster;
CommonBinding objcmnbinding;
DataSet ds;
#endregion

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bindddl();
// BindGV();
}
}

public void Bindddl()
{
objcmnbinding = new CommonBinding();


ddlState = objcmnbinding.CommonBindingDDL("SelectState", "STATE_STATENAME_NM", "STATE_STATEID_ID", ddlState);

}
//ddlState_SelectedIndexChanged
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
objbomaster = new BOMaster();
objbllmaster = new BLLMaster();
ds = new DataSet();
objbomaster.StateID = Convert.ToInt32(ddlState.SelectedItem.Value);
ds = objbllmaster.SelectSiteCode(objbomaster);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
ddlSiteCode.DataTextField = "SITE_SITEID_ID";
ddlSiteCode.DataValueField = "SITE_SITECODE_ID";
ddlSiteCode.DataSource = ds.Tables[0];
ddlSiteCode.DataBind();
ListItem itm = new ListItem("::Select::", "0");
ddlSiteCode.Items.Insert(0, itm);
//return ddlSiteCode;
}
else
{
ListItem itm = new ListItem("::Select::", "0");
ddlSiteCode.Items.Insert(0, itm);
}

}
catch (Exception ex)
{
lblmsg.ForeColor = System.Drawing.Color.Red;
lblmsg.Text = ex.Message.ToString();
}
}
}


DAL

#region SelectSiteCode
public DataSet SelectSiteCode(object ObjBOClass)
{
try
{
objbomaster = ((BOMaster)(ObjBOClass));
objsqlhelper = new sqlhelper();
objsqlhelper.ClearParameters();
objsqlhelper.CreateParameter("@STATE_STATEID_ID", objbomaster.StateID);
return objsqlhelper.ExecuteQueryWP("SelectSite");
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
#endregion


BLL


#region SelectSiteCode
public DataSet SelectSiteCode(object ObjBOClass)
{
try
{
return (DataSet)new DALMaster().SelectSiteCode(ObjBOClass);
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
#endregion


AppCode/CommonBinding.cs

#region DropDownListBinding
public DropDownList CommonBindingDDL(string SPName, string DataTextField, string DataValueField, DropDownList ddlName)
{
try
{
objbllmaster = new BLLMaster();
ds = new DataSet();
ds = objbllmaster.GetDataFromDatabase(SPName);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
ddlName.DataTextField = DataTextField;
ddlName.DataValueField = DataValueField;
ddlName.DataSource = ds.Tables[0];
ddlName.DataBind();
ListItem itm = new ListItem("::Select::", "0");
ddlName.Items.Insert(0, itm);
return ddlName;
}
else
{
return null;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
#endregion

Saturday, July 17, 2010

Save Xml To Database

Default.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/ADMIN/ADMINMASTER.master" AutoEventWireup="true" CodeFile="XmlToDatabase.aspx.cs" Inherits="ADMIN_XmlToDatabase" %>





XmlToDatabase.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.IO;

using System.Configuration;

using System.Xml;

using System.Xml.XPath;

using System.Xml.Serialization;

using System.Drawing;

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

{

#region Declare

DataSet ds;

BOXml objboxml;

BLLXml objbllxml;

#endregion

protected void Page_Load(object sender, EventArgs e) //btnReader_Click

{

string currentdate = "";

string Previous_Date = "";

if (!IsPostBack)

{

string month = DateTime.Today.Month.ToString();

if (month.Length == 1)

{

month = "0" + month;

}

string date = DateTime.Today.Day.ToString();

if (date.Length == 1)

{

date = "0" + date;

}

currentdate = DateTime.Today.Year.ToString() + month + date;

Previous_Date = DateTime.Now.AddDays(-1).ToShortDateString();

string[] Previous_Date_Values = Previous_Date.Split('/');

string Previous_Date_Year = "";

string Previous_Month = "";

string Previous_Date_Vale = "";

if (Previous_Date_Values[0].Length == 1)

{

Previous_Month = "0" + Previous_Date_Values[0].ToString();

}

else

{

Previous_Month = Previous_Date_Values[0].ToString();

}

if (Previous_Date_Values[1].Length == 1)

{

Previous_Date_Vale = "0" + Previous_Date_Values[1].ToString();

}

else

{

Previous_Date_Vale = Previous_Date_Values[1].ToString();

}

Previous_Date_Year = Previous_Date_Values[2].ToString();

Previous_Date_Vale = Previous_Date_Year + Previous_Month + Previous_Date_Vale;

for (int i = 0; i <= 1; i++)

{

if (Directory.Exists(System.Web.Hosting.HostingEnvironment.MapPath("~/Sapoutbound/ProductMaster/" + currentdate)))

{

string FolderDate = "";

FolderDate = currentdate;

//

}

currentdate = Previous_Date_Vale;

}

}

SaveXmlToDatabase("~/MainFolder/SubFolder1/Sub2/Sub3/Sub4/", currentdate);

// WriteToServer("~/FileServer/SubFolder1", currentdate);

}

public void SaveXmlToDatabase(string filepath, string CurrentDate)

{

try

{

string month = DateTime.Today.Month.ToString();

if (month.Length == 1)

{

month = "0" + month;

}

string date = DateTime.Today.Day.ToString();

if (date.Length == 1)

{

date = "0" + date;

}

string currentdate = DateTime.Today.Year.ToString() + month + date;

FileInfo[] fileInfos = null;

string Location_Filename = "Sitemaster" + currentdate;

int intCount = 0;

DirectoryInfo myDir = new DirectoryInfo(System.Web.Hosting.HostingEnvironment.MapPath(filepath));

fileInfos = myDir.GetFiles();

for (intCount = 0; intCount <= fileInfos.Length - 1; intCount++)

{

string OriginalFilename = fileInfos[intCount].Name.ToString();

string[] OriginalFilenames = OriginalFilename.Split('-');

if (Location_Filename == OriginalFilenames[0])

{

string myXMLfile = Server.MapPath("~/MainFolder/SubFolder1/Sub2/Sub3/Sub4/" + OriginalFilename);

DataSet ds = new DataSet();

System.IO.FileStream fsReadXml = new System.IO.FileStream(myXMLfile, System.IO.FileMode.Open);

ds.ReadXml(fsReadXml);

/////Save From DataSet to FileServer Folder

string myXMLfile2 = Server.MapPath("~/otherMainFolder/othersub1/" + OriginalFilename);

DataSet ds1 = new DataSet();

ds1 = ds;

ds1.WriteXml(myXMLfile2);

SqlConnection conn = new SqlConnection("Data Source=info;Initial Catalog=info;User ID=info;Password=info");

conn.Open();

int RowsCount = ds.Tables[0].Rows.Count;

for (int i = 0; i <= RowsCount - 1; i++)

{

objboxml = new BOXml();

objbllxml = new BLLXml();

objboxml.SITE_SITECODE_ID = ds.Tables[0].Rows[i][0].ToString();

objboxml.SITE_SITENAME_NM = ds.Tables[0].Rows[i][1].ToString();

objboxml.SITE_SITECATEGORY_TYPE = ds.Tables[0].Rows[i][2].ToString();

objboxml.SITE_SITEADDRESS = ds.Tables[0].Rows[i][3].ToString();

objboxml.CITY_CITYNAME_NM = ds.Tables[0].Rows[i][4].ToString();

objboxml.SITE_SITEPINCODE_CD = ds.Tables[0].Rows[i][5].ToString();

objboxml.STATE_STATEID_ID = Convert.ToInt32(ds.Tables[0].Rows[i][6]);

objboxml.SITE_SITECONTACTPERSON_NM = ds.Tables[0].Rows[i][7].ToString();

objboxml.SITE_SITETELEPHONENUMBER_NBR = ds.Tables[0].Rows[i][8].ToString();

objboxml.SITE_SITECREATED_DTTM = DateTime.Now.ToString();

int count = objbllxml.InsertXMLDatabase(objboxml);

fsReadXml.Close();

}

}

}

}

catch (Exception ex)

{

Label1.Text = ex.Message.ToString();

}

}

protected void btnReader_Click(object sender, EventArgs e) //btnReader_Click

{

}

}



BOXml.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace POS.BO.ADMIN

{

public class BOXml

{

private string _SITE_SITECODE_ID;

private string _SITE_SITENAME_NM;

private string _SITE_SITECATEGORY_TYPE;

private string _SITE_SITEADDRESS;

private int _CITY_CITYID_ID;

private string _CITY_CITYNAME_NM;

private string _SITE_SITEPINCODE_CD;

private int _STATE_STATEID_ID;

private string _SITE_SITECONTACTPERSON_NM;

private string _SITE_SITETELEPHONENUMBER_NBR;

private string _SITE_SITECREATED_DTTM;

public string SITE_SITECODE_ID

{

get { return _SITE_SITECODE_ID; }

set { _SITE_SITECODE_ID = value; }

}

public string SITE_SITENAME_NM

{

get { return _SITE_SITENAME_NM; }

set { _SITE_SITENAME_NM = value; }

}

public string SITE_SITECATEGORY_TYPE

{

get { return _SITE_SITECATEGORY_TYPE; }

set { _SITE_SITECATEGORY_TYPE = value; }

}

public string SITE_SITEADDRESS

{

get { return _SITE_SITEADDRESS; }

set { _SITE_SITEADDRESS = value; }

}

public int CITY_CITYID_ID

{

get { return _CITY_CITYID_ID; }

set { _CITY_CITYID_ID = value; }

}

public string SITE_SITEPINCODE_CD

{

get { return _SITE_SITEPINCODE_CD; }

set { _SITE_SITEPINCODE_CD = value; }

}

public int STATE_STATEID_ID

{

get { return _STATE_STATEID_ID; }

set { _STATE_STATEID_ID = value; }

}

public string SITE_SITECONTACTPERSON_NM

{

get { return _SITE_SITECONTACTPERSON_NM; }

set { _SITE_SITECONTACTPERSON_NM = value; }

}

public string SITE_SITETELEPHONENUMBER_NBR

{

get { return _SITE_SITETELEPHONENUMBER_NBR; }

set { _SITE_SITETELEPHONENUMBER_NBR = value; }

}

public string SITE_SITECREATED_DTTM

{

get { return _SITE_SITECREATED_DTTM; }

set { _SITE_SITECREATED_DTTM = value; }

}

public string CITY_CITYNAME_NM

{

get { return _CITY_CITYNAME_NM; }

set { _CITY_CITYNAME_NM = value; }

}

}

}






DALXml.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.SqlClient;

public class DALXml

{

#region Declare

BOXml objboxml;

sqlhelper objsqlhelper;

DataSet ds;

#endregion

#region InsertXMLDatabase

public int InsertXMLDatabase(object ObjBOClass)

{

try

{

objboxml = ((BOXml)(ObjBOClass));

objsqlhelper = new sqlhelper();

objsqlhelper.ClearParameters();

objsqlhelper.CreateParameter("@SITE_SITEID_ID", 0);

objsqlhelper.CreateParameter("@SITE_SITECODE_ID", objboxml.SITE_SITECODE_ID);

objsqlhelper.CreateParameter("@SITE_SITENAME_NM", objboxml.SITE_SITENAME_NM);

objsqlhelper.CreateParameter("@SITE_SITECATEGORY_TYPE", objboxml.SITE_SITECATEGORY_TYPE);

objsqlhelper.CreateParameter("@SITE_SITEADDRESS", objboxml.SITE_SITEADDRESS);

objsqlhelper.CreateParameter("@CITY_CITYNAME_NM", objboxml.CITY_CITYNAME_NM);

objsqlhelper.CreateParameter("@SITE_SITEPINCODE_CD", objboxml.SITE_SITEPINCODE_CD);

objsqlhelper.CreateParameter("@STATE_STATEID_ID", objboxml.STATE_STATEID_ID);

objsqlhelper.CreateParameter("@SITE_SITECONTACTPERSON_NM", objboxml.SITE_SITECONTACTPERSON_NM);

objsqlhelper.CreateParameter("@SITE_SITETELEPHONENUMBER_NBR", objboxml.SITE_SITETELEPHONENUMBER_NBR);

objsqlhelper.CreateParameter("@SITE_SITECREATED_DTTM", objboxml.SITE_SITECREATED_DTTM);

return objsqlhelper.ExecuteNonQuery("HOP_MasterSite");

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

#endregion

}

}




BLLXml.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

public class BLLXml

{

#region InsertXMLDatabase

public int InsertXMLDatabase(object ObjBOClass)

{

try

{

return (int)new DALXml().InsertXMLDatabase(ObjBOClass);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

#endregion

}




Stored Procedures

CREATE TABLE [dbo].[ MASTERSITE_HDR] (

[SITE_SITEID_ID] int IDENTITY(1, 1) NOT NULL,

[SITE_SITECODE_ID] varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SITE_SITENAME_NM] varchar(150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SITE_SITECATEGORY_TYPE] varchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SITE_SITEADDRESS] varchar(150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CITY_CITYNAME_NM] varchar(70) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SITE_SITEPINCODE_CD] varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[STATE_STATEID_ID] int NOT NULL,

[SITE_SITECONTACTPERSON_NM] varchar(70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SITE_SITETELEPHONENUMBER_NBR] varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SITE_SITECREATED_DTTM] datetime NULL,

CONSTRAINT [PK_ MASTERSITE_HDR] PRIMARY KEY CLUSTERED ([SITE_SITEID_ID])

)

ON [PRIMARY]

GO

CREATE procedure MasterSite

(

@SITE_SITEID_ID int,

@SITE_SITECODE_ID varchar(20),

@SITE_SITENAME_NM varchar(150),

@SITE_SITECATEGORY_TYPE varchar(20),

@SITE_SITEADDRESS varchar(150),

@CITY_CITYNAME_NM varchar(70),

@SITE_SITEPINCODE_CD varchar(20),

@STATE_STATEID_ID int,

@SITE_SITECONTACTPERSON_NM varchar(70),

@SITE_SITETELEPHONENUMBER_NBR varchar(20),

@SITE_SITECREATED_DTTM DateTime

)

As

IF EXISTS(SELECT * FROM MasterSite_HDR WHERE SITE_SITECODE_ID=@SITE_SITECODE_ID)

BEGIN

UPDATE MasterSite_HDR SET

SITE_SITECODE_ID = @SITE_SITECODE_ID, SITE_SITENAME_NM = @SITE_SITENAME_NM,

SITE_SITECATEGORY_TYPE = @SITE_SITECATEGORY_TYPE, SITE_SITEADDRESS = @SITE_SITEADDRESS,

CITY_CITYNAME_NM = @CITY_CITYNAME_NM, SITE_SITEPINCODE_CD = @SITE_SITEPINCODE_CD,

STATE_STATEID_ID = @STATE_STATEID_ID, SITE_SITECONTACTPERSON_NM = @SITE_SITECONTACTPERSON_NM,

SITE_SITETELEPHONENUMBER_NBR = @SITE_SITETELEPHONENUMBER_NBR,

SITE_SITECREATED_DTTM = @SITE_SITECREATED_DTTM

WHERE SITE_SITEID_ID = @SITE_SITEID_ID

END

ELSE

BEGIN

Insert Into MasterSite_HDR

(

SITE_SITECODE_ID, SITE_SITENAME_NM, SITE_SITECATEGORY_TYPE, SITE_SITEADDRESS,

CITY_CITYNAME_NM, SITE_SITEPINCODE_CD, STATE_STATEID_ID, SITE_SITECONTACTPERSON_NM,

SITE_SITETELEPHONENUMBER_NBR, SITE_SITECREATED_DTTM

)

Values

(

@SITE_SITECODE_ID, @SITE_SITENAME_NM, @SITE_SITECATEGORY_TYPE, @SITE_SITEADDRESS,

@CITY_CITYNAME_NM, @SITE_SITEPINCODE_CD, @STATE_STATEID_ID,@SITE_SITECONTACTPERSON_NM,

@SITE_SITETELEPHONENUMBER_NBR, @SITE_SITECREATED_DTTM

)

END




CREATE Procedure MasterProgram

(

@PROG_PROGARAMID_ID INT,

@PROG_PROGRAMNAME_NM varchar(300),

@PROG_PROGRAMDESCRIPTION_DESC varchar(300),

@PROG_PROGRAMTYPE_DESC varchar(300),

@PROG_PROGRAMSTARTDATE_DTTM DateTime = null,

@PROG_PROGRAMENDDATE_DTTM DateTime = null,

@PROG_PROGRAMCREATED_DTTM DateTime,

@USER_USERID_ID int,

@TranType varchar(60)

)

As

--declare @PROG_PROGRAMCREATED_DTTM datetime

--set @PROG_PROGRAMCREATED_DTTM = getDate()

IF @TRANTYPE = 'INSERT'

BEGIN

INSERT INTO MASTERPROGRAM_HDR

( PROG_PROGRAMNAME_NM, PROG_PROGRAMDESCRIPTION_DESC, PROG_PROGRAMTYPE_DESC,

PROG_PROGRAMSTARTDATE_DTTM, PROG_PROGRAMENDDATE_DTTM , PROG_PROGRAMCREATED_DTTM,

USER_USERID_ID

) VALUES

(@PROG_PROGRAMNAME_NM,@PROG_PROGRAMDESCRIPTION_DESC,@PROG_PROGRAMTYPE_DESC,

@PROG_PROGRAMSTARTDATE_DTTM, @PROG_PROGRAMENDDATE_DTTM, @PROG_PROGRAMCREATED_DTTM,

@USER_USERID_ID

)

END

IF @TRANTYPE = 'UPDATE'

BEGIN

UPDATE MASTERPROGRAM_HDR SET

PROG_PROGRAMNAME_NM = @PROG_PROGRAMNAME_NM, PROG_PROGRAMDESCRIPTION_DESC = @PROG_PROGRAMDESCRIPTION_DESC,

PROG_PROGRAMTYPE_DESC = @PROG_PROGRAMTYPE_DESC , PROG_PROGRAMSTARTDATE_DTTM = @PROG_PROGRAMSTARTDATE_DTTM,

PROG_PROGRAMENDDATE_DTTM = @PROG_PROGRAMENDDATE_DTTM, PROG_PROGRAMCREATED_DTTM = @PROG_PROGRAMCREATED_DTTM,

USER_USERID_ID = @USER_USERID_ID WHERE PROG_PROGARAMID_ID = @PROG_PROGARAMID_ID

END

IF @TRANTYPE = 'DELETE'

BEGIN

DELETE FROM MASTERPROGRAM_HDR WHERE PROG_PROGARAMID_ID = @PROG_PROGARAMID_ID

END

CREATE Procedure SelectProgram

As

Select * from MASTERPROGRAM_HDR



Wednesday, July 14, 2010

Load XML From Database

#region XMLCreation
public bool XMLCreation()
{
string Site_Name = "";
string Site_Date = "";
string Result = "";
int j = 1;
try
{
objbomaster = new BOFileUpload();
objbllmaster = new BLLFileUpload();
DS = new DataSet();
DSITEM = new DataSet();

objbomaster.Site = Session["Site"].ToString();
objbomaster.DocumentDate = Session["DocumentDate"].ToString();
// DS = objbllmaster.SelectXML(objbomaster);

DSITEM = objbllmaster.SelectCommonXML(objbomaster, "proc_selectXML");
if (DSITEM != null && DSITEM.Tables[0].Rows.Count > 0 && DSITEM.Tables[0].Rows[0][0].ToString() != "0")
{
for (int c = 0; c <>
{

objbomaster = new BOFileUpload();
objbllmaster = new BLLFileUpload();
objbomaster.CommonID = Convert.ToInt32(DSITEM.Tables[0].Rows[c][0]);
DS = objbllmaster.SelectCommonParamXML(objbomaster, "proc_selectXML");


XmlDocument writer = new XmlDocument();
XmlNode declaration = writer.CreateNode(XmlNodeType.XmlDeclaration, null, null);
writer.AppendChild(declaration);

XmlElement CONDOLIDATEDSALES = writer.CreateElement("LocalPurchase");
writer.AppendChild(CONDOLIDATEDSALES);

//Creating the element
XmlElement HEADER = writer.CreateElement("HEADER");
CONDOLIDATEDSALES.AppendChild(HEADER);
XmlElement SITE = writer.CreateElement("SITE");
SITE.InnerText = DS.Tables[0].Rows[0][0].ToString();
Site_Name = DS.Tables[0].Rows[0][0].ToString();
HEADER.AppendChild(SITE);
XmlElement DOCUMENTDATE = writer.CreateElement("DOCUMENTDATE");
DOCUMENTDATE.InnerText = DS.Tables[0].Rows[0][1].ToString();
Site_Date = DS.Tables[0].Rows[0][1].ToString();
HEADER.AppendChild(DOCUMENTDATE);
XmlElement POSGRNREFERENCENUMBER = writer.CreateElement("DOCUMENTNUMBER");
POSGRNREFERENCENUMBER.InnerText = DS.Tables[0].Rows[0][2].ToString();
HEADER.AppendChild(POSGRNREFERENCENUMBER);
XmlElement WAREHOUSENUMBER = writer.CreateElement("VENDORNAME");
WAREHOUSENUMBER.InnerText = DS.Tables[0].Rows[0][3].ToString();
HEADER.AppendChild(WAREHOUSENUMBER);

int RowsCount = DS.Tables[1].Rows.Count;
//Response.Write(RowsCount.ToString());

for (int i = 0; i <= RowsCount - 1; i++)
{
XmlElement ITEMDETAILS = writer.CreateElement("ITEMDETAILS");
CONDOLIDATEDSALES.AppendChild(ITEMDETAILS);
XmlElement ARTICLENUMBER = writer.CreateElement("ARTICLENUMBER");
ARTICLENUMBER.InnerText = DS.Tables[1].Rows[i][0].ToString().Trim();
ITEMDETAILS.AppendChild(ARTICLENUMBER);
XmlElement UNITOFMEASURE = writer.CreateElement("UNITOFMEASURE");
UNITOFMEASURE.InnerText = DS.Tables[1].Rows[i][1].ToString().Trim();
ITEMDETAILS.AppendChild(UNITOFMEASURE);
XmlElement INVOICEDQUANTITY = writer.CreateElement("AWACS_ITEMCODE");
INVOICEDQUANTITY.InnerText = DS.Tables[1].Rows[i][2].ToString().Trim();
ITEMDETAILS.AppendChild(INVOICEDQUANTITY);
XmlElement SALESVALUE = writer.CreateElement("INVOICEQUANTITY");
SALESVALUE.InnerText = DS.Tables[1].Rows[i][3].ToString().Trim();
ITEMDETAILS.AppendChild(SALESVALUE);
XmlElement TYPEOFCONDITION = writer.CreateElement("DELIVEREDQUANTITY");
TYPEOFCONDITION.InnerText = DS.Tables[1].Rows[i][4].ToString().Trim();
ITEMDETAILS.AppendChild(TYPEOFCONDITION);
XmlElement SALESDISCOUNTVALUE = writer.CreateElement("BATCH");
SALESDISCOUNTVALUE.InnerText = DS.Tables[1].Rows[i][5].ToString().Trim();
ITEMDETAILS.AppendChild(SALESDISCOUNTVALUE);
XmlElement TAXCODE = writer.CreateElement("EXPIRYDATE");
TAXCODE.InnerText = DS.Tables[1].Rows[i][6].ToString().Trim();
ITEMDETAILS.AppendChild(TAXCODE);
}
string Site_Folder_Path = Server.MapPath("~/FileServer/IB" + "/" + Site_Date).ToString();
if (Directory.Exists(Site_Folder_Path))
{
}
else
{
DirectoryInfo DI = Directory.CreateDirectory(Site_Folder_Path);
}
string Date_Folder_Path = Server.MapPath("~/FileServer/IB" + "/" + Site_Date + "/" + Site_Name).ToString();
if (Directory.Exists(Date_Folder_Path))
{
}
else
{
DirectoryInfo DI = Directory.CreateDirectory(Date_Folder_Path);
}
//string Consolidate_File_Path = Server.MapPath("~/FileServer/IB" + "/" + Site_Date + "/" + Site_Name + "/" + "eSales.xml").ToString();
//if (Directory.Exists(Consolidate_File_Path))
//{
//}
//else
//{
// DirectoryInfo DI = Directory.CreateDirectory(Consolidate_File_Path);
//}
writer.Save(Server.MapPath("~/FileServer/IB" + "/" + Site_Date + "/" + Site_Name + "/" + "PURCHASES_" + " " + j + ".xml"));
j++;
int retval = objbllmaster.CommonParamDeleteFile(objbomaster, "POS_GRAgainstLocalPurchases_FILEDELETE");
if (retval > 0)
{

}

}
return true;
}
else
{
return false;
}


}
catch (Exception ex)
{

// throw new Exception(ex.Message);
return false;

}
}
#endregion

Save XML File Datas To Database

Save XML File Datas To Database

XmlToDatabase. aspx

<asp:Content ID="Content1" ContentPlaceHolderID="cphheader" Runat="Server">

asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="cphcontent" Runat="Server">

<asp:Button ID="btnReader" runat="server" Text="Read" OnClick="btnReader_Click"/>

<asp:GridView ID="GridView1" runat="server">asp:GridView>

<asp:Xml ID="Xml1" runat="server">asp:Xml>

<asp:Label id="Label1" runat="server">asp:Label>

asp:Content>




XmlToDatabase. aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.IO;

using System.Configuration;

using System.Xml;

using System.Xml.XPath;

using System.Xml.Serialization;

using System.Drawing;

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

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnReader_Click(object sender, EventArgs e)

{

try

{

string myXMLfile = Server.MapPath("~/web.xml");

DataSet ds = new DataSet();

System.IO.FileStream fsReadXml = new System.IO.FileStream(myXMLfile, System.IO.FileMode.Open);

ds.ReadXml(fsReadXml);


GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();

SqlConnection conn = new SqlConnection("Data Source=info;Initial Catalog=info;User ID=info;Password=info");

int RowsCount = ds.Tables[0].Rows.Count;

for (int i = 0; i <= RowsCount -1 ; i++)

{

conn.Open();

SqlCommand cmd = new SqlCommand("SP_Name", conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@CODE_ID", ds.Tables[0].Rows[i][0].ToString());

cmd.Parameters.AddWithValue("@NAME_NM", ds.Tables[0].Rows[i][1].ToString());

// cmd.Parameters.AddWithValue("@SKU", ds.Tables[0].Rows[0][3].ToString());

cmd.Parameters.AddWithValue("@CATEGORY", ds.Tables[0].Rows[0][2].ToString());

cmd.Parameters.AddWithValue("@ADDRESS", ds.Tables[0].Rows[i][3].ToString());

cmd.Parameters.AddWithValue("@CITYID", "14");

cmd.Parameters.AddWithValue("@PINCODE", ds.Tables[0].Rows[i][5].ToString()); //@Item_GenericShortCode_cd

cmd.Parameters.AddWithValue("@STATEID", ds.Tables[0].Rows[i][6].ToString());

cmd.Parameters.AddWithValue("@CONTACTPERSON", ds.Tables[0].Rows[i][7].ToString());

cmd.Parameters.AddWithValue("@TELEPHONENUMBER", ds.Tables[0].Rows[i][8].ToString());

cmd.Parameters.AddWithValue("@SITECREATED", DateTime.Now);

cmd.ExecuteNonQuery();

conn.Close();

}

fsReadXml.Close();

}

catch (Exception ex)

{

Response.Write(ex.ToString());

}

finally

{

}

}



Stored Procedure

Alter procedure Site

(

@SITEID int,

@CODE varchar(300),

@NAME varchar(300),

@SITE_SITECATEGORY_TYPE varchar(300),

@ADDRESS varchar(300),

@ CITYID int,

@SITE_SITEPINCODE_CD varchar(300),

@STATEID int,

@CONTACTPERSON varchar(300),

@TELEPHONENUMBERvarchar(300),

@SITE_SITECREATED_DTTM DateTime

)

As

IF EXISTS(SELECT * FROM

Site WHERE

CODE_ID=@CODE_ID)

BEGIN

UPDATE Site

CODE_ID =CODE_ID, NAME = @NAME,

CATEGORY_TYPE = @CATEGORY_TYPE,ADDRESS = @ADDRESS,

CITYID = @CITYID, PINCODE = @SITEPINCODE,

STATEID = @STATEID,CONTACTPERSON = @CONTACTPERSON,

TELEPHONENUMBER = @TELEPHONENUMBER,

CREATED_DTTM = @CREATED_DTTM

WHERE SITEID_ID = @SITEID_ID

END

ELSE

BEGIN

Insert Into Site

(

CODE, NAME, CATEGORY, ADDRESS,

CITYID,PINCODE,STATEID,CONTACTPERSON,

TELEPHONENUMBER, CREATED_DTTM

)

Values

(

@CODE, @NAME_NM, @CATEGORY, @ADDRESS,

@CITYID, @PINCODE, @STATEID,@CONTACTPERSON,

@TELEPHONENUMBER, @CREATED_DTTM

)

END