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