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); }