public bool create(Token entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; bool result = false; try { DM.Load_SP_Parameters("@Token", entity.TokenNumber); DM.Load_SP_Parameters("@Subject", entity.Subject); DM.Load_SP_Parameters("@SubjectKey", entity.SubjectKey.ToString()); DM.Load_SP_Parameters("@DeadDate", entity.DeadDate.ToString("G")); DM.Load_SP_Parameters("@Acknowledgement", entity.Acnkowledgment); result = DM.Execute_StoreProcedure_Open_Conn("TokenMaster_NewToken", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public string createAndReturnIdGenerated(Item entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; string idGenerated = ""; try { DM.Load_SP_Parameters("@PartNumber", entity.PartNumber); DM.Load_SP_Parameters("@PartDescription", entity.Description); DM.Load_SP_Parameters("@UM", entity.Um); DM.Load_SP_Parameters("@PartMaterial", entity.Material); DM.Load_SP_Parameters("@Cost", entity.Cost.ToString()); DM.Load_SP_Parameters("@CapsonicPN", entity.CapsonicPN); DM.Load_SP_Parameters("@CustomerPN", entity.CustomerPN); DM.Load_SP_Parameters("@ManufacturePN", entity.ManufacturePN); DM.Load_SP_Parameters("@SupplierPN", entity.SupplierPN); DM.Load_SP_Parameters("@CommCode", entity.CommCode); //DM.Load_SP_Parameters("@EAU", entity.EAU.ToString()); idGenerated = DM.Execute_StoreProcedure_Scalar_Open_Conn("ItemMaster_NewItem", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public bool create(Commodity entity) { ErrorOccur = false; bool result = false; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@CommodityCode", entity.CommodityCode); DM.Load_SP_Parameters("@Commodity", entity.CommidityName); result = DM.Execute_StoreProcedure("CommodityMaster_NewCommodity", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public bool create(Item entity) { ErrorOccur = false; bool result = false; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@PartNumber", entity.PartNumber); DM.Load_SP_Parameters("@PartDescription", entity.Description); DM.Load_SP_Parameters("@UM", entity.Um); DM.Load_SP_Parameters("@PartMaterial", entity.Material); DM.Load_SP_Parameters("@Cost", entity.Cost.ToString()); DM.Load_SP_Parameters("@CapsonicPN", entity.CapsonicPN); DM.Load_SP_Parameters("@CustomerPN", entity.CustomerPN); DM.Load_SP_Parameters("@ManufacturePN", entity.ManufacturePN); DM.Load_SP_Parameters("@SupplierPN", entity.SupplierPN); DM.Load_SP_Parameters("@CommCode", entity.CommCode); //DM.Load_SP_Parameters("@EAU", entity.EAU.ToString()); result = DM.Execute_StoreProcedure("ItemMaster_NewItem", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public bool take(long bomDetailKey, string user) { ErrorOccur = false; bool result = false; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@BOMDetailKey", bomDetailKey.ToString()); DM.Load_SP_Parameters("@AssignedTo", user); result = DM.Execute_StoreProcedure("TakeBOM", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public string createAndReturnIdGenerated(BOM entity) { ErrorOccur = false; string idGenerated = ""; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@SIFHeaderKey", entity.SifId.ToString()); DM.Load_SP_Parameters("@TopPartNumber", entity.TopPartNumber); DM.Load_SP_Parameters("@PartDescription", entity.PartDescription); DM.Load_SP_Parameters("@Revision", entity.Revision); DM.Load_SP_Parameters("@AnnualVolume", entity.AnnualVolume.ToString()); idGenerated = DM.Execute_StoreProcedure_Scalar("BOMHeader_NewBOM", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public bool update(Customer entity) { ErrorOccur = false; bool result = false; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@CustomerKey", entity.Id.ToString()); DM.Load_SP_Parameters("@CustomerName", entity.CustomerName); result = DM.Execute_StoreProcedure("CustomerMaster_EditCustomer", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public bool create(BOM entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; bool result = false; try { DM.Load_SP_Parameters("@SIFHeaderKey", entity.SifId.ToString()); DM.Load_SP_Parameters("@TopPartNumber", entity.TopPartNumber); DM.Load_SP_Parameters("@PartDescription", entity.PartDescription); DM.Load_SP_Parameters("@Revision", entity.Revision); DM.Load_SP_Parameters("@AnnualVolume", entity.AnnualVolume.ToString()); result = DM.Execute_StoreProcedure_Open_Conn("BOMHeader_NewBOM", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public string createAndReturnIdGenerated(Supplier_Commodity entity) { ErrorOccur = false; string idGenerated = ""; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@SupplierKey", entity.SupplierKey.ToString()); DM.Load_SP_Parameters("@CommodityKey", entity.CommodityKey.ToString()); idGenerated = DM.Execute_StoreProcedure_Scalar("SupplierCommodity_New", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public bool update(Supplier_Commodity entity) { ErrorOccur = false; bool result = false; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@SupplierCommodityKey", entity.Id.ToString()); DM.Load_SP_Parameters("@SupplierKey", entity.SupplierKey.ToString()); DM.Load_SP_Parameters("@CommodityKey", entity.CommodityKey.ToString()); result = DM.Execute_StoreProcedure("SupplierCommodity_Edit", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public string createAndReturnIdGenerated(Commodity entity) { ErrorOccur = false; string idGenerated = ""; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@CommodityCode", entity.CommodityCode); DM.Load_SP_Parameters("@Commodity", entity.CommidityName); idGenerated = DM.Execute_StoreProcedure_Scalar("CommodityMaster_NewCommodity", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public string createAndReturnIdGenerated(Token entity) { ErrorOccur = false; string idGenerated = ""; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@Token", entity.TokenNumber); DM.Load_SP_Parameters("@Subject", entity.Subject); DM.Load_SP_Parameters("@SubjectKey", entity.SubjectKey.ToString()); DM.Load_SP_Parameters("@DeadDate", entity.DeadDate.ToString("G")); DM.Load_SP_Parameters("@Acknowledgement", entity.Acnkowledgment); idGenerated = DM.Execute_StoreProcedure_Scalar("TokenMaster_NewToken", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public bool update(Commodity entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; bool result = false; try { DM.Load_SP_Parameters("@ItemMasterKey", entity.Id.ToString()); DM.Load_SP_Parameters("@CommodityCode", entity.CommodityCode); DM.Load_SP_Parameters("@Commodity", entity.CommidityName); result = DM.Execute_StoreProcedure_Open_Conn("CommodityMaster_EditCommodity", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public bool update(BOM entity) { ErrorOccur = false; bool result = false; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@BOMHeaderKey", entity.Id.ToString()); DM.Load_SP_Parameters("@SIFHeaderKey", entity.SifId.ToString()); DM.Load_SP_Parameters("@TopPartNumber", entity.TopPartNumber); DM.Load_SP_Parameters("@PartDescription", entity.PartDescription); DM.Load_SP_Parameters("@Revision", entity.Revision); DM.Load_SP_Parameters("@AnnualVolume", entity.AnnualVolume.ToString()); DM.Load_SP_Parameters("@sys_active", true.ToString()); result = DM.Execute_StoreProcedure("BOMHeader_EditBOM", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public bool update(Token entity) { ErrorOccur = false; bool result = false; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@TokenKey", entity.Id.ToString()); DM.Load_SP_Parameters("@Token", entity.TokenNumber); DM.Load_SP_Parameters("@Subject", entity.Subject); DM.Load_SP_Parameters("@SubjectKey", entity.SubjectKey.ToString()); DM.Load_SP_Parameters("@DeadDate", entity.DeadDate.ToString("G")); DM.Load_SP_Parameters("@Acknowledgement", entity.Acnkowledgment); //sys_active not as a parameter in Store Procedure result = DM.Execute_StoreProcedure("TokenMaster_EditToken", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public string createAndReturnIdGenerated(Commodity entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; string idGenerated = ""; try { DM.Load_SP_Parameters("@CommodityCode", entity.CommodityCode); DM.Load_SP_Parameters("@Commodity", entity.CommidityName); idGenerated = DM.Execute_StoreProcedure_Scalar_Open_Conn("CommodityMaster_NewCommodity", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public bool update(MarketSector entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; bool result = false; try { DM.Load_SP_Parameters("@MarketSectorID", entity.Id.ToString()); DM.Load_SP_Parameters("@Name", entity.Name); result = DM.Execute_StoreProcedure_Open_Conn("MarketSector_EditMarket", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public string createAndReturnIdGenerated(MarketSector entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; string idGenerated = ""; try { DM.Load_SP_Parameters("@Name", entity.Name); idGenerated = DM.Execute_StoreProcedure_Scalar_Open_Conn("MarketSector_NewMarket", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public bool create(MarketSector entity) { ErrorOccur = false; bool result = false; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@Name", entity.Name); result = DM.Execute_StoreProcedure("MarketSector_NewMarket", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public string createAndReturnIdGenerated(MarketSector entity) { ErrorOccur = false; string idGenerated = ""; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@Name", entity.Name); idGenerated = DM.Execute_StoreProcedure_Scalar("MarketSector_NewMarket", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public string createAndReturnIdGenerated(Supplier entity) { ErrorOccur = false; string idGenerated = ""; DM = connectionManager.getDataManager(); try { DM.Load_SP_Parameters("@SupplierName", entity.SupplierName); DM.Load_SP_Parameters("@ContactName", entity.ContactName); DM.Load_SP_Parameters("@ContactPhoneNumber", entity.ContactPhone); DM.Load_SP_Parameters("@ContactEmail", entity.ContactEmail); DM.Load_SP_Parameters("@ManufacturingLocation", entity.ManufacturingLocation); DM.Load_SP_Parameters("@ShipLocation", entity.ShipLocation); DM.Load_SP_Parameters("@QuotedCurrency", entity.QuotedCurrency); DM.Load_SP_Parameters("@Capabilities", entity.Capabilities); DM.Load_SP_Parameters("@Comments", entity.Comments); DM.Load_SP_Parameters("@Visible", entity.Visible.ToString()); DM.Load_SP_Parameters("@Commodity", entity.Commodity); DM.Load_SP_Parameters("@ContactCellPhoneNumber", entity.ContactCellPhone); idGenerated = DM.Execute_StoreProcedure_Scalar("SupplierMaster_NewSupplier", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public bool update(Supplier entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; bool result = false; try { DM.Load_SP_Parameters("@SupplierKey", entity.Id.ToString()); DM.Load_SP_Parameters("@SupplierName", entity.SupplierName); DM.Load_SP_Parameters("@ContactName", entity.ContactName); DM.Load_SP_Parameters("@ContactPhoneNumber", entity.ContactPhone); DM.Load_SP_Parameters("@ContactEmail", entity.ContactEmail); DM.Load_SP_Parameters("@ManufacturingLocation", entity.ManufacturingLocation); DM.Load_SP_Parameters("@ShipLocation", entity.ShipLocation); DM.Load_SP_Parameters("@QuotedCurrency", entity.QuotedCurrency); DM.Load_SP_Parameters("@Capabilities", entity.Capabilities); DM.Load_SP_Parameters("@Comments", entity.Comments); DM.Load_SP_Parameters("@Visible", entity.Visible.ToString()); DM.Load_SP_Parameters("@Commodity", entity.Commodity); DM.Load_SP_Parameters("@ContactCellPhoneNumber", entity.ContactCellPhone); DM.Load_SP_Parameters("@sys_active", true.ToString()); result = DM.Execute_StoreProcedure_Open_Conn("SupplierMaster_EditSupplier", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public bool update(BOMDetail entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; bool result = false; try { DM.Load_SP_Parameters("@BOMDetailKey", entity.Id.ToString()); DM.Load_SP_Parameters("@BOMHeaderKey", entity.BomHeaderKey.ToString()); DM.Load_SP_Parameters("@ItemMasterKey", entity.ItemMasterkey.ToString()); DM.Load_SP_Parameters("@Qty", entity.Qty.ToString()); DM.Load_SP_Parameters("@Cost", entity.Cost.ToString()); DM.Load_SP_Parameters("@Status", entity.Status); DM.Load_SP_Parameters("@Description", entity.Description); DM.Load_SP_Parameters("@LinePosition", entity.LinePosition); DM.Load_SP_Parameters("@SalesStatus", entity.SalesStatus); DM.Load_SP_Parameters("@User", entity.User); DM.Load_SP_Parameters("@PurchasingStatus", entity.PurchasingStatus); DM.Load_SP_Parameters("@DirectedBuy", entity.DirectedBuy.ToString()); DM.Load_SP_Parameters("@Material", entity.Material); DM.Load_SP_Parameters("@Um", entity.Um); DM.Load_SP_Parameters("@VendorQuoteEst", entity.VendorQuoteEst); DM.Load_SP_Parameters("@SalesComments", entity.SalesComments); DM.Load_SP_Parameters("@PurchasingComments", entity.PurchasingComments); DM.Load_SP_Parameters("@CapComAssm", entity.CapComAssm); DM.Load_SP_Parameters("@CapsonicPN", entity.CapsonicPN); DM.Load_SP_Parameters("@CustomerPN", entity.CustomerPN); DM.Load_SP_Parameters("@ManufacturePN", entity.ManufacturePN); DM.Load_SP_Parameters("@SupplierPN", entity.SupplierPN); DM.Load_SP_Parameters("@CommCode", entity.CommCode); DM.Load_SP_Parameters("@sys_active", true.ToString()); DM.Load_SP_Parameters("@Sequence", entity.Sequence.ToString()); DM.Load_SP_Parameters("@AttachmentsFolder", entity.AttachmentsFolder); result = DM.Execute_StoreProcedure_Open_Conn("BOMDetail_EditDetail", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }
public bool update(Item entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; bool result = false; try { DM.Load_SP_Parameters("@ItemMasterKey", entity.Id.ToString()); DM.Load_SP_Parameters("@PartNumber", entity.PartNumber); DM.Load_SP_Parameters("@PartDescription", entity.Description); DM.Load_SP_Parameters("@UM", entity.Um); DM.Load_SP_Parameters("@PartMaterial", entity.Material); DM.Load_SP_Parameters("@Cost", entity.Cost.ToString()); DM.Load_SP_Parameters("@CapsonicPN", entity.CapsonicPN); DM.Load_SP_Parameters("@CustomerPN", entity.CustomerPN); DM.Load_SP_Parameters("@ManufacturePN", entity.ManufacturePN); DM.Load_SP_Parameters("@SupplierPN", entity.SupplierPN); DM.Load_SP_Parameters("@CommCode", entity.CommCode); //DM.Load_SP_Parameters("@EAU", entity.EAU.ToString()); result = DM.Execute_StoreProcedure_Open_Conn("ItemMaster_EditItem", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(false); } return(result); }