public static void updateEmplyeeRequest(int Id) { var empreq = model.Employee_Request.Where(x => x.Request_ID == Id).FirstOrDefault(); empreq.Status = "Completed"; model.SaveChanges(); }
public void UpdateValues1(string repname, string departId) { Department department = model.Departments.Where(c => c.Department_ID == departId).First <Department>(); Employee repid = model.Employees.Where(x => x.Employee_Name == repname).FirstOrDefault(); department.Representative_ID = repid.Employee_ID; model.SaveChanges(); }
public static string Warelist(List <ClerkViewRequest> updatelist, Employee user) { try { Wrehse_Trans trans = new Wrehse_Trans(); trans.Employee_ID = user.Employee_ID; trans.Trans_Date = DateTime.Now; model.Wrehse_Trans.Add(trans); model.SaveChanges(); Wrehse_Trans last = model.Wrehse_Trans.OrderByDescending(x => x.Trans_ID).Take(1).FirstOrDefault(); foreach (var v in updatelist) { Wrehse_Trans_Dtl trans_Dtl = new Wrehse_Trans_Dtl(); trans_Dtl.Trans_ID = last.Trans_ID; trans_Dtl.Item_number = v.itemnumber; trans_Dtl.Retrived_Qunty = v.CollectedQuntity; trans_Dtl.Available_Qunty = v.CollectedQuntity; model.Wrehse_Trans_Dtl.Add(trans_Dtl); var inventoriesChange = model.Inventories.Where(x => x.Item_Number.Equals(v.itemnumber)).FirstOrDefault(); inventoriesChange.Quantity -= v.CollectedQuntity; model.SaveChanges(); if (v.DamagedQuantity > 0) { Dmg_Goods_Dtl d = new Dmg_Goods_Dtl(); d.Item_number = v.itemnumber; d.Damage_Qnty = v.DamagedQuantity; d.Location = "warehouse"; d.Details = "Damage"; d.Employee_ID = user.Employee_ID; d.Dmg_Date = System.DateTime.Today; inventoriesChange.Quantity -= v.DamagedQuantity; model.Dmg_Goods_Dtl.Add(d); model.SaveChanges(); } } return("UPDATE SUCCESS AND get all item fro store and down from inventory and add damage if "); } catch (Exception) { return("ERROR IN UPDATING WAREHOUSE"); } }
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(); }
public static void recordDamageDetails(String Itemnumber, int Quantity, String Location) { Dmg_Goods_Dtl dmg = new Dmg_Goods_Dtl(); dmg.Item_number = Itemnumber; dmg.Damage_Qnty = Quantity; dmg.Location = Location; dmg.Employee_ID = "ENG002"; dmg.Details = " "; dmg.Dmg_Date = System.DateTime.Now; model.Dmg_Goods_Dtl.Add(dmg); model.SaveChanges(); }
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(); } }
public void ValidateDelg() { try { Employee user = (Employee)Session["user"]; string ss = user.Department_ID; Approver approver = model.Approvers.Where(c => c.Department_ID == ss && c.Status == "Active").First <Approver>(); if (approver.End_Date < DateTime.Today) { approver.Status = "Inactive"; } model.SaveChanges(); } catch (Exception) { } }
// 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); } }
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_Click(object sender, EventArgs e) { string departname = TextBox1.Text; string itemnumber = TextBox2.Text; int qunty = Convert.ToInt32(TextBox3.Text); using (model) { string departid = model.Departments.Where(x => x.Department_Name == departname).Select(y => y.Department_Name).FirstOrDefault(); var depart = model.Disbursement_List.Where(x => x.Department_ID == departid && x.Status == "Pending").FirstOrDefault(); var list = model.Disbursement_List_dtl.Where(x => x.Disburse_ID == depart.Disburse_ID).ToList(); Disbursement_List_dtl list_Dtl = list.Where(x => x.Item_number == itemnumber).FirstOrDefault(); list_Dtl.Quantity -= qunty; model.SaveChanges(); rollbackrequest(itemnumber, departid, qunty); } }
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(); } }
protected void Button1_Click(object sender, EventArgs e) { if (CheckBox1.Checked) { Employee user = (Employee)Session["user"]; string departid = user.Department_ID; singlist = m.Disbursement_List.Where(x => x.Department_ID == departid && x.Status == "Pending").ToList(); if (singlist.Count() != 0) { foreach (Disbursement_List item in singlist) { item.Status = "Acknowledged"; m.SaveChanges(); } } } }
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 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(); } }
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 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); } }