public ActionResult Create()
{
JobCardApp obj = new JobCardApp();
MultipleDayJobCardHelper(obj);
return(View(obj));
}
private void SingleDayJobCardHelper(JobCardApp obj)
{
VMLoggedUser LoggedInUser = Session["LoggedInUser"] as VMLoggedUser;
ViewBag.EmpNo = LoggedInUser.OEmpID;
ViewBag.JobCardTypeID = new SelectList(DDService.GetJobCardType().ToList().Where(aa => aa.PJobCardTypeID != 1 && aa.PJobCardTypeID != 3 && aa.PJobCardTypeID != 4).ToList(), "PJobCardTypeID", "JobCardName", obj.JobCardTypeID);
}
//SINGLE DAY CREATE
public ActionResult SingleDay()
{
JobCardApp obj = new JobCardApp();
SingleDayJobCardHelper(obj);
return(View(obj));
}
public void PostCreate(JobCardApp obj, VMLoggedUser LoggedInUser)
{
try
{
//Save the value provided in the Get of Jobcard and save them in the Jobcard app Table.
obj.DateCreated = DateTime.Now;
obj.JobCardStageID = "P";
obj.LineManagerID = LoggedInUser.LineManagerID;
obj.Remarks = obj.Remarks;
obj.JobCardTypeID = obj.JobCardTypeID;
obj.DateStarted = obj.DateStarted;
obj.DateEnded = obj.DateEnded;
JobCardAppRepository.Add(obj);
JobCardAppRepository.Save();
// Add Notification to Line Manager that he has a Pending Job card request
DDService.SaveNotification((int)obj.LineManagerID, "/ESSP/ESSPJobCard/PendingJobCardIndex",
Convert.ToInt32(NotificationTypeJCEnum.JCPending), true, obj.EmployeeID, obj.PJobCardAppID);
SaveJobCardFlow((int)obj.LineManagerID, (int)LoggedInUser.PUserID, obj.JobCardStageID, obj.PJobCardAppID, obj.Remarks, "");
// Save entry in Notification email about the Submission of leave application that is sent to LIne manager through the Service
VHR_UserEmployee LMUser = DDService.GetEmployeeUser(obj.LineManagerID, null);
VHR_UserEmployee EmpUser = DDService.GetEmployeeUser(null, obj.EmployeeID);
Expression <Func <VAT_JobCardApplication, bool> > SpecificEntries = c => (c.PJobCardAppID == obj.PJobCardAppID);
VAT_JobCardApplication dbVAT_JobCardApplication = VATJobCardApplicationReporsitory.FindBy(SpecificEntries).First();
DDService.GenerateEmail(LMUser.OfficialEmailID, "", "Job Card Application # " + obj.PJobCardAppID.ToString(),
ESSPText.GetPendingJCText(dbVAT_JobCardApplication, LMUser.UserEmployeeName), LoggedInUser.PUserID, Convert.ToInt32(NotificationTypeJCEnum.JCPending));
}
catch (Exception ex)
{
}
}
public void RejectJobCard(VMESSPCommon vmESSPCommon, VMLoggedUser LoggedInUser)
{
//Gets the First entry and comment box for the approval of the Job Card Application
JobCardApp jobCardApp = JobCardAppRepository.GetSingle((int)vmESSPCommon.PID);
//Changes the stage of JobCard to "R"(Rejected).
jobCardApp.JobCardStageID = "R";
JobCardAppRepository.Edit(jobCardApp);
UnitOfWork.Commit();
// Add notifcation to Employee end about the Rejection of the Job Card
VHR_UserEmployee LMUser = DDService.GetEmployeeUser(jobCardApp.LineManagerID, null);
VHR_UserEmployee EmpUser = DDService.GetEmployeeUser(null, jobCardApp.EmployeeID);
DDService.SaveNotification((int)EmpUser.PUserID, "/ESSP/ESSPJobCard/Index",
Convert.ToInt32(NotificationTypeJCEnum.JCRejected), true, jobCardApp.EmployeeID, jobCardApp.PJobCardAppID);
// Create Entry in the Job card flow.
SaveJobCardFlow(EmpUser.PUserID, LMUser.PUserID, jobCardApp.JobCardStageID, jobCardApp.PJobCardAppID, "", vmESSPCommon.Comment);
// Save Email in notification email about the Rejection of the jobcard that is being sent to the employeee through Service.
Expression <Func <VAT_JobCardApplication, bool> > SpecificEntries2 = c => (c.PJobCardAppID == jobCardApp.PJobCardAppID);
VAT_JobCardApplication dbVAT_JobCardApplication = VATJobCardApplicationReporsitory.FindBy(SpecificEntries2).First();
DDService.GenerateEmail(EmpUser.OfficialEmailID, "", "Job Card Application # " + jobCardApp.PJobCardAppID.ToString(),
ESSPText.GetRejectJCText(dbVAT_JobCardApplication, EmpUser.UserEmployeeName, LMUser.UserEmployeeName, LMUser.DesignationName), LoggedInUser.PUserID, Convert.ToInt32(NotificationTypeJCEnum.JCRejected));
// Disable Notifications of Pending Job Card
int notiTypeID1 = Convert.ToInt32(NotificationTypeJCEnum.JCPending);
Expression <Func <Notification, bool> > SpecificEntries = c => (c.UserID == LoggedInUser.PUserID && c.Status == true && (c.NotificationTypeID == notiTypeID1) && c.PID == jobCardApp.PJobCardAppID);
DDService.DeleteNotification(SpecificEntries);
}
private void AddJobCardData(Emp _selEmp, JobCardApp jcApp)
{
int _empID = _selEmp.EmpID;
string _empDate = "";
int _userID = (int)jcApp.UserID;
DateTime _Date = (DateTime)jcApp.DateStarted;
while (_Date <= jcApp.DateEnded)
{
_empDate = _selEmp.EmpID + _Date.ToString("yyMMdd");
AddJobCardDataToDatabase(_empDate, _empID, _Date, _userID, jcApp);
if (db.AttProcesses.Where(aa => aa.ProcessDate == _Date).Count() > 0)
{
switch (jcApp.CardType)
{
case 8: // Training
AddJCTrainingToAttData(_empDate, _empID, _Date, _userID, (short)jcApp.CardType);
break;
case 9: // Tour
AddJCTourToAttData(_empDate, _empID, _Date, _userID, (short)jcApp.CardType);
break;
case 10: // Visit
AddJCVisitToAttData(_empDate, _empID, _Date, _userID, (short)jcApp.CardType);
break;
}
}
_Date = _Date.AddDays(1);
}
}
public ActionResult DeleteJC(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
JobCardApp jobcardapp = db.JobCardApps.Find(id);
if (jobcardapp != null)
{
List <JobCardDetail> jcEmps = new List <JobCardDetail>();
jcEmps = db.JobCardDetails.Where(aa => aa.JCAppID == id).ToList();
if (jcEmps.Count > 0)
{
foreach (var item in jcEmps)
{
db.JobCardDetails.Remove(item);
db.SaveChanges();
RemoveFromAttData(item);
}
}
db.JobCardApps.Remove(jobcardapp);
db.SaveChanges();
//return HttpNotFound();
}
return(RedirectToAction("JobCardList"));
}
private bool ValidateJobCard(JobCardApp jobCardApp)
{
List <JobCardApp> _Lc = new List <JobCardApp>();
DateTime _DTime = new DateTime();
DateTime _DTimeLV = new DateTime();
_Lc = db.JobCardApps.Where(aa => aa.CriteriaDate == jobCardApp.CriteriaDate).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);
}
public ActionResult MultipleDay()
{
JobCardApp obj = new JobCardApp();
obj = JobCardService.GetMultipleDay();
CreateHelper(obj);
return(View(obj));
}
public ActionResult DeleteConfirmed(int id)
{
JobCardApp jobcardapp = db.JobCardApps.Find(id);
db.JobCardApps.Remove(jobcardapp);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "JobCardID,DateCreated,DateStarted,DateEnded,CardType,UserID,JobCardCriteria,CriteriaData,Status,TimeIn,TimeOut,WorkMin")] JobCardApp jobcardapp)
{
if (ModelState.IsValid)
{
//db.Entry(jobcardapp).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(jobcardapp));
}
private void AddJobCardData(Emp _selEmp, JobCardApp jcApp)
{
int _empID = _selEmp.EmpID;
string _empDate = "";
int _userID = (int)jcApp.UserID;
DateTime _Date = (DateTime)jcApp.DateStarted;
while (_Date <= jcApp.DateEnded)
{
_empDate = _selEmp.EmpID + _Date.ToString("yyMMdd");
AddJobCardDataToDatabase(_empDate, _empID, _Date, _userID, jcApp);
if (db.AttDatas.Where(aa => aa.EmpDate == _empDate).Count() > 0)
{
//1 Official Duty
//2 Present
//3 Absent
//5 Special Holiday
switch (jcApp.CardType)
{
case 1: // Official Duty
AddJCToAttData(_empDate, _empID, _Date, "O", false, false, false, false, true, "Offical Duty");
break;
case 2: // Present
AddJCToAttData(_empDate, _empID, _Date, "D", false, false, false, false, true, "Present");
break;
case 3: // Absent
AddJCToAttData(_empDate, _empID, _Date, "D", true, false, false, false, false, "Absent");
break;
case 5: // Field Visit
AddJCToAttData(_empDate, _empID, _Date, "D", false, false, false, false, true, "Field Visit");
break;
case 6: // Monitoring Visit
AddJCToAttData(_empDate, _empID, _Date, "D", false, false, false, false, true, "Monitoring Visit");
break;
case 7: // Training
AddJCToAttData(_empDate, _empID, _Date, "D", false, false, false, false, true, "Training");
break;
case 8: // Seminar / Workshop
AddJCToAttData(_empDate, _empID, _Date, "D", false, false, false, false, true, "Seminar / Workshop");
break;
case 9: // Official Meeting
AddJCToAttData(_empDate, _empID, _Date, "D", false, false, false, false, true, "Official Meeting");
break;
}
}
_Date = _Date.AddDays(1);
}
}
public ActionResult Create([Bind(Include = "JobCardID,DateCreated,DateStarted,DateEnded,CardType,UserID,JobCardCriteria,CriteriaData,Status,TimeIn,TimeOut,WorkMin")] JobCardApp jobcardapp)
{
if (ModelState.IsValid)
{
db.JobCardApps.Add(jobcardapp);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(jobcardapp));
}
public void PostSingleDay(JobCardApp obj)
{
obj.DateCreated = DateTime.Now;
obj.DateEnded = obj.DateStarted;
if (obj.TimeEnd != null && obj.TimeEnd != null)
{
obj.Minutes = (short)((obj.TimeEnd.Value - obj.TimeStart.Value).TotalMinutes);
}
JobCardAppRepository.Add(obj);
UnitOfWork.Commit();
}
// GET: /JobCard/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
JobCardApp jobcardapp = db.JobCardApps.Find(id);
if (jobcardapp == null)
{
return(HttpNotFound());
}
return(View(jobcardapp));
}
private void AddJobCardData(Emp _selEmp, JobCardApp jcApp)
{
int _empID = _selEmp.EmpID;
string _empDate = "";
int _userID = (int)jcApp.UserID;
DateTime _Date = (DateTime)jcApp.DateStarted;
while (_Date <= jcApp.DateEnded)
{
_empDate = _selEmp.EmpID + _Date.ToString("yyMMdd");
AddJobCardDataToDatabase(_empDate, _empID, _Date, _userID, jcApp);
if (db.AttProcesses.Where(aa => aa.ProcessDate == _Date).Count() > 0)
{
switch (jcApp.CardType)
{
case 1: //Day Off
AddJCDayOffToAttData(_empDate, _empID, _Date, _userID, (short)jcApp.CardType);
break;
case 2: //GZ Holiday
AddJCGZDayToAttData(_empDate, _empID, _Date, _userID, (short)jcApp.CardType);
break;
case 3: //Absent
AddJCAbsentToAttData(_empDate, _empID, _Date, _userID, (short)jcApp.CardType);
break;
case 4: //official Duty
AddJCODDayToAttData(_empDate, _empID, _Date, _userID, (short)jcApp.CardType);
break;
case 8: // Double Duty
AddDoubleDutyAttData(_empDate, _empID, _Date, _userID, jcApp);
break;
case 9: // Badli Duty
AddBadliTableData(_empID, _empDate, _Date, (short)jcApp.OtherValue, jcApp.Remarks);
AddBadliAttData(_empDate, _empID, _Date, _userID, jcApp);
break;
//case 10:// Late In Margin
// AddLateInMarginAttData(_empDate, _empID, _Date, _userID, (short)jcApp.CardType);
// break;
}
}
_Date = _Date.AddDays(1);
}
HelperClass.MyHelper.SaveAuditLog(_userID, (byte)MyEnums.FormName.EditAttendance, (byte)MyEnums.Operation.Edit, DateTime.Now);
}
public ActionResult Delete(JobCardApp obj)
{
Expression <Func <JobCardApp, bool> > SpecificEntries2 = aa => aa.PJobCardAppID == obj.PJobCardAppID;
JobCardAppService.GetIndexSpecific(SpecificEntries2);
if (ModelState.IsValid)
{
JobCardAppService.PostDelete(obj);
// Create Reprocess Request
DDService.ProcessDailyAttendance(obj.DateStarted, obj.DateEnded, (int)obj.EmployeeID, obj.EmployeeID.ToString());
DDService.ProcessMonthlyAttendance(obj.DateStarted, (int)obj.EmployeeID, obj.EmployeeID.ToString());
return(Json("OK", JsonRequestBehavior.AllowGet));
}
return(PartialView("Delete", obj));
}
public ActionResult Delete(JobCardApp obj)
{
VMLoggedUser LoggedInUser = Session["LoggedInUser"] as VMLoggedUser;
Expression <Func <VEP_JobCardApplication, bool> > SpecificEntries2 = c => (c.PJobCardAppID == obj.PJobCardAppID);
VEP_JobCardApplication vpjca = VEPJobCardApplicationService.GetIndexSpecific(SpecificEntries2).First();
JobCardESSPService.PostDelete(obj);
// Disable Notifications
int notiTypeID1 = Convert.ToInt32(NotificationTypeJCEnum.JCPending);
Expression <Func <Notification, bool> > SpecificEntries = c => (c.EmployeeID == LoggedInUser.UserEmpID && c.Status == true && (c.NotificationTypeID == notiTypeID1) && c.PID == vpjca.PJobCardAppID);
DDService.DeleteNotification(SpecificEntries);
ToasterMessages.Add("Job card Deleted successfully !");
Session["ToasterMessages"] = ToasterMessages;
return(Json("OK", JsonRequestBehavior.AllowGet));
}
public string ApproveJobCard(VMESSPCommon vmESSPCommon, VMLoggedUser LoggedInUser, string Message)
{
//Gets the First entry and comment box for the approval of the Job Card Application
JobCardApp jobCardApp = JobCardAppRepository.GetSingle((int)vmESSPCommon.PID);
//Changes the stage of JobCard to "A"(Approved).
//if (DDService.IsDateLieBetweenActivePayroll(jobCardApp.DateStarted))
//{
Expression <Func <PayrollPeriod, bool> > SpecificEntries96 = c => jobCardApp.DateStarted >= c.PRStartDate && jobCardApp.DateStarted <= c.PREndDate && c.PeriodStageID == "C";
List <PayrollPeriod> dbPayrollPeriods = PayrollPeriodService.GetIndexSpecific(SpecificEntries96).ToList();
if (dbPayrollPeriods.Count() > 0)
{
Message = "Cannot Approve Job Cards of Closed Payroll Period";
}
if (Message == "")
{
jobCardApp.JobCardStageID = "A";
JobCardAppRepository.Edit(jobCardApp);
UnitOfWork.Commit();
//Gets the LM and Employee Information
VHR_UserEmployee LMUser = DDService.GetEmployeeUser(jobCardApp.LineManagerID, null);
VHR_UserEmployee EmpUser = DDService.GetEmployeeUser(null, jobCardApp.EmployeeID);
// Add notifcation to Employee end about the Approval of the Job Card
DDService.SaveNotification((int)EmpUser.PUserID, "/ESSP/ESSPJobCard/Index",
Convert.ToInt32(NotificationTypeJCEnum.JCApproved), true, jobCardApp.LineManagerID, jobCardApp.PJobCardAppID);
// Create Entry in the Job card flow.
SaveJobCardFlow((int)EmpUser.PUserID, (int)jobCardApp.LineManagerID, jobCardApp.JobCardStageID, jobCardApp.PJobCardAppID, "", vmESSPCommon.Comment);
// Save Email in notification email about the approval of the jobcard that is being sent to the employeee through Service.
Expression <Func <VAT_JobCardApplication, bool> > SpecificEntries2 = c => (c.PJobCardAppID == jobCardApp.PJobCardAppID);
VAT_JobCardApplication dbVAT_JobCardApplication = VATJobCardApplicationReporsitory.FindBy(SpecificEntries2).First();
DDService.GenerateEmail(EmpUser.OfficialEmailID, "", "Job Card Application # " + jobCardApp.PJobCardAppID.ToString(),
ESSPText.GetApprovedJCText(dbVAT_JobCardApplication, EmpUser.UserEmployeeName, LMUser.UserEmployeeName, LMUser.DesignationName), LoggedInUser.PUserID, Convert.ToInt32(NotificationTypeJCEnum.JCApproved));
// Create Reprocess Request
DDService.ProcessDailyAttendance(jobCardApp.DateStarted, jobCardApp.DateEnded, (int)jobCardApp.EmployeeID, jobCardApp.EmployeeID.ToString());
DDService.ProcessMonthlyAttendance(jobCardApp.DateStarted, (int)jobCardApp.EmployeeID, jobCardApp.EmployeeID.ToString());
// Disable Notifications of Pending Job Card
int notiTypeID1 = Convert.ToInt32(NotificationTypeJCEnum.JCPending);
Expression <Func <Notification, bool> > SpecificEntries = c => (c.UserID == LoggedInUser.PUserID && c.Status == true && (c.NotificationTypeID == notiTypeID1) && c.PID == jobCardApp.PJobCardAppID);
DDService.DeleteNotification(SpecificEntries);
}
return(Message);
}
public void PostCreate3(VMJobCardCreate es, int?[] employeeIds, VMLoggedUser LoggedInUser)
{
string Message = "";
foreach (var empid in employeeIds)
{
VHR_EmployeeProfile employee = DDService.GetEmployeeInfo(LoggedInUser).Where(aa => aa.PEmployeeID == empid).First();
Expression <Func <Shift, bool> > SpecificEntries97 = c => c.PShiftID == employee.ShiftID;
Shift shifts = ShiftService.GetIndexSpecific(SpecificEntries97).First();
if (shifts.GZDays == true)
{
List <Holiday> holiday = DDService.GetHolidays().Where(aa => aa.HolidayDate == es.JobDateFrom).ToList();
if (holiday.Count > 0)
{
Message = "Cannot apply job card of the Gazetted Holiday";
}
}
Expression <Func <PayrollPeriod, bool> > SpecificEntries96 = c => es.JobDateFrom >= c.PRStartDate && es.JobDateFrom <= c.PREndDate && c.PeriodStageID == "C";
List <PayrollPeriod> dbPayrollPeriods = PayrollPeriodService.GetIndexSpecific(SpecificEntries96).ToList();
if (dbPayrollPeriods.Count() > 0)
{
Message = "Cannot enter Job card in Closed Payroll Period";
}
if (Message == "")
{
JobCardApp jcApp = new JobCardApp();
jcApp.DateCreated = DateTime.Now;
jcApp.DateEnded = es.JobDateTo;
jcApp.DateStarted = es.JobDateFrom;
jcApp.EmployeeID = empid;
jcApp.Minutes = es.TotalMinutes;
jcApp.Remarks = es.Remarks;
jcApp.JobCardTypeID = es.JobCardTypeID;
jcApp.UserID = LoggedInUser.PUserID;
JobCardAppRepository.Add(jcApp);
JobCardAppRepository.Save();
DDService.ProcessDailyAttendance(jcApp.DateStarted, jcApp.DateEnded, (int)jcApp.EmployeeID, jcApp.EmployeeID.ToString());
DDService.ProcessMonthlyAttendance(jcApp.DateStarted, (int)jcApp.EmployeeID, jcApp.EmployeeID.ToString());
}
else
{
}
}
}
private void AddJobCardsIntoDatabse(string empDate, VMLeaveEditor datas, string Name, string date)
{
User LoggedInUser = Session["LoggedUser"] as User;
int empid = db.Emps.First(aa => aa.EmpNo == datas.EmpNo).EmpID;
int cardtypeid = db.JobCards.First(aa => aa.WorkCardName == Name).WorkCardID;
JobCardApp jc = new JobCardApp();
jc.DateStarted = Convert.ToDateTime(date);
jc.DateEnded = Convert.ToDateTime(date);
jc.CardType = (short)cardtypeid;
jc.JobCardCriteria = "E";
jc.CriteriaDate = empid;
jc.Status = false;
jc.UserID = LoggedInUser.UserID;
List <Emp> emptemp = db.Emps.Where(aa => aa.EmpNo == datas.EmpNo && aa.Deleted == false).ToList();
if (emptemp.Count > 0)
{
if (ValidateJobCard(jc))
{
db.JobCardApps.Add(jc);
if (db.SaveChanges() > 0)
{
AddJobCardAppToJobCardData(datas);
}
}
else
{
ViewBag.validtonmessageforJC = "Job Card Validation failed";
}
}
else
{
ViewBag.validtonmessageforJC = "There is no employee found";
}
}
private void AddJobCardData(VMLeaveEditor datas, JobCardApp jcApp)
{
int _empID = db.Emps.First(aa => aa.EmpNo == datas.EmpNo).EmpID;
string _empDate = "";
int _userID = (int)jcApp.UserID;
DateTime _Date = (DateTime)jcApp.DateStarted;
while (_Date <= jcApp.DateEnded)
{
_empDate = _empID + _Date.ToString("yyMMdd");
AddJobCardDataToDatabase(_empDate, _empID, _Date, _userID, jcApp);
db.SaveChanges();
if (db.AttDatas.Where(aa => aa.EmpDate == _empDate).Count() > 0)
{
//1 Official Duty
//2 Present
//3 Absent
//5 Special Holiday
switch (jcApp.CardType)
{
case 1: // Official Duty
AddJCToAttData(_empDate, _empID, _Date, "O", false, false, false, false, true, "Offical Duty");
break;
case 5: // Field Visit
AddJCToAttData(_empDate, _empID, _Date, "O", false, false, false, false, true, "Field Visit");
break;
case 7: // Training
AddJCToAttData(_empDate, _empID, _Date, "O", false, false, false, false, true, "Training");
break;
}
}
_Date = _Date.AddDays(1);
}
}
public void PostDelete(JobCardApp obj)
{
//Get the Specific id of the jobcard that is to be deleted.
Expression <Func <JobCardDetail, bool> > SpecificEntries = c => (c.JobCardAppID == obj.PJobCardAppID);
//delete all the values of the jobcard that are present in the jobcard details.
List <JobCardDetail> jcd = JobCardDetailReporsitory.FindBy(SpecificEntries);
foreach (var jcds in jcd)
{
JobCardDetailReporsitory.Delete(jcds);
}
//Gets the list of Jobcard flows that are created in the database and have same jobcard app id as the job card to be deleted has.
Expression <Func <JobCardAppFlow, bool> > SpecificEntries2 = c => (c.JobCardAppID == obj.PJobCardAppID);
List <JobCardAppFlow> jcf = JobCardAppFlowReporsitory.FindBy(SpecificEntries2);
foreach (var jcfs in jcf)
{
JobCardAppFlowReporsitory.Delete(jcfs);
}
JobCardAppRepository.Delete(obj);
UnitOfWork.Commit();
}
public ActionResult EditAttJobCard()
{
User LoggedInUser = Session["LoggedUser"] as User;
string Message = "";
string MessageSuccess = "";
string criteria = Request.Form["CreateJCCriteria"].ToString();
short _WorkCardID = Convert.ToInt16(Request.Form["JobCardType"].ToString());
//First Save Job Card Application
JobCardApp jobCardApp = new JobCardApp();
jobCardApp.CardType = _WorkCardID;
jobCardApp.DateCreated = DateTime.Now;
jobCardApp.DateStarted = Convert.ToDateTime(Request.Form["JobDateFrom"]);
jobCardApp.DateEnded = Convert.ToDateTime(Request.Form["JobDateTo"]);
jobCardApp.Status = false;
string Remakrs = Request.Form["Remakrs"].ToString();
if (Remakrs != "")
{
jobCardApp.Remarks = Remakrs;
}
jobCardApp.UserID = LoggedInUser.UserID;
int NoOfDays = (int)(jobCardApp.DateEnded.Value - jobCardApp.DateStarted.Value).TotalDays;
if (NoOfDays < 400)
{
if (jobCardApp.DateStarted <= jobCardApp.DateEnded)
{
switch (criteria)
{
case "ByCrew":
jobCardApp.CriteriaDate = Convert.ToInt32(Request.Form["CrewID"].ToString());
jobCardApp.JobCardCriteria = "C";
if (ValidateJobCard(jobCardApp))
{
db.JobCardApps.Add(jobCardApp);
if (db.SaveChanges() > 0)
{
AddJobCardAppToJobCardData();
}
}
else
{
Message = "Job Card Validation failed";
}
break;
case "ByEmployee":
string EmpNo = Request.Form["EmpNo"].ToString();
List <EmpView> emps = new List <EmpView>();
emps = db.EmpViews.Where(aa => aa.EmpNo == EmpNo && aa.Status == true).ToList();
emps = AssistantQuery.GetFilteredEmps(emps, db.UserSections.Where(aa => aa.UserID == LoggedInUser.UserID).ToList());
if (emps.Count > 0)
{
jobCardApp.CriteriaDate = emps.FirstOrDefault().EmpID;
jobCardApp.JobCardCriteria = "E";
if (ValidateJobCard(jobCardApp))
{
db.JobCardApps.Add(jobCardApp);
if (db.SaveChanges() > 0)
{
AddJobCardAppToJobCardData();
}
}
else
{
Message = "Already applied job card on this date";
}
}
else
{
Message = "There is no employee found";
}
break;
}
}
else
{
Message = "Dates format is incorrect, please select correct format";
}
}
else
{
Message = "Job card should not be applied more then one year";
}
//List<EmpView> emps = new List<EmpView>();
ViewData["JobDateFrom"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
ViewData["JobDateTo"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
ViewBag.CrewID = new SelectList(db.Crews, "CrewID", "CrewName");
if (Message == "")
{
MessageSuccess = "Job Card created sucessfully";
}
ViewBag.DMessage = MessageSuccess;
ViewBag.CMessage = Message;
return(View("JCCreate"));
}
public ActionResult SingleDay(JobCardApp obj)
{
{
VMLoggedUser LoggedInUser = Session["LoggedInUser"] as VMLoggedUser;
string _EmpNo = Request.Form["EmpNo"].ToString();
Expression <Func <Employee, bool> > SpecificEntries = c => c.OEmpID == _EmpNo;
List <VHR_EmployeeProfile> _emp = DDService.GetEmployeeInfo(LoggedInUser).Where(aa => aa.OEmpID == _EmpNo).ToList();
VHR_EmployeeProfile employee = DDService.GetEmployeeInfo(LoggedInUser).Where(aa => aa.OEmpID == _EmpNo).First();
if (_emp.Count == 0)
{
ModelState.AddModelError("StartDate", "Emp No not exist");
}
else
{
obj.EmployeeID = _emp.First().PEmployeeID;
}
if (obj.DateStarted == null)
{
ModelState.AddModelError("DateStarted", "Date start cannot be empty");
}
if (obj.TimeStart == null || obj.TimeEnd == null)
{
ModelState.AddModelError("TimeStart", "Time Start and Time End cannot be empty");
}
if (obj.Remarks == null || obj.Remarks == "")
{
ModelState.AddModelError("Remarks", "Reason is Mandatory !");
}
if (obj.TimeEnd <= obj.TimeStart)
{
ModelState.AddModelError("TimeEnd", "Time end cannot be less than or equal to start time .");
}
Expression <Func <VEP_JobCardApplication, bool> > SpecificEntries2 = aa => obj.DateStarted == aa.DateStarted && obj.TimeStart <= aa.TimeEnd && aa.TimeStart <= obj.TimeEnd && aa.EmployeeID == obj.EmployeeID && aa.JobCardStageID != "R";
if (VEPJobCardApplicationService.GetIndexSpecific(SpecificEntries2).Count() > 0)
{
ModelState.AddModelError("TimeStart", "Already exists between the time span");
}
Expression <Func <VAT_LeaveApplication, bool> > SpecificEntries4 = aa => aa.EmpID == obj.EmployeeID && obj.DateStarted <= aa.ToDate && aa.FromDate <= obj.DateEnded && aa.IsHalf != true;
if (VATLeaveApplicationService.GetIndexSpecific(SpecificEntries4).Count() > 0)
{
ModelState.AddModelError("DateStarted", "Leave already applied for one or more days");
}
Expression <Func <PayrollPeriod, bool> > SpecificEntries96 = c => obj.DateStarted >= c.PRStartDate && obj.DateStarted <= c.PREndDate && c.PeriodStageID == "C";
List <PayrollPeriod> dbPayrollPeriods = PayrollPeriodService.GetIndexSpecific(SpecificEntries96).ToList();
if (dbPayrollPeriods.Count() > 0)
{
ModelState.AddModelError("DateStarted", "Cannot enter Job card in Closed Payroll Period");
}
Expression <Func <Shift, bool> > SpecificEntries97 = c => c.PShiftID == employee.ShiftID;
Shift shifts = ShiftService.GetIndexSpecific(SpecificEntries97).First();
if (shifts.GZDays == true)
{
List <Holiday> holiday = DDService.GetHolidays().Where(aa => aa.HolidayDate == obj.DateStarted).ToList();
if (holiday.Count > 0)
{
ModelState.AddModelError("DateStarted", "Cannot apply job card of the Gazetted Holiday");
}
}
if (ModelState.IsValid)
{
JobCardESSPService.SingleDayPostCreate(obj, LoggedInUser);
ToasterMessages.Add("Job card applied successfully !");
Session["ToasterMessages"] = ToasterMessages;
return(Json("OK", JsonRequestBehavior.AllowGet));
}
SingleDayJobCardHelper(obj);
return(PartialView("SingleDay", obj));
}
}
private bool AddBadliAttData(string _empDate, int _empID, DateTime _Date, int _userID, JobCardApp jcApp)
{
bool check = false;
try
{
//Normal Duty
using (var context = new TAS2013Entities())
{
AttData _attdata = context.AttDatas.FirstOrDefault(aa => aa.EmpDate == _empDate);
JobCard _jcCard = context.JobCards.FirstOrDefault(aa => aa.WorkCardID == jcApp.CardType);
if (_attdata != null)
{
_attdata.DutyCode = "D";
_attdata.StatusAB = false;
_attdata.StatusLeave = false;
_attdata.StatusP = true;
_attdata.Remarks = _attdata.Remarks + "[Badli][Manual]";
_attdata.StatusMN = true;
}
context.SaveChanges();
if (context.SaveChanges() > 0)
{
check = true;
}
context.Dispose();
}
}
catch (Exception ex)
{
}
return(check);
}
private bool AddJobCardDataToDatabase(string _empDate, int _empID, DateTime _currentDate, int _userID, JobCardApp jcApp)
{
bool check = false;
try
{
JobCardDetail _jobCardEmp = new JobCardDetail();
_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.Remarks = jcApp.Remarks;
db.JobCardDetails.Add(_jobCardEmp);
if (db.SaveChanges() > 0)
{
check = true;
}
}
catch (Exception ex)
{
check = false;
}
return(check);
}
public JobCardApp GetMultipleDay()
{
JobCardApp obj = new JobCardApp();
return(obj);
}
public ActionResult EditAttJobCard()
{
User LoggedInUser = Session["LoggedUser"] as User;
try
{
string _EmpNo = "";
int CompID = Convert.ToInt16(Request.Form["CompanyID"].ToString());
List <Emp> _Emp = new List <Emp>();
short _WorkCardID = Convert.ToInt16(Request.Form["JobCardType"].ToString());
//First Save Job Card Application
JobCardApp jobCardApp = new JobCardApp();
jobCardApp.CardType = _WorkCardID;
jobCardApp.DateCreated = DateTime.Now;
jobCardApp.DateStarted = Convert.ToDateTime(Request.Form["JobDateFrom"]);
jobCardApp.DateEnded = Convert.ToDateTime(Request.Form["JobDateTo"]);
jobCardApp.Status = false;
switch (Request.Form["cars"].ToString())
{
case "shift":
jobCardApp.CriteriaData = Convert.ToInt32(Request.Form["ShiftList"].ToString());
jobCardApp.JobCardCriteria = "S";
db.JobCardApps.Add(jobCardApp);
if (db.SaveChanges() > 0)
{
AddJobCardAppToJobCardData();
}
break;
case "crew":
jobCardApp.CriteriaData = Convert.ToInt32(Request.Form["CrewList"].ToString());
jobCardApp.JobCardCriteria = "C";
db.JobCardApps.Add(jobCardApp);
if (db.SaveChanges() > 0)
{
AddJobCardAppToJobCardData();
}
break;
case "section":
jobCardApp.CriteriaData = Convert.ToInt32(Request.Form["SectionList"].ToString());
jobCardApp.JobCardCriteria = "T";
db.JobCardApps.Add(jobCardApp);
if (db.SaveChanges() > 0)
{
AddJobCardAppToJobCardData();
}
break;
case "employee":
if (Request.Form["cars"].ToString() == "employee")
{
_EmpNo = Request.Form["JobEmpNo"];
_Emp = db.Emps.Where(aa => aa.EmpNo == _EmpNo && aa.CompanyID == CompID).ToList();
if (_Emp.Count > 0)
{
jobCardApp.CriteriaData = _Emp.FirstOrDefault().EmpID;
jobCardApp.JobCardCriteria = "E";
db.JobCardApps.Add(jobCardApp);
if (db.SaveChanges() > 0)
{
AddJobCardAppToJobCardData();
}
}
}
break;
}
//Add Job Card to JobCardData and Mark Legends in Attendance Data if attendance Created
Session["EditAttendanceDate"] = DateTime.Today.Date.ToString("yyyy-MM-dd");
ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
ViewBag.ShiftList = new SelectList(db.Shifts, "ShiftID", "ShiftName");
ViewBag.CrewList = new SelectList(db.Crews, "CrewID", "CrewName");
ViewBag.SectionList = new SelectList(db.Sections, "SectionID", "SectionName");
ViewBag.CMessage = "Job Card Created sucessfully";
ViewData["datef"] = Session["EditAttendanceDate"].ToString();
ViewData["JobDateFrom"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
ViewData["JobDateTo"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
ViewBag.CompanyID = new SelectList(db.Companies, "CompID", "CompName", LoggedInUser.CompanyID);
return(View("Index"));
}
catch (Exception)
{
//ViewData["datef"] = HttpContext.Session["EditAttendanceDate"].ToString();
ViewData["JobDateFrom"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
ViewData["JobDateTo"] = DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd");
ViewBag.JobCardType = new SelectList(db.JobCards, "WorkCardID", "WorkCardName");
ViewBag.ShiftList = new SelectList(db.Shifts, "ShiftID", "ShiftName");
ViewBag.CrewList = new SelectList(db.Crews, "CrewID", "CrewName");
ViewBag.SectionList = new SelectList(db.Sections, "SectionID", "SectionName");
ViewBag.CMessage = "An Error occured while creating Job Card of" + Request.Form["JobCardType"].ToString();
return(View("Index"));
}
}
public void PostMultipleDay(JobCardApp obj)
{
obj.DateCreated = DateTime.Now;
JobCardAppRepository.Add(obj);
UnitOfWork.Commit();
}
