protected void btngetset_Click(object sender, EventArgs e) { if (ViewState["srate"].ToString() == "") { MessageBox("Kindly select Employee"); //txtsalemanCode.Focus(); ViewState["srate"] = ""; } else { setStateGridview(); Qty = Convert.ToString(txtsetqty.Text.Trim()); if (Qty == "" || Qty == "0") { Qty = "1"; rqty = "1"; } if (txtsetqty.Text != "") { rqty = Convert.ToString(txtsetqty.Text); Qty = Convert.ToString(txtsetqty.Text); } if (txtGCN.Text != "") { grdBookDetails.Columns[7].Visible = true; grdBookDetails.Columns[8].Visible = true; // grdBookDetails.Columns[10].Visible = false; } else { grdBookDetails.Columns[7].Visible = false; grdBookDetails.Columns[8].Visible = false; // grdBookDetails.Columns[10].Visible = true; } if (DDLSelectSet.SelectedValue == "0") { loder("Kindly select bookset"); DDLSelectSet.Focus(); } else { try { DataTable bookdescription = new DataTable(); bookdescription = BookSetDetails.GetDescription_Of_bookset((Convert.ToInt32(DDLSelectSet.SelectedItem.Value)), "Specimen").Tables[0]; Description = bookdescription.Rows[0]["Description"].ToString(); DataTable dt1 = new DataTable(); if (Session["tempBookData"] != null) { Session["tempBookData"] = fillTempBookData("", "set"); dt1 = (DataTable)Session["tempBookData"]; } else { Session["tempBookData"] = fillTempBookData("", "set"); dt1 = (DataTable)Session["tempBookData"]; } foreach (GridViewRow row in grdBookDetails.Rows) { ((Label)row.FindControl("lblavailable")).Visible = false; } grdBookDetails.DataSource = dt1; grdBookDetails.DataBind(); loder(DDLSelectSet.SelectedItem.Text + "(bookset) added successfully"); string jv1 = "clearBookset()"; ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "as", jv1, true); } catch { } } } }
protected void btngetset_Click(object sender, EventArgs e) { //Validate Bookset if (DDLSelectSet.SelectedValue != "0") { Qty = Convert.ToString(txtsetqty.Text.Trim()); if (Qty != "" && Qty != "0") { DataTable dt = Other_Z.OtherBAL.GetValidate_Speciman(Convert.ToInt32(DDLSelectSet.SelectedItem.Value), Qty, txtsalemanCode.Text.Trim(), Convert.ToInt32(strFY), "", "").Tables[0]; if (dt.Rows.Count > 0) { if (Convert.ToInt32(dt.Rows[0][0]) >= 0) { } else { //MessageBox("Out of Limit Book Set " + DDLSelectSet.SelectedItem); MessageBox("Out of Limit Book Set" + DDLSelectSet.SelectedItem + " " + " Total Limit(" + dt.Rows[0][1] + ")" + " " + " Remaining Limit(" + dt.Rows[0][2] + ")"); txtsetqty.Text = ""; txtsetqty.Focus(); return; } } else { MessageBox("Please Set BookSet Limit " + DDLSelectSet.SelectedItem); txtsetqty.Text = ""; txtsetqty.Focus(); return; } } else { MessageBox("Please Enter Quntity"); txtsetqty.Focus(); return; } } else { MessageBox("Please Select Book Set"); DDLSelectSet.Focus(); return; } if (ViewState["srate"].ToString() == "") { MessageBox("Kindly select Employee"); txtsalemanCode.Focus(); ViewState["srate"] = ""; } else { setStateGridview(); Qty = Convert.ToString(txtsetqty.Text.Trim()); if (Qty == "" || Qty == "0") { Qty = "1"; rqty = "1"; } if (txtsetqty.Text != "") { rqty = Convert.ToString(txtsetqty.Text); Qty = Convert.ToString(txtsetqty.Text); } if (txtdoc.Text != "") { grdBookDetails.Columns[7].Visible = true; grdBookDetails.Columns[8].Visible = true; // grdBookDetails.Columns[10].Visible = false; } else { grdBookDetails.Columns[7].Visible = false; grdBookDetails.Columns[8].Visible = false; // grdBookDetails.Columns[10].Visible = true; } if (DDLSelectSet.SelectedValue == "0") { loder("Kindly select bookset"); DDLSelectSet.Focus(); } else { try { DataTable bookdescription = new DataTable(); bookdescription = BookSetDetails.GetDescription_Of_bookset((Convert.ToInt32(DDLSelectSet.SelectedItem.Value)), "Specimen").Tables[0]; Description = bookdescription.Rows[0]["Description"].ToString(); DataTable dt1 = new DataTable(); if (Session["tempBookData"] != null) { Session["tempBookData"] = fillTempBookData("", "set"); dt1 = (DataTable)Session["tempBookData"]; } else { Session["tempBookData"] = fillTempBookData("", "set"); dt1 = (DataTable)Session["tempBookData"]; } foreach (GridViewRow row in grdBookDetails.Rows) { ((Label)row.FindControl("lblavailable")).Visible = false; } grdBookDetails.DataSource = dt1; grdBookDetails.DataBind(); loder(DDLSelectSet.SelectedItem.Text + "(bookset) added successfully"); string jv1 = "clearBookset()"; ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "as", jv1, true); } catch { } } } }
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 = "Rate"; if (Session["tempBookData"] == null) { //CREATE NEW DATATABLE //ADD COLUMNS IN DATATABLE dt.Columns.Add("SpecimenDetailId"); dt.Columns.Add("BookSetID"); 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"); //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]; } 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); 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); } dt.Rows.Add(spcid, Convert.ToInt32(row["BookSetID"].ToString()), 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"); } } else { if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); gqty = row["GivedQty"].ToString(); spcid = row["SpecimenDetailId"].ToString(); booksetid = Convert.ToInt32(row["BookSetID"].ToString()); price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); } dt.Rows.Add(spcid, Convert.ToInt32(row["BookSetID"].ToString()), 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"); } } return(dt); }
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 = "Rate"; DataColumn Discount = new DataColumn(); Discount.DataType = System.Type.GetType("System.String"); Discount.ColumnName = "Discount"; DataColumn AdditionalDiscount = new DataColumn(); AdditionalDiscount.DataType = System.Type.GetType("System.String"); AdditionalDiscount.ColumnName = "AdditionalDiscount"; DataColumn Amount = new DataColumn(); Amount.DataType = System.Type.GetType("System.String"); Amount.ColumnName = "Amount"; if (Session["tempDCData"] == null) { //CREATE NEW DATATABLE //ADD COLUMNS IN DATATABLE dt.Columns.Add("DCDetailID"); dt.Columns.Add("BookId"); 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("DeliveryDate"); dt.Columns.Add(colTax); dt.Columns.Add(Amount); dt.Columns.Add(Discount); dt.Columns.Add(AdditionalDiscount); //ADD DATA AS PER COLUMNS //Books _objBooks = new Books(); } else { dt = (DataTable)Session["tempDCData"]; } if (flag == "set") { tempGetData = BookSetDetails.Get_BookSetDetailsOn_SetID_ForDC((Convert.ToInt32(DDLSelectSet.SelectedItem.Value)), srate).Tables[0]; } else if (flag == "get") { try { tempGetData = DCDetails.GetDCDatilsByCode(bookcode, "documentno").Tables[0]; } catch { } } else { tempGetData = Books.Get_BooksMasterForDC(bookcode, srate).Tables[0]; Isblock = (Convert.ToBoolean(tempGetData.Rows[0]["IsBlock"].ToString())); } foreach (DataRow row in tempGetData.Rows) { price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(Qty) * Convert.ToDecimal(price); 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) { DataSet ds = DCMaster.Get_Discount_On_CusomerAND_Booktype(txtcustomer.Text.ToString() + "!" + Session["FY"].ToString(), row["BookCode"].ToString()); if (ds.Tables[0].Rows.Count > 0) { discount = Convert.ToDecimal(ds.Tables[0].Rows[0][0]); Adddiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][1]); // Totaldiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][2]); Tdiscount = amt * (discount / 100); amt = amt - Tdiscount; } if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); gqty = row["GivedQty"].ToString(); dcid = row["DCDetailID"].ToString(); string EDate = row["DeliveryDate"].ToString(); EDate = EDate.Split('/')[1] + "/" + EDate.Split('/')[0] + "/" + EDate.Split('/')[2]; Delidate = Convert.ToDateTime(EDate); price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(row["Amount"].ToString()); discount = Convert.ToDecimal(row["Discount"].ToString()); } dt.Rows.Add(dcid, row["Bookid"].ToString(), row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, gqty, rqty, Delidate.ToString("dd/MM/yyyy"), String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:0.00}", Convert.ToDecimal(amt)), String.Format("{0:0.00}", Convert.ToDecimal(discount)), String.Format("{0:0.00}", Convert.ToDecimal(Adddiscount))); } } else { DataSet ds = DCMaster.Get_Discount_On_CusomerAND_Booktype(txtcustomer.Text.ToString() + "!" + Session["FY"].ToString(), row["BookCode"].ToString()); if (ds.Tables[0].Rows.Count > 0) { discount = Convert.ToDecimal(ds.Tables[0].Rows[0][0]); Adddiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][1]); // Totaldiscount = Convert.ToDecimal(ds.Tables[0].Rows[0][2]); Tdiscount = amt * (discount / 100); amt = amt - Tdiscount; } if (flag == "get") { Qty = row["Quantity"].ToString(); rqty = row["RemainQty"].ToString(); gqty = row["GivedQty"].ToString(); dcid = row["DCDetailID"].ToString(); string EDate = row["DeliveryDate"].ToString(); EDate = EDate.Split('/')[1] + "/" + EDate.Split('/')[0] + "/" + EDate.Split('/')[2]; Delidate = Convert.ToDateTime(EDate); price = row["SellingPrice"].ToString(); amt = Convert.ToDecimal(row["Amount"].ToString()); discount = Convert.ToDecimal(row["Discount"].ToString()); } dt.Rows.Add(dcid, row["Bookid"].ToString(), row["BookCode"].ToString(), row["BookName"].ToString(), row["Standard"].ToString(), row["Medium"].ToString(), Qty, gqty, rqty, Delidate.ToString("dd/MM/yyyy"), String.Format("{0:0.00}", Convert.ToDecimal(row["SellingPrice"].ToString())), String.Format("{0:0.00}", Convert.ToDecimal(amt)), String.Format("{0:0.00}", Convert.ToDecimal(discount)), String.Format("{0:0.00}", Convert.ToDecimal(Adddiscount))); } } return(dt); }