public ActionResult Display(Models.sleaveBalanceModel mode) { if (ModelState.IsValid) { UpdateBalance(mode.annualID, mode.annual); UpdateBalance(mode.compassionateID, mode.compassionate); UpdateBalance(mode.daysInLieueID, mode.daysInLieue); UpdateBalance(mode.maternityID, mode.maternityID); UpdateBalance(mode.shortID, mode.shortLeaveHours); Response.Write("<script> alert('Sucess. The Information has been updated.');</script>"); } else { ModelState.AddModelError("errmsg", "Failed: An Error Occured. Please Check your input and try again"); } return(Display()); }
public ActionResult Display() { var lv = new Models.sleaveBalanceModel(); var model = new List <Models.sleaveBalanceModel>(); var id = 0; //var connectionString = ConfigurationManager.ConnectionStrings["CustomConnection"].ConnectionString; var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; string queryString = "Select * FROM dbo.Leave_Type"; using (var connection = new SqlConnection(connectionString)) { var command = new SqlCommand(queryString, connection); connection.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { if (reader["Leave_Name"].Equals("Annual")) { ViewBag.annualDuration = (int)reader["Duration"]; ViewBag.annualID = (int)reader["Leave_ID"]; ViewBag.annualName = (string)reader["Leave_Name"]; } else if (reader["Leave_Name"].Equals("Maternity")) { ViewBag.matDuration = (int)reader["Duration"]; ViewBag.matID = (int)reader["Leave_ID"]; ViewBag.matName = (string)reader["Leave_Name"]; } else if (reader["Leave_Name"].Equals("Sick")) { ViewBag.sickDuration = (int)reader["Duration"]; ViewBag.sickID = (int)reader["Leave_ID"]; ViewBag.sickName = (string)reader["Leave_Name"]; } else if (reader["Leave_Name"].Equals("DIL")) { ViewBag.dilDuration = (int)reader["Duration"]; ViewBag.dilID = (int)reader["Leave_ID"]; ViewBag.dilName = (string)reader["Leave_Name"]; } else if (reader["Leave_Name"].Equals("Compassionate")) { ViewBag.compDuration = (int)reader["Duration"]; ViewBag.compID = (int)reader["Leave_ID"]; ViewBag.compName = (string)reader["Leave_Name"]; } else if (reader["Leave_Name"].Equals("Short_Hours")) { ViewBag.shortDuration = (int)reader["Duration"]; ViewBag.shortID = (int)reader["Leave_ID"]; ViewBag.shortName = (string)reader["Leave_Name"]; } } // model.Add(lv); } connection.Close(); } return(View(lv)); }
public ActionResult Edit(string id) { try { if (id.Equals(null)) { return(RedirectToAction("Index")); } } catch (Exception e) { return(RedirectToAction("Index")); } int staff_id = int.Parse(id); var lv = new Models.sleaveBalanceModel(); var model = new List <Models.sleaveBalanceModel>(); //var connectionString = ConfigurationManager.ConnectionStrings["CustomConnection"].ConnectionString; var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; string queryString = "Select * FROM dbo.Leave_Type"; using (var connection = new SqlConnection(connectionString)) { var command = new SqlCommand(queryString, connection); connection.Open(); using (var reader = command.ExecuteReader()) { while (reader.Read()) { if (reader["Leave_Name"].Equals("Annual")) { lv.annualID = (int)reader["Leave_ID"]; } else if (reader["Leave_Name"].Equals("Maternity")) { lv.maternityID = (int)reader["Leave_ID"]; } else if (reader["Leave_Name"].Equals("Sick")) { lv.sickID = (int)reader["Leave_ID"]; } else if (reader["Leave_Name"].Equals("DIL")) { lv.daysInLieueID = (int)reader["Leave_ID"]; } else if (reader["Leave_Name"].Equals("Compassionate")) { lv.compassionateID = (int)reader["Leave_ID"]; } else if (reader["Leave_Name"].Equals("Short_Hours")) { lv.shortID = (int)reader["Leave_ID"]; } } // model.Add(lv); } connection.Close(); } ViewBag.sid = staff_id; ViewBag.annual = getBalance(staff_id, lv.annualID); ViewBag.maternity = getBalance(staff_id, lv.maternityID); ViewBag.sick = getBalance(staff_id, lv.sickID); ViewBag.daysInLieue = getBalance(staff_id, lv.daysInLieueID); ViewBag.compassionate = getBalance(staff_id, lv.compassionateID); ViewBag.shortLeaveHours = getBalance(staff_id, lv.shortID); return(View(lv)); }
// GET: sLeaveBalance public ActionResult Index() { var model = new List <Models.sleaveBalanceModel>(); var claimsIdentity = User.Identity as System.Security.Claims.ClaimsIdentity; var c = claimsIdentity.FindFirst(System.Security.Claims.ClaimTypes.NameIdentifier); ViewBag.claim = c; string a = c.ToString(); a = a.Substring(a.Length - 5); //System.Diagnostics.Debug.WriteLine("id is:"+a + "."); var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; string queryString = "Select Balance,Leave_Name FROM dbo.Leave_Balance, dbo.Leave_Type where Leave_Balance.Employee_ID = '" + a + "' AND Leave_Balance.Leave_ID = Leave_Type.Leave_ID"; using (var connection = new SqlConnection(connectionString)) { var command = new SqlCommand(queryString, connection); connection.Open(); int annual = 0; int sick = 0; int compassionate = 0; int maternity = 0; int shortHrs = 0; int unpaid = 0; int DIL = 0; using (var reader = command.ExecuteReader()) { while (reader.Read()) { var balance = new Models.sleaveBalanceModel(); //string leave = ""; string leave = (string)reader["Leave_Name"]; if (leave.Equals("Annual")) { annual = (int)reader["Balance"]; } ViewBag.annual = annual; if (leave.Equals("Sick")) { sick = (int)reader["Balance"]; } ViewBag.sick = sick; if (leave.Equals("Compassionate")) { compassionate = (int)reader["Balance"]; } ViewBag.compassionate = compassionate; if (leave.Equals("Maternity")) { maternity = (int)reader["Balance"]; } ViewBag.maternity = maternity; if (leave.Equals("Short_Hours")) { shortHrs = (int)reader["Balance"]; } ViewBag.shortHrs = shortHrs; if (leave.Equals("Unpaid")) { unpaid = (int)reader["Balance"]; } ViewBag.unpaid = unpaid; if (leave.Equals("DIL")) { DIL = (int)reader["Balance"]; } ViewBag.DIL = DIL; model.Add(balance); } } connection.Close(); } string queryString1 = "SELECT DATEDIFF(day,Emp_Start_Date,GETDATE()) AS DiffDate from dbo.Employee where Employee_ID = '" + a + "';"; System.Diagnostics.Debug.WriteLine("entered diff query"); using (var connection1 = new SqlConnection(connectionString)) { var command1 = new SqlCommand(queryString1, connection1); connection1.Open(); using (var reader1 = command1.ExecuteReader()) { while (reader1.Read()) { System.Diagnostics.Debug.WriteLine("inside reader"); int dif = (int)reader1["DiffDate"]; System.Diagnostics.Debug.WriteLine("dif is:" + dif); if (dif < 183) { ViewBag.annual = 0; } } } connection1.Close(); } return(View(model)); }