private void Subcription_Report_Detailed_View_Load(object sender, EventArgs e)
{
if (typesub == "USER WISE")
{
Hashtable htselect = new Hashtable();
DataTable dtselect = new System.Data.DataTable();
htselect.Add("@Trans", "GET_SUBSCRIPTION_ORDERS_DATE_WISE");
htselect.Add("@client_Id", Client_ID);
htselect.Add("@To_Date", To_date);
htselect.Add("@User_Password_Id", Website_id);
dtselect = dataaccess.ExecuteSP("Sp_Orders_Subscription_Report", htselect);
if (dtselect.Rows.Count > 0)
{
Grd_OrderTime.Visible = true;
Grd_OrderTime.Rows.Clear();
Grd_OrderTime.Columns.Clear();
Grd_OrderTime.DataSource = null;
Grd_OrderTime.AutoGenerateColumns = true;
Grd_OrderTime.Refresh();
Grd_OrderTime.Visible = true;
Grd_OrderTime.DataSource = dtselect;
ArrangeGrid(Grd_OrderTime);
}
else
{
Grd_OrderTime.Visible = false;
Grd_OrderTime.DataSource = null;
}
}
else if (typesub == "CLIENT WISE")
{
Hashtable htselect = new Hashtable();
DataTable dtselect = new System.Data.DataTable();
if (Website_id != 43)
{
htselect.Add("@Trans", "GET_SUBSCRIPTION_ORDERS_DATE_WISE");
}
else if (Website_id == 43)
{
htselect.Add("@Trans", "GET_SUBSCRIPTION_ORDERS_DATE_WISE_FOR_OTHER_WEBSITE");
}
htselect.Add("@client_Id", Client_ID);
htselect.Add("@To_Date", To_date);
htselect.Add("@User_Password_Id", Website_id);
dtselect = dataaccess.ExecuteSP("Sp_Orders_Subscription_Report", htselect);
if (dtselect.Rows.Count > 0)
{
Grd_OrderTime.Visible = true;
Grd_OrderTime.Rows.Clear();
Grd_OrderTime.Columns.Clear();
Grd_OrderTime.DataSource = null;
Grd_OrderTime.AutoGenerateColumns = true;
Grd_OrderTime.Refresh();
Grd_OrderTime.Visible = true;
Grd_OrderTime.DataSource = dtselect;
ArrangeGrid(Grd_OrderTime);
}
else
{
Grd_OrderTime.Visible = false;
Grd_OrderTime.DataSource = null;
}
}
}
private void Report_Subscription_View_Load(object sender, EventArgs e)
{
if (type_sub == "CLIENT WISE")
{
Hashtable htuser = new Hashtable();
DataTable dtuser = new DataTable();
htuser.Add("@Trans", "GET_USERPASSWORD_CLIENT");
htuser.Add("@client_Id", Client_ID);
htuser.Add("@webSite_Name", web);
dtuser = dataaccess.ExecuteSP("Sp_Orders_Subscription_Report", htuser);
if (dtuser.Rows.Count > 0)
{
userpassword = int.Parse(dtuser.Rows[0]["User_Password_Id"].ToString());
Hashtable htselect = new Hashtable();
DataTable dtselect = new System.Data.DataTable();
htselect.Add("@Trans", "SELECT_DATE_WISE_CLIENT_WISE");
htselect.Add("@client_Id", Client_ID);
htselect.Add("@User_Passwordid", Convert.ToString(userpassword));
dtselect = dataaccess.ExecuteSP("Sp_Orders_Subscription_Report", htselect);
if (dtselect.Rows.Count > 0)
{
Grd_OrderTime.Visible = true;
Grd_OrderTime.Rows.Clear();
Grd_OrderTime.Columns.Clear();
Grd_OrderTime.DataSource = null;
Grd_OrderTime.AutoGenerateColumns = true;
Grd_OrderTime.Refresh();
Grd_OrderTime.Visible = true;
Grd_OrderTime.DataSource = dtselect;
Grd_OrderTime.Columns[0].Visible = false;
ArrangeGrid(Grd_OrderTime);
}
else
{
Grd_OrderTime.Visible = false;
Grd_OrderTime.DataSource = null;
}
}
}
else if (type_sub == "USER WISE")
{
Hashtable htuser = new Hashtable();
DataTable dtuser = new DataTable();
htuser.Add("@Trans", "GET_USERPASSWORD_CLIENT");
htuser.Add("@client_Id", Client_ID);
htuser.Add("@webSite_Name", web);
dtuser = dataaccess.ExecuteSP("Sp_Orders_Subscription_Report", htuser);
{
userpassword = int.Parse(dtuser.Rows[0]["User_Password_Id"].ToString());
Hashtable htselect = new Hashtable();
DataTable dtselect = new System.Data.DataTable();
htselect.Add("@Trans", "SELECT_DATE_WISE_USER_WISE");
htselect.Add("@userid", Client_ID);
htselect.Add("@User_Passwordid", Convert.ToString(userpassword));
dtselect = dataaccess.ExecuteSP("Sp_Orders_Subscription_Report", htselect);
if (dtselect.Rows.Count > 0)
{
Grd_OrderTime.Visible = true;
Grd_OrderTime.Rows.Clear();
Grd_OrderTime.Columns.Clear();
Grd_OrderTime.DataSource = null;
Grd_OrderTime.AutoGenerateColumns = true;
Grd_OrderTime.Refresh();
Grd_OrderTime.Visible = true;
Grd_OrderTime.DataSource = dtselect;
Grd_OrderTime.Columns[0].Visible = false;
ArrangeGrid(Grd_OrderTime);
}
else
{
Grd_OrderTime.Visible = false;
Grd_OrderTime.DataSource = null;
}
}
}
}
