public async Task <IActionResult> PutUserCompanies(int id, UserCompanies userCompanies)
{
if (id != userCompanies.UserId)
{
return(BadRequest());
}
_context.Entry(userCompanies).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserCompaniesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
/// <summary>
/// Gets the User Details based on the UserID
/// </summary>
private void GetUser()
{
try
{
Database db = DatabaseFactory.CreateDatabase(_myConnection.DatabaseName);
string sqlCommand = "spGetUser";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "UserID", DbType.Int32, UserID);
DataSet ds = db.ExecuteDataSet(dbCommand);
// Load Company Info
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dRow = ds.Tables[0].Rows[0];
UserName = Common.CheckIntNull(dRow["UserName"]);
Password = Common.CheckNull(dRow["Password"]);
EmployeeID = Common.CheckIntNull(dRow["EmployeeID"]);
IsValid = Convert.ToBoolean(dRow["IsValid"]);
AuditUserID = Common.CheckIntNull(dRow["AuditUserID"]);
if (dRow["AuditDate"] != DBNull.Value)
{
AuditDate = Convert.ToDateTime(dRow["AuditDate"]);
}
else
{
AuditDate = null;
}
}
// Load User Companies
foreach (DataRow dRow in ds.Tables[1].Rows)
{
CompanyXUsersDL uCompany = new CompanyXUsersDL();
uCompany.CompanyID = Common.CheckIntNull(dRow["CompanyID"]);
uCompany.CompanyName = Common.CheckNull(dRow["CompanyName"]);
uCompany.UserID = Common.CheckIntNull(dRow["UserID"]);
uCompany.RoleID = Common.CheckIntNull(dRow["RoleID"]);
uCompany.RoleName = Common.CheckNull(dRow["RoleName"]);
if (dRow["IsDefault"] != DBNull.Value)
{
uCompany.IsDefault = Convert.ToBoolean(dRow["IsDefault"]);
}
else
{
uCompany.IsDefault = false;
}
UserCompanies.Add(uCompany);
}
}
catch (Exception ex)
{
ErrorLog.LogErrorMessageToDB("", "UsersDL.cs", "GetUser", ex.Message.ToString(), _myConnection);
}
}
public async Task <ActionResult <UserCompanies> > PostUserCompanies(UserCompanies userCompanies)
{
_context.UserCompanies.Add(userCompanies);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (UserCompaniesExists(userCompanies.UserId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetUserCompanies", new { id = userCompanies.UserId }, userCompanies));
}
public ResponseModel UpdateProfileUser(UpdateUserModel user)
{
ResponseModel result = ValidateUpdateProfileUser(user);
if (!result.IsSuccess)
{
return(result);
}
var db_user = _userRepo.GetByID(user.ID);
//image operations
if (user.ProfilePhotoUrl != null)
{
_imageM.SaveProfileImageOrigin(user.ProfilePhotoUrl, user.PhotoSaveBaseUrl);
_imageM.RemoveOldUserProfileImages(db_user.ProfilePhotoUrl);
}
db_user.FirstName = user.FirstName;
db_user.LastName = user.LastName;
db_user.Facebook = user.Facebook;
db_user.Instagram = user.Instagram;
db_user.Linkedin = user.Linkedin;
db_user.ProfilePhotoUrl = user.PhotoName;
db_user.Summary = user.Summary;
result.IsSuccess = _userRepo.Update(db_user);
if (result.IsSuccess)
{
var company = _companyRepo.GetByCustomQuery("select * from UserCompanies where UserID = @UserID", new { UserID = user.ID }).FirstOrDefault();
if (company == null)
{
company = new UserCompanies();
}
company.IsActive = true;
company.Name = user.CompanyName;
company.Phone = user.CompanyPhone;
company.Address = user.CompanyAddress;
company.CityID = user.CompanyCity;
company.Email = user.CompanyEmail;
company.UserID = user.ID;
company.UpdateDate = DateTime.Now;
company.Description = user.CompanyDescription;
if (company.ID > 0)
{
_companyRepo.ExecuteQuery("update UserCompanies set Name = @Name, Description = @Description, Phone = @Phone, Email = @Email , Address = @Address, CityID = @CityID , UpdateDate = GETDATE()", company);
}
else
{
user.CompanyID = _companyRepo.Insert(company);
}
result.ResultData = user;
result.Message = "Profil bilgileri başarı ile güncellenmiştir.";
new LoginManager().ResetSessionUser(user.ID);
}
else
{
result.Message = "Profil bilgileri güncellenirken hata oluştu.";
}
return(result);
}
