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));
}
