Ejemplo n.º 1
0
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();

        inv_IssueMasterReturn = Inv_IssueMasterReturnManager.GetInv_IssueMasterReturnByID(Int32.Parse(Request.QueryString["inv_IssueMasterReturnID"]));
        Inv_IssueMasterReturn tempInv_IssueMasterReturn = new Inv_IssueMasterReturn();

        tempInv_IssueMasterReturn.Inv_IssueMasterReturnID = inv_IssueMasterReturn.Inv_IssueMasterReturnID;

        tempInv_IssueMasterReturn.IssueReturnName = txtIssueReturnName.Text;
        tempInv_IssueMasterReturn.IssueReturnDate = txtIssueReturnDate.Text;
        tempInv_IssueMasterReturn.EmployeeID      = Int32.Parse(ddlEmployee.SelectedValue);
        tempInv_IssueMasterReturn.WorkSatationID  = Int32.Parse(ddlWorkSatation.SelectedValue);
        tempInv_IssueMasterReturn.Particulars     = txtParticulars.Text;
        tempInv_IssueMasterReturn.IsIssue         = cbIsIssue.Checked;
        tempInv_IssueMasterReturn.ExtraField1     = txtExtraField1.Text;
        tempInv_IssueMasterReturn.ExtraField2     = txtExtraField2.Text;
        tempInv_IssueMasterReturn.ExtraField3     = txtExtraField3.Text;
        tempInv_IssueMasterReturn.ExtraField4     = txtExtraField4.Text;
        tempInv_IssueMasterReturn.ExtraField5     = txtExtraField5.Text;
        tempInv_IssueMasterReturn.AddedBy         = Int32.Parse(txtAddedBy.Text);
        tempInv_IssueMasterReturn.AddedDate       = DateTime.Now;
        tempInv_IssueMasterReturn.UpdatedBy       = Int32.Parse(txtUpdatedBy.Text);
        tempInv_IssueMasterReturn.UpdatedDate     = txtUpdatedDate.Text;
        tempInv_IssueMasterReturn.RowStatusID     = Int32.Parse(ddlRowStatus.SelectedValue);
        bool result = Inv_IssueMasterReturnManager.UpdateInv_IssueMasterReturn(tempInv_IssueMasterReturn);

        Response.Redirect("AdminInv_IssueMasterReturnDisplay.aspx");
    }
Ejemplo n.º 2
0
    protected void lbDelete_Click(object sender, EventArgs e)
    {
        LinkButton linkButton = new LinkButton();

        linkButton = (LinkButton)sender;
        bool result = Inv_IssueMasterReturnManager.DeleteInv_IssueMasterReturn(Convert.ToInt32(linkButton.CommandArgument));

        showInv_IssueMasterReturnGrid();
    }
Ejemplo n.º 3
0
    private void showInv_IssueMasterReturnData()
    {
        Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();

        inv_IssueMasterReturn = Inv_IssueMasterReturnManager.GetInv_IssueMasterReturnByID(Int32.Parse(Request.QueryString["inv_IssueMasterReturnID"]));

        txtIssueReturnName.Text       = inv_IssueMasterReturn.IssueReturnName;
        txtIssueReturnDate.Text       = inv_IssueMasterReturn.IssueReturnDate;
        ddlEmployee.SelectedValue     = inv_IssueMasterReturn.EmployeeID.ToString();
        ddlWorkSatation.SelectedValue = inv_IssueMasterReturn.WorkSatationID.ToString();
        txtParticulars.Text           = inv_IssueMasterReturn.Particulars;
        cbIsIssue.Checked             = inv_IssueMasterReturn.IsFeature;
        txtExtraField1.Text           = inv_IssueMasterReturn.ExtraField1;
        txtExtraField2.Text           = inv_IssueMasterReturn.ExtraField2;
        txtExtraField3.Text           = inv_IssueMasterReturn.ExtraField3;
        txtExtraField4.Text           = inv_IssueMasterReturn.ExtraField4;
        txtExtraField5.Text           = inv_IssueMasterReturn.ExtraField5;
        txtAddedBy.Text            = inv_IssueMasterReturn.AddedBy.ToString();
        txtUpdatedBy.Text          = inv_IssueMasterReturn.UpdatedBy.ToString();
        txtUpdatedDate.Text        = inv_IssueMasterReturn.UpdatedDate;
        ddlRowStatus.SelectedValue = inv_IssueMasterReturn.RowStatusID.ToString();
    }
