public ActionResult GetAllCommissionData() { var context = new CommissionEntities(); var settings = new JsonSerializerSettings { ContractResolver = new CamelCasePropertyNamesContractResolver() }; var commissionData = context.CARS_CPR_COMMISSION_TAB.ToList(); var response = new Models.Response(); if (commissionData == null) { //Used to make property name as camel case /*Microsoft.Data.OData.ODataError error = new Microsoft.Data.OData.ODataError() * { * ErrorCode = "404", * Message = "Customer Not Fount" * } * return JsonConvert.SerializeObject(error, Formatting.None, settings);*///Returns students list as JSON response = new Models.Response() { Success = false, JSON_RESPONSE_DATA = null, Message = "Customer Number provided yeilds no result." }; return(this.Json(response, JsonRequestBehavior.AllowGet)); } var commissionDatalist = new List <Models.CommissionData>(); foreach (var entry in commissionData) { var row = new Models.CommissionData() { COMMISSION_ID = entry.COMMISSION_ID, CUSTOMER_NO = entry.CUSTOMER_NO, OUTSIDE_REP_NAME = entry.CARS_CPR_OUTSIDE_REP_TAB.OUTSIDE_REP, REP_ID = entry.REP_ID, COMMISSION = entry.COMMISSION }; commissionDatalist.Add(row); } response = new Models.Response() { Success = true, JSON_RESPONSE_DATA = JsonConvert.SerializeObject(commissionDatalist)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings) }; return(this.Json(response, JsonRequestBehavior.AllowGet)); //return JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings); //Returns students list as JSON }
public ActionResult Save(Models.Request.Commission.Save saveModel) { var context = new CommissionEntities(); var settings = new JsonSerializerSettings { ContractResolver = new CamelCasePropertyNamesContractResolver() }; var response = new Models.Response(); CARS_CPR_COMMISSION_TAB commissionEntry = null; Models.CommissionData commissionDataResponseObject = null; string repName = null; /* * Do checks here making sure input is as expectied */ if (saveModel.COMMISSION_ID != null) { commissionEntry = context.CARS_CPR_COMMISSION_TAB.Where(x => x.COMMISSION_ID == saveModel.COMMISSION_ID).FirstOrDefault(); if (commissionEntry == null) { response = new Models.Response() { Success = false, JSON_RESPONSE_DATA = null, //JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings) Message = "Data to edit does not exist." }; return(this.Json(response, JsonRequestBehavior.AllowGet)); } else { commissionEntry.COMMISSION = (decimal)saveModel.commission; context.SaveChanges(); repName = context.CARS_CPR_OUTSIDE_REP_TAB.Where(x => x.REP_ID == commissionEntry.REP_ID).Select(x => x.OUTSIDE_REP).FirstOrDefault(); commissionDataResponseObject = new Models.CommissionData() { COMMISSION_ID = commissionEntry.COMMISSION_ID, CUSTOMER_NO = commissionEntry.CUSTOMER_NO, OUTSIDE_REP_NAME = repName, //here goest he actuat name after you retrieve it from db REP_ID = commissionEntry.REP_ID, COMMISSION = commissionEntry.COMMISSION }; response = new Models.Response() { Success = true, JSON_RESPONSE_DATA = JsonConvert.SerializeObject(commissionDataResponseObject)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings) }; return(this.Json(response, JsonRequestBehavior.AllowGet)); } } else { commissionEntry = new CARS_CPR_COMMISSION_TAB() { CUSTOMER_NO = saveModel.customerNumber, REP_ID = (decimal)saveModel.representativeId, COMMISSION = (decimal)saveModel.commission }; context.CARS_CPR_COMMISSION_TAB.Add(commissionEntry); context.SaveChanges(); commissionEntry.COMMISSION_ID = context.CARS_CPR_COMMISSION_TAB.Where(x => x.CUSTOMER_NO == commissionEntry.CUSTOMER_NO && x.REP_ID == commissionEntry.REP_ID && x.COMMISSION == commissionEntry.COMMISSION).Select(x => x.COMMISSION_ID).FirstOrDefault(); repName = context.CARS_CPR_OUTSIDE_REP_TAB.Where(x => x.REP_ID == commissionEntry.REP_ID).Select(x => x.OUTSIDE_REP).FirstOrDefault(); commissionDataResponseObject = new Models.CommissionData() { COMMISSION_ID = commissionEntry.COMMISSION_ID, CUSTOMER_NO = commissionEntry.CUSTOMER_NO, OUTSIDE_REP_NAME = repName, //here goest he actuat name after you retrieve it from db REP_ID = commissionEntry.REP_ID, COMMISSION = commissionEntry.COMMISSION }; response = new Models.Response() { Success = true, JSON_RESPONSE_DATA = JsonConvert.SerializeObject(commissionDataResponseObject)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings) }; return(this.Json(response, JsonRequestBehavior.AllowGet)); } //return JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings); //Returns students list as JSON }