public DataSet GetIndentCartList(RequestCart ic) { DS = new DataSet(); try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Id", ic.RequestCartId)); paramCollection.Add(new DBParameter("@Tokan", ic.Tokan)); paramCollection.Add(new DBParameter("@RequestBy", ic.RequestBy)); paramCollection.Add(new DBParameter("@ItemId", ic.ItemId)); //paramCollection.Add(new DBParameter("@VendorId", ic.VendorId)); paramCollection.Add(new DBParameter("@Quantity", ic.Quantity)); paramCollection.Add(new DBParameter("@UnitId", ic.UnitId)); paramCollection.Add(new DBParameter("@Specification", ic.Specification)); paramCollection.Add(new DBParameter("@Purpose", ic.Purpose)); paramCollection.Add(new DBParameter("@Remark", ic.Remark)); paramCollection.Add(new DBParameter("@flag", ic.Flag)); DS = _DBHelper.ExecuteDataSet("SpPrchsRequestCart", paramCollection, CommandType.StoredProcedure); } catch (Exception) { throw; } return(DS); }
public bool RequestCartDML(RequestCart ic) { int result = 0; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Id", ic.RequestCartId)); paramCollection.Add(new DBParameter("@Tokan", ic.Tokan)); paramCollection.Add(new DBParameter("@RequestBy", ic.RequestBy)); paramCollection.Add(new DBParameter("@ItemId", ic.ItemId)); //paramCollection.Add(new DBParameter("@VendorId", ic.VendorId)); paramCollection.Add(new DBParameter("@Quantity", ic.Quantity)); paramCollection.Add(new DBParameter("@UnitId", ic.UnitId)); paramCollection.Add(new DBParameter("@Specification", ic.Specification)); paramCollection.Add(new DBParameter("@Purpose", ic.Purpose)); paramCollection.Add(new DBParameter("@Remark", ic.Remark)); paramCollection.Add(new DBParameter("@flag", ic.Flag)); result = _DBHelper.ExecuteNonQuery("SpPrchsRequestCart", paramCollection, CommandType.StoredProcedure); } catch (Exception ex) { string e = ex.ToString(); } if (result > 0) { return(true); } else { return(false); } }
protected void rpRequestOrderdetails_ItemCommand(object source, RepeaterCommandEventArgs e) { int TempID = 0; TempID = Convert.ToInt32(e.CommandArgument); switch (e.CommandName) { case ("delete"): { requestCart = new RequestCart(); purchaseData = new PurchaseData(); requestCart.RequestCartId = TempID; requestCart.Tokan = hftokanno.Value; requestCart.RequestBy = GlobalInfo.Userid; requestCart.Purpose = string.Empty; requestCart.Remark = string.Empty; requestCart.Specification = string.Empty; requestCart.Flag = 2; //2 for delete purchaseData.RequestCartDML(requestCart); bindCartList(requestCart); //RemoveTempID(TempID); //invocie.TokanId = hftokanno.Value; //invocie.UserID = GlobalInfo.Userid; //BindAgntTempItam(invocie); upMain.Update(); break; } } }
protected void btnAddItem_Click(object sender, EventArgs e) { requestCart = new RequestCart(); purchaseData = new PurchaseData(); requestCart.Tokan = hftokanno.Value; requestCart.RequestBy = GlobalInfo.Userid; requestCart.ItemId = Convert.ToInt32(dpItem.SelectedItem.Value); //requestCart.VendorId = Convert.ToInt32(dpVendor.SelectedItem.Value); requestCart.Quantity = string.IsNullOrEmpty(txtQuantity.Text) ? 0 : Convert.ToDecimal(txtQuantity.Text); requestCart.UnitId = Convert.ToInt32(dpUnit.SelectedItem.Value); requestCart.Specification = txtSpecification.Text; requestCart.Purpose = txtPurpose.Text; requestCart.Remark = txtRemark.Text; requestCart.Flag = 1; //1 for INSERT bool result = purchaseData.RequestCartDML(requestCart); if (result) { bindCartList(requestCart); } //dpSelect(); }
private void bindCartList(RequestCart requestCart) { purchaseData = new PurchaseData(); DS = new DataSet(); requestCart.Flag = 0; //Get Full List rpRequestOrderdetails.DataSource = purchaseData.GetRequestCartList(requestCart); rpRequestOrderdetails.DataBind(); }
public DataSet GetRequestCartList(RequestCart ic) { dbPurchase = new DBPurchase(); DS = new DataSet(); try { DS = dbPurchase.GetIndentCartList(ic); return(DS); } catch (Exception) { throw; } }
/// <summary> /// GetItems /// </summary> /// <param name="EmpID">EmployeeID</param> /// <returns></returns> public List <RequestCart> getItems(string EmpID) { int empID = Convert.ToInt32(EmpID); List <CartItems> cartItemsList = ctx.CartItems.Where(x => x.EmpID == empID).ToList(); List <RequestCart> requestCartList = new List <RequestCart>(); foreach (CartItems cartItem in cartItemsList) { Item item = ctx.Item.Where(x => x.ItemID == cartItem.ItemID).FirstOrDefault(); RequestCart reqCart = new RequestCart(); reqCart.ItemID = cartItem.ItemID; reqCart.ItemName = item.ItemName; reqCart.UOM = item.UOM; reqCart.Qty = (int)cartItem.Qty; requestCartList.Add(reqCart); } return(requestCartList); }
protected void btnSubmit_Click(object sender, EventArgs e) { Request request = new Request(); purchaseData = new PurchaseData(); RequestCart rc = new RequestCart(); request.CreatedBy = GlobalInfo.Userid; request.ReqStatus = "Pending"; request.RequestDate = DateTime.Now; request.Tokan = hftokanno.Value; rc.Tokan = hftokanno.Value; bool result = purchaseData.SubmitRequest(request); if (result) { rc.Purpose = string.Empty; rc.Specification = string.Empty; rc.Remark = string.Empty; bindCartList(rc); //clearFields(); divDanger.Visible = false; divwarning.Visible = false; divSusccess.Visible = true; pnlError.Update(); upMain.Update(); } else { divDanger.Visible = false; divwarning.Visible = true; divSusccess.Visible = false; lblwarning.Text = "Please Contact to Site Admin"; pnlError.Update(); } }
public bool RequestCartDML(RequestCart ic) { dbPurchase = new DBPurchase(); return(dbPurchase.RequestCartDML(ic)); }