protected void grdBookDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { setStateGridview(); SpecimanDetails _objsd1 = new SpecimanDetails(); SpecID = Convert.ToInt32(((Label)grdBookDetails.Rows[e.RowIndex].FindControl("lblspecDetailID")).Text); try { if (SpecID != 0) { _objsd1.SpecimenDetailID = SpecID; _objsd1.IsActive = false; _objsd1.Amount = 0; _objsd1.Rate = 0; _objsd1.Discount = 0; _objsd1.Save(); } DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["tempBookData"]; dt1.Rows[e.RowIndex].Delete(); grdBookDetails.DataSource = dt1; grdBookDetails.DataBind(); Session["tempBookData"] = dt1; loder("Successfully Deleted..."); } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (ConfigurationManager.AppSettings["access"].ToString() != ConfigurationManager.AppSettings["accessok"].ToString()) { string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString(); if (Session["Role"] != null) { if (!Other.Get_UserAccess(page, Session["Role"].ToString())) { Response.Redirect("dashboard.aspx"); } } } if (Request.QueryString["d"] != null) { Qstring = Request.QueryString["d"]; // Get_Reports_SpecimenDashBoard lblqstring.Text = Qstring; DataView dv = new DataView(SpecimanDetails.Get_Reports_SpecimenDashBoard(Qstring, "xxx").Tables[4]); //dv.RowFilter = "RemainQty <>0 "; grdEmployeedetails.DataSource = dv; grdEmployeedetails.DataBind(); grdEmployeedetails.Visible = true; // PnlDashboard.Visible = false; //grdEmployeedetails.Columns[0].Visible = true; //grdEmployeedetails.Columns[1].Visible = true; //grdEmployeedetails.Columns[2].Visible = false; //grdEmployeedetails.Columns[3].Visible = false; //grdEmployeedetails.Columns[4].Visible = false; } }
protected void btnget_Click(object sender, EventArgs e) { pnlDetails.Visible = true; btnconfirm.Enabled = true; docno.InnerHtml = txtdocno.Text.Trim(); txtempc.Visible = true; lblemp.Visible = true; DataSet ds6 = new DataSet(); ds6 = SpecimanDetails.Idv_Get_SpecimenDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno"); grdconfirm.DataSource = ds6.Tables[0]; grdconfirm.DataBind(); lblempname1.InnerHtml = Convert.ToString(ds6.Tables[1].Rows[0][0]) + " " + Convert.ToString(ds6.Tables[1].Rows[0][1]); lblspinstruct.InnerHtml = Convert.ToString(ds6.Tables[1].Rows[0]["SpInstruction"]); lbldescription.InnerHtml = Convert.ToString(ds6.Tables[1].Rows[0]["Description"]); string jv = ""; if (grdconfirm.Rows.Count <= 0) { btnconfirm.Visible = false; btnPrint.Visible = false; jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmDC1_btnconfirm').style.display='none';"; } else { btnconfirm.Visible = true; btnPrint.Visible = true; jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmDC1_btnconfirm').style.display='visible';"; } ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true); txtempc.Focus(); }
public void BindDLDashboard() { DLDashboard.DataSource = SpecimanDetails.Get_Reports_SpecimenDashBoard("abc", "xxx").Tables[0]; DLDashboard.DataBind(); DLDashboard1.DataSource = SpecimanDetails.Get_Reports_SpecimenDashBoard("abc", "xxx").Tables[2]; DLDashboard1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["d"] != null && Request.QueryString["sd"] != null) { DataSet ds = new DataSet(); DataSet dsTransporter = SpecimanDetails.Get_SpecTransporterAndDetails(Convert.ToDecimal(Request.QueryString["sd"].ToString().Trim()), "approved"); ds = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), "approved"); DataView dv = new DataView(ds.Tables[1]); dv.RowFilter = "SubConfirmID = " + Request.QueryString["sd"].ToString().Trim(); DocumentNo.InnerHtml = ds.Tables[1].Rows[0]["DocumentNo"].ToString(); Todaydate.InnerHtml = DateTime.Now.ToString("dd/MM/yyyy"); Subconfirmid.InnerHtml = Request.QueryString["sd"].ToString(); empname.InnerHtml = ds.Tables[2].Rows[0][0].ToString() + " " + ds.Tables[2].Rows[0][1].ToString() + " " + ds.Tables[2].Rows[0][2].ToString(); spnaddress.InnerHtml = ds.Tables[2].Rows[0]["Address"].ToString().ToUpper() + "</br> " + ds.Tables[2].Rows[0]["City"].ToString().ToUpper() + ", " + ds.Tables[2].Rows[0]["State"].ToString().ToUpper(); SpInstruction.InnerHtml = ds.Tables[2].Rows[0]["SpInstruction"].ToString(); Description.InnerHtml = ds.Tables[2].Rows[0]["Description"].ToString(); lbltransporter.InnerHtml = dsTransporter.Tables[0].Rows[0]["Transporter"].ToString(); lbllrno.InnerHtml = dsTransporter.Tables[0].Rows[0]["LrNo"].ToString(); lblbundles.InnerHtml = dsTransporter.Tables[0].Rows[0]["Bundles"].ToString(); grdapproval.DataSource = dv; grdapproval.DataBind(); DataSet ds1 = new DataSet(); ds1 = ActualInvoiceDetails.GetConvertion_fromnumber(tamount); lblrupees.InnerHtml = ds1.Tables[0].Rows[0][0].ToString() + " Only"; } }
public void updateRecords(GridView grd, string DocumentNo, string subdocId) { try { Label confirmQtyId; Label lblQty; TextBox txtQty; Label lblRate; TextBox txtRate; Label lblAmount; TextBox txtAmount; SpecimanDetails obj = new SpecimanDetails(); obj.DocumentNo = Convert.ToInt32(DocumentNo); obj.SubdocID = Convert.ToDecimal(subdocId); foreach (GridViewRow row in grd.Rows) { lblQty = (Label)row.FindControl("lblAvailblQtyOrg"); txtQty = (TextBox)row.FindControl("lblAqty"); lblRate = (Label)row.FindControl("lblrateOrg"); txtRate = (TextBox)row.FindControl("lblrate"); confirmQtyId = (Label)row.FindControl("lblCQt"); if ((lblQty.Text.Trim() != txtQty.Text.Trim()) || lblRate.Text.Trim() != txtRate.Text.Trim()) { obj.Rate = Convert.ToDecimal(txtRate.Text.Trim()); obj.Amount = (Convert.ToDecimal(txtRate.Text.Trim()) * Convert.ToDecimal(txtQty.Text.Trim())); obj.Quantity = Convert.ToInt32(txtQty.Text.Trim()); obj.SpecimenDetailID = Convert.ToInt32(confirmQtyId.Text.Trim()); obj.UpdateSpecimenInvoice(); } } } catch (Exception ex) { } }
public void SaveSpecimanDetails(int docNo) { setStateGridview(); DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["tempBookData"]; grdBookDetails.DataSource = dt1; grdBookDetails.DataBind(); SpecimanDetails _objSD = new SpecimanDetails(); XmlDocument doc = new XmlDocument(); XmlNode inode = doc.CreateElement("f"); XmlNode fnode = doc.CreateElement("r"); foreach (GridViewRow row in grdBookDetails.Rows) { XmlNode element = doc.CreateElement("i"); _objSD.SpecimenDetailID = Convert.ToInt32(((Label)row.FindControl("lblspecDetailID")).Text); _objSD.DocumentNo = docNo; _objSD.BookCode = ((Label)row.FindControl("lblBookCode")).Text; _objSD.BookName = ((Label)row.FindControl("lblBookName")).Text; _objSD.Standard = ((Label)row.FindControl("lblStandard")).Text; _objSD.Medium = ((Label)row.FindControl("lblMedium")).Text; Reqty = Convert.ToInt32(((TextBox)row.FindControl("txtquty")).Text); givqty = Convert.ToInt32(((Label)row.FindControl("lblgivedqty")).Text); _objSD.Quantity = Reqty + givqty; _objSD.Rate = Convert.ToDecimal(((Label)row.FindControl("lblRate")).Text); if (((Label)row.FindControl("lblAmt")).Text != "") { _objSD.Amount = Convert.ToDecimal(((Label)row.FindControl("lblAmt")).Text); } else { _objSD.Amount = 0; } _objSD.Discount = Convert.ToDecimal(((TextBox)row.FindControl("txtDiscount")).Text); //_objSD.Publisher = ((Label)row.FindControl("lblPublisher")).Text; _objSD.IsActive = true; _objSD.Save(); inode = doc.CreateElement("bsi"); inode.InnerText = Convert.ToInt32(((TextBox)row.FindControl("txtbooksetid")).Text).ToString(); element.AppendChild(inode); inode = doc.CreateElement("q"); inode.InnerText = Convert.ToInt32(((TextBox)row.FindControl("txtquty")).Text).ToString(); element.AppendChild(inode); fnode.AppendChild(element); } xmlstr = fnode.OuterXml.ToString(); }
protected void btnget_Click(object sender, EventArgs e) { pnlDetails.Visible = true; stDS = new DataSet(); docno.InnerHtml = txtDocno.Text.Trim(); stDS = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "approved"); ViewState["staticDS"] = stDS; RepDetailsConfirm.DataSource = stDS.Tables[0]; RepDetailsConfirm.DataBind(); }
protected void lnkReceive_Click(object sender, EventArgs e) { //Received DataView dv = new DataView(SpecimanDetails.GetSpecimenDatilsByEmpCode(DDLSalesman.SelectedItem.Value.ToString(), "empcode").Tables[0]); grdSchooldetails.DataSource = dv; grdSchooldetails.DataBind(); grdSchooldetails.Visible = true; // PnlDashboard.Visible = false; grdSchooldetails.Columns[4].Visible = true; grdSchooldetails.Columns[5].Visible = true; grdSchooldetails.Columns[6].Visible = false; grdSchooldetails.Columns[7].Visible = false; grdSchooldetails.Columns[8].Visible = false; showFilter(); }
protected void btnget_Click(object sender, EventArgs e) { stDS = new DataSet(); docno.InnerHtml = txtDocno.Text.Trim(); stDS = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed"); RepDetailsConfirm.DataSource = stDS.Tables[0]; RepDetailsConfirm.DataBind(); if (txtFisrt != null) { txtFisrt.Focus(); } // lblfright.Visible = true; // txtfrieght.Visible = true; // lbltax.Visible = true; // txttax.Visible = true; //string jv = ""; //if (RepDetailsConfirm.Items.Count <= 0) //{ // jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmedDC1_btnapproval').style.display='none';"; //} //else //{ // jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmedDC1_btnapproval').style.display='block';"; //} //ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true); //ds = SpecimanDetails.Idv_Get_SpecimenDetails_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed"); //DataTable dt = ds.Tables[0]; //if (dt.Rows.Count != 0) //{ // btnapproval.Enabled = true; //} //else //{ // bool Auth = Specimen.Get_DocumentNum_Authentication(Convert.ToInt32(txtDocno.Text)); // if (Auth) // { // MessageBox("Document no is not available"); // txtDocno.Focus(); // } // else // { // } //} }
protected void btnget_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = SpecimanDetails.Idv_Get_SpecimenDetails_By_DocNo(Convert.ToInt32(txtdoc.Text), "CanceledSpecimen"); if (ds.Tables[0].Rows.Count > 0) { lbldocno.Text = ds.Tables[0].Rows[0]["DocumentNo"].ToString(); lblorderno.Text = ds.Tables[0].Rows[0]["OrderNo"].ToString(); //txtsalemanCode.Text = dt.Rows[0]["SalesmanCode"].ToString(); lblsalesman.Text = ds.Tables[0].Rows[0]["SalesmanName"].ToString(); lblorderdate.Text = ds.Tables[0].Rows[0]["OrderDate"].ToString(); lbldocdate.Text = ds.Tables[0].Rows[0]["DocumentDate"].ToString(); lblcanceleddate.Text = ds.Tables[0].Rows[0]["CancelDate"].ToString(); } grdBookDetails.DataSource = ds.Tables[1]; grdBookDetails.DataBind(); }
protected void BtnBack_Click(object sender, EventArgs e) { Session["schoolAllotment"] = null; txtqnty.Text = ""; BindDashboardQty(); DataView dv = new DataView(SpecimanDetails.GetSpecimenDatilsByEmpCode(DDLSalesman.SelectedItem.Value.ToString(), "empcode").Tables[0]); //grdSchooldetails.DataSource = SpecimanDetails.GetSpecimenDatilsByEmpCode(DDLSalesman.SelectedItem.Value.ToString(), "empcode"); dv.RowFilter = "RemainQty <>0 "; grdSchooldetails.DataSource = dv; grdSchooldetails.DataBind(); PnlDashboard.Visible = true; BtnSaveAllotDetails.Visible = false; BtnSaveAllotDetails.Enabled = false; GridView1.DataSource = null; GridView1.DataBind(); pnlSchooldetails.Visible = false; grdSchooldetails.Visible = true; BtnBack.Visible = false; }
protected void btnget_Click(object sender, EventArgs e) { pnlDetails.Visible = true; stDS = new DataSet(); docno.InnerHtml = txtDocno.Text.Trim(); stDS = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "approved"); RepDetailsApprove.DataSource = stDS.Tables[0]; RepDetailsApprove.DataBind(); string jv = ""; if (RepDetailsApprove.Items.Count <= 0) { jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmedDC1_btnapproval').style.display='none';"; } else { jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_ConfirmedDC1_btnapproval').style.display='block';"; } ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true); }
public void bindData() { string RdBValue = RdlView.SelectedValue.ToString(); if (RdBValue == "Employee") { Rptrpending.DataSource = SpecimanDetails.Get_DC_Completed_IsApproved("salesman", System.DateTime.Now, System.DateTime.Now, Convert.ToInt32(strFY), DDLEmployee.SelectedValue.ToString()); Rptrpending.DataBind(); } else if (RdBValue == "All") { Rptrpending.DataSource = SpecimanDetails.Get_DC_Completed_IsApproved("all", System.DateTime.Now, System.DateTime.Now, Convert.ToInt32(strFY), DDLEmployee.SelectedValue.ToString()); Rptrpending.DataBind(); } else { try { string from = txtFromDate.Text.Split('/')[2] + "/" + txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0]; string To = txttoDate.Text.Split('/')[2] + "/" + txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0]; fdate = Convert.ToDateTime(from); tdate = Convert.ToDateTime(To); if (fdate > tdate) { MessageBox("From Date is Greater than ToDate"); txtFromDate.Focus(); } else { Rptrpending.DataSource = SpecimanDetails.Get_DC_Completed_IsApproved("datewise", fdate, tdate, Convert.ToInt32(strFY), ""); Rptrpending.DataBind(); } } catch (Exception ex) { } } Rptrpending.Items.Insert(0, new ListItem("All", "0")); Panelrepeater.Visible = true; }
public void SaveSpecimanDetails(int docNo) { setStateGridview(); DataTable dt1 = new DataTable(); dt1 = (DataTable)Session["tempBookData"]; grdBookDetails.DataSource = dt1; grdBookDetails.DataBind(); SpecimanDetails _objSD = new SpecimanDetails(); foreach (GridViewRow row in grdBookDetails.Rows) { _objSD.SpecimenDetailID = Convert.ToInt32(((Label)row.FindControl("lblspecDetailID")).Text); _objSD.DocumentNo = docNo; _objSD.BookCode = ((Label)row.FindControl("lblBookCode")).Text; _objSD.BookName = ((Label)row.FindControl("lblBookName")).Text; _objSD.Standard = ((Label)row.FindControl("lblStandard")).Text; _objSD.Medium = ((Label)row.FindControl("lblMedium")).Text; Reqty = Convert.ToInt32(((TextBox)row.FindControl("txtquty")).Text); givqty = Convert.ToInt32(((Label)row.FindControl("lblgivedqty")).Text); _objSD.Quantity = Reqty + givqty; _objSD.Rate = Convert.ToDecimal(((Label)row.FindControl("lblRate")).Text); if (((Label)row.FindControl("lblAmt")).Text != "") { _objSD.Amount = Convert.ToDecimal(((Label)row.FindControl("lblAmt")).Text); } else { _objSD.Amount = 0; } _objSD.Discount = Convert.ToDecimal(((TextBox)row.FindControl("txtDiscount")).Text); //_objSD.Publisher = ((Label)row.FindControl("lblPublisher")).Text; _objSD.IsActive = true; _objSD.Save(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["d"] == "b") { grdpending.DataSource = SpecimanDetails.Get_Specimen_NotConfirmed_Books(); grdpending.DataBind(); } else if (Request.QueryString["d"] != null) { DataSet ds = new DataSet(); ds = SpecimanDetails.Idv_Get_SpecimenDetails_By_DocNo(Convert.ToInt32(Request.QueryString["d"].ToString().Trim()), "allbydocno"); DataView dv = new DataView(ds.Tables[0]); DocumentNo.InnerHtml = ds.Tables[0].Rows[0]["DocumentNo"].ToString(); Todaydate.InnerHtml = DateTime.Now.ToString("dd/MM/yyyy"); MRname.InnerHtml = ds.Tables[1].Rows[0]["Name"].ToString(); spnaddress.InnerHtml = ds.Tables[1].Rows[0]["Address"].ToString(); spinstruction.InnerHtml = ds.Tables[1].Rows[0]["SpInstruction"].ToString(); Description.InnerHtml = ds.Tables[1].Rows[0]["Description"].ToString(); grdpending.DataSource = dv; grdpending.DataBind(); } }
public void deleteRecords(ImageButton btn) { try { Label confirmQtyId; Label lblQty; TextBox txtQty; Label lblRate; TextBox txtRate; Label lblAmount; TextBox txtAmount; Label subdocId; confirmQtyId = (Label)btn.Parent.FindControl("lblCQt"); subdocId = (Label)btn.Parent.Parent.Parent.Parent.Parent.FindControl("SubConfirmID"); SpecimanDetails obj = new SpecimanDetails(); obj.DocumentNo = Convert.ToInt32(docno.InnerHtml.Trim()); obj.SubdocID = Convert.ToDecimal(subdocId.Text); obj.Rate = 0; obj.Amount = 0; obj.Quantity = 0; obj.SpecimenDetailID = Convert.ToInt32(confirmQtyId.Text.Trim()); obj.UpdateSpecimenInvoice(); GridViewRow row = (GridViewRow)((btn).NamingContainer); row.Visible = false; } catch (Exception ex) { } }
public void BindSpeciman() { grdSchooldetails.DataSource = SpecimanDetails.GetSpecimenDatilsByEmpCode(DDLSalesman.SelectedItem.Value.ToString(), "empcode"); grdSchooldetails.DataBind(); }
protected void RepDetailsConfirm_ItemCommand(object source, RepeaterCommandEventArgs e) { bool Auth = Specimen.Get_DocumentNum_Authentication(Convert.ToInt32(txtDocno.Text)); if (Auth) { MessageBox("Document no is not available"); txtDocno.Focus(); } else { SpecimenConfirmQtyDetails _objSpecimenConfirmQtyDetails = new SpecimenConfirmQtyDetails(); Specimen _objspecimen = new Specimen(); SpecimenConfirmQtyDetails _objSpecimenFT = new SpecimenConfirmQtyDetails(); try { decimal subconfirmdoc = Convert.ToDecimal(e.CommandArgument.ToString().Trim()); _objSpecimenConfirmQtyDetails.IsCreateInvoice = true; _objSpecimenConfirmQtyDetails.CreatedInvoiceBy = "admin"; _objSpecimenConfirmQtyDetails.SubDocNo = Convert.ToDecimal(e.CommandArgument.ToString().Trim()); _objspecimen.DocNo = Convert.ToInt32(txtDocno.Text); _objSpecimenConfirmQtyDetails.Transporter = ((TextBox)e.Item.FindControl("txtTransporter")).Text; _objSpecimenConfirmQtyDetails.LrNo = ((TextBox)e.Item.FindControl("txtlrno")).Text; _objSpecimenConfirmQtyDetails.Bundles = ((TextBox)e.Item.FindControl("txtbundles")).Text; TextBox txtdateabc = (TextBox)e.Item.FindControl("txtdateabc"); string date1; if (txtdateabc.Text == "") { date1 = "01/01/2001"; } else { date1 = txtdateabc.Text.Split('/')[1] + "/" + txtdateabc.Text.Split('/')[0] + "/" + txtdateabc.Text.Split('/')[2]; } _objSpecimenConfirmQtyDetails.InvoiceDate = Convert.ToDateTime(date1); _objSpecimenConfirmQtyDetails.SaveConfirmDetails(); Cleardata(); stDS = new DataSet(); docno.InnerHtml = txtDocno.Text.Trim(); stDS = SpecimanDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed"); RepDetailsConfirm.DataSource = stDS.Tables[0]; RepDetailsConfirm.DataBind(); MessageBox("DC approved successfully for document no. " + subconfirmdoc); docno.InnerHtml = "Last confirm doc no. : " + subconfirmdoc; if (Rptrpending.Items.Count == 1) { Rptrpending.DataSource = Specimen.Get_ApprovedDocNo(); Rptrpending.DataBind(); //updateapprove.Update(); } if (RepDetailsConfirm.Items.Count == 0) { Rptrpending.DataSource = Specimen.Get_ApprovedDocNo(); Rptrpending.DataBind(); upDocNo.Update(); docno.InnerHtml = ""; //lblcustname.InnerHtml = ""; lblempname1.InnerHtml = ""; //updateapprove.Update(); } updateapprove.Update(); } catch (Exception ex) { MessageBox(ex.Message.ToString()); } } }
public void fillGridData() { grdGetNotConfirmedBooks.DataSource = SpecimanDetails.Get_Specimen_NotConfirmed_Books(); grdGetNotConfirmedBooks.DataBind(); }
public void BindGvDetail1() { GrdSpecdetails1.DataSource = SpecimanDetails.GetSpecimenDatilsByEmpCode(DDLSalesman.SelectedItem.Value.ToString(), "rtbkview"); GrdSpecdetails1.DataBind(); }
public DataTable fillTempBookData(string bookcode, string flag) { DataTable dt = new DataTable(); DataTable tempGetData = new DataTable(); DataColumn colTax = new DataColumn(); colTax.DataType = System.Type.GetType("System.String"); colTax.ColumnName = "Amount"; if (Session["tempBookData"] == null) { //CREATE NEW DATATABLE //ADD COLUMNS IN DATATABLE dt.Columns.Add("SpecimenDetailId"); dt.Columns.Add("BookCode"); dt.Columns.Add("BookName"); //dt.Columns.Add("BookType"); dt.Columns.Add("Standard"); dt.Columns.Add("Medium"); dt.Columns.Add("Quantity"); dt.Columns.Add("RemainQty"); dt.Columns.Add("Rate"); dt.Columns.Add(colTax); dt.Columns.Add("Discount"); //ADD DATA AS PER COLUMNS //Books _objBooks = new Books(); } else { dt = (DataTable)Session["tempBookData"]; } if (flag == "get") { tempGetData = SpecimanDetails.GetSpecimenDatilsByEmpCode(bookcode, "documentno_n").Tables[0]; } foreach (DataRow row in tempGetData.Rows) { if (dt.Rows.Count != 0) { DataView dv = new DataView(dt); dv.RowFilter = "BookCode = '" + row["BookCode"].ToString() + "'"; int i = 0; foreach (DataRowView row1 in dv) { i++; } if (i == 0) { if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); } dt.Rows.Add(0, row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, rqty, "0.00", String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), "0.00"); } } else { if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); } dt.Rows.Add(0, row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, rqty, "0.00", String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), "0.00"); } } return(dt); }
public DataTable fillTempBookData(string bookcode, string flag) { int InvQty = 0; int RQty = 0; int total = 0; DataTable dt = new DataTable(); DataTable tempGetData = new DataTable(); DataColumn colTax = new DataColumn(); colTax.DataType = System.Type.GetType("System.String"); colTax.ColumnName = "Rate"; if (Session["tempBookData"] == null) { //CREATE NEW DATATABLE //ADD COLUMNS IN DATATABLE dt.Columns.Add("SpecimenDetailId"); dt.Columns.Add("BookCode"); dt.Columns.Add("BookName"); //dt.Columns.Add("BookType"); dt.Columns.Add("Standard"); dt.Columns.Add("Medium"); dt.Columns.Add("Quantity"); dt.Columns.Add("GivedQty"); dt.Columns.Add("RemainQty"); dt.Columns.Add(colTax); dt.Columns.Add("Amount"); dt.Columns.Add("Discount"); dt.Columns.Add("InvQty"); dt.Columns.Add("RQty"); dt.Columns.Add("Total"); //ADD DATA AS PER COLUMNS //Books _objBooks = new Books(); } else { dt = (DataTable)Session["tempBookData"]; } if (flag == "set") { // tempGetData = BookSetDetails.Get_BookSetDetailsOn_SetIDForSpec((Convert.ToInt32(DDLSelectSet.SelectedItem.Value)), ViewState["srate"].ToString()).Tables[0]; tempGetData = Other_Z.OtherBAL.SpecimanReturn(txtsalemanCode.Text.Split(':')[0], Convert.ToInt32(strFY), Convert.ToInt32(DDLSelectSet.SelectedItem.Value), ViewState["srate"].ToString(), "", "").Tables[0]; } else if (flag == "get") { tempGetData = SpecimanDetails.GetSpecimenDatilsByEmpCode(bookcode, "documentno").Tables[0]; } else { tempGetData = Books.Get_BooksMasterForspecimen(bookcode, ViewState["srate"].ToString()).Tables[0]; } foreach (DataRow row in tempGetData.Rows) { price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); spcid = row["SpecimenDetailId"].ToString(); if (dt.Rows.Count != 0) { DataView dv = new DataView(dt); dv.RowFilter = "BookCode = '" + row["BookCode"].ToString() + "'"; int i = 0; price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); foreach (DataRowView row1 in dv) { i++; } if (i == 0) { if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); gqty = row["GivedQty"].ToString(); spcid = row["SpecimenDetailId"].ToString(); price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); InvQty = Convert.ToInt32(row["InvQty"].ToString()); RQty = Convert.ToInt32(row["RQty"].ToString()); total = Convert.ToInt32(row["Total"].ToString()); } // dt.Rows.Add(spcid, row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, gqty, rqty, String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:.00}", amt), "0.00", row["InvQty"].ToString(), row["RQty"].ToString(), row["Total"].ToString()); dt.Rows.Add(spcid, row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, gqty, rqty, String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:.00}", amt), "0.00", row["InvQty"].ToString(), row["RQty"].ToString(), row["Total"].ToString()); } } else { if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); gqty = row["GivedQty"].ToString(); spcid = row["SpecimenDetailId"].ToString(); price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); InvQty = Convert.ToInt32(row["InvQty"].ToString()); RQty = Convert.ToInt32(row["RQty"].ToString()); total = Convert.ToInt32(row["Total"].ToString()); } dt.Rows.Add(spcid, row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, gqty, rqty, String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:.00}", amt), "0.00", row["InvQty"].ToString(), row["RQty"].ToString(), row["Total"].ToString()); } } return(dt); }
protected void BtnGetByDocNum_Click(object sender, EventArgs e) { grdSchooldetails.DataSource = SpecimanDetails.GetSpecimenDatilsByEmpCode(TxtDocNum.Text.ToString(), "documentno"); grdSchooldetails.DataBind(); }