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));
}
