public async Task <bool> UpdateEmployee(tbl_employee model) { try { using (var uow = _unitOfWorkFactory.Create()) { var result = await FindByIdAmortization(model.autonum); if (result != null) { uow.EmployeeRepository.Update(model); await uow.SaveChangesAsync(); return(true); } else { return(false); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public HttpResponseMessage Edit(int id, [FromBody] tbl_employee employee) { try { using (empEntities entities = new empEntities()) { var entity = entities.tbl_employee.FirstOrDefault(e => e.Id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID" + id.ToString() + " not found")); } else { entity = employee; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } //entity.Id = employee.Id; //entity.Name = employee.Name; //entity.Gender = employee.Gender; } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
// DELETE api/Employee/5 public void Delete(int id) { tbl_employee temp = db.tbl_employee.Where(x => x.Id == id).FirstOrDefault(); db.tbl_employee.Remove(temp); db.SaveChanges(); }
// PUT api/Employee/5 public void Put(int id, tbl_employee emp) { if (ModelState.IsValid) { db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); } }
public ActionResult DeleteConfirmed(int id) { tbl_employee tbl_employee = db.tbl_employee.Find(id); db.tbl_employee.Remove(tbl_employee); db.SaveChanges(); return(RedirectToAction("Index")); }
public void AddEmployee(tbl_employee emp) { EFDal dal = new EFDal(); //tbl_employee employee = new tbl_employee(); dal.AddEmployee(emp); }
public HttpResponseMessage SaveLabour(HttpRequestMessage request, LabourViewModel savelabour) { return(CreateHttpResponse(request, () => { HttpResponseMessage response = null; if (!ModelState.IsValid) { response = request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } else { //start of saving to master emp table var codeFormat = _settingsRepository.GetAll().Where(t => t.tenant_id == savelabour.tenant_id).FirstOrDefault(); var exsistingEmployees = _EmployeeRepository.GetAll().Where(e => e.tenant_id == savelabour.tenant_id); tbl_employee newEmployeeMaster = new tbl_employee(); int empCount = exsistingEmployees.Count(); if (empCount <= 0) { newEmployeeMaster.emp_code = codeFormat.emp_code; newEmployeeMaster.code_seperation = codeFormat.code_seperation; newEmployeeMaster.emp_num = codeFormat.emp_num; } else { var lastERec = _EmployeeRepository.GetAll().Where(e => e.tenant_id == savelabour.tenant_id).OrderByDescending(e => e.id).First(); // var lastERec = _EmployeeRepository.GetSingle(empCount); newEmployeeMaster.emp_code = lastERec.emp_code; newEmployeeMaster.code_seperation = lastERec.code_seperation; newEmployeeMaster.emp_num = lastERec.emp_num + 1; } newEmployeeMaster.tenant_id = savelabour.tenant_id; newEmployeeMaster.project_id = savelabour.project_id; newEmployeeMaster.Designation = "Labour"; newEmployeeMaster.emp_name = savelabour.name; newEmployeeMaster.date_created = DateTime.Now; newEmployeeMaster.CreatedBy = "Admin"; _EmployeeRepository.Add(newEmployeeMaster); //_unitOfWork.Commit(); //end of saving to master emp table. tbl_labour newlabour = new tbl_labour(); newlabour.master_emp_id = _EmployeeRepository.GetAll().Count() + 1; newlabour.AddLabour(savelabour); _labourRepository.Add(newlabour); _unitOfWork.Commit(); response = request.CreateResponse <LabourViewModel>(HttpStatusCode.Created, savelabour); } return response; })); }
public static void AddEmployeeMaster(this tbl_employee employee, EmployeeViewModel employeeVm) { employee.tenant_id = employeeVm.tenant_id; employee.project_id = employeeVm.project_id; employee.Designation = employeeVm.Designation; employee.emp_name = employeeVm.emp_name; //employee.date_created = employeeVm.date_created; employee.date_created = TimeZoneInfo.ConvertTimeFromUtc(employeeVm.date_created, TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")); employee.CreatedBy = employeeVm.CreatedBy; }
// GET api/Employee/5 public tbl_employee Get(int id) { tbl_employee emp = db.tbl_employee.Find(id); if (emp == null) { return(null); } return(emp); }
public async Task <IActionResult> PostEmployees([FromBody] tbl_employee model) { if (model == null) { return(BadRequest()); } _context.tbl_employee.Add(model); await _context.SaveChangesAsync(); return(Ok(new { message = "saved successfully" })); }
public ActionResult Edit([Bind(Include = "employee_status,Id,employeeName,employeeAge,salary,bouns,rate,hoursWorked")] tbl_employee tbl_employee) { if (ModelState.IsValid) { db.Entry(tbl_employee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.employee_status = new SelectList(db.tbl_status, "employee_status", "employee_status", tbl_employee.employee_status); return(View(tbl_employee)); }
protected void Button3_Click(object sender, EventArgs e) { EFDal dal = new EFDal(); var record = new tbl_employee { Ecode = int.Parse(textecode.Text), Salary = int.Parse(textsalary.Text), }; dal.updateEmp(record); Label1.Text = "Updated Successfully!!!"; }
private void btnUpdate_Click(object sender, EventArgs e) { var record = new tbl_employee { Ecode = int.Parse(txtEcode.Text), salary = int.Parse(txtSalary.Text) }; var dal = new EFDal(); dal.UpdateEmp(record); MessageBox.Show("record updated"); dgv.DataSource = dal.GetAllEmps(); }
protected void btnupdate_Click(object sender, EventArgs e) { EmpServiceClient proxy = new EmpServiceClient("BasicHttpBinding_IEmpService"); var result = new tbl_employee { Ecode = int.Parse(txtecode.Text), salary = int.Parse(txtsalary.Text) }; proxy.UpdateEmp(result); GridView1.DataSource = proxy.GetAllEmps().ToList(); GridView1.DataBind(); }
public async Task <bool> AddEmployee(EmployeeModel employeeModel) { var employee = new tbl_employee() { employee_name = employeeModel.Name, employee_email = employeeModel.Email, employee_address = employeeModel.Address, employee_phoneNo = employeeModel.Phone }; emp.tbl_employee.Add(employee); return(await emp.SaveChangesAsync() > 0); }
public void Save() { using (var context = new CashCarryEntities3()) { if (Username == null && Password == null && LoginType == 0) { tbl_employee objemp = new tbl_employee() { Name = Name, Fname = Fname, Gender = Gender, Password = null, Qualifiction = Qualifiction, Username = null, DOB = DOB, Designation = Designation, Contact = Contact, Cnic = Cnic, Address = Address, AsignDate = AsignDate, Salary = Salary, LoginTypeID = 0 }; context.tbl_employee.Add(objemp); context.SaveChanges(); } else { tbl_employee objemp = new tbl_employee() { Name = Name, Fname = Fname, Gender = Gender, Password = Password, Qualifiction = Qualifiction, Username = Username, DOB = DOB, Designation = Designation, Contact = Contact, Cnic = Cnic, Address = Address, AsignDate = AsignDate, Salary = Salary, LoginTypeID = LoginType }; context.tbl_employee.Add(objemp); context.SaveChanges(); } } }
public ActionResult UpdateEmp(Employee emp) { EFDal dal = new EFDal(); tbl_employee e = new tbl_employee { Ecode = emp.Ecode, Ename = emp.Ename, salary = emp.salary, deptid = emp.deptid }; dal.UpdateEmp(e); return(RedirectToAction("DisplayAllEmps")); }
// GET: tbl_employee/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_employee tbl_employee = db.tbl_employee.Find(id); if (tbl_employee == null) { return(HttpNotFound()); } return(View(tbl_employee)); }
protected void Button2_Click(object sender, EventArgs e) { var record = new tbl_employee { Ecode = int.Parse(textecode.Text), Ename = textename.Text, Salary = int.Parse(textsalary.Text), Deptid = int.Parse(textdepid.Text) }; EFDal dal = new EFDal(); dal.AddEmployee(record); Label1.Text = "Inserted Successfully!!!"; }
// GET: tbl_employee/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_employee tbl_employee = db.tbl_employee.Find(id); if (tbl_employee == null) { return(HttpNotFound()); } ViewBag.employee_status = new SelectList(db.tbl_status, "employee_status", "employee_status", tbl_employee.employee_status); return(View(tbl_employee)); }
public string SaveEmployee(EmployeeModel model) { string message = ""; EmployeeEntities db = new EmployeeEntities(); var saveEmployee = new tbl_employee() { FirstName = model.FirstName, LastName = model.LastName, Department = model.Department, }; db.tbl_employee.Add(saveEmployee); db.SaveChanges(); message = "Employee Added Succesfully"; return(message); }
private double?CalcEarnings(DB db, tbl_employee emp) { if (emp.rate != null && emp.hoursWorked != null) { ptEmployee ptemp = new ptEmployee(emp.Id, emp.employeeName, emp.employeeAge, emp.rate, emp.hoursWorked); elist.Add(ptemp); return(emp.rate * emp.hoursWorked); } else if (emp.salary != null && emp.bouns != null) { FtEmployee ftemp = new FtEmployee(emp.Id, emp.employeeName, emp.employeeAge, emp.bouns, emp.salary); elist.Add(ftemp); return(emp.salary + emp.bouns); } return(0); }
protected void btninsert_Click(object sender, EventArgs e) { EmpServiceClient proxy = new EmpServiceClient("BasicHttpBinding_IEmpService"); var result = new tbl_employee { Ecode = int.Parse(txtecode.Text), Ename = txtename.Text, salary = int.Parse(txtsalary.Text), deptid = int.Parse(txtdeptid.Text) }; proxy.AddEmployee(result); GridView1.DataSource = proxy.GetAllEmps().ToList(); GridView1.DataBind(); }
public async Task <IActionResult> UpdateEmployees([FromBody] tbl_employee model) { if (model == null) { return(BadRequest()); } var res = await _context.tbl_employee.FirstOrDefaultAsync(x => x.EmployeeID == model.EmployeeID); if (res == null) { return(NotFound()); } res.Name = model.Name; res.Job = model.Job; await _context.SaveChangesAsync(); return(Ok(new { message = "updated successfully" })); }
private void btnInsert_Click(object sender, EventArgs e) { //take user input for insert var record = new tbl_employee { Ecode = int.Parse(txtEcode.Text), Ename = txtEname.Text, salary = int.Parse(txtSalary.Text), deptid = int.Parse(txtDeptid.Text) }; //insert using dal var dal = new EFDal(); dal.AddEmployee(record); MessageBox.Show("record inserted"); //referesh the data dgv.DataSource = dal.GetAllEmps(); }
public HttpResponseMessage Insert([FromBody] tbl_employee employee) { try { using (empEntities entities = new empEntities()) { entities.tbl_employee.Add(employee); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, employee); message.Headers.Location = new Uri(Request.RequestUri + employee.Id.ToString()); return(message); } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
public HttpResponseMessage AddEmployee(HttpRequestMessage request, EmployeeViewModel employee) { return(CreateHttpResponse(request, () => { HttpResponseMessage response = null; if (!ModelState.IsValid) { response = request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } else { var codeFormat = _settingsRepository.GetAll().Where(t => t.tenant_id == employee.tenant_id).FirstOrDefault(); var exsistingEmployees = _EmployeeRepository.GetAll().Where(e => e.tenant_id == employee.tenant_id); tbl_employee newEmployeeMaster = new tbl_employee(); int empCount = exsistingEmployees.Where(t => t.tenant_id == employee.tenant_id).Count(); if (empCount <= 0) { newEmployeeMaster.emp_code = codeFormat.emp_code; newEmployeeMaster.code_seperation = codeFormat.code_seperation; newEmployeeMaster.emp_num = codeFormat.emp_num; } else { // var lastERec = _EmployeeRepository.GetAll().Where(e=>e.tenant_id==employee.tenant_id).GroupBy(e=>e.tenant_id).Select(y=>new { tenant_id=y.Key, lastrecord=y.OrderByDescending(e=>e.emp_num).FirstOrDefault()}); var lastERec = _EmployeeRepository.GetAll().Where(e => e.tenant_id == employee.tenant_id).OrderByDescending(e => e.id).First(); newEmployeeMaster.emp_code = lastERec.emp_code; newEmployeeMaster.code_seperation = lastERec.code_seperation; newEmployeeMaster.emp_num = lastERec.emp_num + 1; } newEmployeeMaster.AddEmployeeMaster(employee); _EmployeeRepository.Add(newEmployeeMaster); _unitOfWork.Commit(); response = request.CreateResponse <EmployeeViewModel>(HttpStatusCode.Created, employee); } return response; })); }
private string ShowVehicleInEmployee(DB db, tbl_employee emp) { string output = ""; List <tbl_vehicle> vlist = db.GetVehicles(emp); if (vlist.Count > 0) { foreach (tbl_vehicle vehicle in vlist) { output += SPACES + "PLate Number" + SPACES + vehicle.plateNumber + NL + SPACES + "Make" + SPACES + vehicle.make + NL + SPACES + "Modle" + SPACES + vehicle.model + NL; } } else { output += "Employee Does Not have a vehicle" + NL; } output += "-------------------------------" + NL; return(output); }
// PUT: api/EmpService/5 public void Put(int id, [FromBody] tbl_employee emp) { EFDal dal = new EFDal(); dal.UpdateEmp(emp); }
// POST: api/EmpService public void Post([FromBody] tbl_employee emp) { EFDal dal = new EFDal(); dal.AddEmployee(emp); }
// POST api/Employee public void Post(tbl_employee emp) { db.tbl_employee.Add(emp); db.SaveChanges(); }