public static bool ModifyCompanyUser(CompanyUser model)
{
string sql = string.Format(@"update {0} set [Name]=@Name,[Mobile]=@Mobile,[Email]=@Email,[WeChatOpenId]=@WeChatOpenId,[WeChatNickName]=@WeChatNickName,[WeChatHeadUrl]=@WeChatHeadUrl,[IsBindWeChat]=@IsBindWeChat,[CompanyId]=@CompanyId,[CompanyName]=@CompanyName,[DepartId]=@DepartId,[ModifyDate]=getdate(),[IsDeleted]=@IsDeleted,[Password]=@Password,[Ip]=@Ip,[ModifyBy]=@ModifyBy,[SocialNo]=@SocialNo,[CardNo]=@CardNo,[CardFront]=@CardFront,[CardFontBehind]=@CardFontBehind,[Sex]=@Sex,[Nation]=@Nation,[Political]=@Political,[Education]=@Education,[EducationPhoto]=@EducationPhoto,[HomeAddress]=@HomeAddress,[HomeAddressType]=@HomeAddressType,[Address]=@Address,[EnterDate]=@EnterDate,[UsedName]=@UsedName
where Id=@Id", TableName);
return(DBAccess.ExecuteSqlWithEntity(sql, model));
}
public async Task <IActionResult> Activate(string email, int userId)
{
var invitations = await db.CompanyInvitations
.Where(x => x.Email == email && x.Status == InvitationStatus.Accepted)
.ToArrayAsync();
var madeAnActivation = false;
foreach (var invitation in invitations)
{
var companyUser = new CompanyUser
{
CompanyId = invitation.CompanyId,
UserId = userId,
IsFavorite = true
};
db.Add(companyUser);
db.Remove(invitation);
await db.SaveChangesAsync();
madeAnActivation = true;
}
return(Ok(madeAnActivation));
}
async Task <ServiceResponse <List <GetCompanyPostAdminDto> > > ICompanyPostService.CreateCompanyPost(CreateCompanyPostDto companyPostDto)
{
ServiceResponse <List <GetCompanyPostAdminDto> > response = new ServiceResponse <List <GetCompanyPostAdminDto> >();
Company companyOfPost = await _context.Companies.FirstOrDefaultAsync(a => a.companyId == companyPostDto.companyId);
CompanyUser companyUserOfPost = await _context.CompanyUsers.FirstOrDefaultAsync(a => a.companyUserId == companyPostDto.companyUserId);
if (companyOfPost == null)
{
response.Success = false;
response.Message = "The company for this post does not exist";
return(response);
}
if (companyUserOfPost == null)
{
response.Success = false;
response.Message = "The poster of the post does not exist";
return(response);
}
string finalString = new IDGenerator.IDGenerator().generate();
string lastUpdated = DateTime.Now.ToString();
CompanyPost newPost = new CompanyPost(finalString, companyPostDto.companyId, companyPostDto.companyUserId, companyOfPost.companyName, companyPostDto.postTitle, companyPostDto.postSubTitle, companyPostDto.postDescription, companyPostDto.videoUrl, companyPostDto.links, lastUpdated, companyPostDto.approvedBy, companyPostDto.validTill, true);
await _context.CompanyPosts.AddAsync(newPost);
await _context.SaveChangesAsync();
List <GetCompanyPostAdminDto> postList = await _context.CompanyPosts.Select(a => new GetCompanyPostAdminDto(a.companyPostId, a.companyUserId, a.companyId, a.companyName, a.postTitle, a.postSubTitle, a.postDescription, a.videoUrl, a.links, a.lastUpdated, a.approvedBy, a.validTill, a.isActive)).ToListAsync();
response.Data = postList;
return(response);
}
public SignUpViewModel()
{
SignUpCommand = new Command(async() => await SignUp());
VerifyTokenCommand = new Command(async() => await VerifyToken());
CompanyUser = new CompanyUser();
}
async Task OnRowInserting(IDictionary <string, object> newValue)
{
if (newValue != null && newValue.Count > 0)
{
Dictionary <string, string> dic = CreateStringDic(newValue);
var pUserId = dic.GetValueByKey(nameof(CompanyUser.UserId), "");
Status = $"Thêm tài khoản {pUserId}";
StateHasChanged();
foreach (var item in Users)
{
if (item.UserId == pUserId)
{
AlertService.Alert($"Tài khoản {pUserId} đã tồn tại");
return;
}
}
await CompanyUser.RegisterANewUserAsync(TaxId, dic);
await SearchAsync();
}
}
public ActionResult Save(CompanyUserVm model)
{
CompanyUser company = new CompanyUser();
if (model.ImageFile != null)
{
string imageName = System.IO.Path.GetFileName(model.ImageFile.FileName);
string physicalPath = Server.MapPath("~/Images/Upload/" + imageName);
model.ImageFile.SaveAs(physicalPath);
model.ProfilePicture = imageName;
company.ProfilePicture = model.ProfilePicture;
Session["logo"] = company.ProfilePicture;
}
company.Id = model.Id;
company.Name = model.Name;
company.Email = model.Email;
company.Address = model.Address;
company.Phone = model.Phone;
if (companyInfoManager.SaveOrUpdate(company))
{
return(RedirectToAction("Index", "CompanyInfo"));
}
else
{
return(RedirectToAction("Index", "CompanyInfo"));
}
}
private bool LoadTemplateModel(int companyid, CompanyUser user, MassEmail em, EmailTemplateViewModel outtemplate)
{
try
{
var temp_enum = Enum.Parse <EmailTemplateType>(em.TemplateName);
MemberInfo memberInfo = temp_enum.GetType().GetMember(temp_enum.ToString())
.FirstOrDefault();
if (memberInfo == null)
{
return(false);
}
var loader_type = memberInfo.CustomAttributes.FirstOrDefault(at => at.AttributeType.Equals(typeof(TemplateLoaderAttribute)));
if (loader_type == null)
{
return(false);
}
EMailTemplateLoader loader = System.Activator.CreateInstance(loader_type.ConstructorArguments[0].Value as Type, _mailrepo, companyid) as EMailTemplateLoader;
return(loader.LoadModel(em, outtemplate, user));
// (loader_type. as TemplateLoaderAttribute).LoaderType
}
catch (Exception ex)
{
_logger.LogError(ex, "LoadTemplateModel error");
return(false);
}
// var u
}
private async Task <EmailProtoType> CreateEmail(int companyid, CompanyUser user, MassEmail em)
{
EmailProtoType res = new EmailProtoType();
try
{
var model = await CreateEmailModel(companyid, user, em);
res.JustAttachment = model.JustAttachment;
if (!res.JustAttachment)
{
string viewname = $"/Views/MassEmail/{em.TemplateName}_Template.cshtml";
res.Message = await _razorViewToStringRenderer.RenderViewToStringAsync(viewname, model);
}
model.Attachments.ForEach(a => res.Attachments.Add(a));
if (string.IsNullOrEmpty(model.Subject))
{
res.Subject = string.IsNullOrEmpty(em.Subject) ? "Info" : em.Subject;
}
else
{
res.Subject = model.Subject;
}
// var user = _userManager.Users.SingleOrDefault(u => u.Id == userid);
}
catch (Exception ex)
{
_logger.LogError(ex, "CreateEmail error");
return(null);
}
return(res);
}
async Task <ServiceResponse <List <CompanyUserDto> > > ICompanyUserService.CreateCompanyUser(CreateCompanyUserDto companyUserDto)
{
ServiceResponse <List <CompanyUserDto> > response = new ServiceResponse <List <CompanyUserDto> >();
Company company = await _context.Companies.FirstOrDefaultAsync(a => a.companyId == companyUserDto.companyId);
CompanyUser user = await _context.CompanyUsers.FirstOrDefaultAsync(a => a.email == companyUserDto.email);
if (user != null)
{
response.Success = false;
response.Message = "This email already has an account";
return(response);
}
if (company == null)
{
response.Success = false;
response.Message = "The company entered does not exist";
return(response);
}
string finalString = new IDGenerator.IDGenerator().generate();
String lastLoggedIn = DateTime.Now.ToString();
CompanyUser newUser = new CompanyUser(finalString, company.companyName, companyUserDto.companyId, companyUserDto.email, lastLoggedIn, true);
await _context.CompanyUsers.AddAsync(newUser);
await _context.SaveChangesAsync();
List <CompanyUserDto> newList = await _context.CompanyUsers.Select(a => new CompanyUserDto(a.companyUserId, a.companyId, a.companyName, a.email, a.lastLoggedIn, a.isActive)).ToListAsync();
response.Data = newList;
return(response);
}
public async Task <IActionResult> Edit(int id, [Bind("FullName,Username,Password,CompanyId,Id")] CompanyUser companyUser)
{
if (!_sessionService.IsAuthenticated())
{
return(RedirectToAction("Register", "Company"));
}
if (id != companyUser.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
companyUser.CompanyId = _sessionService.User().CompanyId;
_context.Update(companyUser);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CompanyUserExists(companyUser.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CompanyId"] = new SelectList(_context.Companies, "Id", "Email", companyUser.CompanyId);
return(View(companyUser));
}
async Task <ServiceResponse <List <GetCompanyPostRequestDto> > > ICompanyPostRequestService.CreateCompanyPostRequest(CreateCompanyPostRequestDto toCreate)
{
ServiceResponse <List <GetCompanyPostRequestDto> > response = new ServiceResponse <List <GetCompanyPostRequestDto> >();
Company comp = await _context.Companies.FirstOrDefaultAsync(a => a.companyId == toCreate.companyId);
CompanyUser user = await _context.CompanyUsers.FirstOrDefaultAsync(a => a.companyUserId == toCreate.companyUserId);
if (comp == null)
{
response.Success = false;
response.Message = "The company approving the request does not exist";
return(response);
}
if (user == null)
{
response.Success = false;
response.Message = "The company user creating this does not exist";
return(response);
}
string finalString = new IDGenerator.IDGenerator().generate();
string lastUpdated = new DateTime().ToString();
CompanyPostRequest req = new CompanyPostRequest(finalString, toCreate.companyId, toCreate.companyUserId, comp.companyName, toCreate.postTitle,
toCreate.postSubTitle, toCreate.postDescription, toCreate.videoUrl, toCreate.links, toCreate.validTill, "pending", null);
_context.CompanyPostRequests.Add(req);
await _context.SaveChangesAsync();
List <GetCompanyPostRequestDto> data = await _context.CompanyPostRequests.Select(a => new GetCompanyPostRequestDto(a)).ToListAsync();
response.Data = data;
return(response);
}
public async Task <IActionResult> Edit(Guid id, [Bind("CompanyID,ApplicationUserID")] CompanyUser companyUser)
{
if (id != companyUser.CompanyID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(companyUser);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CompanyUserExists(companyUser.CompanyID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ApplicationUserID"] = new SelectList(_context.ApplicationUser, "Id", "Id", companyUser.ApplicationUserID);
ViewData["CompanyID"] = new SelectList(_context.Company, "CompanyID", "Name", companyUser.CompanyID);
return(View(companyUser));
}
private void UpdateCompaniesUsers(ApplicationUser user, OJewelryDB db, List <CompanyAuthorizedUser> Companies)
{
/* Add companies for this user */
List <CompanyUser> addComps = new List <CompanyUser>();
List <CompanyUser> delComps = new List <CompanyUser>();
{
// add bIncluded users who are not in in company
foreach (CompanyAuthorizedUser cau in Companies.Where(c => c.bIncluded == true))
{
CompanyUser cu = new CompanyUser()
{
CompanyId = cau.CompanyId,
UserId = user.Id
};
if (db.CompaniesUsers.Where(x => x.CompanyId == cu.CompanyId && x.UserId == cu.UserId).Count() == 0)
{
addComps.Add(cu);
}
}
db.CompaniesUsers.AddRange(addComps);
// remove !bIncluded users who are in company
foreach (CompanyAuthorizedUser cau in Companies.Where(c => c.bIncluded == false))
{
CompanyUser cu = db.CompaniesUsers.Where(x => x.CompanyId == cau.CompanyId && x.UserId == user.Id).FirstOrDefault();
if (cu != null)
{
delComps.Add(cu);
}
}
db.CompaniesUsers.RemoveRange(delComps);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string CurrentUserId = HttpContext.Current.User.Identity.GetUserId();
var manager = Context.GetOwinContext().GetUserManager <CompanyUserManager>();
user = manager.FindById(CurrentUserId);
}
protected void InitData()
{
CompanyUser InitmodelUser = new CompanyUser();
InitmodelUser = EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance().GetModel(userid);
if (InitmodelUser != null)
{
txt_UserName.Value = InitmodelUser.UserName;
txt_MQNickname.Value = InitmodelUser.MqNickName;
txt_Post.Value = InitmodelUser.Job;
txt_MQNickname.Value = InitmodelUser.MqNickName;
#region 个人会员联系信息
txt_RealName.Value = InitmodelUser.ContactInfo.ContactName;
dropSex.SelectedValue = ((int)InitmodelUser.ContactInfo.ContactSex).ToString();
txt_Email.Value = InitmodelUser.ContactInfo.Email;
txt_Fax.Value = InitmodelUser.ContactInfo.Fax;
txt_MQ.Value = InitmodelUser.ContactInfo.MQ;
txt_MSN.Value = InitmodelUser.ContactInfo.MSN;
txt_QQ.Value = InitmodelUser.ContactInfo.QQ;
txt_tel.Value = InitmodelUser.ContactInfo.Tel;
txt_Mobile.Value = InitmodelUser.ContactInfo.Mobile;
#endregion
GetlineByCompanyId(InitmodelUser.Area);
dropDepartment.SelectedValue = InitmodelUser.DepartId;
dropPermissions.SelectedValue = InitmodelUser.RoleID;
txt_LoginTime.Text = InitmodelUser.LastLoginTime.ToString();
txt_LastLogin.Text = InitmodelUser.LastLoginIp;
txt_RegiserTime.Text = InitmodelUser.JoinTime.ToShortDateString();
IsAdmin.Text = InitmodelUser.IsAdmin == true ? "是" : "否";
}
}
async Task <ServiceResponse <CompanyUserSuccessDto> > IAccountService.LoginCompanyOtp(LoginCompanyOtpDto loginDto)
{
ServiceResponse <CompanyUserSuccessDto> response = new ServiceResponse <CompanyUserSuccessDto>();
CompanyUserOtp otp = await _context.CompanyUserOtps.FirstOrDefaultAsync(a => a.email == loginDto.email);
if (otp == null)
{
response.Success = false;
response.Message = "Something went wrong, the email sent does not exist";
}
if (loginDto.otp == otp.otp)
{
CompanyUser user = await _context.CompanyUsers.FirstOrDefaultAsync(a => a.email == loginDto.email);
response.Data = new CompanyUserSuccessDto(user.companyUserId, user.companyId, user.companyName, user.email);
}
else if (otp.isExpired || DateTime.Now.Subtract(DateTime.Parse(otp.logInTime)).TotalMinutes > 30)
{
otp.isExpired = true;
_context.CompanyUserOtps.Update(otp);
response.Success = false;
response.Message = "The OTP entered has expired";
}
else
{
otp.otpAttemptCount++;
_context.CompanyUserOtps.Update(otp);
response.Success = false;
response.Message = "Error wrong OTP entered" + otp.otp;
}
return(response);
}
public CompanyUser GetSingle(Int32 Id)
{
CompanyUser obj = new CompanyUser();
try
{
string query = "select * from company_users where ID = " + Id + "";
SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection);
mySQLDBConnect.OpenConnection();
DataTable dt = new DataTable();
SqlDataAdapter dA = new SqlDataAdapter(cmd);
dA.Fill(dt); dA.Dispose();
obj = (from x in dt.AsEnumerable()
select new CompanyUser
{
Id = x.Field <Int32>("id"),
CompanyId = x.Field <Int32>("company_id"),
UserId = x.Field <Int32>("user_id"),
UserRoleId = x.Field <Int32>("user_role_id"),
CreatedBy = x.Field <Int32>("created_by"),
CreatedDate = x.Field <DateTime>("created_date"),
UpdatedBy = x.Field <Int32?>("updated_by") == null ? 0 : x.Field <Int32>("updated_by"),
UpdatedDate = x.Field <DateTime?>("updated_date"),
Status = x.Field <Int32>("status"),
}).ToList().FirstOrDefault();
mySQLDBConnect.CloseConnection();
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(obj);
}
public async Task <bool> SendMassEmailToUser(int companyid, CompanyUser user, MassEmail em)
{
try
{
//to do AK send parents email
EmailProtoType proto = await CreateEmail(companyid, user, em);
if (user.IsChild())
{
var email = _context.Users.Where(x => x.Id == user.ParentUserId).FirstOrDefault();
if (email.ConfirmedByAdmin)
{
EmailValidCheck(email.Email);
await _mailservice.SendEmailAsync(email.Email, proto.Subject, proto.Message, companyid);
}
}
else
{
var email = _context.Users.Where(x => x.Id == user.Id).FirstOrDefault();
if (email.ConfirmedByAdmin)
{
EmailValidCheck(email.Email);
await _mailservice.SendEmailAsync(email.Email, proto.Subject, proto.Message, companyid, proto.Attachments);
}
}
}
catch (Exception ex)
{
_logger.LogError(ex, "SendMassEmailToUser error");
return(false);
}
return(true);
}
/// <summary>
/// Delete User Action Activity Log
/// </summary>
/// <param name=></param>
/// <returns>bool</returns>
public async Task <bool> DeleteCompanyUser(int CompanyUserId)
{
#region Declare a return type with initial value.
bool isCompanyUserDeleted = default(bool);
#endregion
try
{
if (CompanyUserId > default(int))
{
#region Vars
CompanyUser CompanyUser = null;
#endregion
#region Get CompanyUser by id
CompanyUser = await UnitOfWork.CompanyUserRepository.GetById(CompanyUserId);
#endregion
#region check if object is not null
if (CompanyUser != null)
{
CompanyUser.IsDeleted = (byte)DeleteStatusEnum.Deleted;
#region Apply the changes to the database
UnitOfWork.CompanyUserRepository.Update(CompanyUser);
isCompanyUserDeleted = await UnitOfWork.Commit() > default(int);
#endregion
}
#endregion
}
}
catch (Exception exception)
{
}
return(isCompanyUserDeleted);
}
public CompanyUser Create(CompanyUser compUser)
{
if (compUser.Id < 1)
{
compUser.Id = 0;
compUser.Active = true;
compUser.UpdatedAt = DateTime.Now;
context.CompanyUsers.Add(compUser);
return(compUser);
}
else
{
var dbItem = context.CompanyUsers
.FirstOrDefault(x => x.Id == compUser.Id);
if (dbItem != null)
{
dbItem.CompanyId = compUser.CompanyId;
dbItem.UserId = compUser.UserId;
dbItem.RolesCSV = compUser.RolesCSV;
dbItem.UpdatedAt = DateTime.Now;
}
return(dbItem);
}
}
public CompanyUserReturnDTO MappingCompanyUserToCompanyUserReturnDTO(CompanyUser CompanyUser)
{
#region Declare a return type with initial value.
CompanyUserReturnDTO CompanyUserReturnDTO = null;
#endregion
try
{
if (CompanyUser != null)
{
CompanyUserReturnDTO = new CompanyUserReturnDTO
{
CompanyInformationId = CompanyUser.CompanyInformationId,
CompanyUserId = CompanyUser.CompanyUserId,
CompanyUserTypeId = CompanyUser.CompanyUserTypeId,
Email = CompanyUser.Email,
FirstName = CompanyUser.FirstName,
IsAcceptInvitation = CompanyUser.IsAcceptInvitation,
IsActive = CompanyUser.IsActive,
IsCanceled = CompanyUser.IsCanceled,
JobTitile = CompanyUser.JobTitile,
LastName = CompanyUser.LastName
};
}
}
catch (Exception exception)
{ }
return(CompanyUserReturnDTO);
}
/// <summary>
/// Mapping user Action Actitvity Log
/// </summary>
/// <param name=></ param >
/// <returns>Task<CompanyUser></returns>
public CompanyUser MappingCompanyUserAddDTOToCompanyUser(CompanyUserAddDTO CompanyUserAddDTO)
{
#region Declare a return type with initial value.
CompanyUser CompanyUser = null;
#endregion
try
{
CompanyUser = new CompanyUser
{
CompanyInformationId = CompanyUserAddDTO.CompanyInformationId,
CompanyUserTypeId = CompanyUserAddDTO.CompanyUserTypeId,
Email = CompanyUserAddDTO.Email,
FirstName = CompanyUserAddDTO.FirstName,
IsAcceptInvitation = CompanyUserAddDTO.IsAcceptInvitation,
IsActive = CompanyUserAddDTO.IsActive,
IsCanceled = CompanyUserAddDTO.IsCanceled,
JobTitile = CompanyUserAddDTO.JobTitile,
LastName = CompanyUserAddDTO.LastName,
CreationDate = DateTime.Now,
IsDeleted = (byte)DeleteStatusEnum.NotDeleted
};
}
catch (Exception exception) { }
return(CompanyUser);
}
public static CompanyUserGetViewModel ToViewModel(this CompanyUser userCompany)
{
return(new CompanyUserGetViewModel
{
ID = userCompany.ID,
Name = userCompany.Name
});
}
/// <summary>
/// 导入报表
/// </summary>
/// <param name="dt">用户所传Excel</param>
/// <param name="admin">用户</param>
/// <returns></returns>
public static bool ImportExcel(DataTable dt, CompanyUser admin)
{
var flag = false;
dt = ConventImportDt(dt, admin);
flag = FinanceReportDBOperate.ImportExcel(dt);
return(flag);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
CompanyUser modelUser = new CompanyUser();
modelUser = EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance().GetModel(userid);
if (modelUser != null)
{
string password = Utils.GetFormValue(txt_Password.UniqueID);
if (!string.IsNullOrEmpty(password))
{
modelUser.PassWordInfo.NoEncryptPassword = password;
}
modelUser.UserName = Utils.GetFormValue(txt_UserName.UniqueID);
modelUser.MqNickName = Utils.GetFormValue(txt_MQNickname.UniqueID);
modelUser.Job = Utils.GetFormValue(txt_Post.UniqueID);
modelUser.DepartId = Utils.GetFormValue(dropDepartment.UniqueID);
#region 个人会员联系信息
ContactPersonInfo ContactInfo = new ContactPersonInfo();
ContactInfo.ContactName = Utils.GetFormValue(txt_RealName.UniqueID);
ContactInfo.ContactSex = (Sex)Enum.Parse(typeof(Sex), Utils.GetFormValue(dropSex.UniqueID));
ContactInfo.Email = Utils.GetFormValue(txt_Email.UniqueID);
ContactInfo.Fax = Utils.GetFormValue(txt_Fax.UniqueID);
ContactInfo.Mobile = Utils.GetFormValue(txt_Mobile.UniqueID);
ContactInfo.MQ = Utils.GetFormValue(txt_MQ.UniqueID);
ContactInfo.MSN = Utils.GetFormValue(txt_MSN.UniqueID);
ContactInfo.QQ = Utils.GetFormValue(txt_QQ.UniqueID);
ContactInfo.Tel = Utils.GetFormValue(txt_tel.UniqueID);
#endregion
#region 线路区域
List <AreaBase> listArea = new List <AreaBase>();
foreach (string AreaId in Utils.GetFormValues("chbArea"))
{
AreaBase modelAreaBase = new AreaBase();
if (!string.IsNullOrEmpty(AreaId))
{
modelAreaBase.AreaId = Utils.GetInt(AreaId);
listArea.Add(modelAreaBase);
}
modelAreaBase = null;
}
modelUser.Area = listArea;
modelUser.RoleID = dropPermissions.SelectedValue;
#endregion
modelUser.ContactInfo = ContactInfo;
if (EyouSoft.BLL.CompanyStructure.CompanyUser.CreateInstance().UpdateChild(modelUser))
{
MessageBox.ShowAndRedirect(Page, "修改成功", "PersonalMemberList.aspx");
}
else
{
MessageBox.Show(Page, "修改失败");
}
}
}
public HttpResponseMessage RegisterCompanyUser([FromBody] CompanyUser user)
{
if (user != null)
{
//can be used to call client functions
var connection = GlobalHost.ConnectionManager.GetHubContext <CrossDomainHub>();
Utilities.PasswordManager mgr = new Utilities.PasswordManager();
SLW_DatabaseInfo db = new SLW_DatabaseInfo();
bool valid_user_type = false;
List <UserType> user_types = db.GetUserTypes();
for (int i = 0; i < user_types.Count; i++)
{
if (user_types[i].user_type == user.user_role)
{
valid_user_type = true;
break;
}
}
if (valid_user_type)
{
if (!db.CheckUserExist(user.username))
{
string source = "";
if (db.CheckLocalClientExist(user.clientId))
{
source = Commons.Constants.LOCAL_SOURCE;
}
else
{
source = Commons.Constants.ASMS_SOURCE;
}
string hash = mgr.GetHash(user.password);
user.user_type = "company";
int id = db.NewCompanyUser(user.username, user.first_name, user.last_name, DateTime.Now, user.user_role, user.user_type, DateTime.Now, (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue, hash, false, user.email, user.company, user.clientId, source);
db.SaveActivity(new UserActivity(user.username, Commons.Constants.ACTIVITY_CREATE_ACCOUNT, "", "", 0));
//Utilities.Email.Send(user.email, "New Account", "Your account was created sucessfully. Username: "******"");
return(Request.CreateResponse(HttpStatusCode.OK, id));
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "user exists"));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, "invalid user type"));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "bad request"));
}
}
public static CompanyUser Post(int companyId, int companyUserId, CompanyUser companyUser)
{
var existing = Get(companyId, companyUserId);
existing.FirstName = companyUser.FirstName;
existing.LastName = companyUser.LastName;
existing.Email = companyUser.Email;
return(existing);
}
public HttpResponseMessage UpdateCompanyUser(HttpRequestMessage request, [FromBody] CompanyUser companyUserModel)
{
return(GetHttpResponse(request, () =>
{
var companyUser = _CoreService.UpdateCompanyUser(companyUserModel);
return request.CreateResponse <CompanyUser>(HttpStatusCode.OK, companyUser);
}));
}
public async Task <IEnumerable <Advertisiment> > GetAdvertisimentsByUser(CompanyUser user)
{
var data = await _context.Advertisiments
.Include(x => x.CompanyUser)
.Where(x => x.CompanyId == user.Id)
.ToListAsync();
return(data);
}
public void SeedUserData()
{
byte[] saltedHashBytes = Encoding.UTF8.GetBytes("Secret123$" + "Korisnik");
HashAlgorithm algorithm = new SHA256Managed();
if (context.Users.Where(x => x.Identifier != Guid.Empty).Count() == 0 || context.CompanyUsers.Count() == 0)
{
if (context.Users.Count(x => x.Email == "*****@*****.**") == 0)
{
saltedHashBytes = Encoding.UTF8.GetBytes("Secret123$" + "Admin");
algorithm = new SHA256Managed();
byte[] hash = algorithm.ComputeHash(saltedHashBytes);
string password = Convert.ToBase64String(hash);
var userForDb = new User()
{
Identifier = Guid.NewGuid(),
Username = "******",
FirstName = "Petar",
LastName = "Petrovic",
PasswordHash = password,
Email = "*****@*****.**",
Active = true,
UpdatedAt = DateTime.Now,
CreatedAt = DateTime.Now
};
context.Users.Add(userForDb);
context.SaveChanges();
}
if (context.Users.FirstOrDefault(x => x.Email == "*****@*****.**").Identifier == Guid.Empty)
{
var user = context.Users.FirstOrDefault(x => x.Email == "*****@*****.**");
user.Identifier = Guid.NewGuid();
user.UpdatedAt = DateTime.Now;
context.SaveChanges();
}
if (context.CompanyUsers.Include(x => x.User).Where(x => x.Identifier != Guid.Empty && x.User.Identifier != Guid.Empty).Count() == 0)
{
if (context.CompanyUsers.Include(x => x.User).Count(x => x.User.Email == "*****@*****.**") == 0)
{
var companyUser = new CompanyUser()
{
Identifier = Guid.NewGuid(),
UserId = context.Users.FirstOrDefault(x => x.Email == "*****@*****.**")?.Id ?? null,
CompanyId = context.Companies.FirstOrDefault()?.Id,
RolesCSV = "Admin",
UpdatedAt = DateTime.Now,
Active = true
};
context.CompanyUsers.Add(companyUser);
context.SaveChanges();
}
}
}
}
public static Company createCompany(Container db, string title, User usr, bool isFakePublisherCompany) {
var compDb = new Company() { Title = title, Created = DateTime.UtcNow }; db.Companies.Add(compDb);
var dep = new CompanyDepartment() { Title = title, Company = compDb };
db.CompanyDepartments.Add(dep);
var compUser = new CompanyUser() { Created = DateTime.UtcNow, Company = compDb, User = usr, RolesEx = (long)(isFakePublisherCompany ? CompRole.All : CompRole.Admin), CompanyDepartment = dep };
db.CompanyUsers.Add(compUser);
if (isFakePublisherCompany) usr.MyPublisher = compDb;
return compDb;
}
static void SetUsers(CmdSetUsers dt) {
var db = Lib.CreateContext();
/************ Users *****************/
if (dt.Users != null && dt.Users.Length > 0) {
//LMComId > 0 => uprav existujiciho usera
var ids = dt.Users.Where(u => u.LMComId != 0).Select(u => u.LMComId).ToArray();
foreach (var usr in db.Users.Where(u => ids.Contains(u.Id)))
if (dt.Users.First(u => u.LMComId == usr.Id).Deleted) usr.Roles &= ~(long)Role.Comps; //deleted => zrus Comps roli
else usr.Roles |= (long)Role.Comps; //neni Deleted => nastav Comps roli
//LMComId == 0 => adjust usera
var emails = dt.Users.Where(u => u.LMComId == 0).Select(u => u.EMail).ToList(); //vsechny nove emaily
foreach (var usr in db.Users.Where(u => emails.Contains(u.EMail))) { //nacti existujici z DB
usr.Roles |= (long)Role.Comps; //nastav Comps roli
emails.Remove(usr.EMail); //vymaz z pozadovanych emailu
}
foreach (var em in emails) NewData.Login.PrepareUser(em, db, true); //compId nenalezen v DB => zaloz users v prepared stavu
}
Lib.SaveChanges(db);
List<int> deletedComps = new List<int>(); //evicence vymazanych companies, abych je v "Company User Roles" ignoroval
/************ Users *****************/
if (dt.Comps != null && dt.Comps.Length > 0) {
//new comps
var newComps = dt.Comps.Where(c => c.Id == 0);
var emails = newComps.Select(c => c.EMail).Where(c => c != null).ToArray();
var newUsers = db.Users.Where(u => emails.Contains(u.EMail));
//zaloz novou company (s primitivnim department) a ev. compUsera a Usera
foreach (var comp in newComps) {
var usr = newUsers.FirstOrDefault(u => u.EMail == comp.EMail);
if (usr == null) usr = NewData.Login.PrepareUser(comp.EMail, db); //zaloz users v prepared stavu
createCompany(db, comp.Title, usr, false);
//var compDb = new Company() { Title = comp.Title, Created = DateTime.UtcNow }; db.Users.Add(compDb);
//db.CompanyDepartments.Add(new CompanyDepartment() { Title = comp.Title, Company = compDb });
//var userObj = newUsers.FirstOrDefault(u => u.compId == comp.compId);
//if (userObj == null) userObj = NewData.Login.PrepareUser(comp.compId, db); //zaloz users v prepared stavu
//var compUser = new CompanyUser() { Created = DateTime.UtcNow, Company = compDb, User = userObj, Roles = (long)CompRole.Admin };
//db.CompanyUsers.Add(compUser);
}
//Uprav stavajici company
var ids = dt.Comps.Where(c => c.Id != 0).Select(c => c.Id).ToArray(); //compId's existujici companies
var compsDb = db.Companies.Where(c => ids.Contains(c.Id)).ToArray(); //nacti companies z DB
foreach (var comp in dt.Comps.Where(c => c.Id != 0)) {
var compDb = compsDb.First(c => c.Id == comp.Id); //aktualni comp v db
if (comp.Deleted) { deletedComps.Add(comp.Id); db.Companies.Remove(compDb); continue; } //delete company
compDb.Title = comp.Title; //aktualizuj //compDb.PublisherId = comp.PublisherId;
var old = dt.OldComps.First(c => c.Id == comp.Id); //najdi starou verzi
if (old.EMail != comp.EMail) {//User je zmeneny
//db.CompanyUsers.First(u => u.compId == old.email).Roles &= ~(long)CompRole.Admin; //zrus admina u old email
db.CompanyUsers.First(u => u.Id == old.UserId).RolesEx &= ~(long)CompRole.Admin; //zrus admina u old email
//adjust noveho admina
var usr = newUsers.FirstOrDefault(u => u.EMail == comp.EMail); //Zacni Userem
CompanyUser compUsr = null;
if (usr == null) usr = NewData.Login.PrepareUser(comp.EMail, db); //pro neexistujiciho zaloz usera v prepared stavu
else compUsr = usr.CompanyUsers.FirstOrDefault(cu => cu.CompanyId == comp.Id); //pro existujiciho usera nalezni Cmpany Usera
if (compUsr == null) compUsr = new CompanyUser() { Created = DateTime.UtcNow, Company = compDb, User = usr, RolesEx = (long)CompRole.Admin }; //Company User neexistuje => zaloz
//else compUsr.Roles |= (long)CompRole.Admin; //existuje, dej mu Admin roli
else compUsr.RolesEx |= (long)CompRole.Admin; //existuje, dej mu Admin roli
}
}
}
Lib.SaveChanges(db);
/************ Company User Roles *****************/
if (dt.CompUsers != null && dt.CompUsers.Length > 0) {
//kontrola companies, ktere byly mozna vymazany v predchozim kroku
CompUserItem[] actUsers = dt.CompUsers.Where(u => !deletedComps.Contains(u.CompanyId)).ToArray();
//Uprav stavajici users
var ids = actUsers.Where(u => u.UserId > 0).Select(u => u.UserId).ToArray();
var dbUsers = db.CompanyUsers.Where(u => ids.Contains(u.Id)).ToArray(); //nacti stavajicu users z DB
foreach (var dbUser in dbUsers) {
var usr = actUsers.First(u => u.UserId == dbUser.Id); //dato s novou verzi
var oldRoles = (CompRole)dbUser.Roles; var newRoles = usr.RoleEx.Role;
oldRoles = usr.Deleted ? oldRoles & CompRole.HumanEvalator : (oldRoles & CompRole.HumanEvalator) | newRoles;
dbUser.RolesEx = (long)oldRoles; //nastav novou roli
}
//Zaloz nove users
var emails = actUsers.Where(u => u.UserId == 0).Select(u => u.EMail).ToList(); //vsechny nove emaily
var newUsers = db.Users.Where(u => emails.Contains(u.EMail)).ToArray(); //existujici Users
foreach (var cusr in actUsers.Where(u => u.UserId == 0)) {
//adjust noveho admina
var usr = newUsers.FirstOrDefault(u => u.EMail == cusr.EMail); //Zacni Userem
CompanyUser compUsr = null;
if (usr == null) usr = NewData.Login.PrepareUser(cusr.EMail, db); //pro neexistujiciho zaloz usera v prepared stavu
else compUsr = usr.CompanyUsers.FirstOrDefault(cu => cu.CompanyId == cusr.CompanyId); //pro existujiciho usera nalezni Cmpany Usera
var newRoles = cusr.RoleEx.Role;
if (compUsr == null)
db.CompanyUsers.Add(compUsr = new CompanyUser() { Created = DateTime.UtcNow, CompanyId = cusr.CompanyId, User = usr, RoleParEx = cusr.RoleEx }); //Company User neexistuje => zaloz
else {
var oldRoles = (CompRole)compUsr.Roles;
newRoles |= oldRoles & CompRole.HumanEvalator;
compUsr.RolesEx = (long)newRoles;
}
}
}
Lib.SaveChanges(db);
}
