private void btnSave_Click(object sender, EventArgs e)
{
if (!isUpdate)
{
if (txtName.Text.Trim() == "")
{
MessageBox.Show("You miss the User Name");
}
else if (txtPassword.Text.Trim() == "")
{
MessageBox.Show("You miss the Password");
}
else if (txtUser.Text.Trim() == "")
{
MessageBox.Show("You miss the User Number");
}
else if (txtSurname.Text.Trim() == "")
{
MessageBox.Show("You miss the Surname");
}
else if (cmbPermission.SelectedIndex == -1)
{
MessageBox.Show("You miss the Permission");
}
else
{
EmployeeDetailDTO employee = new EmployeeDetailDTO();
employee.Name = txtName.Text;
employee.UserNumer = Convert.ToInt32(txtUser.Text);
employee.Surname = txtSurname.Text;
employee.Password = txtPassword.Text;
employee.Permission = Convert.ToInt32(cmbPermission.SelectedValue);
if (bll.Insert(employee))
{
MessageBox.Show("User was added");
CleanAll();
}
}
}
else
{
if (cmbPermission.SelectedIndex == detail.Permission - 1)
{
MessageBox.Show("You must change the permission type");
}
else
{
detail.Permission = Convert.ToInt32(cmbPermission.SelectedValue);
if (bll.Update(detail))
{
MessageBox.Show("User was updated");
this.Close();
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtUserNo.Text.Trim() == "")
{
MessageBox.Show("Enter the User number");
}
else if (txtPass.Text.Trim() == "")
{
MessageBox.Show("Enter the Password number");
}
else
{
List <EmployeeDetailDTO> list = new EmployeeBLL().Get(Convert.ToInt32(txtUserNo.Text), txtPass.Text);
if (list.Count == 0)
{
MessageBox.Show("The user or the password are wrong");
}
else
{
EmployeeDetailDTO emp = new EmployeeDetailDTO();
emp = list.First();
isUser.Permissison = emp.Permission;
FrmMain frm = new FrmMain();
this.Hide();
frm.ShowDialog();
}
}
}
public void Add(EmployeeDetailDTO item)
{
List <string> users = new List <string>();
users = new SecurityHelper().GetAllUsernames();
users = users.Where(u => u.Equals(item.Username)).ToList <string>();
if (users.Count > 0)
{
throw new Exception("This username already exists.");
}
else
{
string password = Membership.GeneratePassword(12, 1);
WebSecurity.CreateUserAndAccount(item.Username, password);
MailMessage message = new MailMessage();
message.From = new MailAddress("*****@*****.**");
message.To.Add(new MailAddress(item.Email));
message.Subject = "LinkTracker Account Created";
message.Body = "" + password;
SmtpClient client = new SmtpClient();
client.Send(message);
Roles.AddUserToRole(item.Username, "Employee");
repo.Add(item);
}
}
// GET: Employees/Details/5
public ActionResult Details(string id)
{
EmployeeDetailDTO dto = new EmployeeDetailDTO();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employee employee = db.Employees.Find(id);
if (employee == null)
{
return(HttpNotFound());
}
dto.employee = employee;
var skilllist = db.EmployeeSkillDetails.Where(x => x.Employee == employee.MSAlias).ToList();
var technicalSkillList = skilllist.Where(x => x.Type == "Technical").OrderBy(o => o.Date).ToList();
dto.TechnicalSkillList = technicalSkillList;
var languageSkillList = skilllist.Where(x => x.Type == "Language").OrderBy(o => o.Date).ToList();
dto.LanguageSkillList = languageSkillList;
var otherSkillList = skilllist.Where(x => x.Type == "Other").OrderBy(o => o.Date).ToList();
dto.OtherSkillList = otherSkillList;
return(View(dto));
}
public EmployeeDetailDTO newEmployeeDetail(EmployeeDetailDTO employeeDetail)
{
var added = MapperFactory.CurrentMapper.Map <EmployeeDetail>(employeeDetail);
added = uow.GetRepository <EmployeeDetail>().Add(added);
uow.SaveChanges();
return(MapperFactory.CurrentMapper.Map <EmployeeDetailDTO>(added));
}
public EmployeeDetailDTO updateEmployeeDetail(EmployeeDetailDTO employeeDetail)
{
var selectedEmployeeDetail = uow.GetRepository <EmployeeDetail>().Get(z => z.Id == employeeDetail.Id);
selectedEmployeeDetail = MapperFactory.CurrentMapper.Map(employeeDetail, selectedEmployeeDetail);
uow.GetRepository <EmployeeDetail>().Update(selectedEmployeeDetail);
uow.SaveChanges();
return(MapperFactory.CurrentMapper.Map <EmployeeDetailDTO>(selectedEmployeeDetail));
}
public HttpResponseMessage Get(int Id)
{
EmployeeDetailDTO selectedTitle = service.getEmployeeDetail(Id);
if (selectedTitle == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Id + sysLanguage.CompanyTitlesControllerStrings.id_title));
}
return(Request.CreateResponse(HttpStatusCode.OK, selectedTitle));
}
private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
{
detail = new EmployeeDetailDTO();
detail.ID = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
detail.UserNumer = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[1].Value);
detail.Name = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
detail.Surname = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
detail.Password = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
detail.Permission = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[5].Value);
}
public void Delete(EmployeeDetailDTO employee)
{
foreach (string r in Roles.GetRolesForUser(employee.Username))
{
Roles.RemoveUserFromRole(employee.Username, r);
}
Membership.DeleteUser(employee.Username);
repo.DeleteEmployee(employee);
}
public EmployeeDetailDTO newEmployeeDetail(EmployeeDetailDTO employeeDetail)
{
if (!uow.GetRepository <EmployeeDetail>().GetAll().Any(z => z.Id == 1))
{
var adedEmployeeDetail = MapperFactory.CurrentMapper.Map <EmployeeDetail>(employeeDetail);
adedEmployeeDetail = uow.GetRepository <EmployeeDetail>().Add(adedEmployeeDetail);
uow.SaveChanges();
return(MapperFactory.CurrentMapper.Map <EmployeeDetailDTO>(adedEmployeeDetail));
}
else
{
return(null);
}
}
public static List <EmployeeDetailDTO> GetEmployees()
{
List <EmployeeDetailDTO> employeeList = new List <EmployeeDetailDTO>();
var list = (from e in db.EMPLOYEEs
join d in db.DEPARTMENTs on e.DepartmentID equals d.ID
join p in db.POSITIONs on e.PositionID equals p.ID
select new
{
UserNo = e.UserNo,
Name = e.Name,
Surname = e.Surname,
EmployeeID = e.ID,
Password = e.Password,
DepartmentName = d.DepartmentName,
PositionName = p.PositionName,
DepartmentID = e.DepartmentID,
PositionId = e.PositionID,
isAdmin = e.isAdmin,
Salary = e.Salary,
ImagePath = e.ImagePath,
birthDay = e.BirthDay,
Adress = e.Adress
}).OrderBy(x => x.UserNo).ToList();
foreach (var item in list)
{
EmployeeDetailDTO dto = new EmployeeDetailDTO();
dto.Name = item.Name;
dto.UserNo = item.UserNo;
dto.Surname = item.Surname;
dto.EmployeeID = item.EmployeeID;
dto.Password = item.Password;
dto.DepartmentID = item.DepartmentID;
dto.DepartmentName = item.DepartmentName;
dto.PositionID = item.PositionId;
dto.PositionName = item.PositionName;
dto.isAdmin = item.isAdmin;
dto.Salary = item.Salary;
dto.BhirtDay = item.birthDay;
dto.Adress = item.Adress;
dto.ImagePath = item.ImagePath;
employeeList.Add(dto);
}
return(employeeList);
}
public EmployeeDetailDTO updateEmployeeDetail(EmployeeDetailDTO employeeDetail)
{
var selectedEmployeeDetail = uow.GetRepository <EmployeeDetail>().Get(z => z.Id == employeeDetail.Id);
selectedEmployeeDetail = MapperFactory.CurrentMapper.Map(employeeDetail, selectedEmployeeDetail);
uow.GetRepository <EmployeeDetail>().Update(selectedEmployeeDetail);
selectedEmployeeDetail.EmployeeID = employeeDetail.EmployeeID;
selectedEmployeeDetail.BloodGroupID = employeeDetail.BloodGroupID;
selectedEmployeeDetail.DisabilitySituationID = employeeDetail.DisabilitySituationID;
selectedEmployeeDetail.EducationLevelID = employeeDetail.EducationLevelID;
selectedEmployeeDetail.EducationStatusID = employeeDetail.EducationStatusID;
selectedEmployeeDetail.GenderID = employeeDetail.GenderID;
selectedEmployeeDetail.MaritalStatusID = employeeDetail.MaritalStatusID;
uow.GetRepository <EmployeeDetail>().Update(selectedEmployeeDetail);
uow.SaveChanges();
return(MapperFactory.CurrentMapper.Map <EmployeeDetailDTO>(selectedEmployeeDetail));
}
public HttpResponseMessage Put(EmployeeDetailDTO accessTypeDTO)
{
try
{
EmployeeDetailDTO dto = service.updateEmployeeDetail(accessTypeDTO);
if (dto != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, dto));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.SeeOther, sysLanguage.CompanyTitlesControllerStrings.update_title));
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.SeeOther, sysLanguage.CompanyTitlesControllerStrings.update_title));
}
}
public void Add(EmployeeDetailDTO item)
{
p1p.Data.Employee mdlEmployee = (p1p.Data.Employee)P1PObjectMapper.Convert(item, typeof(p1p.Data.Employee));
mdlEmployee.InsertDate = DateTime.Now;
using (p1p.Data.P1PContext ctx = new p1p.Data.P1PContext())
{
if (item.Team.Id != 0)
{
ctx.EmployeeTeamXREFs.Add(new EmployeeTeamXREF()
{
EmployeeId = item.Id,
TeamId = item.Team.Id,
InsertDate = DateTime.Now
});
}
ctx.Employees.Add(mdlEmployee);
ctx.SaveChanges();
}
}
public HttpResponseMessage Post(EmployeeDetailDTO accessTypeDTO)
{
try
{
EmployeeDetailDTO dto = service.newEmployeeDetail(accessTypeDTO);
if (dto != null)
{
HttpResponseMessage message = Request.CreateResponse(HttpStatusCode.Created, dto);
message.Headers.Location = new Uri(Request.RequestUri + "/" + dto.Id);
return(message);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.SeeOther, sysLanguage.CompanyTitlesControllerStrings.add_title));
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.SeeOther, sysLanguage.CompanyTitlesControllerStrings.add_title));
}
}
private void btnEmployee_Click(object sender, EventArgs e)
{
if (!UserStatic.isAdmin)
{
EmployeeDTO dto = EmployeeBLL.GetAll();
EmployeeDetailDTO detail = dto.Employees.First(x => x.EmployeeID == UserStatic.EmployeeID);
FrmEmployee frm = new FrmEmployee();
frm.detail = detail;
frm.isUpdate = true;
this.Hide();
frm.ShowDialog();
this.Visible = true;
}
else
{
FrmEmployeeList frm = new FrmEmployeeList();
this.Hide();
frm.ShowDialog();
this.Visible = true;
}
}
public void Update(EmployeeDetailDTO item)
{
p1p.Data.Employee mdlEmployee = (p1p.Data.Employee)P1PObjectMapper.Convert(item, typeof(p1p.Data.Employee));
p1p.Data.Employee match;
using (p1p.Data.P1PContext ctx = new p1p.Data.P1PContext())
{
if (item.Team != null && item.Team.Id != 0)
{
EmployeeTeamXREF xref = ctx.EmployeeTeamXREFs.FirstOrDefault(x => x.EmployeeId == item.Id);
if (xref != null)
{
if (xref.TeamId != item.Team.Id)
{
ctx.EmployeeTeamXREFs.Remove(xref);
ctx.EmployeeTeamXREFs.Add(new EmployeeTeamXREF()
{
EmployeeId = item.Id,
TeamId = item.Team.Id,
InsertDate = DateTime.Now
});
ctx.SaveChanges();
}
}
else
{
ctx.EmployeeTeamXREFs.Add(new EmployeeTeamXREF()
{
EmployeeId = item.Id,
TeamId = item.Team.Id,
InsertDate = DateTime.Now
});
ctx.SaveChanges();
}
}
match = ctx.Employees.Single(c => item.Id == c.Id);
ctx.Entry(match).CurrentValues.SetValues(mdlEmployee);
ctx.SaveChanges();
}
}
public void DeleteEmployee(EmployeeDetailDTO employee)
{
using (p1p.Data.P1PContext ctx = new p1p.Data.P1PContext())
{
var employeeToRm = ctx.Employees.Single(a => a.Id == employee.Id);
ctx.Employees.Remove(employeeToRm);
var teamXrfs = ctx.EmployeeTeamXREFs.Where(x => x.EmployeeId == employee.Id);
foreach (var x in teamXrfs)
{
ctx.EmployeeTeamXREFs.Remove(x);
}
var projXrfs = ctx.OrderEmployeeXREFs.Where(x => x.EmployeeId == employee.Id);
foreach (var x in projXrfs)
{
ctx.OrderEmployeeXREFs.Remove(x);
}
ctx.SaveChanges();
}
}
public void Update(EmployeeDetailDTO employee)
{
repo.Update(employee);
}
public static EmployeeDetail ToEmployeeDetailDomain(EmployeeDetailDTO employeeDetail)
{
return(AutoMapper.Mapper.Map <EmployeeDetailDTO, EmployeeDetail>(employeeDetail));
}
