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