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