Ejemplo n.º 4
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        Inv_IssueMasterReturn inv_IssueMasterReturn = new Inv_IssueMasterReturn();

        inv_IssueMasterReturn.IssueReturnName = txtIssueReturnName.Text;
        inv_IssueMasterReturn.IssueReturnDate = txtIssueReturnDate.Text;
        inv_IssueMasterReturn.EmployeeID      = Int32.Parse(ddlEmployee.SelectedValue);
        inv_IssueMasterReturn.WorkSatationID  = Int32.Parse(ddlWorkSatation.SelectedValue);
        inv_IssueMasterReturn.Particulars     = txtParticulars.Text;
        inv_IssueMasterReturn.IsIssue         = cbIsIssue.Checked;
        inv_IssueMasterReturn.ExtraField1     = txtExtraField1.Text;
        inv_IssueMasterReturn.ExtraField2     = txtExtraField2.Text;
        inv_IssueMasterReturn.ExtraField3     = txtExtraField3.Text;
        inv_IssueMasterReturn.ExtraField4     = txtExtraField4.Text;
        inv_IssueMasterReturn.ExtraField5     = txtExtraField5.Text;
        inv_IssueMasterReturn.AddedBy         = Int32.Parse(txtAddedBy.Text);
        inv_IssueMasterReturn.AddedDate       = DateTime.Now;
        inv_IssueMasterReturn.UpdatedBy       = Int32.Parse(txtUpdatedBy.Text);
        inv_IssueMasterReturn.UpdatedDate     = txtUpdatedDate.Text;
        inv_IssueMasterReturn.RowStatusID     = Int32.Parse(ddlRowStatus.SelectedValue);
        int resutl = Inv_IssueMasterReturnManager.InsertInv_IssueMasterReturn(inv_IssueMasterReturn);

        Response.Redirect("AdminInv_IssueMasterReturnDisplay.aspx");
    }
