コード例 #1
0
    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));
    }
コード例 #2
0
    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));
    }