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