public void btnDisplay_Click(object sender, EventArgs e)
{
//GetALLData();
oDSActivity.Tables[0].Rows.Clear();
objServiceDB = new ServiceDB();
DataSet ds = objServiceDB.GetSearchServiceData(CommonData.CompanyCode, CommonData.BranchCode);
objServiceDB = null;
string strMain = "";
if (strChkDoc != "")
{
strMain += " SIH_DOCUMENT_MONTH in (" + strChkDoc.TrimEnd(',') + ")";
}
if (strChkVill != "")
{
if (strMain != "")
{
strMain += " AND ";
}
strMain += " cm_village in (" + strChkVill.TrimEnd(',') + ")";
}
if (strChkProd != "")
{
if (strMain != "")
{
strMain += " AND ";
}
strMain += " pm_product_name in (" + strChkProd.TrimEnd(',') + ")";
}
if (cmbQty.SelectedIndex == 4)
{
txtTo_Validated(null, null);
}
else
{
txtFrm_Validated(null, null);
}
if (strQty != "")
{
strMain += strQty;
}
DataRow[] dr = ds.Tables[0].Select(strMain, "SIH_INVOICE_NUMBER");
string sInvoiceid = "";
int ival = 0;
string sam_Name = "", ACTUAL_DATE = "", ATTEND_BY_ECODE = "", TNA_FARMER_REMARKS = "", TNA_PRODUCT_ID = "", pm_product_name = "", TNA_TARGET_DATE = "", SHORT_NAME = "";
string sam_Name1 = "", ACTUAL_DATE1 = "", ATTEND_BY_ECODE1 = "", TNA_FARMER_REMARKS1 = "", TNA_PRODUCT_ID1 = "", pm_product_name1 = "", TNA_TARGET_DATE1 = "", SHORT_NAME1 = "";
string sam_Name2 = "", ACTUAL_DATE2 = "", ATTEND_BY_ECODE2 = "", TNA_FARMER_REMARKS2 = "", TNA_PRODUCT_ID2 = "", pm_product_name2 = "", TNA_TARGET_DATE2 = "", SHORT_NAME2 = "";
string sam_Name3 = "", ACTUAL_DATE3 = "", ATTEND_BY_ECODE3 = "", TNA_FARMER_REMARKS3 = "", TNA_PRODUCT_ID3 = "", pm_product_name3 = "", TNA_TARGET_DATE3 = "", SHORT_NAME3 = "";
for (int i = 0; i < dr.Length - 1; i++)
{
if (sInvoiceid != dr[i][4].ToString())
{
ival = 0;
sam_Name = dr[i][20].ToString(); ACTUAL_DATE = dr[i][21].ToString(); ATTEND_BY_ECODE = dr[i][22].ToString(); TNA_FARMER_REMARKS = dr[i][23].ToString(); TNA_PRODUCT_ID = dr[i][24].ToString(); pm_product_name = dr[i][25].ToString(); TNA_TARGET_DATE = dr[i][26].ToString(); SHORT_NAME = dr[i][28].ToString();
}
else
{
ival++;
if (ival == 1)
{
sam_Name1 = dr[i][20].ToString(); ACTUAL_DATE1 = dr[i][21].ToString(); ATTEND_BY_ECODE1 = dr[i][22].ToString(); TNA_FARMER_REMARKS1 = dr[i][23].ToString(); TNA_PRODUCT_ID1 = dr[i][24].ToString(); pm_product_name1 = dr[i][25].ToString(); TNA_TARGET_DATE1 = dr[i][26].ToString(); SHORT_NAME1 = dr[i][28].ToString();
}
else if (ival == 2)
{
sam_Name2 = dr[i][20].ToString(); ACTUAL_DATE2 = dr[i][21].ToString(); ATTEND_BY_ECODE2 = dr[i][22].ToString(); TNA_FARMER_REMARKS2 = dr[i][23].ToString(); TNA_PRODUCT_ID2 = dr[i][24].ToString(); pm_product_name2 = dr[i][25].ToString(); TNA_TARGET_DATE2 = dr[i][26].ToString(); SHORT_NAME2 = dr[i][28].ToString();
}
else if (ival == 3)
{
sam_Name3 = dr[i][20].ToString(); ACTUAL_DATE3 = dr[i][21].ToString(); ATTEND_BY_ECODE3 = dr[i][22].ToString(); TNA_FARMER_REMARKS3 = dr[i][23].ToString(); TNA_PRODUCT_ID3 = dr[i][24].ToString(); pm_product_name3 = dr[i][25].ToString(); TNA_TARGET_DATE3 = dr[i][26].ToString(); SHORT_NAME3 = dr[i][28].ToString();
}
}
if (dr[i][4].ToString() != dr[i + 1][4].ToString())
{
oDSActivity.Tables[0].Rows.Add(dr[i][0].ToString(), dr[i][1].ToString(), dr[i][2].ToString(), dr[i][3].ToString(), dr[i][4].ToString()
, dr[i][5].ToString(), dr[i][6].ToString(), dr[i][7].ToString(), dr[i][8].ToString(), dr[i][9].ToString(), dr[i][10].ToString()
, dr[i][11].ToString(), dr[i][12].ToString(), dr[i][13].ToString(), dr[i][14].ToString(), dr[i][15].ToString(), dr[i][16].ToString()
, dr[i][17].ToString(), dr[i][18].ToString(), dr[i][19].ToString(), sam_Name, ACTUAL_DATE, ATTEND_BY_ECODE, TNA_FARMER_REMARKS,
TNA_PRODUCT_ID, pm_product_name, TNA_TARGET_DATE, SHORT_NAME, sam_Name1, ACTUAL_DATE1, ATTEND_BY_ECODE1, TNA_FARMER_REMARKS1,
TNA_PRODUCT_ID1, pm_product_name1, TNA_TARGET_DATE1, SHORT_NAME1, sam_Name2, ACTUAL_DATE2, ATTEND_BY_ECODE2, TNA_FARMER_REMARKS2,
TNA_PRODUCT_ID2, pm_product_name2, TNA_TARGET_DATE2, SHORT_NAME2, sam_Name3, ACTUAL_DATE3, ATTEND_BY_ECODE3, TNA_FARMER_REMARKS3,
TNA_PRODUCT_ID3, pm_product_name3, TNA_TARGET_DATE3, SHORT_NAME3);
sam_Name = ""; ACTUAL_DATE = ""; ATTEND_BY_ECODE = ""; TNA_FARMER_REMARKS = ""; TNA_PRODUCT_ID = ""; pm_product_name = ""; TNA_TARGET_DATE = ""; SHORT_NAME = "";
sam_Name1 = ""; ACTUAL_DATE1 = ""; ATTEND_BY_ECODE1 = ""; TNA_FARMER_REMARKS1 = ""; TNA_PRODUCT_ID1 = ""; pm_product_name1 = ""; TNA_TARGET_DATE1 = ""; SHORT_NAME1 = "";
sam_Name2 = ""; ACTUAL_DATE2 = ""; ATTEND_BY_ECODE2 = ""; TNA_FARMER_REMARKS2 = ""; TNA_PRODUCT_ID2 = ""; pm_product_name2 = ""; TNA_TARGET_DATE2 = ""; SHORT_NAME2 = "";
sam_Name3 = ""; ACTUAL_DATE3 = ""; ATTEND_BY_ECODE3 = ""; TNA_FARMER_REMARKS3 = ""; TNA_PRODUCT_ID3 = ""; pm_product_name3 = ""; TNA_TARGET_DATE3 = ""; SHORT_NAME3 = "";
}
sInvoiceid = dr[i][4].ToString();
}
CommonData.ViewReport = "SERVICE_ACTIVITY_DETAILS";
ReportViewer chldRV = new ReportViewer(oDSActivity);
chldRV.Show();
}
