public JsonResult MaterialMasterSaveData(MaterialMasterModel materilamastersave)
{
string messageid1 = "";
List <MessageModel> responseMessage = new List <MessageModel>();
string messagetext1 = "";
try
{
var userid = _ICacheManager.Get <object>("UserID");
FactoryMastercontext masterContext = new FactoryMastercontext();
responseMessage = masterContext.MaterialInsertUpdate(materilamastersave, Convert.ToInt32(userid.ToString().Trim())).ToList();
foreach (var msg in responseMessage)
{
messageid1 = msg.MessageID;
messagetext1 = msg.MessageText;
TempData["messageid"] = msg.MessageID;
TempData["messagetext"] = msg.MessageText;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(responseMessage, JsonRequestBehavior.AllowGet));
}
public List <MessageModel> MaterialInsertUpdate(MaterialMasterModel materialmaster, int CreatedBy)
{
DataTable dtFactory;
DataTable dtVendor;
DataTable dtCustomer;
dtFactory = FactoryTypeListDetails(materialmaster.FactoryTypeList);
dtVendor = VendorTypeListDetails(materialmaster.VendorTypeList);
dtCustomer = CustomerTypeListDetails(materialmaster.CustomerTypeList);
List <MessageModel> response = new List <MessageModel>();
try
{
response = _db.Query <MessageModel>("USP_MATERIALMASTER_SAVE_V2 ",
new
{
P_ID = materialmaster.MaterialID,
P_CODE = materialmaster.ProductCode,
P_NAME = materialmaster.ProductName,
P_DIVID = materialmaster.PrimaryItemID,
P_DIVNAME = materialmaster.PrimaryItemText,
P_SUBTYPEID = materialmaster.SubItemID,
P_SUBTYPENAME = materialmaster.SubItemText,
P_UOMID = materialmaster.UomID,
P_UOMNAME = materialmaster.UomText,
P_UNITVALUE = materialmaster.UnitCapacity,
P_MINSTOOKLEVEL = materialmaster.ReorderLevel,
P_RETURNABLE = materialmaster.Returnable,
P_MRP = materialmaster.MRP,
P_MODE = materialmaster.FLAG,
P_ACTIVE = materialmaster.Active,
P_ASSESSABLEPERCENTAGE = materialmaster.Assesment,
P_CBU = CreatedBy,
P_DEPOTID = materialmaster.FactoryID,
P_FACTORYMAPID = materialmaster.FactoryMapID,
P_VENDORID = materialmaster.VendorMapID,
P_UNITCAPACITY = materialmaster.UnitCapacityInput,
P_FROMPACKSIZEID = materialmaster.PacksizeFrom,
P_FROMPACKSIZE = materialmaster.PacksizeFromText,
P_TOPACKSIZEID = materialmaster.PacksizeTo,
P_TOPACKSIZE = materialmaster.PacksizeToText,
P_CUSTOMERID = materialmaster.CustomerMapID,
TempTableFactory = dtFactory.AsTableValuedParameter("Type_MATERIAL_MASTER_FACTORY_MAP"),
TempTableVendor = dtVendor.AsTableValuedParameter("Type_MATERIAL_MASTER_VENDOR_MAP"),
TempTableCustomer = dtCustomer.AsTableValuedParameter("Type_MATERIAL_MASTER_CUSTOMER_MAP"),
P_PRODUCTOWNER = materialmaster.ProductOwner
},
commandType: CommandType.StoredProcedure).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
