public DataTable GetTopCountriesEarning(BLGetMapData obj) { try { SqlConnection cn = new SqlConnection(strcon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[GetMapData]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Instruction", obj.instruction); da.SelectCommand.Parameters.AddWithValue("@AffiliateID", obj.AffiliateID); da.SelectCommand.Parameters.AddWithValue("@startDate", obj.startDate); da.SelectCommand.Parameters.AddWithValue("@endDate", obj.EndDate); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dt = new DataTable(); cn.Close(); da.Fill(dt); if (dt != null) { return(dt); } else { return(null); } } catch (Exception) { return(null); } }
public DataSet GetRevenuePieChart(BLGetMapData obj) { try { SqlConnection cn = new SqlConnection(strcon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[GetMapData]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Instruction", obj.instruction); da.SelectCommand.Parameters.AddWithValue("@startDate", obj.startDate); da.SelectCommand.Parameters.AddWithValue("@AffiliateID", obj.AffiliateID); da.SelectCommand.Parameters.AddWithValue("@date", System.DateTime.Now); da.SelectCommand.Parameters.AddWithValue("@endDate", obj.EndDate); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataSet dt = new DataSet(); cn.Close(); da.Fill(dt); if (dt != null) { return(dt); } else { return(null); } } catch (Exception) { return(null); } }