EmployeeLogin IEmployeeDA.SaveEmployeedetails(M_Employee employee) { DataTable dt = new DataTable(); EmployeeLogin empResp = new EmployeeLogin(); if (connString.State == ConnectionState.Closed) { connString.Open(); } cmd = new SqlCommand("uspInsertNewEmployee", connString); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FistName", employee.FirstName); cmd.Parameters.AddWithValue("@LastName", employee.LastName); cmd.Parameters.AddWithValue("@UserName", employee.UserName); cmd.Parameters.AddWithValue("@Password", employee.Password); cmd.Parameters.AddWithValue("@Email", employee.Email); cmd.Parameters.AddWithValue("@Mobile", employee.Mobile); cmd.Parameters.AddWithValue("@Address", employee.Address); cmd.Parameters.AddWithValue("@CreatedBy", 1); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); sda.Dispose(); connString.Close(); empResp = ExtensionMethods.ConvertToListOf <EmployeeLogin>(dt)[0]; return(empResp); }
public ActionResult CreateEmployee(M_Employee data) { try { data.CreateID = user.CreateID; data.CreateDate = DateTime.Now; data.UpdateID = user.CreateID; data.UpdateDate = DateTime.Now; data.IsDeleted = false; M_Employee checker = (from c in db.M_Employee where c.Family_Name == data.Family_Name && c.First_Name == data.First_Name && c.DailyWage == data.DailyWage && c.IsDeleted == false select c).FirstOrDefault(); if (checker == null) { db.M_Employee.Add(data); db.SaveChanges(); return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } catch (Exception err) { return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult CreateEmployeeLogs(List <long> data) { try { db.Delete_EmployeeLogs(db.GETTIME().FirstOrDefault()); foreach (long datas in data) { M_Employee a = (from c in db.M_Employee where c.ID == datas select c).FirstOrDefault(); T_EmployeeLogs logs = new T_EmployeeLogs(); logs.CreateDate = DateTime.Now; logs.CreateID = user.UserName; logs.UpdateDate = DateTime.Now; logs.UpdateID = user.UserName; logs.DateAttendance = db.GETTIME().FirstOrDefault(); logs.EmployeeID = datas; logs.Wages = a.DailyWage; db.T_EmployeeLogs.Add(logs); db.SaveChanges(); } return(Json(new { msg = "success" }, JsonRequestBehavior.AllowGet)); } catch (Exception err) { return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet)); } }
public EmployeeLogin SaveEmployee(M_Employee employee) { EmployeeLogin obj = new EmployeeLogin(); obj = iempDa.SaveEmployeedetails(employee); return(obj); }
public static ResultResponse Update(EmployeeViewModel entity) { ResultResponse result = new ResultResponse(); try { using (var db = new MarComContext()) { if (entity.Id == 0) { M_Employee employee = new M_Employee(); employee.Employee_Number = entity.Employee_Number; employee.First_Name = entity.First_Name; employee.Last_Name = entity.Last_Name; employee.M_Company_Id = entity.M_Company_Id; employee.Email = entity.Email; employee.Is_Delete = entity.Is_Delete; employee.Create_By = entity.Create_By; employee.Create_Date = DateTime.Now; db.M_Employee.Add(employee); db.SaveChanges(); result.Message = "Data Employee" + entity.FullName + "has been saved"; } else { M_Employee employee = db.M_Employee.Where(c => c.Id == entity.Id).FirstOrDefault(); if (employee != null) { employee.First_Name = entity.First_Name; employee.Last_Name = entity.Last_Name; employee.M_Company_Id = entity.M_Company_Id; employee.Email = entity.Email; employee.Update_By = entity.Update_By; employee.Update_Date = DateTime.Now; db.SaveChanges(); result.Message = "Data Employee" + entity.FullName + "has been edited"; } } } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
// データ更新 // in : M_Employeeデータ // out : エラーメッセージ public string PutEmployee(M_Employee regEmployee) { using (var db = new SalesManagement_DevContext()) { M_Employee employee; try { employee = db.M_Employees.Single(x => x.EmID == regEmployee.EmID); } catch { // throw new Exception(Messages.errorNotFoundItem, ex); // throw new Exception(_cm.GetMessage(110), ex); return(_msc.GetMessage(110)); } employee.EmID = employee.EmID; employee.EmName = employee.EmName; employee.SoID = employee.SoID; employee.PoID = employee.PoID; employee.EmHiredate = employee.EmHiredate; employee.EmPhone = employee.EmPhone; employee.EmHidden = employee.EmHidden; db.Entry(employee).State = EntityState.Modified; try { db.SaveChanges(); } catch { // throw new Exception(Messages.errorConflict, ex); // throw new Exception(_cm.GetMessage(100), ex); return(_msc.GetMessage(100)); } // ログ出力 var operationLog = new OperationLog() { EventRaisingTime = DateTime.Now, Operator = _logonUser, Table = "Employee", Command = "Put", //Data = EmployeeLogData(regEmployee), }; //StaticCommon.PostOperationLog(operationLog); return(string.Empty); } }
// Add new employee to db. public string AddEmployee(M_Employee Emp) { if (Emp != null) { using (AngularCRUDEntities dataContext = new AngularCRUDEntities()) { dataContext.M_Employee.Add(Emp); dataContext.SaveChanges(); return("Employee Updated"); } } else { return("Invalid Employee"); } }
public async Task <HttpResponseMessage> SaveEmployeeDetails(M_Employee emp) { try { EmployeeLogin login = new EmployeeLogin(); await Task.Run(() => { login = iemployee.SaveEmployee(emp); }); return(Request.CreateResponse(HttpStatusCode.OK, login)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
// Delete Specific employee by their ID. public string DeleteEmployee(M_Employee Emp) { if (Emp != null) { using (AngularCRUDEntities dataContext = new AngularCRUDEntities()) { int no = Convert.ToInt32(Emp.Id); var employeeList = dataContext.M_Employee.Where(x => x.Id == no).FirstOrDefault(); dataContext.M_Employee.Remove(employeeList); dataContext.SaveChanges(); return("Employee Deleted"); } } else { return("Invalid Employee"); } }
public ActionResult DeleteEmployee(int ID) { try { M_Employee dataval = new M_Employee(); dataval = (from u in db.M_Employee.ToList() where u.ID == ID select u).FirstOrDefault(); dataval.IsDeleted = true; db.Entry(dataval).State = EntityState.Modified; db.SaveChanges(); return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); } catch (Exception err) { return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet)); } }
// Update Specific employee by their ID. public string UpdateEmployee(M_Employee Emp) { if (Emp != null) { using (AngularCRUDEntities dataContext = new AngularCRUDEntities()) { int no = Convert.ToInt32(Emp.Id); var employeeList = dataContext.M_Employee.Where(x => x.Id == no).FirstOrDefault(); employeeList.name = Emp.name; employeeList.mobileno = Emp.mobileno; employeeList.email = Emp.email; dataContext.SaveChanges(); return("Employee Updated"); } } else { return("Invalid Employee"); } }
public static bool Delete(int id) { bool result = true; try { using (var db = new MarComContext()) { M_Employee employee = db.M_Employee.Where(e => e.Id == id).FirstOrDefault(); if (employee != null) { employee.Is_Delete = true; db.SaveChanges(); } } } catch (Exception ex) { result = false; } return(result); }
public static ResultResponse UpdateEm(RegisterViewModel entity) { ResultResponse result = new ResultResponse(); try { using (var db = new MarComContext()) { M_Employee employee = db.M_Employee.Where(c => c.Id == entity.M_Employee_Id).FirstOrDefault(); if (employee != null) { employee.Em_Role = entity.RoleId; db.SaveChanges(); } } } catch (Exception ex) { result.Success = false; result.Message = ex.Message; } return(result); }
// データ追加 // in : M_Employeeデータ public string PostM_Employee(M_Employee regEmployee) { using (var db1 = new SalesManagement_DevContext()) { db1.M_Employees.Add(regEmployee); db1.Entry(regEmployee).State = EntityState.Added; db1.SaveChanges(); } //// ログ出力 //var operationLog = new OperationLog() //{ // EventRaisingTime = DateTime.Now, // Operator = _logonUser, // Table = "Product", // Command = "Post", // Data = M_ProductLogData(regProduct), // Comments = string.Empty //}; //StaticCommon.PostOperationLog(operationLog); return(string.Empty); }
public ActionResult EditEmployee(M_Employee data) { try { M_Employee dataval = new M_Employee(); dataval = (from u in db.M_Employee.ToList() where u.ID == data.ID select u).FirstOrDefault(); dataval.Family_Name = data.Family_Name; dataval.First_Name = data.First_Name; dataval.DailyWage = data.DailyWage; dataval.UpdateID = user.UserName; dataval.UpdateDate = DateTime.Now; M_Employee checker = (from c in db.M_Employee where c.Family_Name == data.Family_Name && c.First_Name == data.First_Name && c.DailyWage == data.DailyWage && c.IsDeleted == false select c).FirstOrDefault(); if (checker == null) { db.Entry(dataval).State = EntityState.Modified; db.SaveChanges(); return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } catch (Exception err) { return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet)); } }
public bool Insert(M_Employee model) { try { if (model != null) { var update = context.M_Employee.Where(x => x.EmployeeID == model.EmployeeID).FirstOrDefault(); if (update != null) { update.Active = model.Active; update.DivisionID = model.DivisionID; update.Email = model.Email; update.FirstNameEN = model.FirstNameEN; update.FirstNameTH = model.FirstNameTH; update.LastNameEN = model.LastNameEN; update.LastNameTH = model.LastNameTH; update.Mobile = model.Mobile; update.PositionID = model.PositionID; update.UpdBy = model.UpdBy; update.UpdDateTime = DateTime.Now; } else { model.InsDateTime = DateTime.Now; context.M_Employee.Add(model); } context.SaveChanges(); } } catch (Exception e) { var joke = e.Message.ToString(); return(false); } return(true); }
public bool Insert(M_Employee model) { return(m_EmployeeRepository.Insert(model)); }
public bool Update(int id, M_Employee model) { throw new NotImplementedException(); }
public IHttpActionResult PostM_Employee(M_Employee obj) { return(Ok(m_EmployeeService.Insert(obj))); }