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