public ActionResult Delete(ExtPartMapping entry) { var context = new Magnaflow_WebEntitiesProd(); var settings = new JsonSerializerSettings { ContractResolver = new CamelCasePropertyNamesContractResolver() }; Models.Response.Response response = null; /* * Do checks here making sure input is as expectied */ try { var deleteEntry = context.ExtPartMappings.Where(x => x.Id == entry.Id).FirstOrDefault(); if (deleteEntry != null) { context.ExtPartMappings.Remove(deleteEntry); context.SaveChanges(); response = new Models.Response.Response() { Success = true, JSON_RESPONSE_DATA = null // JsonConvert.SerializeObject(commissionDataResponseObject)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings) }; #region log activity var logDelete = new ExtPartMappingToolStagingActivity() { Time = DateTime.UtcNow, UserId = User.Identity.Name, ActionType = Types.ActionType.DELETE }; #endregion context.ExtPartMappingToolStagingActivities.Add(logDelete); context.SaveChanges(); } else { response = new Models.Response.Response() { Success = false, JSON_RESPONSE_DATA = null, // JsonConvert.SerializeObject(commissionDataResponseObject)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings) Message = "Data submitted to delete does not exist." }; } return(this.Json(response, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw;// new HttpException(404, "Internal error"); } //return JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings); //Returns students list as JSON }
//[Authorize(Roles = "DataTeam_APPS_RW, APP_ADMINS")] public ActionResult Save(Models.Request.NestedViews.Save saveModel) { var context = new Magnaflow_WebEntities(); var settings = new JsonSerializerSettings { ContractResolver = new CamelCasePropertyNamesContractResolver() }; Models.Response.Response response = null; ExtPartMapping extPartEntry = null; //Models.CommissionData commissionDataResponseObject = null; /* * get rid of non alphanumeric and spaces [^a-zA-Z0-9] */ if (saveModel.Id != null) { extPartEntry = context.ExtPartMappings.Where(x => x.Id == saveModel.Id).FirstOrDefault(); if (extPartEntry == null) { response = new Models.Response.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 { extPartEntry.OldPartId = saveModel.OldPartId; extPartEntry.NewPartId = saveModel.NewPartId; context.SaveChanges(); #region log save var logUpdate = new ExtPartMappingToolStagingActivity() { Time = DateTime.UtcNow, UserId = User.Identity.Name, ActionType = Types.ActionType.UPDATE }; context.ExtPartMappingToolStagingActivities.Add(logUpdate); context.SaveChanges(); #endregion response = new Models.Response.Response() { Success = true, JSON_RESPONSE_DATA = JsonConvert.SerializeObject(extPartEntry)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings) }; return(this.Json(response, JsonRequestBehavior.AllowGet)); } } else //if it's null we're adding { extPartEntry = new ExtPartMapping() { OldPartId = saveModel.OldPartId, NewPartId = saveModel.NewPartId }; context.ExtPartMappings.Add(extPartEntry); context.SaveChanges(); /* Here needs to be an updatae model of the extpartmapping added object */ #region log save var logSave = new ExtPartMappingToolStagingActivity() { Time = DateTime.UtcNow, UserId = User.Identity.Name, ActionType = Types.ActionType.SAVE }; context.ExtPartMappingToolStagingActivities.Add(logSave); context.SaveChanges(); #endregion response = new Models.Response.Response() { Success = true, JSON_RESPONSE_DATA = JsonConvert.SerializeObject(extPartEntry)// JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings) }; return(this.Json(response, JsonRequestBehavior.AllowGet)); } //return JsonConvert.SerializeObject(commissionDataResponseObject, Formatting.None, settings); //Returns students list as JSON }