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);
}
