public void updateReorderItemGF(ReorderItem ri) { reorderItem r = ctx.reorderItems.FirstOrDefault(o => o.reorderId == ri.ReorderItemId); r.status = ri.Status; r.rejectReason = ri.RejectReason; ctx.SaveChanges(); if (ri.Status == "Rejected") { UserFacade userFacade = new UserFacade(); user us = userFacade.getUser_Lingna(ri.UserId); string subject = "Purchase reorder Rejected"; string bodyStart = "<HTML>" + "<HEAD>" + "</HEAD>" + "<BODY>" + "<BR/>" + "<P>Dear "; string body = ",</P><BR/><P>The purchase reorder you submitted with ID : " + ri.ReorderItemId + ", has been rejected.</P>" + "<BR/><P>Reject Reason : " + ri.RejectReason + "</P>"; body = body + "<BR/>" + "<P>From,</P>" + "<P>SSIS.</P>" + "</BODY>" + "</HTML>"; NotifyUserController notifyUserController = new NotifyUserController(); notifyUserController.sendEmail(us.email, subject, bodyStart + us.name + body); } }
public List<ReorderItem> getReorderItemsByStatusGF() { var items = from o in ctx.reorderItems where o.status == "Pending" select new { reorderItemId = o.reorderId, itemId = o.itemId, itemName = o.item.description, supplierId = o.supplierId, supplierName = o.supplier.name, userId = o.userId, userName = o.user.name, QtyToOrder = o.qty, amount = o.amount, status = o.status, rejectReason = o.rejectReason }; List<ReorderItem> reorderItemCollection = new List<ReorderItem>(); foreach (var i in items) { ReorderItem r = new ReorderItem(); r.ReorderItemId = i.reorderItemId; r.ItemId = i.itemId; r.Description = i.itemName; r.SupplierId = i.supplierId; r.SupplierName = i.supplierName; r.UserId = i.userId; r.UserName = i.userName; r.QtyToOrder = Convert.ToInt32(i.QtyToOrder); r.Amount = Convert.ToDouble(i.amount); r.Status = i.status; r.RejectReason = i.rejectReason; reorderItemCollection.Add(r); } return reorderItemCollection; //gaofan }
// modify in 3/11 protected void SelectGridView_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "AddToTable") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = SelectGridView.Rows[index]; TextBox t = ((TextBox)row.Cells[6].FindControl("TextBox1")); int num; if (!(int.TryParse(t.Text.ToString(), out num))) { row.ForeColor = Color.Red; //Statement.Text = "You need to enter an integer"; this.Message("You need to enter an integer"); } else if (Convert.ToInt32(t.Text) < 1) { row.ForeColor = Color.Red; //Statement.Text = "Quantity cannot be zero "; this.Message("Quantity cannot be zero "); } else { //Statement.Text = ""; row.ForeColor = Color.Black; string itemName = controller.ConvertName(row.Cells[0].Text); int qty = Convert.ToInt16(((TextBox)row.Cells[6].FindControl("TextBox1")).Text); string supplierName = ((DropDownList)row.Cells[7].FindControl("SupplierDropDownList")).SelectedValue; double price = controller.selectAddtoOrder(itemName, supplierName); double amount = qty * price; userEntity = (User)Session["UserEntity"]; ReorderItem r = new ReorderItem(); r.ItemName = itemName; r.UserId = userEntity.UserID; r.QtyToOrder = qty; r.SupplierName = supplierName; r.Price = Convert.ToDouble(price); r.Amount = Convert.ToDouble(amount); List<ReorderItem> orderList = new List<ReorderItem>(); int Index = 0; if (Session["orderList"] != null) { orderList = (List<ReorderItem>)Session["orderList"]; bool flag = false; for (int i = 0; i < orderList.Count; i++) { if (orderList[i].ItemName.Equals(itemName) && orderList[i].SupplierName.Equals(supplierName)) { flag = true; Index = i; } } if (flag == false) { orderList.Add(r); } else { ReorderItem ri = orderList[Index]; ri.QtyToOrder = ri.QtyToOrder + qty; ri.Amount = (ri.QtyToOrder + qty) * price; } } else { orderList.Add(r); } Session["orderList"] = orderList; UpdateGridView.DataSource = orderList; UpdateGridView.DataBind(); SubmitBtn.Visible = true; } } }
//modify in 3/18 //public List<ReorderItem> selectSupplier(string name) //modify in 3/11 //{ // List<reorderItem> list = supplierFacede.getReorderItemsBySupplier_Lingna(name); // List<ReorderItem> l = new List<ReorderItem>(); // foreach (reorderItem i in list) // { // ReorderItem n = new ReorderItem(); // n.ItemName = i.item.description; // n.SupplierName = i.supplier.name; // n.QtyToOrder = Convert.ToInt32(i.qty); // n.Amount = Convert.ToInt32(i.amount); // l.Add(n); // } // return l; //} public List<ReorderItem> selectSupplier(string name) { List<reorderItem> list = supplierFacede.getReorderItemsBySupplier_Lingna(name); List<ReorderItem> l = new List<ReorderItem>(); foreach (reorderItem i in list) { ReorderItem n = new ReorderItem(); n.ReorderItemId = i.reorderId; n.ItemName = i.item.description; n.SupplierName = i.supplier.name; n.QtyToOrder = Convert.ToInt32(i.qty); n.Amount = Convert.ToInt32(i.amount); l.Add(n); } return l; }
public void updateReorderItemStatus(ReorderItem rei) { reordergf.updateReorderItemGF(rei); }