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 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 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 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 string createAndReturnIdGenerated(Item entity) { ErrorOccur = false; string idGenerated = ""; 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()); idGenerated = DM.Execute_StoreProcedure_Scalar("ItemMaster_NewItem", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
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(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); }