protected void btnUpdate_Click(object sender, EventArgs e) { Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail(); inv_IssueDetail = Inv_IssueDetailManager.GetInv_IssueDetailByID(Int32.Parse(Request.QueryString["inv_IssueDetailID"])); Inv_IssueDetail tempInv_IssueDetail = new Inv_IssueDetail(); tempInv_IssueDetail.Inv_IssueDetailID = inv_IssueDetail.Inv_IssueDetailID; tempInv_IssueDetail.ItemID = Int32.Parse(ddlItem.SelectedValue); tempInv_IssueDetail.Quantity = Decimal.Parse(txtQuantity.Text); tempInv_IssueDetail.ApproximateQuantity = Int32.Parse(txtApproximateQuantity.Text); tempInv_IssueDetail.ProductID = Int32.Parse(ddlProduct.SelectedValue); tempInv_IssueDetail.AdditionalWithIssueDetailID = Int32.Parse(ddlAdditionalWithIssueDetail.SelectedValue); tempInv_IssueDetail.ExtraField1 = txtExtraField1.Text; tempInv_IssueDetail.ExtraField2 = txtExtraField2.Text; tempInv_IssueDetail.ExtraField3 = txtExtraField3.Text; tempInv_IssueDetail.ExtraField4 = txtExtraField4.Text; tempInv_IssueDetail.ExtraField5 = txtExtraField5.Text; tempInv_IssueDetail.AddedBy = getLogin().LoginID; tempInv_IssueDetail.AddedDate = DateTime.Now; tempInv_IssueDetail.UpdatedBy = getLogin().LoginID; tempInv_IssueDetail.UpdatedDate = DateTime.Now; tempInv_IssueDetail.RowStatusID = 1; bool result = Inv_IssueDetailManager.UpdateInv_IssueDetail(tempInv_IssueDetail); Response.Redirect("AdminInv_IssueDetailDisplay.aspx"); }
protected void lbDelete_Click(object sender, EventArgs e) { LinkButton linkButton = new LinkButton(); linkButton = (LinkButton)sender; bool result = Inv_IssueDetailManager.DeleteInv_IssueDetail(Convert.ToInt32(linkButton.CommandArgument)); showInv_IssueDetailGrid(); }
private void showInv_IssueDetailData() { Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail(); inv_IssueDetail = Inv_IssueDetailManager.GetInv_IssueDetailByID(Int32.Parse(Request.QueryString["inv_IssueDetailID"])); ddlItem.SelectedValue = inv_IssueDetail.ItemID.ToString(); txtQuantity.Text = inv_IssueDetail.Quantity.ToString(); txtApproximateQuantity.Text = inv_IssueDetail.ApproximateQuantity.ToString(); ddlProduct.SelectedValue = inv_IssueDetail.ProductID.ToString(); }
private void showInv_IssueDetailGrid() { Inv_IssueMaster issueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(int.Parse(Request.QueryString["IssueMasterID"])); txtIssueDate.Text = issueMaster.IssueDate.ToString("dd MMM yyyy"); ddlEmployee.SelectedValue = issueMaster.EmployeeID.ToString(); ddlWorkSatation.SelectedValue = issueMaster.WorkSatationID.ToString(); List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterID(Request.QueryString["IssueMasterID"]); gvInv_IssueDetail.DataSource = inv_IssueDetailsFromDB; gvInv_IssueDetail.DataBind(); }
private void showInv_IssueDetailGrid() { List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterID(hfInv_IssueMasterID.Value); 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); } } gvInv_IssueDetail.DataSource = inv_IssueDetailsArranged; gvInv_IssueDetail.DataBind(); loadItem(); loadPrevioulyIssedItem(); }
private void showInv_IssueDetailData() { Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail(); inv_IssueDetail = Inv_IssueDetailManager.GetInv_IssueDetailByID(Int32.Parse(Request.QueryString["inv_IssueDetailID"])); ddlItem.SelectedValue = inv_IssueDetail.ItemID.ToString(); txtQuantity.Text = inv_IssueDetail.Quantity.ToString(); txtApproximateQuantity.Text = inv_IssueDetail.ApproximateQuantity.ToString(); ddlProduct.SelectedValue = inv_IssueDetail.ProductID.ToString(); ddlAdditionalWithIssueDetail.SelectedValue = inv_IssueDetail.AdditionalWithIssueDetailID.ToString(); txtExtraField1.Text = inv_IssueDetail.ExtraField1; txtExtraField2.Text = inv_IssueDetail.ExtraField2; txtExtraField3.Text = inv_IssueDetail.ExtraField3; txtExtraField4.Text = inv_IssueDetail.ExtraField4; txtExtraField5.Text = inv_IssueDetail.ExtraField5; txtAddedBy.Text = inv_IssueDetail.AddedBy.ToString(); txtUpdatedBy.Text = inv_IssueDetail.UpdatedBy.ToString(); txtUpdatedDate.Text = inv_IssueDetail.UpdatedDate; ddlRowStatus.SelectedValue = inv_IssueDetail.RowStatusID.ToString(); }
protected void btnAdd_Click(object sender, EventArgs e) { Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail(); inv_IssueDetail.ItemID = Int32.Parse(ddlItem.SelectedValue); inv_IssueDetail.Quantity = Decimal.Parse(txtQuantity.Text); inv_IssueDetail.ApproximateQuantity = Int32.Parse(txtApproximateQuantity.Text); inv_IssueDetail.ProductID = Int32.Parse(ddlProduct.SelectedValue); inv_IssueDetail.AdditionalWithIssueDetailID = Int32.Parse(ddlAdditionalWithIssueDetail.SelectedValue); inv_IssueDetail.ExtraField1 = txtExtraField1.Text; inv_IssueDetail.ExtraField2 = txtExtraField2.Text; inv_IssueDetail.ExtraField3 = txtExtraField3.Text; inv_IssueDetail.ExtraField4 = txtExtraField4.Text; inv_IssueDetail.ExtraField5 = txtExtraField5.Text; inv_IssueDetail.AddedBy = getLogin().LoginID; inv_IssueDetail.AddedDate = DateTime.Now; inv_IssueDetail.UpdatedBy = getLogin().LoginID; inv_IssueDetail.UpdatedDate = DateTime.Now; inv_IssueDetail.RowStatusID = 1; int resutl = Inv_IssueDetailManager.InsertInv_IssueDetail(inv_IssueDetail); Response.Redirect("AdminInv_IssueDetailDisplay.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { if (!checking()) { return; } Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster(); inv_IssueMaster.IssueName = ""; inv_IssueMaster.IssueDate = DateTime.Parse(txtIssueDate.Text); inv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue); inv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue); inv_IssueMaster.Particulars = txtParticulars.Text; inv_IssueMaster.IsIssue = (Request.QueryString["IsNonProduction"] != null ? false : true); inv_IssueMaster.ExtraField1 = ""; inv_IssueMaster.ExtraField2 = ""; inv_IssueMaster.ExtraField3 = ""; inv_IssueMaster.ExtraField4 = ""; inv_IssueMaster.ExtraField5 = ""; inv_IssueMaster.AddedBy = getLogin().LoginID; inv_IssueMaster.AddedDate = DateTime.Now; inv_IssueMaster.UpdatedBy = getLogin().LoginID; inv_IssueMaster.UpdatedDate = DateTime.Now; inv_IssueMaster.RowStatusID = 1; if (txtOldIssueID.Text == "") { inv_IssueMaster.Inv_IssueMasterID = Inv_IssueMasterManager.InsertInv_IssueMaster(inv_IssueMaster); } else { inv_IssueMaster.Inv_IssueMasterID = int.Parse(txtOldIssueID.Text); } int JournalMasterID = 0; foreach (GridViewRow gvr in gvInv_Item.Rows) { HiddenField hfInv_ItemID = (HiddenField)gvr.FindControl("hfInv_ItemID"); Label lblPurchaseID = (Label)gvr.FindControl("lblPurchaseID"); TextBox txtIssueQuantity = (TextBox)gvr.FindControl("txtIssueQuantity"); TextBox txtApproximateQuantity = (TextBox)gvr.FindControl("txtApproximateQuantity"); DropDownList ddlProduct = (DropDownList)gvr.FindControl("ddlProduct"); HiddenField hfRawMaterialTypeID = (HiddenField)gvr.FindControl("hfRawMaterialTypeID"); if (hfRawMaterialTypeID.Value == "10" && JournalMasterID == 0) { if (ddlWorkSatation.SelectedValue != "1") { //Journal Entry ACC_JournalMaster aCC_JournalMaster = new ACC_JournalMaster(); aCC_JournalMaster.JournalMasterName = "3";//Journal Voucher aCC_JournalMaster.ExtraField1 = ddlWorkSatation.SelectedItem.Text; aCC_JournalMaster.ExtraField2 = ""; aCC_JournalMaster.ExtraField3 = ""; aCC_JournalMaster.Note = "Inventory Issue-" + inv_IssueMaster.Inv_IssueMasterID.ToString(); aCC_JournalMaster.JournalDate = DateTime.Parse(txtIssueDate.Text); aCC_JournalMaster.AddedBy = getLogin().LoginID; aCC_JournalMaster.AddedDate = DateTime.Now; aCC_JournalMaster.UpdatedBy = getLogin().LoginID; aCC_JournalMaster.UpdatedDate = DateTime.Now; aCC_JournalMaster.RowStatusID = 1; JournalMasterID = ACC_JournalMasterManager.InsertACC_JournalMaster(aCC_JournalMaster); } } Label lblAvailableQuantity = (Label)gvr.FindControl("lblExtraFieldQuantity1"); if (txtIssueQuantity.Text != "0" && txtIssueQuantity.Text != "") { Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail(); inv_IssueDetail.ItemID = Int32.Parse(hfInv_ItemID.Value); inv_IssueDetail.Quantity = Decimal.Parse(txtIssueQuantity.Text); inv_IssueDetail.ProductID = Int32.Parse(ddlProduct.SelectedValue); inv_IssueDetail.AdditionalWithIssueDetailID = 0; inv_IssueDetail.ApproximateQuantity = Int32.Parse(txtApproximateQuantity.Text); inv_IssueDetail.ExtraField1 = txtIssueQuantity.Text; inv_IssueDetail.ExtraField2 = "0"; inv_IssueDetail.ExtraField3 = "0"; inv_IssueDetail.ExtraField4 = (hfRawMaterialTypeID.Value == "10"?JournalMasterID.ToString():"0"); inv_IssueDetail.ExtraField5 = inv_IssueMaster.Inv_IssueMasterID.ToString(); inv_IssueDetail.AddedBy = getLogin().LoginID; inv_IssueDetail.AddedDate = DateTime.Now; inv_IssueDetail.UpdatedBy = getLogin().LoginID; inv_IssueDetail.UpdatedDate = DateTime.Now; inv_IssueDetail.RowStatusID = 1; if (Inv_IssueDetailManager.InsertInv_IssueDetail(inv_IssueDetail) <= 0) { showAlartMessage("Double Pressed"); return; } } } hlnkIssuePrint.NavigateUrl = "IssuePrint.aspx?IssueID=" + inv_IssueMaster.Inv_IssueMasterID.ToString(); hlnkIssuePrint.Visible = true; showInv_IssueDetailGrid(); }
private void loadData() { int issueID = int.Parse(Request.QueryString["IssueID"]); //purchase info Inv_IssueMaster issueMaster = Inv_IssueMasterManager.GetInv_IssueMasterByID(issueID); lblPurchaseDate.Text = issueMaster.IssueDate.ToString("dd-MMM-yyyy"); lblPurchaseID.Text = "<a href='IssueModification.aspx?IssueMasterID=" + issueMaster.Inv_IssueMasterID.ToString() + "' target='_blank'>" + issueMaster.Inv_IssueMasterID.ToString() + "</a>"; //lblInvoiceNo.Text = purchase.InvoiceNo; lblSupplierName.Text = issueMaster.ExtraField1; lblParticulars.Text = issueMaster.Particulars; if (issueMaster.IsIssue) { #region Productive issue //Item Info List <Inv_IssueDetail> inv_IssueDetailsFromDB = Inv_IssueDetailManager.GetAllInv_IssueDetailsByIssueMasterID(issueID.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;'> Issue For: " + AddedIssedItem.ProductName + @" </td> </tr>"; } htmlTable += @"<tr class='itemCss'> <td style='border-left:0px;'>" + (serialNo++).ToString() + (AddedIssedItem.AddedDate <= DateTime.Parse("19 Apr 2012")?"": (" <a href='IssueDetailDelete.aspx?IssueDetailID=" + AddedIssedItem.Inv_IssueDetailID.ToString() + "&IssueID=" + Request.QueryString["IssueID"] + "' style='color:red;'>X</a>")) + @"</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_IssueDetailsByIssueMasterID(issueID.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_IssueDetailGrid() { gvInv_IssueDetail.DataSource = Inv_IssueDetailManager.GetAllInv_IssueDetails(); gvInv_IssueDetail.DataBind(); }
private void loadPrevioulyIssedItem() { ddlIssuedItem.Items.Clear(); //trConfigPerProductRequiredQuantity.Visible = true; trClaculateApproximateQuantity.Visible = true; trApproximateQuantity.Visible = true; if (Request.QueryString["IsNonProduction"] != null) { trProduct.Visible = false; trApproximateQuantity.Visible = false; trClaculateApproximateQuantity.Visible = false; trConfigPerProductRequiredQuantity.Visible = false; } ListItem li = new ListItem("Select Issued Item...", "0"); ddlIssuedItem.Items.Add(li); List <Inv_IssueDetail> inv_IssueDetails = new List <Inv_IssueDetail>(); if (Request.QueryString["IsNonProduction"] != null) { inv_IssueDetails = Inv_IssueDetailManager.GetAllInv_IssueDetailsRootIssueByEmployeeID(int.Parse(ddlEmployee.SelectedValue)); } else { inv_IssueDetails = Inv_IssueDetailManager.GetAllInv_IssueDetailsRootIssueByEmployeeIDnProductID(int.Parse(ddlEmployee.SelectedValue), int.Parse(ddlProduct.SelectedValue)); } string IDs = "-"; foreach (Inv_IssueDetail inv_IssueDetail in inv_IssueDetails) { if (!IDs.Contains("-" + inv_IssueDetail.ItemID + "-")) { IDs += inv_IssueDetail.ItemID + "-"; } } if (IDs != "-") { //to remove the 1st and last - and then replace with , IDs = IDs.Substring(1, IDs.Length - 1); IDs = IDs.Substring(0, IDs.Length - 1); IDs = IDs.Replace("-", ","); } List <Inv_Item> items = new List <Inv_Item>(); if (IDs != "-") { items = Inv_ItemManager.GetAllInv_ItemsByIDs(IDs); } foreach (Inv_IssueDetail inv_IssueDetail in inv_IssueDetails) { foreach (Inv_Item item in items) { if (item.Inv_ItemID == inv_IssueDetail.ItemID) { foreach (ListItem ddlListItem in ddlProduct.Items) { if (inv_IssueDetail.ProductID.ToString() == ddlListItem.Value) { //ListItem li_item = new ListItem(item.ItemName.ToString() + "(" + item.ItemCode.ToString() + ") for " + ddlListItem.Text + "{" + item.QualityValue.ToString() + " " + item.ExtraField1.ToString() + "}" + " [" + inv_IssueDetail.ExtraField1.ToString() + " " + item.ExtraField2.ToString() + "] Apx. Q: " + inv_IssueDetail.ApproximateQuantity.ToString(), inv_IssueDetail.Inv_IssueDetailID.ToString()); ListItem li_item = new ListItem(item.ItemName.ToString() + "(" + item.ItemCode.ToString() + ") IssueID=" + inv_IssueDetail.ExtraField5 + "(" + inv_IssueDetail.AddedDate.ToString("dd MMM yyyy hh:mm tt") + ") {" + item.QualityValue.ToString() + " " + item.ExtraField1.ToString() + "}" + " [" + inv_IssueDetail.ExtraField1.ToString() + " " + item.ExtraField2.ToString() + "] Apx. Q: " + inv_IssueDetail.ApproximateQuantity.ToString(), inv_IssueDetail.Inv_IssueDetailID.ToString()); ddlIssuedItem.Items.Add(li_item); break; } } break; } } } }
protected void btnAdd_Click(object sender, EventArgs e) { //if(Request.QueryString["IsNonProduction"] == null) //addConfiguration(); if (Request.QueryString["IsNonProduction"] != null) { txtApproximateQuantity.Text = txtQuantity.Text; } if (hfInv_IssueMasterID.Value == "0" || hfInv_IssueMasterID.Value == "") { Inv_IssueMaster inv_IssueMaster = new Inv_IssueMaster(); inv_IssueMaster.IssueName = ""; inv_IssueMaster.IssueDate = DateTime.Parse(txtIssueDate.Text); inv_IssueMaster.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue); inv_IssueMaster.WorkSatationID = Int32.Parse(ddlWorkSatation.SelectedValue); inv_IssueMaster.Particulars = txtParticulars.Text; inv_IssueMaster.IsIssue = (Request.QueryString["IsNonProduction"] != null ?false:true); inv_IssueMaster.ExtraField1 = ""; inv_IssueMaster.ExtraField2 = ""; inv_IssueMaster.ExtraField3 = ""; inv_IssueMaster.ExtraField4 = ""; inv_IssueMaster.ExtraField5 = ""; inv_IssueMaster.AddedBy = getLogin().LoginID; inv_IssueMaster.AddedDate = DateTime.Now; inv_IssueMaster.UpdatedBy = getLogin().LoginID; inv_IssueMaster.UpdatedDate = DateTime.Now; inv_IssueMaster.RowStatusID = 1; hfInv_IssueMasterID.Value = Inv_IssueMasterManager.InsertInv_IssueMaster(inv_IssueMaster).ToString(); } Inv_IssueDetail inv_IssueDetail = new Inv_IssueDetail(); inv_IssueDetail.ItemID = Int32.Parse(ddlItem.SelectedValue); inv_IssueDetail.Quantity = Decimal.Parse(txtQuantity.Text); inv_IssueDetail.ProductID = Int32.Parse(ddlProduct.SelectedValue); if (ddlIssuedItem.Items.Count == 0 || ddlIssuedItem.SelectedValue == "0") { inv_IssueDetail.AdditionalWithIssueDetailID = 0; inv_IssueDetail.ApproximateQuantity = Int32.Parse(txtApproximateQuantity.Text); } else { inv_IssueDetail.AdditionalWithIssueDetailID = int.Parse(ddlIssuedItem.SelectedValue); inv_IssueDetail.ApproximateQuantity = 0; } //inv_IssueDetail.ExtraField1 = ddlItem.SelectedItem.Text.Split(' ')[0]; //Item COde //inv_IssueDetail.ExtraField2 = ddlItem.SelectedItem.Text.Split('{')[0].Trim().Replace(inv_IssueDetail.ExtraField1 +" - ","");//item Name //inv_IssueDetail.ExtraField3 = ddlItem.SelectedItem.Text.Split('{')[1].Split('}')[0];//quality //inv_IssueDetail.ExtraField4 = Request.QueryString["IsNonProduction"] != null ?"":ddlProduct.SelectedItem.Text;//productName //inv_IssueDetail.ExtraField5 = Inv_ItemManager.GetInv_ItemByID(Int32.Parse(ddlItem.SelectedValue)).PricePerUnit.ToString("0,0.00");//Price Per unit inv_IssueDetail.ExtraField1 = txtQuantity.Text; inv_IssueDetail.ExtraField2 = "0"; inv_IssueDetail.ExtraField3 = "0"; inv_IssueDetail.ExtraField4 = "0"; inv_IssueDetail.ExtraField5 = hfInv_IssueMasterID.Value; inv_IssueDetail.AddedBy = getLogin().LoginID; inv_IssueDetail.AddedDate = DateTime.Now; inv_IssueDetail.UpdatedBy = getLogin().LoginID; inv_IssueDetail.UpdatedDate = DateTime.Now; inv_IssueDetail.RowStatusID = 1; Inv_IssueDetailManager.InsertInv_IssueDetail(inv_IssueDetail); showInv_IssueDetailGrid(); //btnClear_Click(this, new EventArgs()); }