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