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"); }
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(); }
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(); }
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"); }
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> </td> <td> </td> <td>Sub Total</td> <td>" + subTotalQuantity.ToString("0,0.00") + @"</td> <td> </td> <td> </td> <td>" + subTotalAmount.ToString("0,0.00") + @"</td> <td> </td> <td> </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> </td> <td> </td> <td>Sub Total</td> <td>" + subTotalQuantity.ToString("0,0.00") + @"</td> <td> </td> <td> </td> <td>" + subTotalAmount.ToString("0,0.00") + @"</td> <td> </td> <td> </td> <td>" + subTotalAppxQty.ToString("0,0.00") + @"</td> </tr>"; htmlTable += @"<tr id='lastRow'> <td> </td> <td> </td> <td>Grand Total</td> <td>" + totalQuantity.ToString("0,0.00") + @"</td> <td> </td> <td> </td> <td>" + totalAmount.ToString("0,0.00") + @"</td> <td> </td> <td> </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> </td> <td> </td> <td>Grand Total</td> <td>" + totalQuantity.ToString("0,0.00") + @"</td> <td> </td> <td>" + totalAmount.ToString("0,0.00") + @"</td> </tr></table>"; lblItemList.Text = htmlTable; #endregion } }
private void showInv_IssueMasterReturnGrid() { gvInv_IssueMasterReturn.DataSource = Inv_IssueMasterReturnManager.GetAllInv_IssueMasterReturns(); gvInv_IssueMasterReturn.DataBind(); }