private DataTable updateGrid(string R3)
{
string Id = "";
string R1 = "";
string R2 = "";
string PrintId = "";
string strTemp = "";
string FromDate = DateTime.Now.ToString("MM/dd/yyyy");
string ToDate = DateTime.Now.ToString("MM/dd/yyyy");
int TokenKyc = 0;
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dtgrid = new DataTable();
if (rbtnToken.Checked)
{
TokenKyc = Convert.ToInt32(txtTokenFind.Text.Trim());
strTemp = "TokenNo";
}
else if (rbtnKyc.Checked)
{
TokenKyc = Convert.ToInt32(txtKycFind.Text.Trim());
strTemp = "KycNo";
}
else if (rbtDatewise.Checked)
{
FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2];
ToDate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2];
}
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId,
rbtDatewise.Checked == true ? Convert.ToDateTime(FromDate):Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")),
rbtDatewise.Checked == true ? Convert.ToDateTime(ToDate): Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")));
dtgrid = ds.Tables[0];
if (dtgrid.Rows.Count == 0)
{
if (rbtDatewise.Checked)
{
MessageBox("Record Not Found ");
txtFromDate.Focus();
}
else if (rbtnKyc.Checked)
{
MessageBox("Record Not Found ");
txtKycFind.Focus();
}
else if (rbtnToken.Checked)
{
MessageBox("Record Not Found ");
txtTokenFind.Focus();
}
}
return(dtgrid);
}
private DataTable updateGridWithCustName(string R3)
{
string Id = "";
string R1 = txtCustomerName.Text;
string R2 = "";
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dtgrid = new DataTable();
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, 0, "", DateTime.Now, DateTime.Now);
dtgrid = ds.Tables[0];
return(dtgrid);
}
public DataTable DataPrint(string R3, string PrintId)
{
string Id = "";
string R1 = "";
string R2 = "";
int TokenKyc = 0;
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dtgrid = new DataTable();
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId, Convert.ToDateTime(null),
Convert.ToDateTime(null));
return(dtgrid = ds.Tables[0]);
}
private DataTable FillGridView(string R3, string PrintId)
{
string Id = "";
string R1 = "";
string R2 = "";
string strTemp = "";
string FromDate = DateTime.Now.ToString("MM/dd/yyyy");
string ToDate = DateTime.Now.ToString("MM/dd/yyyy");
int TokenKyc = 0;
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dt = new DataTable();
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId,
R3 == strTemp ? Convert.ToDateTime(FromDate) : Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")),
R3 == strTemp ? Convert.ToDateTime(ToDate) : Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")));
dt = ds.Tables[0];
return(dt);
}
private DataTable FillGridData(string R3, string PrintId)
{
string Id = "";
string R1 = "";
string R2 = "";
int TokenKyc = 0;
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dtgrid = new DataTable();
string FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2];
string ToDate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2];
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId,
Convert.ToDateTime(FromDate),
Convert.ToDateTime(ToDate)
);
dtgrid = ds.Tables[0];
return(dtgrid);
}