Ejemplo n.º 5
0
    private void loadData()
    {
        int IssueReturnID = int.Parse(Request.QueryString["IssueReturnID"]);

        //purchase info
        Inv_IssueMasterReturn issueMasterReturn = Inv_IssueMasterReturnManager.GetInv_IssueMasterReturnByID(IssueReturnID);

        lblPurchaseDate.Text = issueMasterReturn.IssueReturnDate.ToString("dd-MMM-yyyy");
        lblPurchaseID.Text   = issueMasterReturn.Inv_IssueMasterReturnID.ToString();
        //lblInvoiceNo.Text = purchase.InvoiceNo;
        lblSupplierName.Text = issueMasterReturn.ExtraField1;
        lblParticulars.Text  = issueMasterReturn.Particulars;

        if (issueMasterReturn.IsIssue)
        {
            #region Productive issue

            //Item Info
            List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterReturnID(IssueReturnID.ToString());

            List <Inv_IssueDetail> inv_IssueDetailsArranged = new List <Inv_IssueDetail>();

            foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
            {
                AddedIssedItem.IsProcessed = false;
            }

            foreach (Inv_IssueDetail rootIssedItem in inv_IssueDetailsFromDB)
            {
                if (rootIssedItem.AdditionalWithIssueDetailID == 0)
                {
                    rootIssedItem.ParentChildGap = "";
                    rootIssedItem.IsProcessed    = true;
                    inv_IssueDetailsArranged.Add(rootIssedItem);
                    foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
                    {
                        if (AddedIssedItem.AdditionalWithIssueDetailID == rootIssedItem.Inv_IssueDetailID)
                        {
                            AddedIssedItem.IsProcessed    = true;
                            AddedIssedItem.ParentChildGap = "----";
                            inv_IssueDetailsArranged.Add(AddedIssedItem);
                        }
                    }
                }
            }

            foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
            {
                if (!AddedIssedItem.IsProcessed)
                {
                    AddedIssedItem.IsProcessed    = true;
                    AddedIssedItem.ParentChildGap = "";
                    inv_IssueDetailsArranged.Add(AddedIssedItem);
                }
            }

            string htmlTable     = @" <table id='itemList_tbl' style='border:1px solid black;width:100%;' cellpadding='0' cellspacing='0'>
                        <tr id='tableHeader'>
                            <td  style='border-left:0px;'>SL no</td>
                            <td>Code</td>
                            <td>Description</td>
                            <td>Quantity</td>
                            <td>Unit</td>
                            <td>Unit price</td>
                            <td>Amount</td>
                            <td>Quality</td>
                            <td>Issue For</td>
                            <td>Qppx. Qty</td>
                        </tr>";
            int    lastProductID = 0;

            decimal subTotalQuantity = 0;
            decimal subTotalAmount   = 0;
            decimal subTotalAppxQty  = 0;

            decimal totalQuantity = 0;
            decimal totalAmount   = 0;
            decimal totalAppxQty  = 0;

            int serialNo = 1;
            foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsArranged)
            {
                if (lastProductID != 0 && lastProductID != AddedIssedItem.ProductID)
                {
                    htmlTable += @"<tr class='subtotalRow'>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>Sub Total</td>
                            <td>" + subTotalQuantity.ToString("0,0.00") + @"</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>" + subTotalAmount.ToString("0,0.00") + @"</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>" + subTotalAppxQty.ToString("0,0.00") + @"</td>
                        </tr>";

                    subTotalQuantity = 0;
                    subTotalAmount   = 0;
                    subTotalAppxQty  = 0;
                }

                if (lastProductID != AddedIssedItem.ProductID)
                {
                    lastProductID = AddedIssedItem.ProductID;
                    htmlTable    += @"<tr>
                            <td colspan='10' style='padding-left:50px; border-top:1px solid black;border-bottom:1px solid black;font-weight:bold;'>
                                Issued For: " + AddedIssedItem.ProductName + @"
                            </td>
                        </tr>";
                }

                htmlTable += @"<tr class='itemCss'>
                            <td  style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
                            <td>" + AddedIssedItem.ItemCode + @"</td>
                            <td>" + AddedIssedItem.ItemName + @"</td>
                            <td style='text-align:right;'>" + AddedIssedItem.Quantity.ToString("0,0.00") + @"</td>
                            <td>" + AddedIssedItem.QuantityUnitName + @"</td>
                            <td style='text-align:right;'>" + AddedIssedItem.PricePerUnit.ToString("0,0.00") + @"</td>
                            <td style='text-align:right;'>" + AddedIssedItem.TotalPrice.ToString("0,0.00") + @"</td>
                            <td>" + AddedIssedItem.QualityUnitValue + @" - " + AddedIssedItem.QualityUnitName + @"</td>                          
                            <td>" + AddedIssedItem.ProductName + @"</td>
                            <td style='text-align:right;'>" + AddedIssedItem.ApproximateQuantity.ToString("0,0.00") + @"</td>
                        </tr>";

                subTotalQuantity += AddedIssedItem.Quantity;
                subTotalAmount   += AddedIssedItem.TotalPrice;
                subTotalAppxQty  += AddedIssedItem.ApproximateQuantity;

                totalQuantity += AddedIssedItem.Quantity;
                totalAmount   += AddedIssedItem.TotalPrice;
                totalAppxQty  += AddedIssedItem.ApproximateQuantity;
            }

            htmlTable += @"<tr class='subtotalRow'>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>Sub Total</td>
                            <td>" + subTotalQuantity.ToString("0,0.00") + @"</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>" + subTotalAmount.ToString("0,0.00") + @"</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>" + subTotalAppxQty.ToString("0,0.00") + @"</td>
                        </tr>";


            htmlTable += @"<tr  id='lastRow'>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>Grand Total</td>
                            <td>" + totalQuantity.ToString("0,0.00") + @"</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>" + totalAmount.ToString("0,0.00") + @"</td>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>" + totalAppxQty.ToString("0,0.00") + @"</td>
                        </tr></table>";

            lblItemList.Text = htmlTable;

            #endregion
        }
        else
        {
            #region Non-productive issue
            //Item Info
            List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterReturnID(IssueReturnID.ToString());

            List <Inv_IssueDetail> inv_IssueDetailsArranged = new List <Inv_IssueDetail>();

            foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
            {
                AddedIssedItem.IsProcessed = false;
            }

            foreach (Inv_IssueDetail rootIssedItem in inv_IssueDetailsFromDB)
            {
                if (rootIssedItem.AdditionalWithIssueDetailID == 0)
                {
                    rootIssedItem.ParentChildGap = "";
                    rootIssedItem.IsProcessed    = true;
                    inv_IssueDetailsArranged.Add(rootIssedItem);
                    foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
                    {
                        if (AddedIssedItem.AdditionalWithIssueDetailID == rootIssedItem.Inv_IssueDetailID)
                        {
                            AddedIssedItem.IsProcessed    = true;
                            AddedIssedItem.ParentChildGap = "----";
                            inv_IssueDetailsArranged.Add(AddedIssedItem);
                        }
                    }
                }
            }

            foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsFromDB)
            {
                if (!AddedIssedItem.IsProcessed)
                {
                    AddedIssedItem.IsProcessed    = true;
                    AddedIssedItem.ParentChildGap = "";
                    inv_IssueDetailsArranged.Add(AddedIssedItem);
                }
            }

            string  htmlTable     = @" <table id='itemList_tbl' style='border:1px solid black;width:100%;' cellpadding='0' cellspacing='0'>
                        <tr id='tableHeader'>
                            <td  style='border-left:0px;'>SL no</td>
                            <td>Product ID</td>
                            <td>Description</td>
                            <td>Quantity</td>
                            <td>Rate</td>
                            <td>Amount</td>
                        </tr>";
            decimal totalQuantity = 0;
            decimal totalAmount   = 0;

            int serialNo = 1;
            foreach (Inv_IssueDetail AddedIssedItem in inv_IssueDetailsArranged)
            {
                htmlTable += @"<tr class='itemCss'>
                            <td  style='border-left:0px;'>" + (serialNo++).ToString() + @"</td>
                            <td>" + AddedIssedItem.ItemCode + @"</td>
                            <td>" + AddedIssedItem.ItemName + @"</td>
                            <td style='text-align:right;'>" + AddedIssedItem.Quantity.ToString("0,0.00") + @"</td>
                            <td style='text-align:right;'>" + AddedIssedItem.PricePerUnit.ToString("0,0.00") + @"</td>
                            <td style='text-align:right;'>" + AddedIssedItem.TotalPrice.ToString("0,0.00") + @"</td>
                        </tr>";

                totalQuantity += AddedIssedItem.Quantity;
                totalAmount   += AddedIssedItem.TotalPrice;
            }

            htmlTable += @"<tr  id='lastRow'>
                            <td>&nbsp;</td>
                            <td>&nbsp;</td>
                            <td>Grand Total</td>
                            <td>" + totalQuantity.ToString("0,0.00") + @"</td>
                            <td>&nbsp;</td>
                            <td>" + totalAmount.ToString("0,0.00") + @"</td>
                        </tr></table>";

            lblItemList.Text = htmlTable;
            #endregion
        }
    }
Ejemplo n.º 6
0
 private void showInv_IssueMasterReturnGrid()
 {
     gvInv_IssueMasterReturn.DataSource = Inv_IssueMasterReturnManager.GetAllInv_IssueMasterReturns();
     gvInv_IssueMasterReturn.DataBind();
 }