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