Ejemplo n.º 1
0
 private bool ValidateJobCard(JobCardTime jobCardApp)
 {
     //List<JobCardApp> _Lc = new List<JobCardApp>();
     //DateTime _DTime = new DateTime();
     //DateTime _DTimeLV = new DateTime();
     //_Lc = db.JobCardApps.Where(aa => aa.CriteriaData == jobCardApp.CriteriaData).ToList();
     //foreach (var item in _Lc)
     //{
     //    _DTime = (DateTime)item.DateStarted;
     //    _DTimeLV = (DateTime)jobCardApp.DateStarted;
     //    while (_DTime <= item.DateEnded)
     //    {
     //        while (_DTimeLV <= jobCardApp.DateEnded)
     //        {
     //            if (_DTime == _DTimeLV)
     //                return false;
     //            _DTimeLV = _DTimeLV.AddDays(1);
     //        }
     //        _DTime = _DTime.AddDays(1);
     //    }
     //}
     return true;
 }
Ejemplo n.º 2
0
 private void RemoveFromAttData(JobCardTime item)
 {
     try
     {
         DateTime date = item.DutyDate.Value;
         List<Emp> emp = db.Emps.Where(aa => aa.EmpID == item.EmpID).ToList();
         ManualProcess mp = new ManualProcess();
         mp.ManualProcessAttendance(date, emp);
     }
     catch (Exception ex)
     {
     }
 }
Ejemplo n.º 3
0
 private bool AddJCVisitToAttData(JobCardTime jcTime)
 {
     bool check = false;
     try
     {
         //Normal Duty
         using (var context = new TAS2013Entities())
         {
             string empDate = jcTime.EmpID.ToString() + jcTime.DutyDate.Value.ToString("yyMMdd");
             AttData _attdata = context.AttDatas.FirstOrDefault(aa => aa.EmpDate == empDate);
             if (_attdata != null)
             {
                 _attdata.DutyCode = "D";
                 _attdata.StatusAB = false;
                 _attdata.StatusDO = false;
                 _attdata.StatusLeave = false;
                 _attdata.StatusP = true;
                 _attdata.StatusLI = false;
                 _attdata.StatusEO = false;
                 if (_attdata.ShifMin > 0)
                     _attdata.ShifMin = (short)(_attdata.ShifMin - (short)jcTime.TTime.Value.TotalMinutes);
                 else
                     _attdata.ShifMin = (short)jcTime.TTime.Value.TotalMinutes;
                 _attdata.Remarks = "[ODT-Visit]";
                 _attdata.EarlyIn = null;
                 _attdata.EarlyOut = null;
                 _attdata.LateIn = null;
                 _attdata.LateOut = null;
                 _attdata.OTMin = null;
                 _attdata.StatusEI = null;
                 _attdata.StatusEO = null;
                 _attdata.StatusLI = null;
                 _attdata.StatusLO = null;
                 _attdata.StatusP = true;
             }
             context.SaveChanges();
             if (context.SaveChanges() > 0)
                 check = true;
             context.Dispose();
         }
     }
     catch (Exception ex)
     {
     }
     return check;
 }
Ejemplo n.º 4
0
        private void AddJobCardTimeInAttData(JobCardTime jobCardTime)
        {
            if (db.AttProcesses.Where(aa => aa.ProcessDate == jobCardTime.DutyDate).Count() > 0)
                {
                    switch (jobCardTime.JobCardID)
                    {

                        case 8:// Training
                            AddJCTrainingToAttData(jobCardTime);
                            break;
                        case 9:// Tour
                            AddJCTourToAttData(jobCardTime);
                            break;
                        case 10:// Visit
                            AddJCVisitToAttData(jobCardTime);
                            break;
                        case 11:// Assignment
                            AddJCAssignToAttData(jobCardTime);
                            break;
                    }
                }
        }
