Example #1
0
        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);
        }
Example #2
0
        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);
        }
Example #3
0
        public ActionResult DeleteConfirmed(long id)
        {
            JobCardEmp jobcardemp = db.JobCardEmps.Find(id);

            db.JobCardEmps.Remove(jobcardemp);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Example #4
0
 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));
 }
Example #5
0
        // 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
        }