public bool SaveUserSetting(GetUserSettingObject PostDataArrived) { bool success = false; try { if (PostDataArrived == null) { throw new Exception("Input Error"); } Sqlconn.Open(); string sqlquery; sqlquery = string.Format(@"DELETE FROM [UserSettings] WHERE [UserCode]='" + PostDataArrived.userCode + "'"); using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn)) { int resAdd = comm.ExecuteNonQuery(); } sqlquery = string.Format(@"INSERT INTO [UserSettings] ([UserCode],[Settings]) VALUES('{0}','{1}')", PostDataArrived.userCode, new JavaScriptSerializer().Serialize(PostDataArrived.setting).Replace("'", "''")); using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn)) { int resAdd = comm.ExecuteNonQuery(); if (resAdd == 0) { success = false; throw new Exception("User Setting not insert"); } } success = true; } catch (Exception ex) { Logger.Warn(ex.Message, ex); throw new Exception(string.Format(ErrorOccuredMess, ex.Message)); } finally { Sqlconn.Close(); if (PostDataArrived.userRole == 1) { success = SaveDefaultSetting(PostDataArrived); } } return(success); }
public ActionResult GetUserSettings() { try { if (connectionStringSetting == null || string.IsNullOrEmpty(connectionStringSetting.ConnectionString)) { throw new Exception("ConnectionString not set"); } GetUserSettingObject PostDataArrived = CS.GetPostData <GetUserSettingObject>(this.Request); SettingsWidget qw = new SettingsWidget(connectionStringSetting.ConnectionString); return(CS.ReturnForJQuery(qw.LoadUserSetting(PostDataArrived.userCode))); } catch (Exception ex) { return(CS.ReturnForJQuery(JSONConst.Error)); } }