Ejemplo n.º 5
0
 public ActionResult EditAttJobCard()
 {
     User LoggedInUser = Session["LoggedUser"] as User;
     string Message = "";
     QueryBuilder qb = new QueryBuilder();
     string query = qb.MakeCustomizeQuery(LoggedInUser);
     DataTable dt = qb.GetValuesfromDB("select * from EmpView " + query);
     List<EmpView> emps = dt.ToList<EmpView>();
     try
     {
         string _EmpNo = "";
         // int CompID = Convert.ToInt16(Request.Form["CompanyID"].ToString());
         List<EmpView> _Emp = new List<EmpView>();
         short _WorkCardID = Convert.ToInt16(Request.Form["JobCardType"].ToString());
         //First Save Job Card Application
         JobCardTime jobCardTime = new JobCardTime();
         jobCardTime.JobCardID = _WorkCardID;
         jobCardTime.CreatedDate = DateTime.Now;
         jobCardTime.DutyDate = Convert.ToDateTime(Request.Form["JobDate"]);
         string STime = Request.Form["SHour"].ToString();
         string ETime = Request.Form["EHour"].ToString();
         string STimeH = STime.Substring(0, 2);
         string STimeM = STime.Substring(2, 2);
         string ETimeH = ETime.Substring(0, 2);
         string ETimeM = ETime.Substring(2, 2);
         jobCardTime.CreatedBy = LoggedInUser.UserID;
         jobCardTime.AssignedBy = Convert.ToInt16(Request.Form["JobCardDesignation"].ToString());
         jobCardTime.StartTime = new TimeSpan(Convert.ToInt32(STimeH), Convert.ToInt32(STimeM), 0);
         jobCardTime.EndTime = new TimeSpan(Convert.ToInt32(ETimeH), Convert.ToInt32(ETimeM), 0);
         jobCardTime.TTime = (jobCardTime.EndTime - jobCardTime.StartTime);
         //jobCardTime.StartTime = Convert.toti(Request.Form["SHour"]);
         //jobCardTime.EndTime = Convert.ToDateTime(Request.Form["EHour"]);
         string Remakrs = Request.Form["Remakrs"].ToString();
         if (Remakrs != "")
             jobCardTime.Remarks = Remakrs;
         jobCardTime.CreatedBy = LoggedInUser.UserID;
         _EmpNo = Request.Form["JobEmpNo"];
         _Emp = emps.Where(aa => aa.EmpNo == _EmpNo).ToList();
         if (_Emp.Count > 0)
         {
             jobCardTime.EmpID = _Emp.FirstOrDefault().EmpID;
             //if ((jobCardTime.EndTime - jobCardTime.StartTime).TotalMinutes > 0)
             //{
                 if (ValidateJobCard(jobCardTime))
                 {
                     db.JobCardTimes.Add(jobCardTime);
                     if (db.SaveChanges() > 0)
                     {
                         AddJobCardTimeInAttData(jobCardTime);
                         Message = "Job Card Created Sucessfully";
                     }
                     else
                         Message = "Job Card is not created due to server error";
                 }
                 else
                     Message = "Job Card already created for FPID: " + _EmpNo;
             //}
         }
         else
             Message = "No Employee found, Please enter a valid FPID";
         //Add Job Card to JobCardData and Mark Legends in Attendance Data if attendance Created
         Session["EditAttendanceDate"] = DateTime.Today.Date.ToString("yyyy-MM-dd");
         ViewData["datef"] = Session["EditAttendanceDate"].ToString();
         ViewData["JobDate"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
         ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
         ViewBag.JobCardDesignation = new SelectList(db.Designations, "DesignationID", "DesignationName");
     }
     catch (Exception ex)
     {
         Message = "An Error occured while creating Job Card of " + Request.Form["JobCardType"].ToString();
     }
     //List<EmpView> emps = new List<EmpView>();
     ViewData["JobDate"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
     ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
     ViewBag.JobCardDesignation = new SelectList(db.Designations, "DesignationID", "DesignationName");
     ViewBag.CMessage = Message;
     ViewBag.CurrentFilter = "";
     int pageSize = 10;
     int? page = 1;
     int pageNumber = (page ?? 1);
     return View("Index", emps.ToPagedList(pageNumber, pageSize));
 }