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