public ActionResult Edit(EmployeeDetailsVM employeeDetailsVM)
{
try
{
EmployeeDetail emp = db.EmployeeInfo.Find(employeeDetailsVM.EmployeeId);
emp.Address = employeeDetailsVM.Address;
emp.Number = employeeDetailsVM.Number;
emp.Name = employeeDetailsVM.Name;
emp.UpdatedBy = 1;
emp.UpdatedDate = DateTime.Now;
db.SaveChanges();
var routeValues = new RouteValueDictionary {
{ "Message", "Success" }
};
return(RedirectToAction("Index", "EmployeeDetail", routeValues));
}
catch (Exception ex)
{
var routeValues = new RouteValueDictionary {
{ "Message", "Error" }
};
return(RedirectToAction("Index", "EmployeeDetail", routeValues));
}
}
public ActionResult Details(string id)
{
EmployeeDetailsVM obj = iEmployee.EmployeeDetails(id);
ViewBag.Path = ConfigurationManager.AppSettings["HrFile"];
return(PartialView(obj));
}
public IActionResult Details(int id)
{
EmployeeDetailsVM model = new EmployeeDetailsVM();
model.Employee = _employeeDbUnitOfWork.GetGenericRepository <Employee>().Get().Where(e => e.EmployeeID == id).FirstOrDefault();
model.Products = _employeeDbUnitOfWork.GetGenericRepository <Product>().Get();
model.Sales = _employeeDbUnitOfWork.GetGenericRepository <Sale>().Get().GetTotalSalesByEmployeeId(id);
return(View(model));
}
public ActionResult Edit(int Id)
{
EmployeeDetail emp = db.EmployeeInfo.Find(Id);
EmployeeDetailsVM employeeDetailsVM = new EmployeeDetailsVM()
{
Address = emp.Address,
EmployeeId = emp.Id,
Name = emp.Name,
Number = emp.Number
};
return(View(employeeDetailsVM));
}
public ViewResult Details(int id)
{
Employee employee = _employeeRepository.GetEmployee(id);
if (employee == null)
{
Response.StatusCode = 404;
return(View("EmployeeNotFound", id));
}
string pageTitle = "Employee Details";
EmployeeDetailsVM viewModel = new EmployeeDetailsVM(pageTitle, employee);
return(View(viewModel));
}
public async Task <IActionResult> Sell(int id, int productID)
{
EmployeeDetailsVM model = new EmployeeDetailsVM();
try
{
model.Employee = _employeeDbUnitOfWork.GetGenericRepository <Employee>().Get().Where(e => e.EmployeeID == id).FirstOrDefault();
Sale sale = new Sale
{
ProductID = productID,
EmployeeID = id,
SaleData = DateTime.Now,
Count = 1
};
_employeeDbUnitOfWork.CreateTransaction();
await _employeeDbUnitOfWork.GetGenericRepository <Sale>().Insert(sale);
model.Sales = _employeeDbUnitOfWork.GetGenericRepository <Sale>().Get().GetTotalSalesByEmployeeId(id);
Product product = _employeeDbUnitOfWork.GetGenericRepository <Product>().Get().Where(e => e.ProductID == productID).FirstOrDefault();
product.Stock--;
_employeeDbUnitOfWork.GetGenericRepository <Product>().Update(product);
model.Products = _employeeDbUnitOfWork.GetGenericRepository <Product>().Get();
_employeeDbUnitOfWork.Commit();
//test
var productsInproductDb = _productDbUnitOfWork.GetGenericRepository <Product>().Get();
foreach (var p in productsInproductDb)
{
Debug.WriteLine("p--" + p.Name);
}
var productsInemployeeDb = _employeeDbUnitOfWork.GetGenericRepository <Product>().Get();
foreach (var p in productsInemployeeDb)
{
Debug.WriteLine("e--" + p.Name);
}
}
catch (Exception err)
{
_employeeDbUnitOfWork.Rollback();
}
return(View("Details", model));
}
// GET: VendorInfoes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeDetail employeeDetail = db.EmployeeInfo.Find(id);
EmployeeDetailsVM employeeDetailsVM = new EmployeeDetailsVM();
employeeDetailsVM.Address = employeeDetail.Address;
employeeDetailsVM.EmployeeId = employeeDetail.Id;
employeeDetailsVM.Name = employeeDetail.Name;
employeeDetailsVM.Number = employeeDetail.Number;
employeeDetailsVM.CreatedDate = employeeDetail.CreatedDate;
employeeDetailsVM.UpdatedDate = employeeDetail.UpdatedDate;
if (employeeDetail == null)
{
return(HttpNotFound());
}
return(View(employeeDetailsVM));
}
public ViewResult Details(int?id)
{
Employee emp = _employeeRepository.GetEmployee(id.Value);
if (emp == null)
{
Response.StatusCode = 404;
return(View("EmployeeNotFound", id.Value));
}
EmployeeDetailsVM employeeVM = new EmployeeDetailsVM()
{
Employee = emp,
PageTitle = "Employee Details"
};
//Employee model = _employeeRepository.GetEmployee(id);
//ViewBag.Employee = model;
//ViewBag.pagedetails = "Employee Details";
return(View(employeeVM));
}
public ActionResult Details(int id)
{
var data = _employeeRepository.GetByID(id).Select(e => new
{
Full_Name = e.Full_Name,
Email = e.Email,
Address = e.Address,
Phone = e.Phone,
Salary = e.Salary,
Department = e.Department
}).SingleOrDefault();
var empObj = new EmployeeDetailsVM
{
Full_Name = data.Full_Name,
Email = data.Email,
Address = data.Address,
Phone = data.Phone,
Salary = data.Salary,
Department = data.Department
};
return(View(empObj));
}
public ActionResult Create()
{
EmployeeDetailsVM employeeDetailsVM = new EmployeeDetailsVM();
return(View(employeeDetailsVM));
}
public EmployeeDetailsVM EmployeeDetails(string empId)
{
SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 50)
{
Value = "get-details"
}
, new SqlParameter("@EmployeeId", SqlDbType.Int)
{
Value = empId
} };
var table = SqlHelper.ExecuteDataSet("spEmployee", param);
EmployeeDetailsVM obj = new EmployeeDetailsVM();
List <JobHistoryVM> list = new List <JobHistoryVM>();
DataTable details = table.Tables[0];
DataTable history = table.Tables[1];
if (details != null && details.Rows.Count > 0)
{
obj.FirstName = details.Rows[0]["FirstName"].ToString();
obj.MiddleName = details.Rows[0]["MiddleName"].ToString();
obj.LastName = details.Rows[0]["LastName"].ToString();
obj.Gender = details.Rows[0]["Gender"].ToString();
obj.Phone = details.Rows[0]["Phone"].ToString();
obj.Nationality = details.Rows[0]["Nationality"].ToString();
obj.DOB = details.Rows[0]["DOB"] != DBNull.Value ? Convert.ToDateTime(details.Rows[0]["DOB"]) : (DateTime?)null; // Convert.ToDateTime(details.Rows[0]["DOB"]);
obj.MaritalStatus = details.Rows[0]["MaritalStatus"].ToString();
obj.Ethnicity = details.Rows[0]["Ethnicity"].ToString();
obj.Province = Convert.ToString(details.Rows[0]["Province"]);
obj.District = Convert.ToString(details.Rows[0]["District"]);
obj.Address = details.Rows[0]["Address"].ToString();
obj.Email = details.Rows[0]["Email"].ToString();
obj.BasicSalary = details.Rows[0]["BasicSalary"].ToString();
obj.ProfilePath = details.Rows[0]["ProfilePath"].ToString();
obj.ContractFile = details.Rows[0]["ContractFile"].ToString();
obj.BankName = details.Rows[0]["BankName"].ToString();
obj.BankBranch = details.Rows[0]["BankBranch"].ToString();
obj.AccountNo = details.Rows[0]["AccountNo"].ToString();
obj.AccountName = details.Rows[0]["AccountName"].ToString();
obj.StartDate = Convert.ToDateTime(details.Rows[0]["StartDate"]);
}
if (history != null && history.Rows.Count > 0)
{
foreach (DataRow drow in history.Rows)
{
JobHistoryVM job = new JobHistoryVM();
job.Designation = Convert.ToString(drow["Designation"]);
job.Department = Convert.ToString(drow["Department"]);
job.StartDate = Convert.ToDateTime(drow["StartDate"]);
job.EndDate = drow["EndDate"] != DBNull.Value? Convert.ToDateTime(drow["EndDate"]) :(DateTime?)null;
job.Shift = Convert.ToString(drow["Shift"]);
job.EmployementType = Convert.ToString(drow["EmployementType"]);
job.Salary = Convert.ToString(drow["Salary"]);
job.OTRate = Convert.ToString(drow["OTRate"]);
job.WorkingHR = Convert.ToString(drow["WorkingHR"]);
job.ContractExpiry = Convert.ToString(drow["ContractExpiry"]);
job.PaySchedule = Convert.ToString(drow["PaySchedule"]);
job.IsCurrent = Convert.ToBoolean(drow["IsCurrent"]);
list.Add(job);
}
}
obj.jobList = list;
return(obj);
}
