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