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