public int AddEmployee(Employee emp)
{
GetEmail checkemail = new GetEmail();
checkemail.Email = emp.EmpEmail;
try
{
if (this.IsEmailUnique(checkemail) == false)
{
Random rand = new Random((int)DateTime.Now.Ticks);
int numIterations = rand.Next(10000, 99999);
DateTime today = DateTime.Today;
emp.StartDate = today;
emp.RegisterCode = numIterations.ToString();
emp.PositionPId = "RC";
_context.Employees.Add(emp);
_context.SaveChanges();
return(numIterations);
}
return(0);
}
catch
{
return(0);
}
}
/// <summary>
/// if forgot password genarate new register code
/// </summary>
/// <param name="email"></param>
/// <returns> register code</returns>
public int ForgetPassword(string email)
{
try
{
GetEmail getEmail = new GetEmail();
getEmail.Email = email;
if (this.IsEmail(getEmail) == true)
{
Random rand = new Random((int)DateTime.Now.Ticks);
int regitercode = rand.Next(10000, 99999);
// Employee employee = new Employee();
// employee = GetEmployeeByEmail(email);
Employee employee = _context.Employees.Where(c => c.IsActive == true && c.EmpEmail == email).FirstOrDefault();
employee.RegisterCode = regitercode.ToString();
_context.Entry(employee).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(regitercode);
}
return(0);
}
catch
{
return(0);
}
}
public Boolean RegisterEmployee(RegisterActive reg)
{
try
{
GetEmail getEmail = new GetEmail();
getEmail.Email = reg.RegisterEmpEmail;
if (this.IsEmailUnique(getEmail) == false)
{
var data = _context.Employees
.Where(c => c.EmpEmail == reg.RegisterEmpEmail && c.RegisterCode == reg.RegisterCode)
.Select(c => c.EmpEmail)
.FirstOrDefault();
if (string.IsNullOrEmpty(data))
{
return(false);
}
else
{
var employee = _context.Employees.Where(c => c.EmpEmail == reg.RegisterEmpEmail && c.RegisterCode == reg.RegisterCode).FirstOrDefault();
employee.IsActive = true;
_context.Entry(employee).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
return(false);
} catch { return(false); }
}
/// <summary>
/// after forgot password update employee new password
/// </summary>
/// <param name="getEP"></param>
/// <returns> if success return true</returns>
public Boolean SetEmailAndPassword(GetEmailPassword getEP)
{
GetEmail getEmail = new GetEmail();
getEmail.Email = getEP.EmpEmail;
if (this.IsEmail(getEmail) == true)
{
Random rand = new Random((int)DateTime.Now.Ticks);
int numIterations = rand.Next(10000, 99999);
Employee employee = new Employee();
employee = _context.Employees
.Where(c => c.EmpEmail == getEP.EmpEmail && c.IsActive == true).FirstOrDefault();
if (employee.RegisterCode == getEP.Code)
{
employee.EmpPassword = getEP.EmpPassword;
employee.RegisterCode = numIterations.ToString();
_context.Entry(employee).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(true);
}
return(false);
}
return(false);
}
private void envoiEmailToolStripMenuItem_Click(object sender, EventArgs e)
{
// mailbox recupere le mail et appelle le reste de la fonction (sending_mail)
GetEmail mailbox = new GetEmail(this);
mailbox.Show();
}
public Boolean IsEmailUnique([FromBody] GetEmail email)
{
try
{
return(_service.IsEmailUnique(email));
}
catch
{
return(false);
}
}
public IActionResult IsEmailUnique([FromBody] GetEmail email)
{
try
{
var employee = _service.IsEmailUnique(email);
return(Ok(employee));
}
catch
{
return(BadRequest());
}
}
//SandEmail ticket, int mode = 0
protected void SendMail_BCOM(GetEmail Email)
{
string fnt1 = "<font size='5' face='Angsana New'>";
string fnt2 = "</font>";
//string url = global::System.Configuration.ConfigurationManager.AppSettings["Beauty.Host"].ToString();
try
{
MailMessage mail = new MailMessage();
mail.From = new MailAddress("*****@*****.**", "User");
mail.To.Add("*****@*****.**");
mail.Subject = "Information request from your website";
//if (devdetail.EMAIL != null && devdetail.EMAIL.Length > 10)
//{
// mail.To.Add(devdetail.EMAIL_CRE);
//}
//else{
// mail.Subject = "ปิด Ticket ! " + devdetail.TOPIC;
//}
mail.IsBodyHtml = true;
StringBuilder sb = new StringBuilder();
//url = url + "/Dev/DevDetail?DevId=" + devdetail.DV_ID.ToString();
sb.Append($"<br><b>{fnt1} มีผู้สมัครงานใหม่ !!{fnt2}</b><hr>");
sb.Append($"<br><strong>{fnt1}ชื่อ-นามสกุล</strong> : {Email.FULLNAME}{fnt2}"); //ชื่อ-นามสกุล
sb.Append($"<br><strong>{fnt1}อีเมลติดต่อ</strong> : {Email.EMAIL}{fnt2}"); //อีเมลติดต่อกลับ
sb.Append($"<br><strong>{fnt1}เบอร์ต่อต่อ</strong> : {Email.PHONE}{fnt2}"); //เบอร์ติดต่อ
sb.Append($"<br><strong>{fnt1}รายละเอียด</strong> : {Email.MESSAGE}{fnt2}"); //รายละเอียด
mail.Body = sb.ToString();
SmtpClient stmp = new SmtpClient();
stmp.Send(mail);
ViewBag.ErrorMessage = "Success";
}
catch (Exception ex)
{
ViewBag.ErrorMessage = ex.Message;
}
}
public ActionResult SandEmail_S(SandEmail mail)
{
GetEmail Email = new GetEmail();
Email.FULLNAME = mail.FULLNAME;
Email.EMAIL = mail.EMAIL;
Email.PHONE = mail.PHONE;
Email.MESSAGE = mail.MESSAGE;
SendMail(Email);
return(RedirectToAction("success", "Home"));
}
public Boolean IsEmail(GetEmail email)
{
var data = _context.Employees
.Where(c => c.EmpEmail == email.Email && c.IsActive == true)
.Select(c => c.EmpId)
.FirstOrDefault();
if (data != null)
{
return(true);
}
else
{
return(false);
}
}
//SandEmail ticket, int mode = 0
protected void SendMail(GetEmail Email)
{
string fnt1 = "<font size='5' face='Angsana New'>";
string fnt2 = "</font>";
//string url = global::System.Configuration.ConfigurationManager.AppSettings["Beauty.Host"].ToString();
try
{
MailMessage mail = new MailMessage();
mail.From = new MailAddress("*****@*****.**", "International Business");
mail.To.Add("*****@*****.**");
mail.Subject = "Inquiry BeautyCommunity";
mail.IsBodyHtml = true;
StringBuilder sb = new StringBuilder();
//url = url + "/Dev/DevDetail?DevId=" + devdetail.DV_ID.ToString();
sb.Append($"<br><b>{fnt1} มีผู้สมัครงานใหม่ !!{fnt2}</b><hr>");
sb.Append($"<br><strong>{fnt1}ชื่อ-นามสกุล</strong> : {Email.FULLNAME}{fnt2}"); //ชื่อ-นามสกุล
sb.Append($"<br><strong>{fnt1}อีเมลติดต่อ</strong> : {Email.EMAIL}{fnt2}"); //อีเมลติดต่อกลับ
sb.Append($"<br><strong>{fnt1}เบอร์ต่อต่อ</strong> : {Email.PHONE}{fnt2}"); //เบอร์ติดต่อ
sb.Append($"<br><strong>{fnt1}รายละเอียด</strong> : {Email.MESSAGE}{fnt2}"); //รายละเอียด
mail.Body = sb.ToString();
SmtpClient stmp = new SmtpClient();
stmp.Send(mail);
ViewBag.ErrorMessage = "Success";
}
catch (Exception ex)
{
ViewBag.ErrorMessage = ex.Message;
}
}
/// <summary>
/// check the email in the database
/// </summary>
/// <param name="email"></param>
/// <returns> true if email in table</returns>
public ViewEmployee IsEmailUnique(GetEmail email)
{
var data = _context.Employees
.Where(c => c.EmpEmail == email.Email)
.Select(c => c.IsActive)
.FirstOrDefault();
var employee = _context.Employees.Where(c => c.EmpEmail == email.Email).Select(c => new ViewEmployee {
EmpEmail = c.EmpEmail, EmpName = c.EmpName, EmpProfilePicture = c.EmpProfilePicture
}).FirstOrDefault();
if (data)
{
return(employee);
}
else
{
return(employee);
}
}
public int ForgetPassword(string email)
{
try {
GetEmail getEmail = new GetEmail();
getEmail.Email = email;
if (this.IsEmailUnique(getEmail) == true)
{
Random rand = new Random((int)DateTime.Now.Ticks);
int numIterations = rand.Next(10000, 99999);
Employee employee = new Employee();
employee = GetEmployeeByEmail(email);
employee.RegisterCode = numIterations.ToString();
UpdateEmployee(employee);
return(numIterations);
}
return(0);
} catch {
return(0);
}
}
public async Task <ActionResult> AddEmails([FromBody] GetEmail x)
{
var applist = await db.Emails.Where(m => m.Application == x.Application).Select(m => m.Application).FirstOrDefaultAsync();
if (applist != x.Application && x.Application != null)
{
db.Emails.Add(new Emails {
Application = x.Application,
Email_1 = x.Email_1,
Email_2 = x.Email_2,
Email_3 = x.Email_3,
Enable = x.Enable
});
await db.SaveChangesAsync();
return(Ok());
}
else
{
return(BadRequest());
}
}
public Boolean SetEmailAndPassword(GetEmailPassword getEP)
{
GetEmail getEmail = new GetEmail();
getEmail.Email = getEP.EmpEmail;
if (this.IsEmailUnique(getEmail) == true)
{
Random rand = new Random((int)DateTime.Now.Ticks);
int numIterations = rand.Next(10000, 99999);
Employee employee = new Employee();
employee = GetEmployeeByEmail(getEP.EmpEmail);
if (employee.RegisterCode == getEP.Code)
{
employee.EmpPassword = getEP.EmpPassword;
employee.RegisterCode = numIterations.ToString();
UpdateEmployee(employee);
return(true);
}
return(false);
}
return(false);
}
/// <summary>
/// register employee using regiter code
/// </summary>
/// <param name="reg"></param>
/// <returns> if success return true</returns>
public Boolean RegisterEmployee(RegisterActive reg)
{
try
{
GetEmail getEmail = new GetEmail();
getEmail.Email = reg.RegisterEmpEmail;
if (this.IsEmail(getEmail) == false)
{
var data = _context.Employees
.Where(c => c.EmpEmail == reg.RegisterEmpEmail && c.RegisterCode == reg.RegisterCode)
.Select(c => c.EmpEmail)
.FirstOrDefault();
if (string.IsNullOrEmpty(data))
{
return(false);
}
else
{
//create new random number for register code
Random rand = new Random((int)DateTime.Now.Ticks);
int regitercode = rand.Next(10000, 99999);
var employee = _context.Employees.Where(c => c.EmpEmail == reg.RegisterEmpEmail && c.RegisterCode == reg.RegisterCode).FirstOrDefault();
employee.IsActive = true;
employee.RegisterCode = regitercode.ToString();
_context.Entry(employee).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(true);
}
}
return(false);
}
catch { return(false); }
}
/// <summary>
/// login by email
/// </summary>
/// <param name="log"></param>
/// <returns>if login success return true</returns>
public Boolean LoginEmail(LoginEmail log)
{
GetEmail getEmail = new GetEmail();
getEmail.Email = log.EmpEmail;
if (this.IsEmail(getEmail))
{
var data = _context.Employees
.Where(c => c.EmpEmail == log.EmpEmail && c.EmpPassword == log.EmpPassword)
.Select(c => c.EmpId)
.FirstOrDefault();
if (string.IsNullOrEmpty(data))
{
return(false);
}
else
{
return(true);
}
}
return(false);
}
public async Task <ActionResult> UpdateEmail([FromBody] GetEmail Mail)
{
var applist = await db.Emails.Where(m => m.Application == Mail.Application).Select(m => m.Application).FirstOrDefaultAsync();
if (applist == Mail.Application)
{
var value = await db.Emails.Where(o => o.Application == Mail.Application).ToListAsync();
foreach (var data in value)
{
data.Email_1 = Mail.Email_1;
data.Email_2 = Mail.Email_2;
data.Email_3 = Mail.Email_3;
data.Enable = Mail.Enable;
}
await db.SaveChangesAsync();
return(Ok());
}
else
{
return(BadRequest());
}
}
/// <summary>
/// add a employee to employee table
/// </summary>
/// <param name="employee"></param>
/// <returns>return register code</returns>
public int AddEmployee(Employee employee)
{
GetEmail checkemail = new GetEmail();
checkemail.Email = employee.EmpEmail;
try
{
if (this.IsEmail(checkemail) == false)
{
//create a random number for register employee
Random rand = new Random((int)DateTime.Now.Ticks);
int regitercode = rand.Next(10000, 99999);
//generate today date
DateTime today = DateTime.Today;
employee.StartDate = today;
employee.LastUpdate = today;
employee.RegisterCode = regitercode.ToString();
var count = _context.Employees.Where(c => c.IsActive == true && c.PositionPId == "AD").Count();
if (count == 0)
{
var countAD = _context.Positions.Where(c => c.PositionId == "AD").Count();
if (countAD == 0)
{
Position positionUser = new Position();
positionUser.PositionId = "AD";
positionUser.PositionName = "Admin";
_context.Positions.Add(positionUser);
_context.SaveChanges();
}
var countuser = _context.Positions.Where(c => c.PositionId == "User").Count();
if (countuser == 0)
{
Position positionUser = new Position();
positionUser.PositionId = "User";
positionUser.PositionName = "User";
_context.Positions.Add(positionUser);
_context.SaveChanges();
}
var countproject = _context.Projects.Count();
if (countproject == 0)
{
Project project = new Project();
project.IsActive = true;
project.ProjectName = "No Project";
_context.Projects.Add(project);
_context.SaveChanges();
}
var countdepartment = _context.Departments.Count();
if (countdepartment == 0)
{
Department department = new Department();
department.DprtId = "No";
department.DprtName = "No Department";
_context.Departments.Add(department);
_context.SaveChanges();
}
employee.DepartmentDprtId = "No";
employee.ProjectPrId = 1;
employee.PositionPId = "AD";
}
else
{
if (employee.ProjectPrId == null)
{
employee.ProjectPrId = 1;
}
if (employee.DepartmentDprtId == null)
{
employee.DepartmentDprtId = "No";
}
employee.PositionPId = "User";
}
_context.Employees.Add(employee);
_context.SaveChanges();
//return register code after signup
return(regitercode);
}
//if did not unique email return 0
return(0);
}
catch
{
return(0);
}
}
public Boolean IsEmailUnique(GetEmail email)
{
return(_service.IsEmailUnique(email));
}
public ViewEmployee IsEmailUnique(GetEmail email)
{
return(_service.IsEmailUnique(email));
}
