public static void AddRequest(string description, int quantity)
{
var xy = (from z in entities.Inventories where z.Description == description select z.Item_Number).SingleOrDefault();
string itemnumber = xy.ToString();
Emp_Request_items item = new Emp_Request_items();
item.Item_Number = itemnumber;
item.Quantity = quantity;
item.Status = "Pending";
entities.Emp_Request_items.Add(item);
entities.SaveChanges();
}
protected void btn_Submitrequest_Click(object sender, EventArgs e)
{
List <EmployeeMakeReq> employeeMakes = new List <EmployeeMakeReq>();
int count = Requestdetails.Rows.Count;
for (int i = 0; i < count; i++)
{
GridViewRow r = Requestdetails.Rows[i];
DropDownList description = (DropDownList)r.Cells[1].FindControl("DropDownList2");
TextBox b = (TextBox)r.Cells[2].FindControl("TextBox1");
string desc = description.Text.ToString();
int quantity = Convert.ToInt32(b.Text);
employeeMakes.Add(new EmployeeMakeReq(desc, quantity));
}
try
{
Employee user = (Employee)Session["user"];
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Employee_Request request = new Employee_Request();
request.Department_ID = user.Department_ID;
request.Employee_ID = user.Employee_ID;
request.Date_of_Request = System.DateTime.Now;
request.Status = "Pending";
entities.Employee_Request.Add(request);
entities.SaveChanges();
Employee_Request Requestid = entities.Employee_Request.OrderByDescending(x => x.Request_ID).Take(1).FirstOrDefault();
foreach (var v in employeeMakes)
{
var xy = (from z in entities.Inventories where z.Description == v.Description select z.Item_Number).SingleOrDefault();
string itemnumber = xy.ToString();
Emp_Request_items item = new Emp_Request_items();
item.Request_ID = Requestid.Request_ID;
item.Item_Number = itemnumber;
item.Quantity = v.Quantity;
item.Status = "Pending";
entities.Emp_Request_items.Add(item);
entities.SaveChanges();
}
btn_Submitrequest.Enabled = false;
}
MailMessage mail = new MailMessage();
mail.IsBodyHtml = false;
string empid = user.Employee_ID;
string mv = sm.Employees.Where(x => x.Employee_ID == empid).FirstOrDefault <Employee>().Email;
mail.To.Add(mv);
mail.Subject = "Application for Stationary requests";
string name = user.Employee_Name;
mail.Body = "Hi HOD," + Environment.NewLine + "I've applied for stationary." + Environment.NewLine + "Best Regards," + Environment.NewLine + name;
SmtpClient smtp = new SmtpClient();
mail.From = new MailAddress("*****@*****.**", "Surendran");
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "littleflower");
smtp.EnableSsl = true;
smtp.Send(mail);
Response.Write(@"<script language='javascript'>alert('Request Sent successfully');window.location.href='RepHome.aspx'</script>");
}
catch (Exception)
{
}
}
public static int getRequestId()
{
Emp_Request_items em = entities.Emp_Request_items.ToList <Emp_Request_items>().Last();
return(requestid);
}
