public Tuple <int, dynamic> UpdateUserSettings(UsersSettingsViewModel basicinfo, string ClientId, string ConnectionString, string emailId)
{
var Errormsg = new SqlParameter
{
ParameterName = "@ErrorMsg",
Size = -1,
DbType = System.Data.DbType.String,
Direction = System.Data.ParameterDirection.Output
};
string[] OldList = basicinfo.Settings.Resoucresgroup.Split(',');
foreach (var item in basicinfo.owners)
{
if (item.IsCheked)
{
OldList[item.Id - 1] = "1";
}
else
{
OldList[item.Id - 1] = "0";
}
}
string newvalue = String.Join(",", OldList);
try
{
string strConnectionString = GetConnectionString(ConnectionString, ClientId);
int rowAffected = 0;
using (SqlConnection con = new SqlConnection(strConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
var IsCrud = basicinfo.Settings.IsCrud == true ? 1 : 0;
var StartViewAsMerged = basicinfo.Settings.StartViewAsMerged == true ? 1 : 0;
var IsShowDeletedRecords = basicinfo.Settings.IsShowDeletedRecords == true ? 1 : 0;
string query = "update UserSettings set CellDuration='" + basicinfo.Settings.CellDuration + "', Resoucresgroup='" + newvalue + "',IsCrud=" + IsCrud + ",StartViewAsMerged=" + StartViewAsMerged + ",IsShowDeletedRecords=" + IsShowDeletedRecords + ",StartHour=" + basicinfo.Settings.StartHour + ",EndHour=" + basicinfo.Settings.EndHour + " where email='" + emailId + "'";
SqlCommand cmd = new SqlCommand(query, con);
//
// Resoucresgroup(basicinfo, strConnectionString);
//string query = "update Tasks set teur='" + value.Teur + "',ownerIds='" + value.OwnerIds + "',starttime ='" + Convert.ToDateTime(value.StartTime).ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss") + "', endtime='" + Convert.ToDateTime(value.EndTime).ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss") + "' ,allDayEvent='" + value.AllDayEvent + "',label='" + value.Label + "', ltName='" + value.LtName + "',remark='" + value.Remark + "',place='" + value.PLACE + "',tiK_IN='" + value.TIK_IN + "',withwho='" + value.withwho + "',lakNum='" + value.lakNum + "',attendees='" + value.attendees + "' where " + PrimekeyName + "=" + id + "";
//SqlCommand cmd = new SqlCommand(query, con);
rowAffected = cmd.ExecuteNonQuery();
}
return(new Tuple <int, dynamic>(rowAffected, Errormsg.Value));
}
catch (Exception e) { throw e.InnerException; }
}
public ResponseModel UpdateUserSettings(int id, UsersSettingsViewModel data)
{
ResponseModel response = new ResponseModel();
var getmiscellaneous = _unitOfWork.AppontmentRepository.UpdateUserSettings(data, SessionUser.ClientID, SessionUser.ConnectionString, SessionUser.eMail);
response.data = getmiscellaneous.Item2;
response.status = Status.Success;
return(response);
}
public Tuple <int, dynamic> UpdateUserSettings(UsersSettingsViewModel data, string ClinetId, string ConnectionString, string Email)
{
return(context.UpdateUserSettings(data, ClinetId, ConnectionString, Email));
}
public async Task <ResponseModel> UpdateUserSettings([FromBody] UsersSettingsViewModel data)
{
var result = _appontmentService.UpdateUserSettings(1, data);
return(await Task.FromResult(result));
}
