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