public static string SaveChanges(string rows) { Dictionary <string, string> result = new Dictionary <string, string>() { { "saved", "" }, { "ids", "" }, { "error", "" } }; bool exists = false, saved = false, duplicate = false; string ids = string.Empty, errorMsg = string.Empty, tempMsg = string.Empty; try { DataTable dtjson = (DataTable)JsonConvert.DeserializeObject(rows, (typeof(DataTable))); if (dtjson.Rows.Count == 0) { errorMsg = "Unable to save. An invalid list of changes was provided."; saved = false; } int id = 0, sortOrder = 0, archive = 0; string AORWorkTypeName = string.Empty, description = string.Empty; HttpServerUtility server = HttpContext.Current.Server; //save foreach (DataRow dr in dtjson.Rows) { id = 0; sortOrder = 0; AORWorkTypeName = string.Empty; description = string.Empty; archive = 0; tempMsg = string.Empty; int.TryParse(dr["AORWorkTypeID"].ToString(), out id); AORWorkTypeName = server.UrlDecode(dr["AORWorkTypeName"].ToString()); description = server.UrlDecode(dr["Description"].ToString()); int.TryParse(dr["Sort"].ToString(), out sortOrder); int.TryParse(dr["ARCHIVE"].ToString(), out archive); if (string.IsNullOrWhiteSpace(AORWorkTypeName)) { tempMsg = "You must specify a value for AOR Workload Type."; saved = false; } else { if (id == 0) { exists = false; saved = MasterData.AORType_Add(AORWorkTypeName: AORWorkTypeName, description: description, sort: sortOrder, archive: (archive == 1), exists: out exists, newID: out id, errorMsg: out tempMsg); if (exists) { saved = false; tempMsg = string.Format("{0}{1}{2}", tempMsg, tempMsg.Length > 0 ? Environment.NewLine : "", "Cannot add duplicate AOR Workload Type record [" + AORWorkTypeName + "]."); } } else { saved = MasterData.AORType_Update(AORWorkTypeID: id, AORWorkTypeName: AORWorkTypeName, description: description, sort: sortOrder, archive: (archive == 1), duplicate: out duplicate, errorMsg: out tempMsg); } } if (saved) { ids += string.Format("{0}{1}", ids.Length > 0 ? "," : "", id.ToString()); } if (tempMsg.Length > 0) { errorMsg = string.Format("{0}{1}{2}", errorMsg, errorMsg.Length > 0 ? Environment.NewLine : "", tempMsg); } } } catch (Exception ex) { LogUtility.LogException(ex); saved = false; errorMsg = ex.Message; } result["saved"] = saved.ToString(); result["error"] = errorMsg; return(JsonConvert.SerializeObject(result, Formatting.None)); }