protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { int rowindex = Convert.ToInt32(e.CommandArgument); int adjid = Int32.Parse(((Label)GridView2.Rows[rowindex].FindControl("Label1")).Text); using (LastADEntities entities = new LastADEntities()) { AdjVoucher abc = entities.AdjVouchers.Where(p => p.AdjVoucherId == adjid).First(); if (e.CommandName == "Issue Voucher") { abc.ApprovedDate = DateTime.Now; //abc.ApprovalEmpNum = ... abc.Status = "Authorised"; entities.SaveChanges(); Transaction trans = new Transaction(); string itemname = ((Label)GridView2.Rows[rowindex].FindControl("Label3")).Text; string ItemId = Business.Finditemidbyname(itemname); trans.ItemId = ItemId; int Quantity = Int32.Parse(((Label)GridView2.Rows[rowindex].FindControl("Label4")).Text); trans.Quantity = Quantity; ItemList i = entities.ItemLists.Find(ItemId); int stock = (int)i.Stock; int Balance = stock + (Quantity); trans.Balance = Balance; trans.AdjVoucherId = adjid; trans.EntryDate = DateTime.Now; entities.Transactions.Add(trans); entities.SaveChanges(); GridView2.DataBind(); ItemList xyz = entities.ItemLists.Where(p => p.ItemId == ItemId).First(); xyz.Stock = Balance; entities.SaveChanges(); Response.Redirect("~/6StoreSupervisor/SupervisorAdjVoucher.aspx"); } else if (e.CommandName == "Inform Manager") { abc.Status = "PendingDHAuthorisation"; entities.SaveChanges(); Response.Redirect("~/6StoreSupervisor/SupervisorAdjVoucher.aspx"); } } }
internal static void generatedishburement(List <string> idlist, List <int> amtlist) { LastADEntities entities = new LastADEntities(); RequDetail requDetail = new RequDetail(); for (int i = 0; i < idlist.Count(); i++) { string id = idlist[i]; var c = entities.Requisitions.Where(x => x.Status.Equals("Waiting For Collection") && x.RequDetails.Select(y => y.ItemId).Contains(id)).OrderBy(x => x.SignDate).ToList(); foreach (Requisition requ in c) { DateTime entryday = DateTime.Now; int? RetrievedAmtnt = requ.RequDetails.Where(x => x.ItemId.Equals(idlist[i])).Select(x => x.RequestedQuantity).First(); if (amtlist[i] == 0) { } else if (amtlist[i] < RetrievedAmtnt) { RetrievedAmtnt = amtlist[i]; } if (RetrievedAmtnt != 0) { RequDetail requde = new RequDetail(); requde = requ.RequDetails.Where(x => x.ItemId.Equals(id)).First(); int balance = Convert.ToInt32(requde.ItemList.Stock) - Convert.ToInt32(RetrievedAmtnt); Transaction tt = new Transaction(); tt.Balance = balance; tt.EntryDate = entryday; tt.ItemId = requde.ItemId; tt.Quantity = RetrievedAmtnt; tt.Requid = requde.RequId; ItemList ii = new ItemList(); ii = requde.ItemList; ii.Stock = balance; entities.Transactions.Add(tt); entities.SaveChanges(); amtlist[i] = amtlist[i] - Convert.ToInt32(RetrievedAmtnt); } } foreach (Requisition requ in c) { requ.Status = "Waiting For Delivery"; entities.SaveChanges(); } } }
protected void Button2_Click(object sender, EventArgs e) { LastADEntities entities = new LastADEntities(); Requisition req = new Requisition(); //employee id need to ad later req.RequestedDate = DateTime.Now; req.Status = "Pending Approval"; if (Session["EmpId"] != null) { req.EmployeeId = Int32.Parse(Session["EmpId"].ToString()); } entities.Requisitions.Add(req); entities.SaveChanges(); for (int i = 0; i < list2.Count; i++) { RequDetail reqdetail = new RequDetail(); reqdetail.RequId = req.RequId; reqdetail.ItemId = list2[i].ToString(); TextBox tb = (TextBox)this.GridView1.Rows[i].Cells[2].FindControl("TextBox1"); int aa = Int32.Parse(tb.Text); reqdetail.RequestedQuantity = aa; reqdetail.OutstandingQuantity = aa; entities.RequDetails.Add(reqdetail); entities.SaveChanges(); } Session["reqid"] = req.RequId; string bossmail = "*****@*****.**"; if (Session["BossEmail"] != null) { bossmail = Session["BossEmail"].ToString(); } Business.sendemail(); MailMessage mm = new MailMessage("*****@*****.**", bossmail); mm.Subject = "Requisition ID" + Session["reqid"].ToString() + " Has been submitted. Please Approve"; mm.Body = "Requisition ID" + Session["reqid"].ToString() + " Has been submitted. Please Approve"; Business.sendemail().Send(mm); Response.Redirect("EmployeeHome.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { LastADEntities entities = new LastADEntities(); List <PurchaseOrderDetail> pd = entities.PurchaseOrderDetails.Where(x => x.PurchaseOrderId == poid).ToList(); PurchaseOrder ppo = entities.PurchaseOrders.Where(x => x.PurchaseOrderId == poid).First(); foreach (PurchaseOrderDetail p in pd) { String id = p.ItemId; int qty = Convert.ToInt16(p.Amount); int qtyy = Convert.ToInt16(p.Quantity); int balance = Convert.ToInt16(p.ItemList.Stock) + qtyy; //DateTime entryday = Convert.ToDateTime(p.PurchaseOrder.DeliveryDate); ppo.DeliveryDate = DateTime.Now; Transaction t = new Transaction(); t.Balance = balance; t.EntryDate = DateTime.Now; t.ItemId = id; t.Quantity = qtyy; t.PurchaseOrderId = poid; ItemList ii = new ItemList(); ii = entities.ItemLists.Find(id); ii.Stock = balance; entities.Transactions.Add(t); entities.SaveChanges(); } List <PurchaseOrder> po = POcontrol.GetPurchaseOrder(); GridView1.DataSource = po; GridView1.DataBind(); GridView2.DataSource = ""; GridView2.DataBind(); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int UserId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); int RoleId = Int32.Parse((row.FindControl("DropDownList1") as DropDownList).SelectedValue); DateTime stdate; DateTime eddate; try { stdate = (row.FindControl("Calendar1") as Calendar).SelectedDate; eddate = (row.FindControl("Calendar2") as Calendar).SelectedDate; using (LastADEntities entities = new LastADEntities()) { Employee employee = entities.Employees.Where(p => p.UserId == UserId).First <Employee>(); employee.StartDate = stdate; employee.EndDate = eddate; entities.SaveChanges(); } GridView1.EditIndex = -1; BindGrid(); } catch (Exception f) { f.ToString(); Response.Redirect("DelegateRep.aspx"); } }
//public static void ChangeCollectionPoint(int id) //{ // LastADEntities ctx = new LastADEntities(); // Department c = ctx.Departments.Where(x => x.CollectionPointId == id).First(); // c.CollectionPointId = id; // ctx.SaveChanges(); //} public static void ChangeCollectionPoint(int id, string dpcd) { LastADEntities ctx = new LastADEntities(); Department c = ctx.Departments.Where(x => x.DepartmentCode == dpcd).First(); c.CollectionPointId = id; ctx.SaveChanges(); }
protected void Button1_Click(object sender, EventArgs e) { String DpCode = Session["DpCode"].ToString(); LastADEntities ctx = new LastADEntities(); Department c = ctx.Departments.Where(x => x.DepartmentCode == DpCode).First(); c.CollectionPointId = RadioButtonList1.SelectedIndex + 1; ctx.SaveChanges(); }
public static void ConfirmRequsition(int requsitionid, string reason, string signby) { using (LastADEntities ctx = new LastADEntities()) { Requisition requsition = ctx.Requisitions.Where(x => x.RequId == requsitionid).First <Requisition>(); requsition.Status = "Waiting for Collection"; requsition.SignDate = DateTime.Now; requsition.SignBy = signby; requsition.Note = reason; ctx.SaveChanges(); } }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int requDetailId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); using (LastADEntities entities = new LastADEntities()) { RequDetail requdetails = entities.RequDetails.Where(p => p.RequDetailId == requDetailId).First <RequDetail>(); entities.RequDetails.Remove(requdetails); entities.SaveChanges(); } BindGrid(); }
// get PurchaseOrder i's OrderDetail public static void PlacePurchaseOrder(List <itemsuppliers> cclist) { LastADEntities entities = new LastADEntities(); String[] ss = cclist.GroupBy(c => c.SupplierId).Select(c => c.Key).ToArray(); String[] sss = cclist.Select(c => c.SupplierId).ToArray(); int m = ss.Count(); for (int i = 0; i < m; i++) { PurchaseOrder po = new PurchaseOrder(); po.SupplierCode = ss[i]; po.PurchaseDate = DateTime.Now; entities.PurchaseOrders.Add(po); entities.SaveChanges(); for (int j = 0; j < cclist.Count(); j++) { if (sss[j] == ss[i]) { PurchaseOrderDetail pod = new PurchaseOrderDetail(); pod.ItemId = cclist[j].ItemId; ItemList item = new ItemList(); item = entities.ItemLists.Find(pod.ItemId); decimal?price = item.ItemSuppliers.Where(x => x.SupplierCode.Equals(ss[i])).Select(x => x.Price).First(); pod.PurchaseOrderId = po.PurchaseOrderId; pod.Quantity = cclist[j].ReOrderQty; pod.Amount = pod.Quantity * price; entities.PurchaseOrderDetails.Add(pod); entities.SaveChanges(); } } } }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int UserId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); int RoleId = Int32.Parse((row.FindControl("DropDownList1") as DropDownList).SelectedValue); using (LastADEntities entities = new LastADEntities()) { Employee employee = entities.Employees.Where(p => p.UserId == UserId).First <Employee>(); employee.RoleId = RoleId; entities.SaveChanges(); } GridView1.EditIndex = -1; BindGrid(); }
public String UpdateAdjVoucher(WCF_AdjVoucher AdjV) { LastADEntities entities = new LastADEntities(); AdjVoucher adj = new AdjVoucher(); adj.ItemId = AdjV.ItemId; adj.QuantityAdj = Int32.Parse(AdjV.QuantityAdj); adj.Reason = AdjV.Reason; adj.RequestEmpNum = Int32.Parse(AdjV.RequestEmpNum); adj.SubmitDate = DateTime.Now; adj.Status = "Pending Authorisation"; entities.AdjVouchers.Add(adj); entities.SaveChanges(); return("Successfully"); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int requdetailid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); int requestedquantity = Int32.Parse((row.FindControl("TextBox1") as TextBox).Text); using (LastADEntities entities = new LastADEntities()) { RequDetail requdetail = entities.RequDetails.Where(p => p.RequDetailId == requdetailid).First <RequDetail>(); requdetail.RequestedQuantity = requestedquantity; requdetail.OutstandingQuantity = requdetail.RequestedQuantity; entities.SaveChanges(); } GridView1.EditIndex = -1; BindGrid(); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; String ItemId = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); int ReOrderLevel = Int32.Parse((row.FindControl("TextBox1") as TextBox).Text); int ReOrderQty = Int32.Parse((row.FindControl("TextBox2") as TextBox).Text); using (LastADEntities entities = new LastADEntities()) { ItemList itemlist = entities.ItemLists.Where(p => p.ItemId.Equals(ItemId)).First <ItemList>(); itemlist.ReOrderLevel = ReOrderLevel; itemlist.ReOrderQty = ReOrderQty; entities.SaveChanges(); } GridView1.EditIndex = -1; BindGrid(); }
public static void RejectRequisition(int requisitionid, string reason, string signby) { using (LastADEntities ctx = new LastADEntities()) { Requisition requsition = ctx.Requisitions.Where(x => x.RequId == requisitionid).First <Requisition>(); requsition.Status = "Rejected"; requsition.SignDate = DateTime.Now; requsition.SignBy = signby; requsition.Note = reason; List <RequDetail> reqdetail = ctx.RequDetails.Where(y => y.RequId == requisitionid).ToList(); foreach (RequDetail a in reqdetail) { a.OutstandingQuantity = 0; } ctx.SaveChanges(); } }
protected void Button1_Click(object sender, EventArgs e) { //Clicking this button will generate a new Adjustment voucher. Those values displayed in the gridview //wil be added into the adjustment voucher accordingly. This adjustment voucher will be added into the database LastADEntities entities = new LastADEntities(); for (int i = 0; i < list3.Rows.Count; i++) { AdjVoucher adj = new AdjVoucher(); adj.ItemId = (list3.Rows[i][0].ToString()); adj.QuantityAdj = Int32.Parse(list3.Rows[i][1].ToString()); adj.Reason = list3.Rows[i][2].ToString(); if (Session["EmpId"] != null) { adj.RequestEmpNum = Int32.Parse(Session["EmpId"].ToString()); } adj.SubmitDate = DateTime.Now; adj.Status = "Pending Authorisation"; entities.AdjVouchers.Add(adj); entities.SaveChanges(); } //An email will be sent to the supervisor for approval. string bossmail = "*****@*****.**"; Business.sendemail(); MailMessage mm = new MailMessage("*****@*****.**", bossmail); mm.Subject = "The new Adjustment voucher has been send to you, please help us check and review"; mm.Body = "There are" + list3.Rows.Count.ToString() + " item need to be issued"; Business.sendemail().Send(mm); Response.Redirect("DiscrepancyListSubmitted.aspx"); }
protected void Button4_Click(object sender, EventArgs e) { LastADEntities entities = new LastADEntities(); if (Session["a"] != null) { list2 = (ArrayList)Session["a"]; } Requisition rr = new Requisition(); List <Requisition> c = new List <Requisition>(); List <string> email = new List <string>(); foreach (int i in list2) { rr = entities.Requisitions.Where(x => x.RequId == i).First(); string emal = rr.Employee.Department.Employees.Where(x => x.RoleId == 5).First().Email.ToString(); c.Add(rr); email.Add(emal); } for (int i = 0; i < this.GridView1.Rows.Count; i++) { TextBox txt = (TextBox)this.GridView1.Rows[i].Cells[5].FindControl("TextBox1"); int RetrievedAmt = Int32.Parse(txt.Text); Label lab = (Label)this.GridView1.Rows[i].Cells[2].FindControl("Label7"); RequDetail requDetail = new RequDetail(); c = c.Where(x => x.RequDetails.Select(y => y.ItemId).Contains(lab.Text)).OrderBy(x => x.SignDate).ToList(); foreach (Requisition requ in c) { DateTime entryday = DateTime.Now; int? RetrievedAmtnt = requ.RequDetails.Where(x => x.ItemId.Equals(lab.Text)).Select(x => x.RequestedQuantity).First(); if (RetrievedAmt == 0) { } else if (RetrievedAmt < RetrievedAmtnt) { RetrievedAmtnt = RetrievedAmt; } if (RetrievedAmtnt != 0) { RequDetail requde = new RequDetail(); requde = requ.RequDetails.Where(x => x.ItemId.Equals(lab.Text)).First(); int balance = Convert.ToInt32(requde.ItemList.Stock) - Convert.ToInt32(RetrievedAmtnt); Transaction tt = new Transaction(); tt.Balance = balance; tt.EntryDate = entryday; tt.ItemId = requde.ItemId; tt.Quantity = RetrievedAmtnt; tt.Requid = requde.RequId; ItemList ii = new ItemList(); ii = requde.ItemList; ii.Stock = balance; entities.Transactions.Add(tt); entities.SaveChanges(); RetrievedAmt = RetrievedAmt - Convert.ToInt32(RetrievedAmtnt); } } foreach (Requisition requ in c) { requ.Status = "Waiting For Delivery"; entities.SaveChanges(); } } foreach (string em in email) { string bossmail = em; Business.sendemail(); MailMessage mm = new MailMessage("*****@*****.**", bossmail); mm.Subject = "Your Requisition order has been send to your collection point "; mm.Body = "Your Requisition order has been send to your collection point, please collect your item before tmr 12:00pm "; Business.sendemail().Send(mm); } Response.Redirect("DisbursementList.aspx"); }
public static String Confrimrequ(List <WCF_RequisitionDetail> WRDS) { //String WRDD= WRD.ToString(); //JArray array = (JArray)JsonConvert.DeserializeObject(WRDD); //List<WCF_RequisitionDetail> WRDS = new List<WCF_RequisitionDetail>(); //foreach (JObject j in array) //{ // WCF_RequisitionDetail w= j.ToObject<WCF_RequisitionDetail>(); // WRDS.Add(w); //} int requid = Convert.ToInt32(WRDS.First().Requid); // int id = 13; LastADEntities entities = new LastADEntities(); Requisition requ = entities.Requisitions.Where(x => x.RequId == requid).First(); List <RequDetail> details = requ.RequDetails.ToList(); int percentage = 0; string ending = WRDS.ToString(); //String WCFitemid = "1"; try { // foreach (RequDetail detail in details) for (int i = 0; i < WRDS.Count(); i++) { // entities.Entry(detail).State = System.Data.Entity.EntityState.Modified; //WCFitemid = WRDS[i].itemid.ToString(); String WCFitemdesc = WRDS[i].name.ToString(); // ending = WCFitemid; RequDetail wdetail = details.Where(x => x.ItemList.Description == WCFitemdesc).First(); wdetail.OutstandingQuantity = Convert.ToInt32(WRDS[i].OutstandingQuantity); if (wdetail.OutstandingQuantity != 0) { percentage++; } else { } if (percentage == 0) { requ.Status = "Completed"; requ.CollectionDate = DateTime.Now; } else { requ.Status = "Waiting for Collection"; } entities.Entry(requ).State = System.Data.Entity.EntityState.Modified; } entities.SaveChanges(); ending = "execute successfully"; } catch (Exception e) { ending = e.ToString(); } return(ending); }