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