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