public async Task <string> CreateNewUserAsync(EmployeeDTO ADUser)
{
try
{
Employee user = new Employee();
EmployeeProfile employeeProfile = Context.EmployeeProfile.Where(x => x.Empcode == ADUser.Empcode).FirstOrDefault();
DbPosition dbPosition = Context.DbPosition.Where(x => x.PositionName == ADUser.Position).FirstOrDefault();
user.Empcode = ADUser.Empcode;
user.Username = ADUser.Username;
user.Passwordsalt = EncryptionService.GeneratePasswordSalt();
user.Password = EncryptionService.HashToMD5(ADUser.Password + user.Passwordsalt);
user.Active = true;
user.CrBy = "LDAP";
user.CrDate = DateTime.Now;
Context.Employee.Add(user);
Context.SaveChanges();
if (employeeProfile == null)
{
employeeProfile.Empcode = ADUser.Empcode;
employeeProfile.FirstnameTh = ADUser.FirstnameEn;
employeeProfile.LastnameEn = ADUser.LastnameEn;
employeeProfile.Tel = ADUser.Tel;
employeeProfile.Email = ADUser.Email;
employeeProfile.Position = ADUser.Position;
if (dbPosition != null)
{
employeeProfile.PositionCode = dbPosition.PositonCode;
}
Context.EmployeeProfile.Add(employeeProfile);
Context.SaveChanges();
}
//TOKEN
tokens.empCode = ADUser.Empcode;
tokens.Username = ADUser.Username;
tokens.Firstname = ADUser.FirstnameEn;
tokens.Lastname = ADUser.LastnameEn;
tokens.PositionCode = dbPosition.PositonCode;
tokens.Token = GenerateToken(user.Empcode);
return(user.Empcode);
}
catch (Exception ex)
{
throw ex;
}
}
public void Mockdata()
{
foreach (var entity in Context.RunningType)
{
Context.RunningType.Remove(entity);
}
Context.SaveChanges();
Context.RunningType.Add(new RunningType()
{
Code = "01",
Name = "Username",
RunningNoFormat = "{0}{1}{2}{3}{4}{5}{6}{7}{8}{9}[RUNNING]",
RunningNoDigit = 8,
Active = true,
CreatedBy = "System",
CreatedDate = DateTime.Parse("5/1/2008 8:30:52 AM", System.Globalization.CultureInfo.InvariantCulture)
});
Context.SaveChanges();
}
public void MockDataToDB()
{
foreach (var entity in Context.Authentication)
{
Context.Authentication.Remove(entity);
}
Context.SaveChanges();
Context.Authentication.Add(new Authentication()
{
Username = "******",
Password = "******",//password = test
PasswordSalt = "test",
Firstname = "test",
Lastname = "test",
Email = "*****@*****.**",
Active = true,
FailTime = 0,
PasswordExpiryDate = DateTime.Now.AddYears(1),
SystemCode = "US00000001",
CreatedBy = "System",
CreatedDate = DateTime.Parse("5/1/2008 8:30:52 AM", System.Globalization.CultureInfo.InvariantCulture)
});
Context.SaveChanges();
}
public string CreateRunningType(RuRunningType RunningType)
{
try
{
RuRunningType runningType = new RuRunningType();
runningType.Code = RunningType.Code;
runningType.Name = RunningType.Name;
runningType.RunningNoFormat = "{0}{1}{2}{3}{4}{5}{6}{7}{8}{9}[RUNNING]";
runningType.RunningNoDigit = RunningType.RunningNoDigit;
runningType.Active = true;
runningType.CreatedBy = "System";
runningType.CreatedDate = DateTime.Now;
Context.RuRunningType.Add(runningType);
Context.SaveChanges();
return(runningType.Code);
}
catch (Exception ex) {
throw ex;
}
}
public RuRunningNo CreateRunningNo(RuRunningType runningType, params string[] parameter)
{
int Count = parameter.Length;
RuRunningNo CreateRunning = new RuRunningNo();
CreateRunning.RunningTypeCode = runningType.Code;
if (Count > 0 && Count <= parameter.Length)
{
if (Count >= 1)
{
if (!string.IsNullOrWhiteSpace(parameter[0]))
{
CreateRunning.Parameter1 = parameter[0];
}
}
if (Count >= 2)
{
if (!string.IsNullOrWhiteSpace(parameter[1]))
{
CreateRunning.Parameter2 = parameter[1];
}
}
if (Count >= 3)
{
if (!string.IsNullOrWhiteSpace(parameter[2]))
{
CreateRunning.Parameter3 = parameter[2];
}
}
if (Count >= 4)
{
if (!string.IsNullOrWhiteSpace(parameter[3]))
{
CreateRunning.Parameter4 = parameter[3];
}
}
if (Count >= 5)
{
if (!string.IsNullOrWhiteSpace(parameter[4]))
{
CreateRunning.Parameter5 = parameter[4];
}
}
if (Count >= 6)
{
if (!string.IsNullOrWhiteSpace(parameter[5]))
{
CreateRunning.Parameter6 = parameter[5];
}
}
if (Count >= 7)
{
if (!string.IsNullOrWhiteSpace(parameter[6]))
{
CreateRunning.Parameter7 = parameter[6];
}
}
if (Count >= 8)
{
if (!string.IsNullOrWhiteSpace(parameter[7]))
{
CreateRunning.Parameter8 = parameter[7];
}
}
if (Count >= 9)
{
if (!string.IsNullOrWhiteSpace(parameter[8]))
{
CreateRunning.Parameter9 = parameter[8];
}
}
if (Count >= 10)
{
if (!string.IsNullOrWhiteSpace(parameter[9]))
{
CreateRunning.Parameter10 = parameter[9];
}
}
}
CreateRunning.RunningNo = 0;
CreateRunning.Active = true;
CreateRunning.CreatedBy = "Ru";
CreateRunning.CreatedDate = DateTime.Now;
Context.RuRunningNo.Add(CreateRunning);
Context.SaveChanges();
return(CreateRunning);
}
