private bool AddJobCardDataToDatabase(string _empDate, int _empID, DateTime _currentDate, int _userID, short _WorkCardID, short _CompID, DateTime dateTime) { bool check = false; try { JobCardEmp _jobCardEmp = new JobCardEmp(); _jobCardEmp.EmpDate = _empDate; _jobCardEmp.EmpID = _empID; _jobCardEmp.Dated = _currentDate; _jobCardEmp.SubmittedFrom = _userID; _jobCardEmp.WrkCardID = _WorkCardID; _jobCardEmp.CompanyID = _CompID; _jobCardEmp.DateCreated = dateTime; db.JobCardEmps.Add(_jobCardEmp); if (db.SaveChanges() > 0) { check = true; } } catch (Exception ex) { check = false; } return(check); }
private bool AddJobCardDataToDatabase(string _empDate, int _empID, DateTime _currentDate, int _userID, JobCardApp jcApp) { bool check = false; try { JobCardEmp _jobCardEmp = new JobCardEmp(); _jobCardEmp.EmpDate = _empDate; _jobCardEmp.EmpID = _empID; _jobCardEmp.Dated = _currentDate; _jobCardEmp.SubmittedFrom = _userID; _jobCardEmp.WrkCardID = jcApp.CardType; _jobCardEmp.DateCreated = DateTime.Now; _jobCardEmp.WorkMin = jcApp.WorkMin; _jobCardEmp.JCAppID = jcApp.JobCardID; _jobCardEmp.OtherValue = jcApp.OtherValue; db.JobCardEmps.Add(_jobCardEmp); if (db.SaveChanges() > 0) { check = true; } } catch (Exception ex) { check = false; } return(check); }
public ActionResult DeleteConfirmed(long id) { JobCardEmp jobcardemp = db.JobCardEmps.Find(id); db.JobCardEmps.Remove(jobcardemp); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "EmpDate,JobDataID,EmpID,Dated,SubmittedFrom,WrkCardID,SendTo,Approved,Rejected,DateCreated,Remarks,TimeIn,TimeOut,WorkMin")] JobCardEmp jobcardemp) { if (ModelState.IsValid) { db.Entry(jobcardemp).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(jobcardemp)); }
// GET: /JobCardEmpR/Delete/5 public ActionResult Delete(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } JobCardEmp jobcardemp = db.JobCardEmps.Find(id); if (jobcardemp == null) { return(HttpNotFound()); } return(View(jobcardemp)); }
private void AddJobCardToDatabase(string _empDate, int _empID, DateTime _currentDate, int _userID, short _WorkCardID, short _CompID, DateTime dateTime) { JobCardEmp _jobCardEmp = new JobCardEmp(); _jobCardEmp.EmpDate = _empDate; _jobCardEmp.EmpID = _empID; _jobCardEmp.Dated = _currentDate; _jobCardEmp.SubmittedFrom = _userID; _jobCardEmp.WrkCardID = _WorkCardID; _jobCardEmp.CompanyID = _CompID; _jobCardEmp.DateCreated = dateTime; db.JobCardEmps.Add(_jobCardEmp); db.SaveChanges(); // ToDo ===== check for already processed Attendance }