public TenderQuotation getTenderQuotationByKey(string suppliercode, string itemcode) { TenderQuotation tq = sce.TenderQuotations.Where(x => x.suppliercode == suppliercode && x.itemcode == itemcode).FirstOrDefault(); //TenderQuotation tq = sce.TenderQuotations.Where(x => x.itemcoditemcode) == .FirstOrDefault(); return(tq); }
public void updateTenderQuotation(TenderQuotation tq) { TenderQuotation tender = new TenderQuotation(); tender = getTenderQuotationByKey(tq.suppliercode, tq.itemcode); tender.price = tq.price; sce.SaveChanges(); }
protected void Save_Click(object sender, EventArgs e) { GridViewRow row = GridView1.SelectedRow; string itemdescription = row.Cells[0].Text; Item i = scService.getItemByItemdescription(itemdescription); //i.itemdescription = TextBox1.Text; string suppliername = DropDownList1.SelectedValue; Supplier s = scService.getSupplierByName(suppliername); TenderQuotation tq = new TenderQuotation(); tq.suppliercode = s.suppliercode; tq.itemcode = i.itemcode; tq.price = Convert.ToDouble(TextBox2.Text); //scService.updateTenderQuotation(i, tq); scService.updateTenderQuotation(tq); Response.Redirect("SCupdateTenderInformation.aspx"); }
public TenderQuotation GetFirstTenderbyProdutId(string ProductId) { DateTime now = DateTime.Today; int year = now.Year; try { TenderQuotation firsttq = (from tq in dbcontext.TenderQuotations where tq.ProductId == ProductId && tq.Year == year && tq.Rank != null orderby tq.Rank ascending select tq).Include(m => m.Product).Include(m => m.Supplier).Take(1).FirstOrDefault(); if (firsttq == null) { throw new Exception(); } return(firsttq); } catch { throw new Exception("Error finding tender quotation by this product id"); } }
protected void Page_Load(object sender, EventArgs e) { IIdentity id = User.Identity; role = Convert.ToInt32(User.Identity.Name); if (GridView1.Rows.Count == 0) { //Button1.Visible = false; Button2.Visible = false; } if (!IsPostBack) { int sno = 1; ViewState["sno"] = sno; DataTable dt = new DataTable(); ViewState["list"] = dt; DropDownList2.DataBind(); DropDownList2.SelectedIndex = 0; Item item = sc.getsuppliercode(DropDownList2.SelectedValue); TenderQuotation price1 = sc.getprice(item.supplier1, DropDownList2.SelectedValue); Label4.Text = price1.price.ToString() + "(Unit Price)"; TenderQuotation price2 = sc.getprice(item.supplier2, DropDownList2.SelectedValue); Label1.Text = price2.price.ToString() + "(Unit Price)"; TenderQuotation price3 = sc.getprice(item.supplier3, DropDownList2.SelectedValue); Label5.Text = price3.price.ToString() + "(Unit price)"; RadioButton1.Text = item.supplier1; RadioButton2.Text = item.supplier2; RadioButton3.Text = item.supplier3; RadioButton2.Checked = false; RadioButton3.Checked = false; RadioButton1.Checked = true; } }
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { Item item = sc.getsuppliercode(DropDownList2.SelectedValue); TenderQuotation price1 = sc.getprice(item.supplier1, DropDownList2.SelectedValue); Label4.Text = price1.price.ToString() + "(Unit Price)"; TenderQuotation price2 = sc.getprice(item.supplier2, DropDownList2.SelectedValue); Label1.Text = price2.price.ToString() + "(Unit Price)"; TenderQuotation price3 = sc.getprice(item.supplier3, DropDownList2.SelectedValue); Label5.Text = price3.price.ToString() + "(Unit price)"; RadioButton1.Text = item.supplier1; RadioButton2.Text = item.supplier2; RadioButton3.Text = item.supplier3; RadioButton2.Checked = false; RadioButton3.Checked = false; RadioButton1.Checked = true; }
protected void Button3_Click(object sender, EventArgs e) { //Button1.Visible = true; Button2.Visible = true; Item item = sc.getsuppliercode(DropDownList2.SelectedValue); TenderQuotation price1 = sc.getprice(item.supplier1, DropDownList2.SelectedValue); TenderQuotation price2 = sc.getprice(item.supplier2, DropDownList2.SelectedValue); TenderQuotation price3 = sc.getprice(item.supplier3, DropDownList2.SelectedValue); // OrderItem order = sc.getorderquantity(DropDownList2.SelectedValue); int quantity = Convert.ToInt32(TextBox1.Text); //double qty = order.orderquantity; double cost; if (RadioButton1.Checked) { if (GridView1.Rows.Count == 0) { ViewState["sno"] = 1; } int sno = (int)ViewState["sno"]; cost = price1.price; double amount = quantity * cost; DataTable dt = new DataTable(); dt = (DataTable)ViewState["list"]; if (dt.Rows.Count == 0) { dt.Columns.Add("S.no"); dt.Columns.Add("Item Number"); dt.Columns.Add("Description"); dt.Columns.Add("Quantity"); dt.Columns.Add("Price"); dt.Columns.Add("Amount"); dt.Columns.Add("Supplier"); // dt.Columns.Add("Special Request"); } dt.Rows.Add(sno, item.itemcode, item.itemdescription, quantity, price1.price, amount, item.supplier1); GridView1.DataSource = dt; GridView1.DataBind(); ViewState["list"] = dt; sno++; ViewState["sno"] = sno; } else if (RadioButton2.Checked) { if (GridView1.Rows.Count == 0) { ViewState["sno"] = 1; } int sno = (int)ViewState["sno"]; cost = price2.price; double amount = quantity * cost; DataTable dt = new DataTable(); dt = (DataTable)ViewState["list"]; if (dt.Rows.Count == 0) { dt.Columns.Add("S.no"); dt.Columns.Add("Item Number"); dt.Columns.Add("Description"); dt.Columns.Add("Quantity"); dt.Columns.Add("Price"); dt.Columns.Add("Amount"); dt.Columns.Add("Supplier"); // dt.Columns.Add("Special Request"); } dt.Rows.Add(sno, item.itemcode, item.itemdescription, quantity, price2.price, amount, item.supplier2); GridView1.DataSource = dt; GridView1.DataBind(); ViewState["list"] = dt; sno++; ViewState["sno"] = sno; } else if (RadioButton3.Checked) { if (GridView1.Rows.Count == 0) { ViewState["sno"] = 1; } int sno = (int)ViewState["sno"]; cost = price3.price; double amount = quantity * cost; DataTable dt = new DataTable(); dt = (DataTable)ViewState["list"]; //int quant = Convert.ToInt32(TextBox1.Text); if (dt.Rows.Count == 0) { dt.Columns.Add("S.no"); dt.Columns.Add("Item Number"); dt.Columns.Add("Description"); dt.Columns.Add("Quantity"); dt.Columns.Add("Price"); dt.Columns.Add("Amount"); dt.Columns.Add("Supplier"); // dt.Columns.Add("Special Request"); } dt.Rows.Add(sno, item.itemcode, item.itemdescription, quantity, price3.price, amount, item.supplier3); GridView1.DataSource = dt; GridView1.DataBind(); ViewState["list"] = dt; sno++; ViewState["sno"] = sno; } }
public TenderQuotation getprice(String suppliercode, String item) { TenderQuotation price = sce.TenderQuotations.Where(x => x.suppliercode == suppliercode && x.itemcode == item).First(); return(price); }
public void deleteTenderQuotation(TenderQuotation t) { sce.TenderQuotations.Remove(t); sce.SaveChanges(); }
public static double findTenderQuotation(string suppliercode, string itemcode) { TenderQuotation tq = ds.TenderQuotations.Where(x => x.suppliercode == suppliercode && x.itemcode == itemcode).First(); return(tq.price); }
protected void Button1_Click(object sender, EventArgs e) { String actualqty; List <RequisitionItem> rlist = new List <RequisitionItem>(); List <Requisition> reqlist = new List <Requisition>(); string deptcode; deptcode = RadioButtonList1.SelectedValue; int approvercode = sc.getrepresentativecode(deptcode); // deptcode=sc.getdepartmentcode(deptname); rlist = sc.getrequisitions(deptcode); reqlist = sc.getreq(deptcode); int allocated; for (int i = 0; i < GridView1.Rows.Count; i++) { String suppliercode = ""; TenderQuotation price = new TenderQuotation(); GridViewRow row = GridView1.Rows[i]; String itemcode = GridView1.Rows[i].Cells[0].Text; TextBox tx = (TextBox)row.FindControl("Textfrom"); allocated = Convert.ToInt32(GridView1.Rows[i].Cells[2].Text); actualqty = tx.Text; DropDownList supplier = (row.FindControl("MyDD") as DropDownList); if (!supplier.SelectedItem.Text.Equals("select")) { suppliercode = supplier.SelectedItem.Text; price = sc.getprice(suppliercode, itemcode); } int actualquantity = Convert.ToInt32(actualqty); int disbursementid = Convert.ToInt32(GridView1.Rows[i].Cells[4].Text); if (allocated == actualquantity) { for (int j = 0; j < rlist.Count; j++) { if (rlist[j].itemcode == itemcode) { sc.updatestatusto3(rlist[j].requisitionid, itemcode); sc.updatedisbursement(disbursementid, itemcode, actualquantity); } } } else if (allocated != actualquantity) { sc.addadjustmentvoucher(price.price, role, itemcode, allocated - actualquantity); for (int j = 0; j < rlist.Count; j++) { if (rlist[j].itemcode == itemcode) { sc.deliverstatus(rlist[j].requisitionid, itemcode, allocated - actualquantity, actualquantity, deptcode, rlist[j].Requisition.employeecode); sc.updatedisbursement(disbursementid, itemcode, actualquantity); } } } } for (int z = 0; z < reqlist.Count; z++) { int reqcount = sc.getreqcount(reqlist[z].requisitionid); int statuscount = sc.getstatuscount(reqlist[z].requisitionid); if (reqcount == statuscount) { sc.updaterequisition(reqlist[z].requisitionid); } } sc.updatedisb(deptcode); List <int> dis = sc.getdis(RadioButtonList1.SelectedValue); List <dynamic> disitems = new List <dynamic>(); foreach (int i in dis) { List <dynamic> disitem = sc.getdisbursementitems(i).ToList(); disitems.AddRange(disitem); } GridView1.DataSource = disitems; GridView1.DataBind(); }