public string SaveItem()
{
StringBuilder sbQry = new StringBuilder();
clsDB oDB = new clsDB();
try
{
oDB.Connect();
string sMsg = "OK";
sbQry.Append("Select Count(*) From Item Where ItemDesc = '" + ItemDesc + "'");
int iCount = (int)oDB.ExecuteScalar(sbQry.ToString());
sbQry.Length = 0;
//If already exist then update otherwise insert
if (iCount > 0)
{
sMsg = "Item already exist!!";
}
else
{
sbQry.Append("Insert Into Item(ItemDesc) Values('" + ItemDesc + "')");
}
iCount = oDB.ExecuteNonQuery(sbQry.ToString());
return(sMsg);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sbQry = null;
oDB.DisConnect();
oDB = null;
}
}
public int SaveHeader()
{
StringBuilder sbQry = new StringBuilder();
clsDB oDB = new clsDB();
try
{
oDB.Connect();
string sMsg = "OK";
sbQry.Append("Select Count(*) From mHeader Where Id = '" + HeaderId + "'");
int iCount = (int)oDB.ExecuteScalar(sbQry.ToString());
sbQry.Length = 0;
//If already exist then update otherwise insert
if (iCount > 0)
{
sbQry.Append("Update mHeader Set Header1='" + Header1 + "',Header2='" + Header2 + "',Header3='" + Header3 + "',Header4='" + Header4 + "' Where Id = '" + HeaderId + "'");
}
else
{
sbQry.Append("Insert Into mHeader(Id,Header1,Header2,Header3,Header4) Values('" + HeaderId + "','" + Header1 + "','" + Header2 + "','" + Header3 + "','" + Header4 + "')");
}
iCount = oDB.ExecuteNonQuery(sbQry.ToString());
return(iCount);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sbQry = null;
oDB.DisConnect();
oDB = null;
}
}
public int SaveAddress()
{
StringBuilder sbQry = new StringBuilder();
clsDB oDB = new clsDB();
try
{
oDB.Connect();
string sMsg = "OK";
sbQry.Append("Select Count(*) From mAddress Where Id = '" + AddressId + "'");
int iCount = (int)oDB.ExecuteScalar(sbQry.ToString());
sbQry.Length = 0;
//If already exist then update otherwise insert
if (iCount > 0)
{
sbQry.Append("Update mAddress Set Address1='" + Address1 + "',Address2='" + Address2 + "',Address3='" + Address3 + "',Address4='" + Address4 + "' Where Id = '" + AddressId + "'");
}
else
{
sbQry.Append("Insert Into mAddress(Id,Address1,Address2,Address3,Address4) Values('" + AddressId + "','" + Address1 + "','" + Address2 + "','" + Address3 + "','" + Address4 + "')");
}
iCount = oDB.ExecuteNonQuery(sbQry.ToString());
return(iCount);
}
catch (Exception ex)
{
throw ex;
}
finally
{
sbQry = null;
oDB.DisConnect();
oDB = null;
}
}
