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