public ActionResult Select(sLeaveModel SL, string submit)
{
string queryString = "";
int lid;
int.TryParse(SL.leaveID, out lid);
switch (submit)
{
case "Approve":
queryString = "UPDATE dbo.Leave SET Status = '1', " +
"LM_Comment = '" + SL.lmComment + "' " +
"WHERE dbo.Leave.Leave_Application_ID = '" + lid + "' ";
break;
case "Reject":
queryString = "UPDATE dbo.Leave SET Status = '3', " +
"LM_Comment = '" + SL.lmComment + "' " +
"WHERE dbo.Leave.Leave_Application_ID = '" + lid + "' ";
break;
}
var connectionString =
ConfigurationManager.ConnectionStrings["DefaultConnection"].
ConnectionString;
using (var connection = new SqlConnection(connectionString))
{
var command = new SqlCommand(queryString, connection);
connection.Open();
using (var reader = command.ExecuteReader())
connection.Close();
}
/*Construct an e-mail and send it.*/
string temp_email = TempData["EmployeeEmail"] as string;
MailMessage message = new MailMessage();
message.From = new MailAddress("*****@*****.**", "GIMEL LMS");
message.To.Add(new MailAddress(temp_email));
message.Subject = "Leave Application Update";
string body = "";
body = body + "You application has been fully approved.";
message.Body = body;
SmtpClient client = new SmtpClient();
client.EnableSsl = true;
client.Credentials = new NetworkCredential("*****@*****.**", "ict@333");
client.Send(message);
return(RedirectToAction("Index"));
}
public ActionResult Select(string Id)
{
List <sLeaveModel> passedApplications = TempData["RetrievedApplications"] as List <sLeaveModel>;
sLeaveModel passingLeave = passedApplications.First(leave => leave.leaveID.Equals(Id));
List <string> balanceStrings = new List <string>();
var connectionString =
ConfigurationManager.ConnectionStrings["DefaultConnection"].
ConnectionString;
string queryString = "SELECT * FROM dbo.Leave_Balance, dbo.Employee " +
"WHERE dbo.Leave_Balance.Employee_ID = '" + passingLeave.employeeID + "' " +
"AND dbo.Employee.Employee_ID = '" + passingLeave.employeeID + "' ";
using (var connection = new SqlConnection(connectionString))
{
var command = new SqlCommand(queryString, connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
string balanceType = GetLeaveType((int)reader["Leave_ID"]);
int balance = (int)reader["Balance"];
string empGender = (string)reader["Gender"];
if (empGender.Equals("M") && balanceType.Equals("Maternity"))
{
continue;
}
string email = (string)reader["Email"];
TempData["EmployeeEmail"] = email;
string balanceString = balanceType + ": " + balance.ToString();
balanceStrings.Add(balanceString);
}
}
}
connection.Close();
}
ViewData["BalanceStrings"] = balanceStrings;
return(View(passingLeave));
}
public ActionResult Index(sLeaveModel SL)
{
return(Index());
}
