Esempio n. 1
0
        //3..Save to Database
        public void addRequisitionList(List <ReqBO> rlst, LoginBO loginBo)
        {
            //create purchase object
            Requisition robj = new Requisition();

            robj.DepartmentID = loginBo.DepID;
            robj.EmployeeID   = loginBo.EmpID;
            robj.Status       = "Pending";
            robj.OrderDate    = DateTime.Now;
            robj.Reason       = "";

            //For requistion items list
            List <Requisition_Item> rst = new List <Requisition_Item>();

            foreach (ReqBO r in rlst) //from parameter pass
            {
                Requisition_Item ri = new Requisition_Item();
                ri.ItemID         = r.ItemID;
                ri.Status         = "New";
                ri.RequestedQty   = r.RequestedQty;
                ri.ReceivedQty    = 0;
                ri.UnfulfilledQty = r.RequestedQty;
                ri.RetrievedQty   = 0;
                ri.ToRetrieveQty  = 0;
                rst.Add(ri);
            }
            da.addRequisitionList(robj, rst);
        }
Esempio n. 2
0
    public static void AddNewRequisition(List <RequestedItem> item, DateTime date, string status, int empID, string DeptCode)
    {
        using (TransactionScope ts = new TransactionScope())
        {
            StationeryEntities      context = new StationeryEntities();
            Requisition             r       = new Requisition();
            List <Requisition_Item> list    = new List <Requisition_Item>();
            //to pass from previous form
            r.RequestDate = date;
            r.Status      = status;
            r.RequestedBy = empID;
            r.DeptCode    = DeptCode;
            context.Requisitions.Add(r);
            context.SaveChanges();

            foreach (RequestedItem i in item)
            {
                int qty = i.Quantity;

                string code = i.Code;

                Requisition_Item ri = new Requisition_Item();
                ri.RequisitionID = r.RequisitionID;
                ri.ItemCode      = code;
                ri.RequestedQty  = qty;
                list.Add(ri);
            }
            context.Requisition_Item.AddRange(list);
            context.SaveChanges();
            ts.Complete();
        }
    }
Esempio n. 3
0
    //ADD REQUISITION ITEM
    public static void addItemToRequisition(string code, int qty, int id)
    {
        Requisition_Item ri = new Requisition_Item();

        ri.RequisitionID = id;
        ri.ItemCode      = code;
        ri.RequestedQty  = qty;
        EFBroker_Requisition.AddItemToRequisition(ri);
    }
Esempio n. 4
0
 public static void AddItemToRequisition(Requisition_Item item)
 {
     using (StationeryEntities context = new StationeryEntities())
     {
         context.Requisition_Item.Add(item);
         context.SaveChanges();
     }
     return;
 }
Esempio n. 5
0
    public Disbursement_Item CreateDisbursementItemList(int disbursementID, Requisition_Item r)
    {
        Disbursement_Item disbursement_Item = new Disbursement_Item();

        disbursement_Item.DisbursementID    = disbursementID;
        disbursement_Item.ItemCode          = r.ItemCode;
        disbursement_Item.TotalRequestedQty = r.RequestedQty;
        disbursement_Item.ActualQty         = 0;///////////////////////////////////////////////////////in order to do += ActualQty
        return(disbursement_Item);
    }
Esempio n. 6
0
 public static void removeRequisitionItem(int id, string code)
 {
     using (TransactionScope ts = new TransactionScope())
     {
         StationeryEntities context = new StationeryEntities();
         Requisition_Item   ri      = context.Requisition_Item.Where(r => r.RequisitionID.Equals(id)).Where(r => r.ItemCode.Equals(code)).FirstOrDefault();
         context.Requisition_Item.Remove(ri);
         context.SaveChanges();
         ts.Complete();
     }
 }
Esempio n. 7
0
 public static void EditRequisitionItemQty(int id, string code, int qty)
 {
     using (TransactionScope ts = new TransactionScope())
     {
         StationeryEntities context = new StationeryEntities();
         Requisition_Item   ri      = context.Requisition_Item.Where(i => i.RequisitionID == id).Where(i => i.ItemCode.Equals(code)).FirstOrDefault();
         ri.RequestedQty += qty;
         context.SaveChanges();
         ts.Complete();
     }
 }
Esempio n. 8
0
 public static void UpdateRequisitionItem(int id, string code, int qty)
 {
     using (TransactionScope ts = new TransactionScope())
     {
         StationeryEntities context = new StationeryEntities();
         Requisition_Item   ri      = context.Requisition_Item.Where(r => r.RequisitionID == id && r.ItemCode.Equals(code)).FirstOrDefault();
         ri.RequestedQty         = qty;
         context.Entry(ri).State = System.Data.Entity.EntityState.Modified;
         context.SaveChanges();
         ts.Complete();
     }
 }
    protected void BtnDelete_Click(object sender, EventArgs e)
    {
        //LoadData();
        GridViewRow row     = ((System.Web.UI.WebControls.Button)sender).Parent.Parent as GridViewRow;
        string      itemDes = gvItemList.DataKeys[row.RowIndex].Value.ToString();


        Requisition_Item rItem = RequisitionControl.findByReqIDItemCode(id, itemDes);
        string           iCode = rItem.ItemCode;
        int rId = rItem.RequisitionID;

        RequisitionControl.removeRequisitionItem(rId, iCode);

        showAllItems();
    }
Esempio n. 10
0
    protected void ReqRow_Updating(object sender, GridViewUpdateEventArgs e)
    {
        vsQty.Enabled = true;
        System.Web.UI.WebControls.TextBox qtyText = (System.Web.UI.WebControls.TextBox)gvItemList.Rows[e.RowIndex].FindControl("txtQuantity");
        int newQty = Convert.ToInt32(qtyText.Text);

        System.Web.UI.WebControls.Label codeLabel = (System.Web.UI.WebControls.Label)gvItemList.Rows[e.RowIndex].FindControl("lblCode");
        string itemDesc = codeLabel.Text;

        Requisition_Item item  = RequisitionControl.findByReqIDItemCode(id, itemDesc);
        string           iCode = item.ItemCode;
        int rId = item.RequisitionID;

        RequisitionControl.updateRequisitionItem(rId, iCode, newQty);

        gvItemList.EditIndex = -1;
        showAllItems();
    }