public ActionResult AddEmp() { teethLabEntities db = new teethLabEntities(); string name = Request.Form["name"]; employee emp = new employee(); emp.name = name; db.employees.Add(emp); db.SaveChanges(); return Redirect(Url.Action("Index", "Employee")); }
public employee Delete_employee_select(int ID) { employee = employee.Select(ID); Delete_employee_id_txt_lbl.Text = Convert.ToString(employee.employee_id); Delete_employee_date_hired_txt_lbl.Text = Convert.ToString(employee.employee_date_hired); Delete_employee_department_txt_lbl.Text = Convert.ToString(employee.employee_department); Delete_employee_hours_worked_txt_lbl.Text = Convert.ToString(employee.employee_hours_worked); Delete_employee_leadership_txt_lbl.Text = Convert.ToString(employee.employee_leadership); Delete_employee_motivation_txt_lbl.Text = Convert.ToString(employee.employee_motivation); Delete_employee_notes_txt_lbl.Text = Convert.ToString(employee.employee_notes); Delete_employee_overall_txt_lbl.Text = Convert.ToString(employee.employee_overall); Delete_employee_payrate_txt_lbl.Text = Convert.ToString(employee.employee_payrate); Delete_employee_performance_txt_lbl.Text = Convert.ToString(employee.employee_performance); Delete_employee_quality_txt_lbl.Text = Convert.ToString(employee.employee_quality); Delete_employee_timeliness_txt_lbl.Text = Convert.ToString(employee.employee_timeliness); Delete_username_txt_lbl.Text = Convert.ToString(employee.username); Delete_pswd_txt_lbl.Text = Convert.ToString(employee.pswd); return employee; }
public static bool UpdateEmployeeBL(employee updateEmployee) { bool EmployeeUpdated = false; try { if (ValidateEmployee(updateEmployee)) { EmployeeDL employeeDL = new employeeDL(); employeeUpdated = employeeDL.UpdateEmployeeDL(updateEmployee); } } catch (EmsException) { throw; } catch (Exception ex) { throw ex; } return employeeUpdated; }
public void ConvertEntityToModel_Test() { // Arrange TestKolgraphEntities context = new TestKolgraphEntities(); //var repository = new EmployeeRepository(context); var service = new EmployeeService(); employee entity = context.employee.Where(x => x.id == 1).FirstOrDefault(); // Act EmployeeModel model = service.ConvertEntityToModel(entity); // Assert Assert.IsNotNull(model); Assert.AreEqual(model.Id, entity.id); Assert.AreEqual(model.LastName, entity.lastName); Assert.AreEqual(model.FirstName, entity.firstName); Assert.AreEqual(model.Zehut, entity.zehut); Assert.AreEqual(model.IsCurrent, entity.isCurrent); Assert.AreEqual(model.LicenceNumber, entity.licenceNumber); Assert.AreEqual(model.LoginName, entity.loginName); Assert.AreEqual(model.LoginPassword, entity.loginPassword); }
public string PostEmployee(employee employee) { try { using (SPORT_LINK_DBDataContext db = new SPORT_LINK_DBDataContext()) { var innerJoinQuery = (from file in db.Employees where file.EmpNo.Equals(Convert.ToInt32(employee.EmpNo)) select file); if (innerJoinQuery.Count() == 0) { Employee res = new Employee(); res.EmpNo = employee.EmpNo; res.EmpName = employee.EmpName; res.DeptName = employee.DeptName; res.Designation = employee.Designation; db.Employees.InsertOnSubmit(res); db.SubmitChanges(); return("success created"); } else { Employee res = innerJoinQuery.Single(); res.EmpNo = employee.EmpNo; res.EmpName = employee.EmpName; res.DeptName = employee.DeptName; res.Designation = employee.Designation; // db.Employees.InsertOnSubmit(res); db.SubmitChanges(); return("success edited"); } }; } catch (Exception) { return("failed"); } }
public string UpdateEmployee(string json) { var obj = JObject.Parse(json); Hashtable updateColumns = new Hashtable(); Hashtable whereClause = new Hashtable(); foreach (JProperty x in (JToken)obj) { if (string.Compare(x.Name, "empId") == 0) { whereClause.Add(x.Name, x.Value); } else { updateColumns.Add(x.Name, "\'" + x.Value + "\'"); } } employee emp = new employee(); return(emp.EmployeeUpdate(updateColumns, whereClause)); }
/** * GET attemps log in */ public LogInResponse attempLogIn(string user_name, string password) { LogInResponse res = new LogInResponse(); res.success = false; res.message = "ERROR: User Invalid"; employee emp = new employee(); var query = "SELECT * FROM getEmployeeByUsername('" + user_name + "');"; emp = _context.Database.SqlQuery <employee>(query).FirstOrDefault(); if (emp != null) { res.message = "ERROR: Wrong Password"; if (emp.password.Equals(password)) { res.success = true; res.message = "LOGIN SUCCESSFUL"; res.information = emp; } } return(res); }
public ActionResult UploadFiles(ProfilePicture files) { var userId = System.Web.HttpContext.Current.Session["UserID"] as String; int IntID = Convert.ToInt32(userId); if (ModelState.IsValid) { // string p = Path.GetExtension(files.FileName).ToLower(); // if (p == ".png" || p == ".jpg" || p == ".gif" || p == ".bmp") // { var Nameofrecord = Path.GetFileName(files.file.FileName); string p = Path.GetExtension(files.file.FileName).ToLower(); if (p == ".png" || p == ".jpg" || p == ".gif" || p == ".bmp") { var sourcepath = Path.Combine(Server.MapPath("~/ProfilePictures/") + Nameofrecord); files.file.SaveAs(sourcepath); ViewBag.UploadStatus = "Your file Uploaded successfully"; employee employee = db.employees.Find(IntID); employee.Employee_Avatar = Nameofrecord; db.Entry(employee).State = EntityState.Modified; db.SaveChanges(); ModelState.Clear(); } else { ViewBag.Error = "Please select and image type of .png, .jpg, .gif or .bmp"; } } return(View()); }
public ActionResult Index(string id) { string section = id; // объект для взаимодействия с html AdminPanelPageView model = new AdminPanelPageView(); // параметр доступа ViewBag.access = false; // параметр наличия ошибки ViewBag.error = null; model.user = new employee(); // проверка наличия cookie, если пользователь уже авторизован if (HttpContext.Request.Cookies["session"] != null) { string sessionFromCookie = HttpContext.Request.Cookies["session"].Value; if (sessionFromCookie != null) { // проверка подлинности пользователя, представившегося по cookie employee user = _dbContext.employees.Where(e => e.session == sessionFromCookie).FirstOrDefault(); if (user != null) { // Аутентификация успешно пройдена ViewBag.access = true; model.user = user; if (section != null) { model.section = section; } // подготовка данных для авторизованного пользователя prepareModel(model); } } } return(View(model)); }
public ActionResult register(employee em, HttpPostedFileBase imgpath, HttpPostedFileBase filpath) { if (ModelState.IsValid) { string path = "~/imgfile/" + imgpath.FileName; string pathfile = "~/imgfile/" + filpath.FileName; imgpath.SaveAs(Server.MapPath(path)); filpath.SaveAs(Server.MapPath(pathfile)); em.imgpath = imgpath.FileName; em.cvpath = filpath.FileName; db.Employees.Add(em); db.SaveChanges(); return(RedirectToAction("index")); } else { List <department> dept = db.Departments.ToList(); SelectList deptlist = new SelectList(dept, "deptid", "deptname"); ViewBag.dept = deptlist; return(View()); } }
public void Modify(employee emp) { AddEmployee addWindow = new AddEmployee(); // Sets the window's context and gives it the types available, that aren't deleted addWindow.DataContext = new { employee = emp, types = dataHandler.GetEntities().employee_type.ToList().FindAll(type => { return(!type.deleted); }) }; if (addWindow.ShowDialog() == true) { try { dataHandler.AddOrUpdate(emp); } catch (Exception e) { System.Windows.MessageBox.Show("Error: " + e.Message); } } else { ((System.Data.Entity.Infrastructure.IObjectContextAdapter)dataHandler.GetEntities()).ObjectContext.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, emp); } NotifyOfPropertyChange("Employees"); }
public ActionResult JoinByCode([Bind(Include = "Id,CompanyId,employeId,invKey")] employee employee) { if (ModelState.IsValid) { employee.employeId = User.Identity.GetUserId(); foreach (Company company in db.Companies.ToList()) { if (company.InvKey.ToString() == employee.invKey.ToString()) { employee.Company = company; employee.CompanyId = company.Id; db.Employes.Add(employee); db.SaveChanges(); } } return(RedirectToAction("Index")); } return(View(employee)); }
internal static employee add(employee emp) { OracleDataAdapter oda = new OracleDataAdapter(); string sql = "Insert into employees "; sql = sql + "(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID) "; sql = sql + "values (EMPLOYEES_SEQ.NEXTVAL,:first_name,:last_name,:email,:phone_number,sysdate,:job_id,:salary,:commission_pct,:manager_id,:department_id)"; OracleConnection cn = new OracleConnection( ConfigurationManager.ConnectionStrings ["hr"].ConnectionString); cn.Open(); oda.InsertCommand = new OracleCommand(sql, cn); oda.InsertCommand.BindByName = true; oda.InsertCommand.Parameters.Add(":first_name", emp.first_name); oda.InsertCommand.Parameters.Add(":last_name", emp.last_name); oda.InsertCommand.Parameters.Add(":email", emp.email); oda.InsertCommand.Parameters.Add(":phone_number", emp.phone_number); oda.InsertCommand.Parameters.Add(":job_id", emp.job_id); oda.InsertCommand.Parameters.Add(":salary", emp.salary); oda.InsertCommand.Parameters.Add(":commission_pct", emp.commission_pct); oda.InsertCommand.Parameters.Add(":manager_id", emp.manager_id); oda.InsertCommand.Parameters.Add(":department_id", emp.department_id); int count = oda.InsertCommand.ExecuteNonQuery(); sql = "SELECT * from employees where employee_id = EMPLOYEES_SEQ.CURRVAL"; OracleDataReader rdr = dataHelper.getrdr(sql); if (rdr.HasRows) { while (rdr.Read()) { emp = getEmployee(rdr); } rdr.Close(); } return(emp); }
public ActionResult Delete(int id, string confirmButton) { string message = ""; using (Entities dc = new Entities()) { employee employee = dc.employees.Find(id); if (employee == null) { message = "Employee not found."; TempData["message"] = message; return(RedirectToAction("MyEmployees", "Business")); } dc.employees.Remove(employee); dc.SaveChanges(); message = "Employee successfully deleted."; } TempData["message"] = message; return(RedirectToAction("MyEmployees", "Business")); }
// read from the DB public ActionResult Edit(int id) { try { //setting dropdown list for forgern key var utype = new List <SelectListItem>(); utype.AddRange(db.users_types.Where(x => x.deleted != true).Select(a => new SelectListItem { Text = a.user_type_name, Selected = false, Value = a.user_type_number.ToString() })); var branchtypes = new List <SelectListItem>(); branchtypes.AddRange(db.branches.Where(x => x.deleted != true).Select(b => new SelectListItem { Text = b.branch_name, Selected = false, Value = b.branch_number.ToString() })); //setting variable passing ViewBag.utype = utype; ViewBag.branch = branchtypes; ViewBag.id = id; List <employee> Employees_list = db.employees.Where(d => d.emp_number == id).ToList(); ViewBag.Customerslist = Employees_list; employee target = Employees_list[0]; target.emp_password = EncryptionHelper.Decrypt(target.emp_password); branchtypes.Where(q => int.Parse(q.Value) == target.branch.branch_number).First().Selected = true; utype.Where(t => int.Parse(t.Value) == target.users_types.user_type_number).First().Selected = true; return(View(target)); } catch (Exception e) { ViewBag.m = "Something went wrong ... " + e.Message; return(View()); } }
public JsonResult Edit(int id) { Dictionary <string, object> result = new Dictionary <string, object>(); try { employee employee = _dbContext.employees.Find(id); serializeEmployeeToModel(ref employee); person employeePerson = employee.person; serializePersonToModal(ref employeePerson); // сохранение в базу _dbContext.SaveChanges(); } catch (Exception exc) { result.Add("error", exc.Message); } return(Json(result, JsonRequestBehavior.DenyGet)); }
public ActionResult Education_JobSeeker(education education1) { //System.Linq.IQueryable education1 = db.educations.Where(model => model.id_employee == educationJobseekerlog1.id_employee); //var education1 = db.educations.Any(model => model.id_employee == educationJobseekerlog1.id_employee); //if (db.users.Any(model => model.email == jobseeker1.userJobSeeker.email)) education1.degree_name = education1.degree_name.ToLower(); var educationlogs = from edu in db.educations where edu.id_employee == education1.id_employee select edu; foreach (education checkedu in educationlogs) { if (checkedu.degree_name == education1.degree_name) { ModelState.AddModelError("degree_name", "Ooops! you have given your this degree info. give ur new degree"); break; } } if (education1.score > education1.scale) { ModelState.AddModelError("score", "Ooops! score can't be greater than scale. plz give correct info!"); } if (ModelState.IsValid) { db.educations.Add(education1); db.SaveChanges(); var employ = from emp in db.employees where emp.id_employee == education1.id_employee select emp; employee employee1 = employ.First(); var userlogs = from us in db.users where us.id_user == employee1.id_user select us; user user1 = userlogs.First(); return(RedirectToAction("Details_JobSeeker", user1)); } return(View(education1)); }
/** * PUT request that updates a employee */ public Response updateEmployee(int id_employee, employee emp) { Response res = new Response(); res.success = true; res.code = "1"; res.message = "SUCCESSFUL"; try { var query = "SELECT updateEmployee(" + id_employee + ", '" + emp.first_name + "', '" + emp.second_name + "'" + ", '" + emp.first_last_name + "', '" + emp.second_last_name + "', '" + emp.birthdate.ToString("MM/dd/yyyy") + "', '" + emp.user_name + "'" + ", '" + emp.password + "', '" + emp.phone + "', '" + emp.residence + "', " + emp.role + ", " + emp.subsidiary + ")"; _context.Database.SqlQuery <Boolean>(query).FirstOrDefault(); } catch (NpgsqlException ex) { res.success = false; res.code = ex.Code; res.message = ex.BaseMessage; } return(res); }
public IHttpActionResult Putemployee(int id, employee employee) { try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != employee.Id) { return(BadRequest()); } db.Entry(employee).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!employeeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); } catch (Exception e) { throw e; } }
//WebClass kyj = null; //--------------------------insert 쿼리문-------------------------------// public string insert_qury(string table, employee t) { employee emp = new employee(); emp.st_code = t.st_code; emp.st_emp_member = t.st_emp_member; emp.st_emp_birth = t.st_emp_birth; emp.st_emp_zip = t.st_emp_zip; emp.st_emp_addr2 = t.st_emp_addr2; emp.st_emp_sex = t.st_emp_sex; emp.st_emp_code = t.st_emp_code; emp.st_emp_picture_Path = t.st_emp_picture_Path; string sql = "insert into " + table + "(st_code,st_emp_member,st_emp_birth,st_emp_zip,st_emp_addr2,st_emp_sex,st_emp_code,st_emp_picture_Path)" + "values (N'" + emp.st_code + "', N'" + emp.st_emp_member + "', N'" + emp.st_emp_birth + "', N'" + emp.st_emp_zip + "', N'" + emp.st_emp_addr2 + "', N'" + emp.st_emp_sex + "', N'" + emp.st_emp_code + "' ,N'" + emp.st_emp_picture_Path + "')"; //string sql = "insert into " + table + "(st_code,st_emp_member,st_emp_birth,st_emp_zip,st_emp_addr2,st_emp_sex,st_emp_code)" + "values ('" + emp.st_code + "', '" + emp.st_emp_member + "', '" + emp.st_emp_birth + "', '" + emp.st_emp_zip + "', '" + // emp.st_emp_addr2 + "', '" + emp.st_emp_sex + "', '" + emp.st_emp_code + "')"; return(sql); }
//查询所有供应者 public List <employee> find_all() { MySqlConnection conn = Util.Util.getConn(); MySqlDataReader dataReader = null; MySqlCommand command = null; employee r = null; List <employee> rs = new List <employee>(); try { command = conn.CreateCommand(); command.CommandText = "SELECT * FROM employee"; dataReader = command.ExecuteReader(); while (dataReader.Read()) { r = new employee(); r.Employee_name = dataReader.GetString("employee_name"); r.Employee_number = dataReader.GetString("employee_number"); r.Phone = dataReader.GetString("phone"); rs.Add(r); } } catch (Exception) { } finally { if (!dataReader.IsClosed) { dataReader.Close(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(rs); }
public ActionResult editemployeeaction(int empid, string empname, string department, int phoneno) { try { employee e = (from e1 in db.employees where e1.empid == empid select e1).Single(); e.empid = empid; e.empname = empname; e.department = department; e.phoneno = phoneno; db.SaveChanges(); ViewData["message"] = "Succesfully updated"; } catch (Exception ex) { ViewData["message"] = ex.Message; } return(RedirectToAction("employees")); }
//gets projects for the calender public JsonResult GetEvents(string empId) { //create an employee object mathcing the empId passed through employee emp = db.employees.Find(empId); var dbGrps = db.groups.ToList(); //all groups where the employee is within the list of employees assigned to the group. var groups = (from s in dbGrps where s.employees.Contains(emp) select s).ToList(); //list of projects to return List <project> returnProj = new List <project>(); //for each group found for that employee foreach (group grp in groups) { group grpObject = db.groups.Find(grp.groupID); var dbProjects = db.projects.ToList(); //you find a list of projects where the project has that group assigned to it. List <project> projects = (from s in dbProjects where s.groups.Contains(grpObject) select s).ToList(); foreach (project proj in projects) { //for each of those projects, add them to the returnProj list. if (proj.projectActive == 1) { returnProj.Add(new project() { projectID = proj.projectID, projectName = proj.projectName, projectStartDate = proj.projectStartDate, projectEndDate = proj.projectEndDate }); } } } //return a list of projects defined above return(Json(returnProj, JsonRequestBehavior.AllowGet)); }
public ActionResult Update(employee em) { if (Session["UserInfo"] == null) { return(RedirectToAction("Index")); } if (!ModelState.IsValid) { var ee = c.employees.FirstOrDefault(e => e.ID == em.ID); var deps = c.Departments.Select(d => d); List <SelectListItem> ls = new List <SelectListItem>(); foreach (var temp in deps) { ls.Add(new SelectListItem() { Text = temp.Name, Value = temp.ID.ToString() }); } ViewBag.DepList = ls; return(View(ee)); } var emp = c.employees.FirstOrDefault(e => e.ID == em.ID); emp.Name = em.Name; emp.Email = em.Email; emp.UserName = em.UserName; emp.Password = em.Password; emp.DeptID = em.DeptID; c.SubmitChanges(); return(RedirectToAction("TestTempData")); }
public List <employee> FindAllEmployees(string projID) { List <employee> employees = new List <employee>(); // Data Provider DbConnection object SqlConnection dataConnection; // Data Provider DbCommand object SqlCommand dataCommand = new SqlCommand(); // Data Provider DbDataReader object SqlDataReader dataReader; dataConnection = new SqlConnection(connectionKey); dataConnection.Open(); dataCommand.Connection = dataConnection; dataCommand.CommandText = String.Format("SELECT e_id, fname, lname, dept_id, dateOfHire, contract FROM employees WHERE employees.e_id IN(SELECT employeeProjects.e_id FROM employeeProjects WHERE employeeProjects.p_id = @P_ID)"); dataCommand.Parameters.Add(new SqlParameter("@P_ID", projID)); dataReader = dataCommand.ExecuteReader(); while (dataReader.Read()) { employee emp = new employee((int)dataReader["e_id"], dataReader["fname"].ToString(), dataReader["lname"].ToString(), dataReader["dept_id"].ToString(), (System.DateTime)dataReader["dateOfHire"], (bool)dataReader["contract"]); employees.Add(emp); } // end read loop return(employees); }
public ActionResult Update2(int id, string name, int? salary, DateTime? birthday, DateTime? entryday, int? departmentid) { if (string.IsNullOrEmpty(name)) { employee emp = new employee { id= id, name= name, salary= salary, birthday = birthday, entryday= entryday,departmentid= departmentid}; ViewBag.auth = false; return View("Update1",emp); } using (var db = new DatabaseEntities()) { var u = db.employees.Find(id); u.name = name; u.salary = salary; u.birthday = birthday; u.entryday = entryday; u.departmentid = departmentid; db.SaveChanges(); var v = db.employees.Find(id); return View(v); } }
////-----------------------------------직원 추가-----------------------------------------// //private void btn_picture_Add_Click(object sender, EventArgs e) //{ // make_qury qury = new make_qury(); // DBClass DB = new DBClass(); // employee emp = new employee(); // if (btn_man.Checked == true) // { // Radio = 1; // } // else // { // Radio = 2; // } // // DB에 저장 // string DB_insert = qury.insert_qury("st_employee", emp); // //st_emp_code // //DB 읽기<> // string DB_read = qury.target_select_qury("st_employee", emp, $"st_emp_code = {emp.st_emp_code}"); // //DB 입력 결과 // int result = DB.DataInsert(DB_read); // DataSet emp_result = DB.DataSetGrid(DB_read); // DataTable dt = emp_result.Tables[0]; // string result2 = dt.Columns[0].ToString(); // if (result2 == emp.st_emp_code) // { // MessageBox.Show("직원 코드 확인"); // } // else // { // emp = new employee() // { // st_code = combo_store2.Text, // st_emp_member = txt_name.Text, // st_emp_birth = txt_birth.Text, // st_emp_zip = txt_zipCode.Text, // st_emp_addr2 = txt_address.Text, // st_emp_sex = Radio, // //st_emp_code= // }; // if (DB.DataInsert(DB_insert) != -1) // { // MessageBox.Show("등록 확인"); // } // else // { // MessageBox.Show("등록 실패"); // } // } //} //------------------------------------콤보 박스에 db 바인딩-------------------------------// private string[] insert_combox() { employee emp0 = new employee(); make_qury qury = new make_qury(); DBClass db = new DBClass(); //string researchCode = qury.distinct__ALL_select_qury("st_table","st_name"); string researchCode = qury.All_select_qury("st_table", emp0); DataSet ds = db.DataSetGrid(researchCode); DataTable dt = ds.Tables[0]; string store_name = dt.Columns[1].ToString(); object[] arr_st_name = dt.Select().Select(x => x["st_name"]).Distinct().ToArray(); string[] str_st_name = arr_st_name.Cast <string>().ToArray(); return(str_st_name); }
public ActionResult Edit(string id, string firstName, string department, string hiredate, string phone, string address) { if (Request.Form["btnOKCancel"] == "Cancel") { return(RedirectToAction("employee")); } var query = from o in db.employees where o.empID == id select o; employee empDb = query.SingleOrDefault(); empDb.empName = firstName; empDb.department = department; empDb.phone = phone; empDb.address = address; DateTime date = DateTime.Parse(hiredate); empDb.hireDate = date; db.SaveChanges(); return(RedirectToAction("employee")); }
public static EmployeeModel findEmployeeWithID(long employeeID) { employee theEmp = null; bool done = false; for (int i = 0; i < 3 && !done; i++) { try { theEmp = empSvc.findoneAsync(employeeID).GetAwaiter().GetResult().employee; done = true; } catch (System.Exception e) { if (i == 2) { throw e; } Thread.Sleep(1500); } } return(getEmployeeModel(theEmp)); }
public static EmployeeModel findEmployeeWithKACARE_ID(string kacare_id) { employee theEmp = null; bool done = false; for (int i = 0; i < 3 && !done; i++) { try { theEmp = empSvc.findBy_KACARE_IdAsync(kacare_id).GetAwaiter().GetResult().employee; done = true; } catch (System.Exception e) { if (i == 2) { throw e; } Thread.Sleep(1500); } } return(getEmployeeModel(theEmp)); }
public bool DeleteEmployee(long employee_id) { try { employee oEmployee = _entities.employees.FirstOrDefault(c => c.employee_id == employee_id); _entities.employees.Attach(oEmployee); _entities.employees.Remove(oEmployee); _entities.SaveChanges(); user existUser = _entities.users.FirstOrDefault(c => c.emp_id == employee_id); if (existUser != null) { _entities.users.Attach(existUser); _entities.users.Remove(existUser); _entities.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public employee employee_update(int ID) { employee = employee.Select(ID); employee.employee_id = Convert.ToInt32(Update_employee_id_txt.Text); employee.employee_date_hired = Convert.ToDateTime(Update_employee_date_hired_txt.Text); employee.employee_department = Update_employee_department_txt.Text; employee.employee_hours_worked = Convert.ToInt32(Update_employee_hours_worked_txt.Text); employee.employee_leadership = Update_employee_leadership_txt.Text; employee.employee_motivation = Update_employee_motivation_txt.Text; employee.employee_notes = Update_employee_notes_txt.Text; employee.employee_overall = Update_employee_overall_txt.Text; employee.employee_payrate = Convert.ToDecimal(Update_employee_payrate_txt.Text); employee.employee_performance = Update_employee_performance_txt.Text; employee.employee_quality = Update_employee_quality_txt.Text; employee.employee_timeliness = Update_employee_timeliness_txt.Text; employee.username = Update_username_txt.Text; employee.pswd = Update_pswd_txt.Text; employee.Update(employee); Insert_employee_GridView.DataBind(); Update_employee_GridView.DataBind(); Delete_employee_GridView.DataBind(); return(employee); }
public string updateEmployee(int id, NameValueCollection new_data) { // update an employee record RequestById bData = new RequestById(); bData.token = Token; bData.output = OutPut; employee objrequest = new employee(); objrequest.method = "UPDATE"; objrequest.module = "staff.employees"; objrequest.nick_name = "sherwood"; objrequest.id = id.ToString(); bData.request = objrequest; NameValueCollection RequestApi = new NameValueCollection(); JavaScriptSerializer js = new JavaScriptSerializer(); RequestApi.Add("data", js.Serialize(bData)); return perform_request(RequestApi); }
protected void Insert_Select_Record(object sender, EventArgs e) { employee = Insert_employee_select(Convert.ToInt32(Insert_employee_GridView.SelectedValue)); }
public employee employee_update(int ID) { employee = employee.Select(ID); employee.employee_id = Convert.ToInt32(Update_employee_id_txt.Text); employee.employee_date_hired = Convert.ToDateTime(Update_employee_date_hired_txt.Text); employee.employee_department = Update_employee_department_txt.Text; employee.employee_hours_worked = Convert.ToInt32(Update_employee_hours_worked_txt.Text); employee.employee_leadership = Update_employee_leadership_txt.Text; employee.employee_motivation = Update_employee_motivation_txt.Text; employee.employee_notes = Update_employee_notes_txt.Text; employee.employee_overall = Update_employee_overall_txt.Text; employee.employee_payrate = Convert.ToDecimal(Update_employee_payrate_txt.Text); employee.employee_performance = Update_employee_performance_txt.Text; employee.employee_quality = Update_employee_quality_txt.Text; employee.employee_timeliness = Update_employee_timeliness_txt.Text; employee.username = Update_username_txt.Text; employee.pswd = Update_pswd_txt.Text; employee.Update(employee); Insert_employee_GridView.DataBind(); Update_employee_GridView.DataBind(); Delete_employee_GridView.DataBind(); return employee; }
protected void Update_Select_Record(object sender, EventArgs e) { employee = Update_employee_select(Convert.ToInt32(Update_employee_GridView.SelectedValue)); }
public static employee Createemployee(long id_employee) { employee employee = new employee(); employee.id_employee = id_employee; return employee; }
public void AddToemployee(employee employee) { base.AddObject("employee", employee); }
protected void INSERT(object sender, EventArgs e) { employee = employee_insert(); }
protected void UPDATE(object sender, EventArgs e) { employee = employee_update(Convert.ToInt32(Update_employee_GridView.SelectedValue)); }