public void ReceiptBookIdBind() { btnprint.Visible = true; if (txtReceiptBookId.Text == "") { } else { int ActualReceiptNo = Convert.ToInt32(txtReceiptBookId.Text.Trim()); //txtempcode.Text = ECode; DataTable dt1 = ReciptBookDetails.getReceiptBookDetails(ECode, "1", "2", ActualReceiptNo).Tables[1]; gvshow.DataSource = dt1; if (dt1.Rows.Count != 0) { gvshow.DataBind(); gvshow.Visible = true; Button1.Visible = false; gvshow.Visible = true; } else { MessageBox("No Data Found"); lblempname.Text = ""; lblempname.Visible = false; txtReceiptBookId.Focus(); txtReceiptBookId.Text = ""; gvshow.DataSource = null; gvshow.Visible = false; } } }
protected void txtempcode_TextChanged(object sender, EventArgs e) { btnprint.Visible = true; string ECode = txtempcode.Text.ToString().Split(':')[0].Trim(); DataTable dt = new DataTable(); dt = DCMaster.Get_Name(ECode, "Employee").Tables[0]; if (dt.Rows.Count != 0) { txtempcode.Text = ECode; lblempname.Text = dt.Rows[0]["FirstName"] + " " + dt.Rows[0]["MiddleName"] + " " + dt.Rows[0]["LastName"]; DataTable dt1 = ReciptBookDetails.getReceiptBookDetails(ECode, "1", "2", ActualReceiptNo).Tables[1]; gvshow.DataSource = dt1; gvshow.DataBind(); gvshow.Visible = true; Button1.Visible = false; } else { lblempname.Text = "No such salesman code"; txtempcode.Focus(); txtempcode.Text = ""; gvshow.Visible = false; } }
public DataView BindGvBookDetail() { DataTable dt1 = ReciptBookDetails.getReceiptBookDetails(val, "1", "2", 0).Tables[1]; DataView dv = new DataView(dt1); return(dv); gvshow.DataSource = dt1; gvshow.DataBind(); gvshow.Visible = true; // Button1.Visible = false; //DataTable dt = new DataTable(); //dt = Books.GetBookMaster(); //DataView dv = new DataView(dt); }
protected void gvshow_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Used") { string empid = txtempcode.Text.ToString(); if (redio.Items[1].Selected) { ActualReceiptNo = Convert.ToInt32(txtReceiptBookId.Text.Trim()); } lnkarg = e.CommandArgument.ToString(); fromno = lnkarg.Split('-')[0].ToString(); Tono = lnkarg.Split('-')[1].ToString(); DataTable ds = new DataTable(); ds = (ReciptBookDetails.getReceiptBookDetails(empid, fromno, Tono, ActualReceiptNo).Tables[2]); GridViewUsed.DataSource = ds; GridViewUsed.DataBind(); pnlusedDetails.Visible = true; PanelCancelDetalis.Visible = false; gvshow.Visible = false; Button1.Visible = true; //upCounts.Visible = false; btnSave.Visible = false; btnview.Text = "Back"; upCounts.Update(); upDetails.Update(); } else if (e.CommandName == "CancelReceipt") { if (redio.Items[1].Selected) { ActualReceiptNo = Convert.ToInt32(txtReceiptBookId.Text.Trim()); } string empid = txtempcode.Text.ToString(); lnkarg = e.CommandArgument.ToString(); fromno = lnkarg.Split('-')[0].ToString(); Tono = lnkarg.Split('-')[1].ToString(); DataTable ds = new DataTable(); ds = (ReciptBookDetails.getReceiptBookDetails(empid, fromno, Tono, ActualReceiptNo).Tables[3]); GridViewCancel.DataSource = ds; GridViewCancel.DataBind(); pnlusedDetails.Visible = false; PanelCancelDetalis.Visible = true; gvshow.Visible = false; btnSave.Visible = false; Button1.Visible = true; btnview.Text = "Back"; upCounts.Update(); upDetails.Update(); } else if (e.CommandName == "Pending") { if (redio.Items[1].Selected) { ActualReceiptNo = Convert.ToInt32(txtReceiptBookId.Text.Trim()); } string empid = txtempcode.Text.ToString(); lnkarg = e.CommandArgument.ToString(); fromno = lnkarg.Split('-')[0].ToString(); Tono = lnkarg.Split('-')[1].ToString(); DataTable ds = new DataTable(); ds = (ReciptBookDetails.getReceiptBookDetails(empid, fromno, Tono, ActualReceiptNo).Tables[4]); GridViewCancel.DataSource = ds; GridViewCancel.DataBind(); pnlusedDetails.Visible = false; PanelCancelDetalis.Visible = true; gvshow.Visible = false; btnSave.Visible = false; Button1.Visible = true; btnview.Text = "Back"; upCounts.Update(); upDetails.Update(); } }