private void Load() { OdbcCommand cmdS = new OdbcCommand(); cmdS.Parameters.AddWithValue("tblname", "m_season"); cmdS.Parameters.AddWithValue("attribute", "season_id,season_sub_id, DATE_FORMAT(CAST(startdate AS CHAR(12)),'%d/%m/%Y' ) AS 'startdate',DATE_FORMAT(CAST(enddate AS CHAR(12)),'%d/%m/%Y' ) AS 'enddate'"); cmdS.Parameters.AddWithValue("conditionv", "curdate() between startdate and enddate and is_current=" + 1 + " and rowstatus<>" + 2 + ""); DataTable dtS = new DataTable(); dtS = objcls.SpDtTbl("CALL selectcond(?,?,?)", cmdS); if (dtS.Rows.Count > 0) { int curseason1 = int.Parse(dtS.Rows[0]["season_id"].ToString()); Session["season"] = curseason1.ToString(); Session["seasonid"] = dtS.Rows[0]["season_id"].ToString(); Session["seasonsubid"] = dtS.Rows[0]["season_sub_id"].ToString(); txtfromdate.Text = dtS.Rows[0]["startdate"].ToString(); txttodate.Text = dtS.Rows[0]["enddate"].ToString(); DataTable dt_seas = objcls.DtTbl("SELECT season_sub_id,seasonname FROM m_sub_season WHERE season_sub_id = '" + dtS.Rows[0]["season_sub_id"].ToString() + "'"); if (dt_seas.Rows.Count > 0) { ddlseason.DataSource = dt_seas; ddlseason.DataBind(); } string unclaimed = @"SELECT IFNULL(SUM(amount),0) -IFNULL((SELECT IFNULL(SUM(amount),0) AS 'Deposit' FROM t_unclaimedremittance,m_season WHERE t_unclaimedremittance.DATE BETWEEN m_season.startdate AND m_season.enddate AND m_season.season_id='" + Session["seasonid"] + "' GROUP BY m_season.season_id),0) AS 'Unclaimed' FROM t_daily_transaction,m_season WHERE t_daily_transaction.ledger_id = '2' AND t_daily_transaction.DATE BETWEEN m_season.startdate AND m_season.enddate AND m_season.season_id='" + Session["seasonid"] + "' GROUP BY m_season.season_id"; DataTable dt_unclaimed = objcls.DtTbl(unclaimed); if (dt_unclaimed.Rows.Count > 0) { txtunclaimed.Text = dt_unclaimed.Rows[0][0].ToString(); } else { txtunclaimed.Text = "0"; } } else { obc.ShowAlertMessage(this, "Season not found"); } DataTable dt_nw = objcls.DtTbl("select date_format(now(),'%d/%m/%Y') as 'dt',date_format(now(),'%l:%i:%s %p') as 'time'"); txtdate.Text = dt_nw.Rows[0][0].ToString(); }