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 string createAndReturnIdGenerated(BOM entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; string idGenerated = ""; 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_Open_Conn("BOMHeader_NewBOM", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public string createAndReturnIdGenerated(BOMDetail entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; string idGenerated = ""; try { 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("@Sequence", entity.Sequence.ToString()); DM.Load_SP_Parameters("@AttachmentsFolder", entity.AttachmentsFolder); idGenerated = DM.Execute_StoreProcedure_Scalar_Open_Conn("BOMDetail_NewDetail", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }
public string createAndReturnIdGenerated(Customer entity, ref Data_Base_MNG.SQL DM) { ErrorOccur = false; string idGenerated = ""; try { DM.Load_SP_Parameters("@CustomerName", entity.CustomerName); idGenerated = DM.Execute_StoreProcedure_Scalar_Open_Conn("CustomerMaster_NewCustomer", true); ErrorOccur = DM.ErrorOccur; ErrorMessage = DM.Error_Mjs; } catch (Exception e) { ErrorOccur = true; ErrorMessage = e.Message; return(""); } return(idGenerated); }