public static string AddCertification(int userId, string certification, string description, string expirationDate, bool expired = false) { Dictionary <string, string> result = new Dictionary <string, string>() { { "saved", "" }, { "id", "" }, { "error", "" } }; bool saved = false; int id = 0; string errorMsg = string.Empty; try { WTS_User u = new WTS_User(userId); u.Load(); saved = u.Certification_Add(certification, description, expirationDate, expired, out id, out errorMsg); } catch (Exception ex) { LogUtility.LogException(ex); saved = false; errorMsg = ex.Message; } result["id"] = id.ToString(); result["saved"] = saved.ToString(); result["error"] = errorMsg; return(JsonConvert.SerializeObject(result, Formatting.None)); }
public static string SaveChanges(int userID, string rows) { Dictionary <string, string> result = new Dictionary <string, string>() { { "saved", "" } , { "ids", "" } , { "error", "" } }; bool 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. No list of changes was provided."; saved = false; } else { WTS_User u = new WTS_User(userID); u.Load(); int id = 0, expired = 0; string certification = string.Empty, description = string.Empty, expirationDate = string.Empty; //save foreach (DataRow dr in dtjson.Rows) { id = 0; certification = string.Empty; description = string.Empty; expirationDate = string.Empty; expired = 0; duplicate = false; tempMsg = string.Empty; int.TryParse(dr["Resource_CertificationID"].ToString(), out id); certification = dr["Resource_Certification"].ToString(); description = dr["Description"].ToString(); expirationDate = dr["Expiration_Date"].ToString(); int.TryParse(dr["Expired"].ToString(), out expired); if (string.IsNullOrWhiteSpace(certification)) { tempMsg = "You must specify a value for Certification."; saved = false; } else { if (id == 0) { saved = u.Certification_Add(certification, description, expirationDate, (expired == 1), out id, out tempMsg); } else { saved = u.Certification_Update(id, certification, description, expirationDate, (expired == 1), out duplicate, 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["ids"] = ids; result["saved"] = saved.ToString(); result["error"] = errorMsg; return(JsonConvert.SerializeObject(result, Formatting.None)); }