// 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; } }