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