public void bind()
{
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Employee user = (Employee)Session["user"];
if (user.Employee_Role != "Employee-Rep")
{
Response.Redirect("LoginPage.aspx");
}
string userid = user.Department_ID;
int requestid = Convert.ToInt32(Request.QueryString["ID"]);
var list = entities.Employee_Request.Where(x => x.Status == "Pending" && x.Department_ID == userid).
Join(entities.Emp_Request_items, a => a.Request_ID, b => b.Request_ID, (a, b)
=> new { a, b }).Where(y => y.b.Status == "Pending").
Select(x => new {
x.b.Request_ID,
x.b.Inventory.Description,
x.b.Quantity,
x.b.Inventory.Unit_Measure
}).ToList();
var list2 = entities.Emp_Request_items.Where(x => x.Request_ID == requestid && x.Status == "Pending").Select(y => new { DESCRIPTION = y.Inventory.Description, QUANTITY = y.Quantity, UNIT_MEASURE = y.Inventory.Unit_Measure, STATUS = y.Status }).ToList();
GridView1.DataSource = list2;
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
/*Code by Mani & Prasanth*/
if (!IsPostBack)
{
Employee emp = (Employee)Session["user"];
if (emp.Employee_Role != "Store-Clerk")
{
Response.Redirect("LoginPage.aspx");
}
Logic_University_Entity model = new Logic_University_Entity();
var store_Requests = model.Store_Request.Where(x => x.Status == "Done").ToList();
var list = store_Requests.Select(x => new { x.StoreRequest_ID, x.Department.Department_Name, x.Employee.Employee_Name, x.Request_Date, x.Status }).ToList();
List <ClerkViewRequest> cLerk_Request = list.Select(x => new ClerkViewRequest(x.StoreRequest_ID, x.Department_Name, x.Employee_Name, x.Request_Date, x.Status)).ToList <ClerkViewRequest>();
List <ClerkViewRequest> listdes = cLerk_Request.OrderByDescending(x => x.StoreRequest_ID).ToList();
GridView2.DataSource = listdes.ToList();
GridView2.DataBind();
}
}
public void BindSalesChart(string fromDate, string toDate)
{
using (Logic_University_Entity context = new Logic_University_Entity())
{
DateTime fromm = DateTime.Parse(fromDate);
DateTime to = DateTime.Parse(toDate);
var sales =
context.GenerateReport1.AsEnumerable()
.Select(x =>
new {
RetrivedQuantity = x.Retrived_Qunty,
Description = x.Description,
TransDate = x.Trans_Date,
}
).Where(a => (a.TransDate >= fromm) && (a.TransDate <= to))
.GroupBy(s => new { s.Description })
.Select(g =>
new {
RetrivedQuantity = g.Sum(x => x.RetrivedQuantity),
Description = g.Key.Description,
}
);
foreach (var sale in sales)
{
Chart1.Series["Series1"].Points.AddXY(sale.Description, sale.RetrivedQuantity);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
/*Code by Mani & Prasanth*/
if (!IsPostBack)
{
Employee emp = (Employee)Session["user"];
if (emp.Employee_Role != "Store-Clerk")
{
Response.Redirect("LoginPage.aspx");
}
Logic_University_Entity model = new Logic_University_Entity();
List <ClerkViewRequest> result = ClerkBusinessLogic.collectedlist();
if (!result.Count().Equals(0))
{
GridView1.DataSource = result;
GridView1.DataBind();
}
else
{
Img_NoRecordFound.Visible = true;
}
}
else
{
lbl_no.Visible = true;
}
}
// To Find the previous collection point
public string findPreviousCollectionPoint()
{
using (Logic_University_Entity t = new Logic_University_Entity())
{
var d = from x in t.Departments where x.Representative_ID == "REG002" select x;
Department d1 = d.FirstOrDefault();
return(d1.Collection_Point);
}
}
public static void Deleteitem(string itemnumber)
{
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Inventory inventory = entities.Inventories.Where(p => p.Item_Number == itemnumber).First <Inventory>();
entities.Inventories.Remove(inventory);
entities.SaveChanges();
}
}
// To notify the stor clerk by email regarding change of collection point by department representative
public void sendNotificationByEmail(Employee emp, string value)
{
using (Logic_University_Entity t = new Logic_University_Entity())
{
// need to write two sql queries
//1) to find the department of the employee logged in using session
//2) to find the email address of the clerk and send email
//3) to find the employee email address using session
Department d = t.Departments.Where(x => x.Department_ID == emp.Department_ID).First <Department>();
d.Collection_Point = value;
t.SaveChanges();
MailMessage mail = new MailMessage();
mail.IsBodyHtml = true;
mail.To.Add("*****@*****.**");
mail.Subject = "Change of Collection Point";
string departmentName = d.Department_Name;
string departHead = d.Department_Head;
string departID = d.Department_ID;
Employee e = t.Employees.Where(x => x.Employee_ID == emp.Employee_ID).First <Employee>();
string depRepName = e.Employee_Name;
StringBuilder sb = new StringBuilder();
sb.Append("<table border='5', bordercolorlight='#b9dcff', bordercolordark='#006fdd', width='400',align='center',bordercolor='black'><tr><th>Title</th><th>Details</th></tr><tr><td><b>Department</b></td>" + "<td>" + departmentName + "</td></tr>" +
"<tr><td><b>Department Head</b></td>" + "<td>" + departHead + "</td></tr>" +
"<tr><td><b>Department ID</b></td>" + "<td>" + departID + "</td></tr>" +
"<tr><td><b>Department Rep Name</b></td>" + "<td>" + depRepName + "</td></tr>" +
"<tr><td><b>Updated Collection Point</b></td>" + "<td>" + value + "</td></tr></table>");
mail.Body = sb.ToString();
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);
}
}
protected void btn_ViewDisbmt_Click(object sender, EventArgs e)
{
string department_name = DropDownList1.SelectedValue.ToString();
if (DropDownList1.SelectedIndex == 0)
{
GridView1.Visible = false;
}
else
{
using (Logic_University_Entity m = new Logic_University_Entity())
{
var depart = m.Departments.Where(x => x.Department_Name == department_name).FirstOrDefault();
string departid = depart.Department_ID;
DateTime date = DateTime.Now;
var s = date.ToString("yyyy-MM-dd");
DateTime da = DateTime.Parse(s);
var singlist = m.Disbursement_List.Where(x => x.Department_ID == departid && x.Status == "Pending").ToList();
List <Disbursement_List_dtl> list = new List <Disbursement_List_dtl>();
foreach (var v in singlist)
{
list.AddRange(m.Disbursement_List_dtl.Where(x => x.Disburse_ID == v.Disburse_ID).ToList());
}
var list2 = list.GroupBy(x => new { x.Item_number, x.Discription }).Select(x => new { x.Key.Item_number, x.Key.Discription, request_quantity = x.Sum(y => y.req_qunty), delivered_quantity = x.Sum(y => y.Quantity) }).ToList();
if (list2.Count != 0)
{
Img_NoRecord.Visible = false;
GridView1.Visible = true;
GridView1.DataSource = list2.ToList();
GridView1.DataBind();
}
else
{
Img_NoRecord.Visible = true;
GridView1.Visible = false;
Button3.Enabled = false;
}
}
}
}
public static void Edititem(string itemnumber, int quantity, string suppiler_ID_1, string suppiler_ID_2, string suppiler_ID_3)
{
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Inventory inventory = entities.Inventories.Where(p => p.Item_Number == itemnumber).First <Inventory>();
inventory.Quantity = quantity;
inventory.Supplier_ID_1 = suppiler_ID_1;
inventory.Supplier_ID_2 = suppiler_ID_2;
inventory.Supplier_ID_3 = suppiler_ID_3;
entities.SaveChanges();
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
string value = RadioButtonList1.SelectedValue;
using (Logic_University_Entity t = new Logic_University_Entity())
{
Employee user = (Employee)Session["user"];
Label2.Text = value;
bl.sendNotificationByEmail(user, value);
Label1.Text = "Collection Point has been Updated! Email sent to store clerk.";
}
}
public void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int quantity = Convert.ToInt32(e.NewValues["Quantity"]);
using (Logic_University_Entity entitie = new Logic_University_Entity())
{
int id = Convert.ToInt32(Request.QueryString["ID"]);
string description = row.Cells[0].Text.ToString();
string item_number = entitie.Inventories.Where(x => x.Description == description).Select(x => x.Item_Number).FirstOrDefault();
var emp = entitie.Emp_Request_items.Where(p => p.Request_ID == id && p.Item_Number == item_number).FirstOrDefault();
emp.Quantity = quantity;
entitie.SaveChanges();
GridView1.EditIndex = -1;
bind();
}
}
public void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
string descr = row.Cells[0].Text.ToString();
using (Logic_University_Entity entities = new Logic_University_Entity())
{
var xy1 = entities.Inventories.Where(x => x.Description == descr).FirstOrDefault();
string id = xy1.Item_Number;
int req_id = Convert.ToInt32(Request.QueryString["ID"]);
var emp = entities.Emp_Request_items.Where
(x => x.Request_ID.Equals(req_id) && x.Item_Number.Equals(id)).
FirstOrDefault();
entities.Emp_Request_items.Remove(emp);
entities.SaveChanges();
bind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Employee user = (Employee)Session["user"];
if (user.Employee_Role != "Store-Supervisor")
{
Response.Redirect("LoginPage.aspx");
}
}
Logic_University_Entity model = new Logic_University_Entity();
List <Voucher_details> voucherslist = model.Voucher_details.Where(x => x.Status == "Pending" && x.Amount <= 250).ToList();
var newlist = voucherslist.Select(x => new { Description = x.Item_Number, Quantity = x.Quantity, Amount = x.Amount, Status = x.Status }).ToList();
GridView1.DataSource = newlist;
GridView1.DataBind();
}
protected void Approve_Click(object sender, EventArgs e)
{
Employee user = (Employee)Session["user"];
Logic_University_Entity model = new Logic_University_Entity();
List <Voucher_details> voucherslist = model.Voucher_details.Where(x => x.Status == "Pending").ToList();
var newlist = voucherslist.Select(x => new { Id = x.ID, Status = x.Status }).ToList();
foreach (var v in newlist)
{
var first = model.Voucher_details.Where(x => x.ID == v.Id).FirstOrDefault();
first.Approve_ID = "STR001"; // user.Employee_ID;
first.Status = "APPROVED";
model.SaveChanges();
}
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
Logic_University_Entity model = new Logic_University_Entity();
DateTime today = DateTime.Now;
DateTime per = DateTime.Today.AddDays(-7);
var store_Requests = model.Store_Request.Where(x => x.Status == "Done" && x.Request_Date <= today && x.Request_Date > per).ToList();
var list = store_Requests.Select(x => new { x.StoreRequest_ID, x.Department.Department_Name, x.Employee.Employee_Name, x.Request_Date, x.Status }).ToList();
List <ClerkViewRequest> cLerk_Request = list.Select(x => new ClerkViewRequest(x.StoreRequest_ID, x.Department_Name, x.Employee_Name, x.Request_Date, x.Status)).ToList <ClerkViewRequest>();
List <ClerkViewRequest> listdes = cLerk_Request.OrderByDescending(x => x.StoreRequest_ID).ToList();
GridView2.DataSource = listdes.ToList();
GridView2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
/*Code by Santhosh*/
if (!IsPostBack)
{
Employee user = (Employee)Session["user"];
if (user.Employee_Role != "Employee-Rep")
{
Response.Redirect("LoginPage.aspx");
}
if (user == null)
{
// Response.Redirect("LoginPage.aspx");
}
}
using (Logic_University_Entity t = new Logic_University_Entity())
{
Label2.Text = bl.findPreviousCollectionPoint();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Employee user = (Employee)Session["user"];
if (user.Employee_Role != "Employee-Rep")
{
Response.Redirect("LoginPage.aspx");
}
string depid = user.Department_ID;
string empid = user.Employee_ID;
using (Logic_University_Entity entities = new Logic_University_Entity())
{
var list = entities.Employee_Request.Where(x => x.Department_ID == depid && x.Employee_ID == empid && x.Status == "Pending").ToList();
GridView1.DataSource = list;
GridView1.DataBind();
}
}
}
public static void AddItem(string itemnumber, string category, string description, int reorder_level, int reorder_qty, decimal price, string unit_measure, int quantity, string bin_number, string suppiler_ID_1, string suppiler_ID_2, string suppiler_ID_3)
{
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Inventory inventory = new Inventory
{
Item_Number = itemnumber,
Category = category,
Description = description,
Reorder_level = reorder_level,
Reorder_qty = reorder_qty,
Price = price,
Unit_Measure = unit_measure,
Quantity = quantity,
Bin_number = bin_number,
Supplier_ID_1 = suppiler_ID_1,
Supplier_ID_2 = suppiler_ID_2,
Supplier_ID_3 = suppiler_ID_3,
};
entities.Inventories.Add(inventory);
entities.SaveChanges();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string host = Application["host"].ToString();
Logic_University_Entity logic = new Logic_University_Entity();
Inventory inventory = new Inventory();
inventory.Item_Number = TextBox1.Text;
inventory.Category = TextBox2.Text;
inventory.Description = TextBox3.Text;
inventory.Reorder_level = Convert.ToInt32(TextBox4.Text);
inventory.Reorder_qty = Convert.ToInt32(TextBox5.Text);
inventory.Price = Convert.ToDecimal(TextBox6.Text);
inventory.Unit_Measure = TextBox7.Text;
inventory.Quantity = Convert.ToInt32(TextBox8.Text);
inventory.Bin_number = TextBox9.Text;
inventory.Supplier_ID_1 = ClerkMaintenanceBusinessLogic.GetSupplierByName(DropDownList1.SelectedValue);
inventory.Supplier_ID_2 = ClerkMaintenanceBusinessLogic.GetSupplierByName(DropDownList2.SelectedValue);
inventory.Supplier_ID_3 = ClerkMaintenanceBusinessLogic.GetSupplierByName(DropDownList3.SelectedValue);
string sus = ClerkMaintenanceBusinessLogic.AddnewInventory(inventory);
}
protected void Page_Load(object sender, EventArgs e)
{
/*Code by Mani & Prasanth*/
int id = Convert.ToInt32(Request.QueryString["ID"]);
string host = Application["host"].ToString();
if (!IsPostBack)
{
Employee emp = (Employee)Session["user"];
if (emp.Employee_Role != "Store-Clerk")
{
Response.Redirect("LoginPage.aspx");
}
using (WebClient webClient = new WebClient())
{
//String rawJSON = webClient.DownloadString("http://" + host + "/AD_Service/WCF/Service1.svc/listClerkRequest/"+id);
//List<Store_Request_items> store_Requests_items = JsonConvert.DeserializeObject<List<Store_Request_items>>(rawJSON);
// var storeRequestsitems = ClerkBusinessLogic.storeRequestItems(id);
Logic_University_Entity model = new Logic_University_Entity();
List <Store_Request_items> HistoryDetails = model.Store_Request_items.Where(x => x.StoreRequest_ID.Equals(id) && x.Status.Equals("Done")).ToList <Store_Request_items>();
if (!HistoryDetails.Count().Equals(0))
{
GridView1.DataSource = HistoryDetails;
GridView1.DataBind();
}
else
{
Response.Write("Record Not Found");
}
}
}
}
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 string disbursementprocess()
{
try
{
string[] departmentlist = new string[] { "CMC", "COO", "CSE", "ELC", "ENG", "HSE", "MEC", "MED", "REG", "STR" };
using (Logic_University_Entity m = new Logic_University_Entity())
{
DateTime date = DateTime.Now;
var s = date.ToString("yyyy-MM-dd");
DateTime da = DateTime.Parse(s);
var list = m.Request_completed.Where(x => x.Date == (da)).GroupBy(x => new { x.Department_ID, x.Item_Number, x.Inventory }).Select(x => new { x.Key.Department_ID, x.Key.Item_Number, req_qunty = x.Sum(y => y.Req_quantity), Deli_qunty = x.Sum(y => y.Delivered_quantity), x.Key.Inventory.Description }).ToList();
List <DemoClass> demos = new List <DemoClass>();
List <ClerkViewRequest> clist = new List <ClerkViewRequest>();
foreach (var v in list)
{
clist.Add(new ClerkViewRequest {
Department_ID = v.Department_ID, itemnumber = v.Item_Number, description = v.Description, Requried_qunty = v.req_qunty, delivered_qunty = v.Deli_qunty
});
}
foreach (var d in departmentlist)
{
List <ClerkViewRequest> disList = new List <ClerkViewRequest>();
foreach (var l in clist)
{
if (l.Department_ID.Equals(d))
{
disList.Add(l);
}
}
if (disList.Count != 0)
{
using (Logic_University_Entity dl = new Logic_University_Entity())
{
Disbursement_List disbursement_List = new Disbursement_List();
disbursement_List.Department_ID = d;
disbursement_List.Disburse_date = DateTime.Now;
disbursement_List.Status = "Pending";
dl.Disbursement_List.Add(disbursement_List);
dl.SaveChanges();
var lastrecord = dl.Disbursement_List.OrderByDescending(x => x.Disburse_ID).Take(1).FirstOrDefault();
foreach (var disDetails in disList)
{
Disbursement_List_dtl List_Dtl = new Disbursement_List_dtl();
List_Dtl.Disburse_ID = lastrecord.Disburse_ID;
List_Dtl.Item_number = disDetails.itemnumber;
List_Dtl.Quantity = disDetails.delivered_qunty;
List_Dtl.Discription = disDetails.description;
List_Dtl.req_qunty = disDetails.Requried_qunty;
dl.Disbursement_List_dtl.Add(List_Dtl);
dl.SaveChanges();
}
}
disList.Clear();
}
}
}
return("dis trun ");
}
catch (Exception exw)
{
return(exw.Message);
}
}
