public ActionResult DeleteConfirmed(int id) { EmpLeaveApplication empLeaveApplication = db.EmpLeaveApplications.Find(id); db.EmpLeaveApplications.Remove(empLeaveApplication); db.SaveChanges(); return(RedirectToAction("Create")); }
public ActionResult Create([Bind(Include = "empLeaveAppID,empID,LeaveTypeID,LeaveReason,DateFiled,StartDate,EndDate,AppliedHours,ApprovedDate,ApprovedBy,IsApproved,IsWithPay,IsCancelled,Remarks,StampTime")] EmpLeaveApplication empLeaveApplication, string Create, string Edit) { EmployeeDD(); LeaveTypeDD(); SupervisorDD(); var check = empLeaveApplication.empLeaveAppID; var CheckAttendance = db.EmpLeaveApplications.FirstOrDefault(id => id.empLeaveAppID == empLeaveApplication.empLeaveAppID); if (ModelState.IsValid) { if (Create != null) { if (CheckAttendance == null) { string conn = ConfigurationManager.ConnectionStrings["kalingaPPDO"].ConnectionString; using (SqlConnection cn = new SqlConnection(conn)) { SqlCommand cmd = cn.CreateCommand(); cmd.CommandText = "Execute sp_InsertEmpLeave @empID, @empAttendanceMainID, @LeaveTypeID, @LeaveReason, @DateFiled, @StartDate, @EndDate, @AppliedHours, @ApprovedDate, @ApprovedBy, @IsApproved, @IsWithPay, @IsCancelled, @Remarks"; cmd.Parameters.AddWithValue("@empID", empLeaveApplication.empID); cmd.Parameters.AddWithValue("@empAttendanceMainID", empLeaveApplication.empAttendanceMainID.ToString()); cmd.Parameters.AddWithValue("@@attendancedetaildtrID", empLeaveApplication.AttendanceDetailDTRId.ToString()); cmd.Parameters.AddWithValue("@LeaveTypeID", empLeaveApplication.LeaveTypeID); cmd.Parameters.AddWithValue("@LeaveReason", empLeaveApplication.LeaveReason); cmd.Parameters.AddWithValue("@DateFiled", empLeaveApplication.DateFiled); cmd.Parameters.AddWithValue("@StartDate", empLeaveApplication.StartDate); cmd.Parameters.AddWithValue("@EndDate", empLeaveApplication.EndDate); cmd.Parameters.AddWithValue("@AppliedHours", empLeaveApplication.AppliedHours); cmd.Parameters.AddWithValue("@ApprovedDate", empLeaveApplication.ApprovedDate); cmd.Parameters.AddWithValue("@ApprovedBy", empLeaveApplication.ApprovedBy); cmd.Parameters.AddWithValue("@IsApproved", empLeaveApplication.IsApproved); cmd.Parameters.AddWithValue("@IsWithPay", empLeaveApplication.IsWithPay); cmd.Parameters.AddWithValue("@IsCancelled", empLeaveApplication.IsCancelled); cmd.Parameters.AddWithValue("@Remarks", empLeaveApplication.Remarks); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); return(RedirectToAction("Create")); } } else { ModelState.AddModelError(string.Empty, "Leave Number " + empLeaveApplication.empLeaveAppID + " already exists. Please click update if you're trying to update a data."); return(View(empLeaveApplication)); } } else if (Edit != null) { db.Set <EmpLeaveApplication>().AddOrUpdate(empLeaveApplication); db.SaveChanges(); return(RedirectToAction("Create")); } } return(View(empLeaveApplication)); }
public ActionResult Edit([Bind(Include = "empLeaveAppID,empID,LeaveTypeID,LeaveReason,DateFiled,StartDate,EndDate,AppliedHours,ApprovedDate,ApprovedBy,IsApproved,IsWithPay,IsCancelled,Remarks,StampTime")] EmpLeaveApplication empLeaveApplication) { if (ModelState.IsValid) { db.Entry(empLeaveApplication).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Create")); } return(View(empLeaveApplication)); }
// GET: LeaveApplication/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EmpLeaveApplication empLeaveApplication = db.EmpLeaveApplications.Find(id); if (empLeaveApplication == null) { return(HttpNotFound()); } return(View(empLeaveApplication)); }