// insert register into employee table
private void insertEmployee()
{
tblEmployee = adpEmployee.GetData();
Cache["tblEmployee"] = tblEmployee;
string name = txtName.Text;
string address = txtAddress.Text;
string city = txtCity.Text;
string province = ddlProvinceE.SelectedValue;
string zipcode = txtZipcode.Text;
decimal homephone = decimal.Parse(txtHomePhone.Text);
decimal cellphone = decimal.Parse(txtCellPhone.Text);
string email = txtEmail.Text;
//Treat DOB
string year = ddlDOBY.SelectedValue;
string month = ddlDOBM.SelectedValue;
string day = ddlDOBD.SelectedValue;
string dobTemp = year + "-" + month + "-" + day;
DateTime dob = DateTime.Parse(dobTemp);
int dept = int.Parse(ddlDept.SelectedValue);
int title = int.Parse(ddlTitle.SelectedValue);
decimal salary = decimal.Parse(txtSalary.Text);
//Treat startDate
string syear = ddlStartdty.SelectedValue;
string smonth = ddlStartdtm.SelectedValue;
string sday = ddlStartdtd.SelectedValue;
string startTemp = syear + "-" + smonth + "-" + sday;
DateTime startdate = DateTime.Parse(startTemp);
string gender = "";
if (rdbGender.SelectedIndex == 1)
{
gender = "F";
}
else if (rdbGender.SelectedIndex == 2)
{
gender = "O";
}
else
{
gender = "M";
}
int result = adpEmployee.Insert(name, address, city, province, zipcode, homephone, cellphone, email, dob, gender, dept, title, startdate, salary, "A");
if (result == 1)
{
clearFields();
resetFields();
lblErrorMessage.Text = "Employee Inserted ";
lblErrorMessage.ForeColor = System.Drawing.Color.Yellow;
insertPassword();
}
else
{
lblErrorMessage.Text = "Employee NOT Inserted";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
}
// GET: Employee/Delete/5
public ActionResult Delete(TableEmployee employee)
{
var d = obj.TableEmployees.Where(x => x.ID == employee.ID).FirstOrDefault();
obj.TableEmployees.Remove(d);
obj.SaveChanges();
return(RedirectToAction("EmployeeList"));
}
// GET: Employees/Create
public IActionResult Create()
{
var emp = new TableEmployee
{
StoreId = int.Parse(User.FindFirst(ClaimTypes.NameIdentifier).Value)
};
return(View(emp));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,FirstName,LastName,TelephoneNumber,DefaultAnnotation,Active,Image,StoreId")]
TableEmployee tableEmployee, IFormFile picture)
{
if (id != tableEmployee.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
if (tableEmployee.StoreId != int.Parse(User.FindFirst(ClaimTypes.NameIdentifier).Value))
{
return(Forbid());
}
var tempImage = _context.TblEmployees.AsNoTracking().FirstOrDefault(a => a.Id == tableEmployee.Id).Image;
tableEmployee.Image = CreateImage(picture);
if (tableEmployee.Image == null)
{
tableEmployee.Image = tempImage;
}
if (!String.IsNullOrEmpty(tableEmployee.TelephoneNumber))
{
string outPhoneNumber;
var a = ValidationHelper.ProoveValidPhoneNumber(tableEmployee.TelephoneNumber, out outPhoneNumber);
//TODO: Meldung wenn nicht passt
tableEmployee.TelephoneNumber = outPhoneNumber;
}
_context.Update(tableEmployee);
await _context.SaveChangesAsync();
TempData["message"] = "Daten erfolgreich gespeichert";
return(RedirectToAction("Employees", "Stores"));
}
catch (DbUpdateConcurrencyException)
{
ViewData["message"] = "Daten erfolgreich gespeichert";
//if (!TableEmployeeExists(tableEmployee.Id))
//{
// return NotFound();
//}
//else
//{
// throw;
//}
}
}
return(View(tableEmployee));
}
public ActionResult Create([Bind(Exclude = "id")] TableEmployee employee)
{
if (!ModelState.IsValid)
{
return(View());
}
obj.TableEmployees.Add(employee);
obj.SaveChanges();
return(RedirectToAction("EmployeeList"));
}
public async Task <IActionResult> Create([Bind("Id,FirstName,LastName,TelephoneNumber,DefaultAnnotation,Active,Image,StoreId")]
TableEmployee tableEmployee, IFormFile picture)
{
if (ModelState.IsValid)
{
try
{
if (tableEmployee.StoreId != int.Parse(User.FindFirst(ClaimTypes.NameIdentifier).Value))
{
return(Forbid());
}
if (_context.TblEmployees.Count(a => a.StoreId == tableEmployee.StoreId) >= 1)
{
TempData["message"] = "Zur Zeit kann nur ein Mitarbeiter angelegt werden!";
return(RedirectToAction("Employees", "Stores"));
}
tableEmployee.Image = CreateImage(picture);
var storeId = int.Parse(User.FindFirst(ClaimTypes.NameIdentifier).Value);
//Zuweisung zu SecondaryLocation!
var sec = await _context.TblLocations.FirstOrDefaultAsync(a => a.StoreId == storeId);
sec.TblLocationEmployee = new List <TableLocationEmployee>();
sec.TblLocationEmployee.Add(new TableLocationEmployee
{
TblEmployee = tableEmployee
});
//tableEmployee.TblSecondaryLocation = new List<TableSecondaryLocation>();
//tableEmployee.TblSecondaryLocation.Add(sec);
if (!String.IsNullOrEmpty(tableEmployee.TelephoneNumber))
{
string outPhoneNumber;
var a = ValidationHelper.ProoveValidPhoneNumber(tableEmployee.TelephoneNumber, out outPhoneNumber);
//TODO: Meldung wenn nicht passt
tableEmployee.TelephoneNumber = outPhoneNumber;
}
_context.Add(tableEmployee);
await _context.SaveChangesAsync();
TempData["message"] = "Daten erfolgreich gespeichert";
return(RedirectToAction("Employees", "Stores"));
}
catch (Exception)
{
ViewData["message"] = "Daten konnten nicht gespeichert werden!";
}
}
return(View(tableEmployee));
}
public ActionResult Edit(TableEmployee employee)
{
var orignalRecord = (from m in obj.TableEmployees where m.ID == employee.ID select m).First();
if (!ModelState.IsValid)
{
return(View(orignalRecord));
}
obj.Entry(orignalRecord).CurrentValues.SetValues(employee);
obj.SaveChanges();
return(RedirectToAction("EmployeeList"));
}
// Load fields From Employee Table
private void loadFields()
{
int id = int.Parse(txtEmployeeNumber.Text);
tblEmployee = adpEmployee.GetDataBy(id);
Cache["tblEmployee"] = tblEmployee;
var row = tblEmployee;
if (row.Count > 0)
{
if (row != null)
{
txtName.Text = row[0].EmployeeName.ToString();
txtAddress.Text = row[0].EmployeeAddress.ToString();
txtCity.Text = row[0].EmployeeCity.ToString();
txtZipcode.Text = row[0].EmployeeZipCode.ToString();
txtHomePhone.Text = row[0].EmployeeHomePhone.ToString();
txtCellPhone.Text = row[0].EmployeeCellPhone.ToString();
txtEmail.Text = row[0].EmployeeEmail.ToString();
txtSalary.Text = row[0].EmployeeSalary.ToString();
selectGender(row[0].EmployeeGender.ToString());
selectProvince(row[0].EmployeeProvince.ToString());
selectDepartment(row[0].EmployeeDepartmentID.ToString());
loadJobTitle();
selectJobTitle(row[0].EmployeeJobTitleId.ToString());
loadDOB(row[0].EmployeeDOB);
loadStartDate(row[0].EmployeeStartDate);
if (row[0].EmployeeStatus.ToString() == "A")
{
rdbStatus.SelectedIndex = 0;
}
else
{
rdbStatus.SelectedIndex = 1;
}
}
else
{
clearFields();
lblErrorMessage.Text = "Employee with ID " + id + " is not found";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
}
else
{
clearFields();
lblErrorMessage.Text = " Employee with ID " + id + " is not found";
lblErrorMessage.ForeColor = System.Drawing.Color.Red;
}
}
public static ExStaff GetExStaff(TableEmployee employee, bool withImage = false)
{
if (employee == null)
{
return(null);
}
return(new ExStaff
{
Id = employee.Id,
Name = employee.FirstName + " " + employee.LastName,
WhatsappContact = employee.TelephoneNumber,
Image = withImage ? employee.Image : null,
ImageUrl = Constants.ServiceClientEndPointWithApiPrefix + nameof(MeetingController.GetStaffImage) + "/" + employee.Id,
});
}
public void refresh()
{
if (Session["DepartmentId"] != null || Session["EmployeeId"] != null)
{
int departmentID = int.Parse(Session["DepartmentId"].ToString());
int employeeId = int.Parse(Session["EmployeeId"].ToString());
mountPage(departmentID);
tblEmployee = adpEmployee.GetDataBy(employeeId);
Cache["tblEmployee"] = tblEmployee;
lblEmployeeName.Text = "Hello " + tblEmployee[0].EmployeeName;
}
else
{
Response.Redirect("~/LoginForm.aspx");
}
}
public void createSession()
{
int id = int.Parse(txtEmployeeID.Text);
tblEmployee = adpEmployee.GetDataBy(id);
var row = tblEmployee;
if (row.Count > 0)
{
if (row != null)
{
Session["DepartmentId"] = row[0].EmployeeDepartmentID;
Session["EmployeeId"] = txtEmployeeID.Text;
Response.Redirect("~/WelcomeForm.aspx");
}
}
else
{
lblMessageError.Text = " Error to create Session";
lblMessageError.ForeColor = System.Drawing.Color.Red;
}
}
