public void UpdateSalesCategory()
{
try
{
SqlCeParameter spDoc = new SqlCeParameter();
spDoc.ParameterName = "@DocumentId";
spDoc.SqlDbType = System.Data.SqlDbType.NVarChar;
spDoc.Value = DocumentId;
SqlCeParameter spCategoryname = new SqlCeParameter();
spCategoryname.ParameterName = "@CATEGORYNAME";
spCategoryname.SqlDbType = System.Data.SqlDbType.NVarChar;
spCategoryname.Value = CategoryName;
string _read = "UPDATE TBL_SALESCATEGORY SET ConRead='True' WHERE DOCUMENTID=@DOCUMENTID and CATEGORYNAME=@CATEGORYNAME";
CeDataCon.ConString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
CeDataCon.CmdType = CommandType.Text;
CeDataCon.CmdString = _read;
CeDataCon.InsertRecord(spDoc, spCategoryname);
}
catch (Exception ex)
{
throw;
}
}
public DataTable InsertCurrency()
{
DataTable dt_curr = null;
try
{
SqlCeParameter spCurrencyID = new SqlCeParameter();
spCurrencyID.ParameterName = "@CurrencyID";
spCurrencyID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCurrencyID.Value = this.CurrencyID;
SqlCeParameter spCurrencyName = new SqlCeParameter();
spCurrencyName.ParameterName = "@CurrencyName";
spCurrencyName.SqlDbType = System.Data.SqlDbType.NVarChar;
spCurrencyName.Value = this.CurrencyName;
SqlCeParameter spCurrRate = new SqlCeParameter();
spCurrRate.ParameterName = "@CurrRate";
spCurrRate.SqlDbType = System.Data.SqlDbType.Decimal;
spCurrRate.Value = this.CurrRate;
string s = "Insert into tbl_Currency_Temp values(@CurrencyID,@CurrencyName,@CurrRate)";
objDb.ConString = Dcon;
objDb.CmdType = CommandType.Text;
objDb.CmdString = s;
objDb.InsertRecord(spCurrencyID, spCurrencyName, spCurrRate);
}
catch (Exception ex)
{
throw;
}
return(dt_curr);
}
public DataTable InsertTerminal_MasterData()
{
DataTable dt_tt = null;
try
{
SqlCeParameter spTerminalID = new SqlCeParameter();
spTerminalID.ParameterName = "@TerminalID";
spTerminalID.SqlDbType = System.Data.SqlDbType.NVarChar;
spTerminalID.Value = this.TerminalID;
SqlCeParameter spLocationID = new SqlCeParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = this.LocationID;
string s = "Insert into tbl_terminal values(@TerminalID,@LocationID)";
objDb.ConString = Dcon;
objDb.CmdType = CommandType.Text;
objDb.CmdString = s;
objDb.InsertRecord(spTerminalID, spLocationID);
}
catch (Exception ex)
{
}
return(dt_tt);
}
public DataTable InsertSubCategory()
{
DataTable dt_subcat = null;
try
{
SqlCeParameter spSubCategoryID = new SqlCeParameter();
spSubCategoryID.ParameterName = "@SubCategoryID";
spSubCategoryID.SqlDbType = System.Data.SqlDbType.NVarChar;
spSubCategoryID.Value = this.SubCategoryID;
SqlCeParameter spCategoryID = new SqlCeParameter();
spCategoryID.ParameterName = "@CategoryID";
spCategoryID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCategoryID.Value = this.CategoryID;
SqlCeParameter spSubCategoryDesc = new SqlCeParameter();
spSubCategoryDesc.ParameterName = "@SubCategoryDesc";
spSubCategoryDesc.SqlDbType = System.Data.SqlDbType.NVarChar;
spSubCategoryDesc.Value = this.SubCategoryDesc;
string s = "insert into tbl_SubCategory_Temp values(@SubCategoryID,@SubCategoryDesc,@CategoryID)";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spSubCategoryID, spSubCategoryDesc, spCategoryID);
}
catch (Exception ex)
{
throw;
}
return dt_subcat;
}
public DataTable InsertPreferUOM()
{
DataTable dt_prefer = null;
try
{
SqlCeParameter spMaterialID = new SqlCeParameter();
spMaterialID.ParameterName = "@MaterialID";
spMaterialID.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialID.Value = this.MaterialID;
SqlCeParameter spEAN13 = new SqlCeParameter();
spEAN13.ParameterName = "@EAN13";
spEAN13.SqlDbType = System.Data.SqlDbType.NVarChar;
spEAN13.Value = this.EAN13;
SqlCeParameter spUOM = new SqlCeParameter();
spUOM.ParameterName = "@UOM";
spUOM.SqlDbType = System.Data.SqlDbType.NVarChar;
spUOM.Value = this.UOM;
string s = "insert into tbl_PreferUOM_Temp values(@MaterialID,@EAN13,@UOM)";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spMaterialID, spEAN13, spUOM);
}
catch (Exception ex)
{
throw;
}
return(dt_prefer);
}
public DataTable InsertCity_MasterData()
{
DataTable dt_city = null;
try
{
SqlCeParameter spCityID = new SqlCeParameter();
spCityID.ParameterName = "@CityID";
spCityID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCityID.Value = this.CityID;
SqlCeParameter spCityName = new SqlCeParameter();
spCityName.ParameterName = "@CityName";
spCityName.SqlDbType = System.Data.SqlDbType.NVarChar;
spCityName.Value = this.CityName;
string s = "insert into tbl_city values(@CityID,@CityName)";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spCityID, spCityName);
}
catch (Exception ex)
{
}
return(dt_city);
}
public DataTable InsertUom_MasterData()
{
DataTable dt = null;
try
{
SqlCeParameter spUOM = new SqlCeParameter();
spUOM.ParameterName = "@UOM";
spUOM.SqlDbType = System.Data.SqlDbType.NVarChar;
spUOM.Value = this.UOM;
SqlCeParameter spUOMDesc = new SqlCeParameter();
spUOMDesc.ParameterName = "@UOMDesc";
spUOMDesc.SqlDbType = System.Data.SqlDbType.NVarChar;
spUOMDesc.Value = this.UOMDesc;
string s = "insert tbl_uom values(@UOM,@UOMDesc)";
objDb.ConString = Dcon;
objDb.CmdType = CommandType.Text;
objDb.CmdString = s;
objDb.InsertRecord(spUOM, spUOMDesc);
}
catch (Exception ex)
{
}
return(dt);
}
public DataTable InsertMaterialEAN()
{
DataTable dt_material = null;
try
{
SqlCeParameter spEAN13 = new SqlCeParameter();
spEAN13.ParameterName = "@EAN13";
spEAN13.SqlDbType = System.Data.SqlDbType.NVarChar;
spEAN13.Value = this.EAN13;
SqlCeParameter spMaterialID = new SqlCeParameter();
spMaterialID.ParameterName = "@MaterialID";
spMaterialID.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialID.Value = this.MaterialID;
SqlCeParameter spUom = new SqlCeParameter();
spUom.ParameterName = "@Uom";
spUom.SqlDbType = System.Data.SqlDbType.NVarChar;
spUom.Value = this.Uom;
SqlCeParameter spConvertvalue = new SqlCeParameter();
spConvertvalue.ParameterName = "@ConvertValue";
spConvertvalue.SqlDbType = System.Data.SqlDbType.Decimal;
spConvertvalue.Value = this.ConvertValue;
SqlCeParameter spBaseUom = new SqlCeParameter();
spBaseUom.ParameterName = "@BaseUom";
spBaseUom.SqlDbType = System.Data.SqlDbType.NVarChar;
spBaseUom.Value = this.BaseUom;
SqlCeParameter spMaterialMix = new SqlCeParameter();
spMaterialMix.ParameterName = "@MaterialMix";
spMaterialMix.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialMix.Value = this.MaterialMix;
string s = "INSERT INTO TBL_MATERIALEAN_TEMP VALUES(@EAN13,@MATERIALID,@UOM,@CONVERTVALUE,@BASEUOM,@MATERIALMIX)";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spEAN13, spMaterialID, spUom, spConvertvalue, spBaseUom, spMaterialMix);
}
catch (Exception ex)
{
throw;
}
return(dt_material);
}
public void UpdateReadEod()
{
try
{
using (TransactionScope objsco = new TransactionScope())
{
SqlCeParameter spEod = new SqlCeParameter();
spEod.ParameterName = "@EodId";
spEod.SqlDbType = System.Data.SqlDbType.NVarChar;
spEod.Value = EODID;
string _read = "UPDATE TBL_EOD SET ConRead='True' WHERE EODID=@EODID";
dcon.ConString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
dcon.CmdType = CommandType.Text;
dcon.CmdString = _read;
dcon.InsertRecord(spEod);
objsco.Complete();
}
}
catch (Exception ex)
{
}
}
public DataTable InsertLocationPrice()
{
DataTable dt_locationPrice = null;
try
{
SqlCeParameter spLocationID = new SqlCeParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = this.LocationID;
SqlCeParameter spEAN13 = new SqlCeParameter();
spEAN13.ParameterName = "@EAN13";
spEAN13.SqlDbType = System.Data.SqlDbType.NVarChar;
spEAN13.Value = this.EAN13;
SqlCeParameter spMaterialID = new SqlCeParameter();
spMaterialID.ParameterName = "@MaterialID";
spMaterialID.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialID.Value = this.MaterialID;
SqlCeParameter spUOM = new SqlCeParameter();
spUOM.ParameterName = "@UOM";
spUOM.SqlDbType = System.Data.SqlDbType.NVarChar;
spUOM.Value = this.UOM;
SqlCeParameter spPrice = new SqlCeParameter();
spPrice.ParameterName = "@Price";
spPrice.SqlDbType = System.Data.SqlDbType.Decimal;
spPrice.Value = this.Price;
string s = "INSERT INTO TBL_LOCATIONPRICE_TEMP VALUES(@LOCATIONID,@EAN13,@MATERIALID,@UOM,@PRICE)";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spLocationID, spEAN13, spMaterialID, spUOM, spPrice);
}
catch (Exception ex)
{
throw;
}
return(dt_locationPrice);
}
public void UpdateReadSalesdtls()
{
try
{
SqlCeParameter spDoc = new SqlCeParameter();
spDoc.ParameterName = "@DocumentId";
spDoc.SqlDbType = System.Data.SqlDbType.NVarChar;
spDoc.Value = DocumentID;
string _read = "UPDATE TBL_SALES_DETAIL SET ConRead='True' WHERE DOCUMENTID=@DOCUMENTID";
objDcon.ConString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
objDcon.CmdType = CommandType.Text;
objDcon.CmdString = _read;
objDcon.InsertRecord(spDoc);
}
catch (Exception ex)
{
}
}
public DataTable InsertTender_MasterData()
{
DataTable dt_tender = null;
try
{
SqlCeParameter spTenderID = new SqlCeParameter();
spTenderID.ParameterName = "@TenderID";
spTenderID.SqlDbType = System.Data.SqlDbType.NVarChar;
spTenderID.Value = this.TenderID;
SqlCeParameter spTenderName = new SqlCeParameter();
spTenderName.ParameterName = "@TenderName";
spTenderName.SqlDbType = System.Data.SqlDbType.NVarChar;
spTenderName.Value = this.TenderName;
SqlCeParameter spGL_Debit = new SqlCeParameter();
spGL_Debit.ParameterName = "@GL_Debit";
spGL_Debit.SqlDbType = System.Data.SqlDbType.NVarChar;
spGL_Debit.Value = this.GL_Debit;
SqlCeParameter spGL_Credit = new SqlCeParameter();
spGL_Credit.ParameterName = "@GL_Credit";
spGL_Credit.SqlDbType = System.Data.SqlDbType.NVarChar;
spGL_Credit.Value = this.GL_Credit;
string s = "insert into tbl_tender values(@TenderID,@TenderName,@GL_Debit,@GL_Credit)";
objDb.ConString = Dcon;
objDb.CmdType = CommandType.Text;
objDb.CmdString = s;
objDb.InsertRecord(spTenderID, spTenderName, spGL_Debit, spGL_Credit);
}
catch (Exception ex)
{
}
return(dt_tender);
}
public DataTable InsertStorage_MasterData()
{
DataTable dt_storage = null;
try
{
SqlCeParameter spStorageID = new SqlCeParameter();
spStorageID.ParameterName = "@StorageID";
spStorageID.SqlDbType = System.Data.SqlDbType.NVarChar;
spStorageID.Value = this.StorageID;
SqlCeParameter spStorageName = new SqlCeParameter();
spStorageName.ParameterName = "@StorageName";
spStorageName.SqlDbType = System.Data.SqlDbType.NVarChar;
spStorageName.Value = this.StorageName;
SqlCeParameter spStorageType = new SqlCeParameter();
spStorageType.ParameterName = "@StorageType";
spStorageType.SqlDbType = System.Data.SqlDbType.NVarChar;
spStorageType.Value = this.StorageType;
SqlCeParameter spLocationID = new SqlCeParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = this.LocationID;
string s = "insert into tbl_storage values(@StorageID,@StorageName,@StorageType,@LocationID)";
objDb.ConString = Dcon;
objDb.CmdType = CommandType.Text;
objDb.CmdString = s;
objDb.InsertRecord(spStorageID, spStorageName, spStorageType, spLocationID);
}
catch (Exception ex)
{
}
return(dt_storage);
}
public void UpdateMasterSyncDate()
{
try
{
string s = "update tbl_Default set MasterSyncDate=@NewMasterSyncDate";
SqlCeParameter spNewMasteSyncDate = new SqlCeParameter();
spNewMasteSyncDate.ParameterName = "@NewMasterSyncDate";
spNewMasteSyncDate.SqlDbType = System.Data.SqlDbType.NVarChar;
spNewMasteSyncDate.Value = this.NewMasterSyncDate;
objDB.ConString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spNewMasteSyncDate);
}
catch (Exception ex)
{
}
}
public DataTable InsertMaterial()
{
DataTable dt_material = null;
try
{
SqlCeParameter spMaterialID = new SqlCeParameter();
spMaterialID.ParameterName = "@MaterialID";
spMaterialID.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialID.Value = this.MaterialID;
SqlCeParameter spMaterialDesc1 = new SqlCeParameter();
spMaterialDesc1.ParameterName = "@MaterialDesc1";
spMaterialDesc1.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialDesc1.Value = this.MaterialDesc1;
SqlCeParameter spMaterialDesc2 = new SqlCeParameter();
spMaterialDesc2.ParameterName = "@MaterialDesc2";
spMaterialDesc2.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialDesc2.Value = this.MaterialDesc2;
SqlCeParameter spMaterialDesc3 = new SqlCeParameter();
spMaterialDesc3.ParameterName = "@MaterialDesc3";
spMaterialDesc3.SqlDbType = System.Data.SqlDbType.NVarChar;
spMaterialDesc3.Value = this.MaterialDesc3;
SqlCeParameter spProductURL = new SqlCeParameter();
spProductURL.ParameterName = "@ProductURL";
spProductURL.SqlDbType = System.Data.SqlDbType.NVarChar;
spProductURL.Value = this.ProductURL;
SqlCeParameter spCategoryID = new SqlCeParameter();
spCategoryID.ParameterName = "@CategoryID";
spCategoryID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCategoryID.Value = this.CategoryID;
SqlCeParameter spUserID = new SqlCeParameter();
spUserID.ParameterName = "@UserID";
spUserID.SqlDbType = System.Data.SqlDbType.NVarChar;
spUserID.Value = this.UserID;
SqlCeParameter spSubCategoryID = new SqlCeParameter();
spSubCategoryID.ParameterName = "@SubCategoryID";
spSubCategoryID.SqlDbType = System.Data.SqlDbType.NVarChar;
spSubCategoryID.Value = this.SubCategoryID;
SqlCeParameter spBaseUOM = new SqlCeParameter();
spBaseUOM.ParameterName = "@BaseUOM";
spBaseUOM.SqlDbType = System.Data.SqlDbType.NVarChar;
spBaseUOM.Value = this.BaseUOM;
SqlCeParameter spCost = new SqlCeParameter();
spCost.ParameterName = "@Cost";
spCost.SqlDbType = System.Data.SqlDbType.Decimal;
spCost.Value = this.Cost;
SqlCeParameter spVendorID = new SqlCeParameter();
spVendorID.ParameterName = "@VendorID";
spVendorID.SqlDbType = System.Data.SqlDbType.NVarChar;
spVendorID.Value = this.VendorID;
SqlCeParameter spCustInt1 = new SqlCeParameter();
spCustInt1.ParameterName = "@CustInt1";
spCustInt1.SqlDbType = System.Data.SqlDbType.Int;
spCustInt1.Value = this.CustInt1;
SqlCeParameter spCustInt2 = new SqlCeParameter();
spCustInt2.ParameterName = "@CustInt2";
spCustInt2.SqlDbType = System.Data.SqlDbType.Int;
spCustInt2.Value = this.CustInt2;
SqlCeParameter spCustInt3 = new SqlCeParameter();
spCustInt3.ParameterName = "@CustInt3";
spCustInt3.SqlDbType = System.Data.SqlDbType.Int;
spCustInt3.Value = this.CustInt3;
SqlCeParameter spCustDate1 = new SqlCeParameter();
spCustDate1.ParameterName = "@CustDate1";
spCustDate1.SqlDbType = System.Data.SqlDbType.DateTime;
spCustDate1.Value = this.CustDate1;
SqlCeParameter spCustDate2 = new SqlCeParameter();
spCustDate2.ParameterName = "@CustDate2";
spCustDate2.SqlDbType = System.Data.SqlDbType.DateTime;
spCustDate2.Value = this.CustDate2;
SqlCeParameter spCustDate3 = new SqlCeParameter();
spCustDate3.ParameterName = "@CustDate3";
spCustDate3.SqlDbType = System.Data.SqlDbType.DateTime;
spCustDate3.Value = this.CustDate3;
SqlCeParameter spAddDate = new SqlCeParameter();
spAddDate.ParameterName = "@AddDate";
spAddDate.SqlDbType = System.Data.SqlDbType.DateTime;
spAddDate.Value = this.AddDate;
SqlCeParameter spUpdDate = new SqlCeParameter();
spUpdDate.ParameterName = "@UpdDate";
spUpdDate.SqlDbType = System.Data.SqlDbType.DateTime;
spUpdDate.Value = this.UpdDate;
SqlCeParameter spDataid = new SqlCeParameter();
spDataid.ParameterName = "@Dataid";
spDataid.SqlDbType = System.Data.SqlDbType.Int;
spDataid.Value = this.Dataid;
string s = "insert into tbl_material_temp(MaterialID,MaterialDesc1,MaterialDesc2,MaterialDesc3,ProductURL,CategoryID,SubCategoryID,"
+ "BaseUOM,Cost,VendorID,CustInt1,CustInt2,CustInt3,CustDate1,CustDate2,CustDate3,UserID,AddDate,UpdDate,Dataid)"
+ "values(@MaterialID,@MaterialDesc1,@MaterialDesc2,@MaterialDesc3,@ProductURL,@CategoryID,@SubCategoryID,@BaseUOM,@Cost,@VendorID,"
+ " @CustInt1,@CustInt2,@CustInt3,@CustDate1,@CustDate2,@CustDate3,@UserID,@AddDate,@UpdDate,@Dataid)";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spMaterialID, spMaterialDesc1, spMaterialDesc2, spMaterialDesc3, spProductURL, spCategoryID, spSubCategoryID,
spBaseUOM, spCost, spVendorID, spCustInt1, spCustInt2, spCustInt3, spCustDate1, spCustDate2, spCustDate3, spUserID, spAddDate, spUpdDate, spDataid);
}
catch (Exception ex)
{
throw;
}
return(dt_material);
}
public DataTable InsertVendor_MasterData()
{
DataTable dt = null;
try
{
SqlCeParameter spVendorID = new SqlCeParameter();
spVendorID.ParameterName = "@VendorID";
spVendorID.SqlDbType = System.Data.SqlDbType.NVarChar;
spVendorID.Value = this.VendorID;
SqlCeParameter spName1 = new SqlCeParameter();
spName1.ParameterName = "@Name1";
spName1.SqlDbType = System.Data.SqlDbType.NVarChar;
spName1.Value = this.Name1;
SqlCeParameter spName2 = new SqlCeParameter();
spName2.ParameterName = "@Name2";
spName2.SqlDbType = System.Data.SqlDbType.NVarChar;
spName2.Value = this.Name2;
SqlCeParameter spAddress1 = new SqlCeParameter();
spAddress1.ParameterName = "@Address1";
spAddress1.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress1.Value = this.Address1;
SqlCeParameter spAddress2 = new SqlCeParameter();
spAddress2.ParameterName = "@Address2";
spAddress2.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress2.Value = this.Address2;
SqlCeParameter spAddress3 = new SqlCeParameter();
spAddress3.ParameterName = "@Address3";
spAddress3.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress3.Value = this.Address3;
SqlCeParameter spPOBox = new SqlCeParameter();
spPOBox.ParameterName = "@POBox";
spPOBox.SqlDbType = System.Data.SqlDbType.NVarChar;
spPOBox.Value = this.POBox;
SqlCeParameter spContact = new SqlCeParameter();
spContact.ParameterName = "@Contact";
spContact.SqlDbType = System.Data.SqlDbType.NVarChar;
spContact.Value = this.Contact;
SqlCeParameter spPhone = new SqlCeParameter();
spPhone.ParameterName = "@Phone";
spPhone.SqlDbType = System.Data.SqlDbType.NVarChar;
spPhone.Value = this.Phone;
SqlCeParameter spFax = new SqlCeParameter();
spFax.ParameterName = "@Fax";
spFax.SqlDbType = System.Data.SqlDbType.NVarChar;
spFax.Value = this.Fax;
SqlCeParameter spEmail = new SqlCeParameter();
spEmail.ParameterName = "@Email";
spEmail.SqlDbType = System.Data.SqlDbType.NVarChar;
spEmail.Value = this.Email;
SqlCeParameter spCity = new SqlCeParameter();
spCity.ParameterName = "@City";
spCity.SqlDbType = System.Data.SqlDbType.NVarChar;
spCity.Value = this.City;
SqlCeParameter spRegion = new SqlCeParameter();
spRegion.ParameterName = "@Region";
spRegion.SqlDbType = System.Data.SqlDbType.NVarChar;
spRegion.Value = this.Region;
SqlCeParameter spCountry = new SqlCeParameter();
spCountry.ParameterName = "@Country";
spCountry.SqlDbType = System.Data.SqlDbType.NVarChar;
spCountry.Value = this.Country;
SqlCeParameter spCustInt1 = new SqlCeParameter();
spCustInt1.ParameterName = "@CustInt1";
spCustInt1.SqlDbType = System.Data.SqlDbType.Int;
spCustInt1.Value = this.CustInt1;
SqlCeParameter spCustInt2 = new SqlCeParameter();
spCustInt2.ParameterName = "@CustInt2";
spCustInt2.SqlDbType = System.Data.SqlDbType.Int;
spCustInt2.Value = this.CustInt2;
SqlCeParameter spCustInt3 = new SqlCeParameter();
spCustInt3.ParameterName = "@CustInt3";
spCustInt3.SqlDbType = System.Data.SqlDbType.Int;
spCustInt3.Value = this.CustInt3;
SqlCeParameter spCustText1 = new SqlCeParameter();
spCustText1.ParameterName = "@CustText1";
spCustText1.SqlDbType = System.Data.SqlDbType.NVarChar;
spCustText1.Value = this.CustText1;
SqlCeParameter spCustText2 = new SqlCeParameter();
spCustText2.ParameterName = "@CustText2";
spCustText2.SqlDbType = System.Data.SqlDbType.NVarChar;
spCustText2.Value = this.CustText2;
SqlCeParameter spCustText3 = new SqlCeParameter();
spCustText3.ParameterName = "@CustText3";
spCustText3.SqlDbType = System.Data.SqlDbType.NVarChar;
spCustText3.Value = this.CustText3;
string s = "insert into tbl_Vendor values(@VendorID,@Name1,@Name2,@Address1,@Address2,@Address3,@POBox,@Contact,@Phone,@Fax,@Email,@City,@Region,@Country,@CustInt1,"
+ " @CustInt2,@CustInt3,@CustText1,@CustText2,@CustText3)";
objDb.ConString = Dcon;
objDb.CmdType = CommandType.Text;
objDb.CmdString = s;
objDb.InsertRecord(spVendorID, spName1, spName2, spAddress1, spAddress2, spAddress3, spPOBox, spContact, spPhone, spFax, spEmail, spCity, spRegion, spCountry, spCustInt1,
spCustInt2, spCustInt3, spCustText1, spCustText2, spCustText3);
}
catch (Exception ex)
{
}
return(dt);
}
public DataTable InsertLocation()
{
DataTable dt_location = null;
try
{
SqlCeParameter spLocationID = new SqlCeParameter();
spLocationID.ParameterName = "@LocationID";
spLocationID.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationID.Value = this.LocationID;
SqlCeParameter spLocationDesc = new SqlCeParameter();
spLocationDesc.ParameterName = "@LocationDesc";
spLocationDesc.SqlDbType = System.Data.SqlDbType.NVarChar;
spLocationDesc.Value = this.LocationDesc;
SqlCeParameter spAddress1 = new SqlCeParameter();
spAddress1.ParameterName = "@Address1";
spAddress1.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress1.Value = this.Address1;
SqlCeParameter spAddress2 = new SqlCeParameter();
spAddress2.ParameterName = "@Address2";
spAddress2.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress2.Value = this.Address2;
SqlCeParameter spAddress3 = new SqlCeParameter();
spAddress3.ParameterName = "@Address3";
spAddress3.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress3.Value = this.Address3;
SqlCeParameter spPOBox = new SqlCeParameter();
spPOBox.ParameterName = "@POBox";
spPOBox.SqlDbType = System.Data.SqlDbType.NVarChar;
spPOBox.Value = this.POBox;
SqlCeParameter spContact = new SqlCeParameter();
spContact.ParameterName = "@Contact";
spContact.SqlDbType = System.Data.SqlDbType.NVarChar;
spContact.Value = this.Contact;
SqlCeParameter spPhone = new SqlCeParameter();
spPhone.ParameterName = "@Phone";
spPhone.SqlDbType = System.Data.SqlDbType.NVarChar;
spPhone.Value = this.Phone;
SqlCeParameter spFax = new SqlCeParameter();
spFax.ParameterName = "@Fax";
spFax.SqlDbType = System.Data.SqlDbType.NVarChar;
spFax.Value = this.Fax;
SqlCeParameter spEmail = new SqlCeParameter();
spEmail.ParameterName = "@Email";
spEmail.SqlDbType = System.Data.SqlDbType.NVarChar;
spEmail.Value = this.Email;
SqlCeParameter spCity = new SqlCeParameter();
spCity.ParameterName = "@City";
spCity.SqlDbType = System.Data.SqlDbType.NVarChar;
spCity.Value = this.City;
SqlCeParameter spRegion = new SqlCeParameter();
spRegion.ParameterName = "@Region";
spRegion.SqlDbType = System.Data.SqlDbType.NVarChar;
spRegion.Value = this.Region;
SqlCeParameter spCountry = new SqlCeParameter();
spCountry.ParameterName = "@Country";
spCountry.SqlDbType = System.Data.SqlDbType.NVarChar;
spCountry.Value = this.Country;
SqlCeParameter spCostCenter = new SqlCeParameter();
spCostCenter.ParameterName = "@CostCenter";
spCostCenter.SqlDbType = System.Data.SqlDbType.NVarChar;
spCostCenter.Value = this.CostCenter;
SqlCeParameter spCashLoan = new SqlCeParameter();
spCashLoan.ParameterName = "@CashLoan";
spCashLoan.SqlDbType = System.Data.SqlDbType.Decimal;
spCashLoan.Value = this.CashLoan;
SqlCeParameter spCustInt1 = new SqlCeParameter();
spCustInt1.ParameterName = "@CustInt1";
spCustInt1.SqlDbType = System.Data.SqlDbType.Int;
spCustInt1.Value = this.CustInt1;
SqlCeParameter spCustInt2 = new SqlCeParameter();
spCustInt2.ParameterName = "@CustInt2";
spCustInt2.SqlDbType = System.Data.SqlDbType.Int;
spCustInt2.Value = this.CustInt2;
SqlCeParameter spCustInt3 = new SqlCeParameter();
spCustInt3.ParameterName = "@CustInt3";
spCustInt3.SqlDbType = System.Data.SqlDbType.Int;
spCustInt3.Value = this.CustInt3;
string s = "insert into tbl_location_temp(LocationID,LocationDesc,Address1,Address2,Address3,POBox,Contact,Phone,Fax,Email,City,Region,Country,"
+ " CostCenter,CashLoan,CustInt1,CustInt2,CustInt3)values(@LocationID,@LocationDesc,@Address1,@Address2,@Address3,@POBox,@Contact,"
+ " @Phone,@Fax,@Email,@City,@Region,@Country,@CostCenter,@CashLoan,@CustInt1,@CustInt2,@CustInt3)";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spLocationID, spLocationDesc, spAddress1, spAddress2, spAddress3, spPOBox, spContact, spPhone, spFax, spEmail, spCity, spRegion, spCountry,
spCostCenter, spCashLoan, spCustInt1, spCustInt2, spCustInt3);
}
catch (Exception ex)
{
throw;
}
return(dt_location);
}
public DataTable InsertCustomer()
{
DataTable dt_cus = null;
try
{
SqlCeParameter spCustomerID = new SqlCeParameter();
spCustomerID.ParameterName = "@CustomerID";
spCustomerID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCustomerID.Value = this.CustomerID;
SqlCeParameter spName1 = new SqlCeParameter();
spName1.ParameterName = "@Name1";
spName1.SqlDbType = System.Data.SqlDbType.NVarChar;
spName1.Value = this.Name1;
SqlCeParameter spName2 = new SqlCeParameter();
spName2.ParameterName = "@Name2";
spName2.SqlDbType = System.Data.SqlDbType.NVarChar;
spName2.Value = this.Name2;
SqlCeParameter spAddress1 = new SqlCeParameter();
spAddress1.ParameterName = "@Address1";
spAddress1.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress1.Value = this.Address1;
SqlCeParameter spAddress2 = new SqlCeParameter();
spAddress2.ParameterName = "@Address2";
spAddress2.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress2.Value = this.Address2;
SqlCeParameter spAddress3 = new SqlCeParameter();
spAddress3.ParameterName = "@Address3";
spAddress3.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress3.Value = this.Address3;
SqlCeParameter spPOBox = new SqlCeParameter();
spPOBox.ParameterName = "@POBox";
spPOBox.SqlDbType = System.Data.SqlDbType.NVarChar;
spPOBox.Value = this.POBox;
SqlCeParameter spPhone = new SqlCeParameter();
spPhone.ParameterName = "@Phone";
spPhone.SqlDbType = System.Data.SqlDbType.NVarChar;
spPhone.Value = this.Phone;
SqlCeParameter spFax = new SqlCeParameter();
spFax.ParameterName = "@Fax";
spFax.SqlDbType = System.Data.SqlDbType.NVarChar;
spFax.Value = this.Fax;
SqlCeParameter spEmail = new SqlCeParameter();
spEmail.ParameterName = "@Email";
spEmail.SqlDbType = System.Data.SqlDbType.NVarChar;
spEmail.Value = this.Email;
SqlCeParameter spCity = new SqlCeParameter();
spCity.ParameterName = "@City";
spCity.SqlDbType = System.Data.SqlDbType.NVarChar;
spCity.Value = this.City;
SqlCeParameter spRegion = new SqlCeParameter();
spRegion.ParameterName = "@Region";
spRegion.SqlDbType = System.Data.SqlDbType.NVarChar;
spRegion.Value = this.Region;
SqlCeParameter spCountry = new SqlCeParameter();
spCountry.ParameterName = "@Country";
spCountry.SqlDbType = System.Data.SqlDbType.NVarChar;
spCountry.Value = this.Country;
SqlCeParameter spCreditLimit = new SqlCeParameter();
spCreditLimit.ParameterName = "@CreditLimit";
spCreditLimit.SqlDbType = System.Data.SqlDbType.Decimal;
spCreditLimit.Value = this.CreditLimit;
SqlCeParameter spCustInt1 = new SqlCeParameter();
spCustInt1.ParameterName = "@CustInt1";
spCustInt1.SqlDbType = System.Data.SqlDbType.Int;
spCustInt1.Value = this.CustInt1;
SqlCeParameter spCustInt2 = new SqlCeParameter();
spCustInt2.ParameterName = "@CustInt2";
spCustInt2.SqlDbType = System.Data.SqlDbType.Int;
spCustInt2.Value = this.CustInt2;
SqlCeParameter spCustInt3 = new SqlCeParameter();
spCustInt3.ParameterName = "@CustInt3";
spCustInt3.SqlDbType = System.Data.SqlDbType.Int;
spCustInt3.Value = this.CustInt3;
SqlCeParameter spCustType = new SqlCeParameter();
spCustType.ParameterName = "@CustType";
spCustType.SqlDbType = System.Data.SqlDbType.NVarChar;
spCustType.Value = this.CustType;
SqlCeParameter spTotalDue = new SqlCeParameter();
spTotalDue.ParameterName = "@TotalDue";
spTotalDue.SqlDbType = System.Data.SqlDbType.Decimal;
spTotalDue.Value = this.TotalDue;
string s = "insert into tbl_Customer_Temp(CustomerID,Name1,Name2,Address1,Address2,Address3,POBox,Phone,Fax,Email,City,Region,Country,CreditLimit,"
+ " CustInt1,CustInt2,CustInt3,CustType,TotalDue)values(@CustomerID,@Name1,@Name2,@Address1,@Address2,@Address3,@POBox,@Phone,@Fax,@Email,@City,@Region,@Country,@CreditLimit,"
+ " @CustInt1,@CustInt2,@CustInt3,@CustType,@TotalDue)";
objDB.ConString = Dcon;
objDB.CmdType = CommandType.Text;
objDB.CmdString = s;
objDB.InsertRecord(spCustomerID, spName1, spName2, spAddress1, spAddress2, spAddress3, spPOBox, spPhone, spFax, spEmail, spCity, spRegion, spCountry, spCreditLimit,
spCustInt1, spCustInt2, spCustInt3, spCustType, spTotalDue);
}
catch (Exception ex)
{
throw;
}
return(dt_cus);
}
public DataTable InsertCompany_MaserData()
{
DataTable dt_company = null;
try
{
SqlCeParameter spCompanyID = new SqlCeParameter();
spCompanyID.ParameterName = "@CompanyID";
spCompanyID.SqlDbType = System.Data.SqlDbType.NVarChar;
spCompanyID.Value = this.CompanyID;
SqlCeParameter spLongName = new SqlCeParameter();
spLongName.ParameterName = "@LongName";
spLongName.SqlDbType = System.Data.SqlDbType.NVarChar;
spLongName.Value = this.LongName;
SqlCeParameter spShortName = new SqlCeParameter();
spShortName.ParameterName = "@ShortName";
spShortName.SqlDbType = System.Data.SqlDbType.NVarChar;
spShortName.Value = this.ShortName;
SqlCeParameter spAddress1 = new SqlCeParameter();
spAddress1.ParameterName = "@Address1";
spAddress1.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress1.Value = this.Address1;
SqlCeParameter spAddress2 = new SqlCeParameter();
spAddress2.ParameterName = "@Address2";
spAddress2.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress2.Value = this.Address2;
SqlCeParameter spAddress3 = new SqlCeParameter();
spAddress3.ParameterName = "@Address3";
spAddress3.SqlDbType = System.Data.SqlDbType.NVarChar;
spAddress3.Value = this.Address3;
SqlCeParameter spPOBox = new SqlCeParameter();
spPOBox.ParameterName = "@POBox";
spPOBox.SqlDbType = System.Data.SqlDbType.NVarChar;
spPOBox.Value = this.POBox;
SqlCeParameter spContact = new SqlCeParameter();
spContact.ParameterName = "@Contact";
spContact.SqlDbType = System.Data.SqlDbType.NVarChar;
spContact.Value = this.Contact;
SqlCeParameter spPhone = new SqlCeParameter();
spPhone.ParameterName = "@Phone";
spPhone.SqlDbType = System.Data.SqlDbType.NVarChar;
spPhone.Value = this.Phone;
SqlCeParameter spFax = new SqlCeParameter();
spFax.ParameterName = "@Fax";
spFax.SqlDbType = System.Data.SqlDbType.NVarChar;
spFax.Value = this.Fax;
SqlCeParameter spEmail = new SqlCeParameter();
spEmail.ParameterName = "@Email";
spEmail.SqlDbType = System.Data.SqlDbType.NVarChar;
spEmail.Value = this.Email;
SqlCeParameter spCity = new SqlCeParameter();
spCity.ParameterName = "@City";
spCity.SqlDbType = System.Data.SqlDbType.NVarChar;
spCity.Value = this.City;
SqlCeParameter spRegion = new SqlCeParameter();
spRegion.ParameterName = "@Region";
spRegion.SqlDbType = System.Data.SqlDbType.NVarChar;
spRegion.Value = this.Region;
SqlCeParameter spCountry = new SqlCeParameter();
spCountry.ParameterName = "@Country";
spCountry.SqlDbType = System.Data.SqlDbType.NVarChar;
spCountry.Value = this.Country;
SqlCeParameter spDefaultCurrency = new SqlCeParameter();
spDefaultCurrency.ParameterName = "@DefaultCurrency";
spDefaultCurrency.SqlDbType = System.Data.SqlDbType.NVarChar;
spDefaultCurrency.Value = this.DefaultCurrency;
string s = "Insert into tbl_Company values(@CompanyID,@LongName,@ShortName,@Address1,@Address2,@Address3,@POBox,@Contact,@Phone,@Fax,@Email,@City,@Region,@Country,@DefaultCurrency)";
objDb.ConString = Dcon;
objDb.CmdType = CommandType.Text;
objDb.CmdString = s;
objDb.InsertRecord(spCompanyID, spLongName, spShortName, spAddress1, spAddress2, spAddress3, spPOBox, spContact, spPhone, spFax, spEmail, spCity, spRegion, spCountry, spDefaultCurrency);
}
catch (Exception ex)
{
}
return(dt_company);
}
