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