protected void Button1_Click1(object sender, EventArgs e) { try { if (Convert.ToDateTime(txtStartLdate.Text) < DateTime.Now) { Response.Write("<script>alert('Please enter proper date.....!');</script>"); return; } LeaveMaster l = new LeaveMaster(); l.LeaveReason = txtLreason.Text; l.LeaveDate = Convert.ToDateTime(txtLdate.Text); l.StartLeaveDate = Convert.ToDateTime(txtStartLdate.Text); l.EndLeaveDate = Convert.ToDateTime(txtEndLdate.Text); l.EmpId = Convert.ToInt16(Session["EmpId"].ToString()); l.LeaveStatus = "Not Approve"; db.LeaveMasters.InsertOnSubmit(l); db.SubmitChanges(); //db.manage_leavemaster(0, txtLreason.Text, "Not Approve",, 1); bindgrid(); Response.Write("<script>alert('Leave Request Sent Successfully');</script>"); txtEndLdate.Text = ""; txtLdate.Text = ""; txtLreason.Text = ""; txtStartLdate.Text = ""; } catch (Exception ex) { Response.Write(ex.Message); } }
public ActionResult DeleteConfirmed(int id) { LeaveMaster leaveMaster = db.LeaveMasters.Find(id); db.LeaveMasters.Remove(leaveMaster); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "CustomerId,LeaveId,LeaveTypeId,LeaveCount,CalenderYear,IsActive,IsDelete,IsCreated")] LeaveMaster leaveMaster) { if (ModelState.IsValid) { db.Entry(leaveMaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(leaveMaster)); }
public ActionResult Create([Bind(Include = "CustomerId,LeaveId,LeaveTypeId,LeaveCount,CalenderYear,IsActive,IsDelete,IsCreated")] LeaveMaster leaveMaster) { if (ModelState.IsValid) { db.LeaveMasters.Add(leaveMaster); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(leaveMaster)); }
public static string[] GetCompletionListLeaveName(string prefixText, int count, string contextKey) { LeaveMaster objLeaveMaster = new LeaveMaster(); DataTable dt = new DataView(objLeaveMaster.GetLeaveMaster(HttpContext.Current.Session["CompId"].ToString()), "Leave_Name like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable(); string[] txt = new string[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { txt[i] = dt.Rows[i]["Leave_Name"].ToString(); } return(txt); }
// GET: LeaveMasters/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LeaveMaster leaveMaster = db.LeaveMasters.Find(id); if (leaveMaster == null) { return(HttpNotFound()); } return(View(leaveMaster)); }
public static void CalculateLeave(OtherLeave LeaveTransaction, EmployeeLeaveList obj, LeaveListCalc leaveListCalc, int branchId) { LeaveMaster lMaster = new LeaveMaster(); if (obj.LeaveTypeId == lMaster.CASUALLEAVE(branchId)) { leaveListCalc.currentLeaves = leaveListCalc.currentLeaves - obj.Days.Value; } else if (obj.LeaveTypeId == lMaster.ANNUALLEAVE(branchId)) { leaveListCalc.currentLeaves = leaveListCalc.currentLeaves - obj.Days.Value; } if (obj.LeaveTypeId == lMaster.MEDICALLEAVE(branchId)) { leaveListCalc.currentLeaves = leaveListCalc.currentLeaves - obj.Days.Value; } }
public decimal GetLeavesCount(int BranchID, int EmployeeID, int LeaveType, DateTime fromDate) { DateTime date = fromDate; //int currentMonth = date.Month; int currentYear = date.Year; decimal eligibleLeaves = 0; decimal appliedLeave = 0; using (HrDataContext dbContext = new HrDataContext()) { OtherLeave leave = dbContext.OtherLeaves.Where(x => x.BranchId == BranchID && x.LeaveTypeId == LeaveType).FirstOrDefault(); LeaveTran leaveTransaction = dbContext.LeaveTrans.Where(x => x.EmployeeId == EmployeeID && x.BranchId == BranchID && x.LeaveType == LeaveType) .OrderByDescending(x => x.TransactionId) .ThenByDescending(x => x.CreatedOn).FirstOrDefault(); DateTime now = date; var startDate = new DateTime(now.Year, now.Month, 1); var endDate = startDate.AddMonths(1).AddDays(-1); List <EmployeeLeaveList> leaveList = dbContext.EmployeeLeaveLists .Where(x => x.EmployeeId == EmployeeID && x.BranchId == BranchID && x.LeaveTypeId == LeaveType && x.FromDate >= startDate && x.ToDate <= endDate && x.Status != UTILITY.LEAVECANCELLED).ToList(); decimal?DaysCount = 0; foreach (EmployeeLeaveList item in leaveList) { DaysCount += item.Days; } if (leaveTransaction != null) { LeaveMaster lMaster = new LeaveMaster(); if (LeaveType == lMaster.MEDICALLEAVE(BranchID)) { appliedLeave = leave.LeavesPerYear.Value - leaveTransaction.CurrentLeaves; if (leave.IsCarryForward) { eligibleLeaves = (currentYear * leave.LeavesPerYear.Value) - appliedLeave; } else { eligibleLeaves = leave.LeavesPerYear.Value - appliedLeave; } } if (LeaveType == lMaster.CASUALLEAVE(BranchID)) { appliedLeave = leave.LeavesPerYear.Value - leaveTransaction.CurrentLeaves; if (leave.IsCarryForward) { eligibleLeaves = (currentYear * leave.LeavesPerYear.Value) - appliedLeave; } else if (DaysCount == 0) { eligibleLeaves = leave.LeavesPerYear.Value; } else { eligibleLeaves = leave.LeavesPerYear.Value - appliedLeave; } } if (LeaveType == lMaster.ANNUALLEAVE(BranchID)) { appliedLeave = leave.LeavesPerYear.Value - leaveTransaction.CurrentLeaves; if (leave.IsCarryForward) { eligibleLeaves = (currentYear * leave.LeavesPerYear.Value) - appliedLeave; } else { eligibleLeaves = leave.LeavesPerYear.Value - appliedLeave; } } //else if (LeaveType == UTILITY.PAIDLEAVE) //{ // appliedLeave = leave.LeavesPerYear.Value - leaveTransaction.CurrentLeaves; // eligibleLeaves = (currentMonth * leave.LeavesPerMonth.Value) - appliedLeave; //} //else if (LeaveType == UTILITY.PAIDLEAVE) //{ // appliedLeave = leave.LeavesPerYear.Value - leaveTransaction.CurrentLeaves; // eligibleLeaves = (currentMonth * leave.LeavesPerMonth.Value) - appliedLeave; //} } return(eligibleLeaves); } }