private void OnApplyCommand(object obj)
{
if (EmployeeHours != null)
{
foreach (EmployeeHours e in EmployeeHours)
{
e.EmployeeRefId = e.Employee.EmployeeNumber;
//check if that record exist..if yes Update.
if (EmployeeData.GetEmployeeHoursByEmpnonDate(e.Employee.EmployeeNumber, e.WorkDate) != null)
{
EmployeeData.GetEmployeeHoursByEmpnonDate(e.Employee.EmployeeNumber, e.WorkDate).Description = e.Description;
EmployeeData.GetEmployeeHoursByEmpnonDate(e.Employee.EmployeeNumber, e.WorkDate).HoursWorked = e.HoursWorked;
EmployeeData.Commit();
}
else
{
if (!String.IsNullOrEmpty(e.Description) || e.HoursWorked > 0)
{
EmployeeData.Add(e, CurrentEmployee);
}
}
//Check if that record not exist ...simply add..
}
}
}
public void GetData()
{
DataTable data = DALayer.GetEmployeeData();
EmployeeModel employeeModel;
foreach (DataRow row in data.Rows)
{
employeeModel = new EmployeeModel();
employeeModel.EmployeeId = Convert.ToInt32(row["EmployeeId"].ToString());
employeeModel.FirstName = row["FirstName"].ToString();
employeeModel.LastName = row["LastName"].ToString();
employeeModel.Address = row["Address"].ToString();
employeeModel.IsPermanentEmployee = Convert.ToChar(row["IsPermanentEmployee"]);
EmployeeData.Add(employeeModel);
}
}
public ActionResult Create([Bind(Include =
"FirstName"
+ "," + "LastName"
+ "," + "DOB"
+ "," + "DOJ"
+ "," + "Gender"
+ "," + "EMail"
+ "," + "Mobile"
+ "," + "Address1"
+ "," + "Address2"
+ "," + "Salary"
+ "," + "SignatureURL"
+ "," + "UserName"
+ "," + "Password"
+ "," + "CompanyID"
+ "," + "AddUserID"
+ "," + "AddDate"
+ "," + "ArchiveUserID"
+ "," + "ArchiveDate"
)] Employee Employee)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = EmployeeData.Add(Employee);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
// ComboBox
ViewData["CompanyID"] = new SelectList(Employee_CompanyData.List(), "CompanyID", "CompanyName", Employee.CompanyID);
return(View(Employee));
}