//public System.Data.DataSet GetPage(int start, int count, ref int totalCount,
// string Distributor_No, string customer, string address, string email,
// string phone, string country, string state, string from_Date,
// string to_Date)
//{
// System.Data.DataSet ds = new System.Data.DataSet();
// //_is_Single_Transaction = false;
// try
// {
// DataAccessLayer.Distributor.Distributor obj = new DataAccessLayer.Distributor.Distributor(start, count, totalCount,
// Distributor_No, customer, address, email, phone, country, state, from_Date, to_Date);
// obj.SetConnection();
// _db = obj.GetDatabase();
// ds = obj.GetPage();
// totalCount = obj._ID;
// }
// catch
// {
// //_base.RollBackTransaction();
// //throw;
// }
// return ds;
//}
//public System.Data.DataSet GetPage(int start, int count, ref int totalCount,
// string UCI, int? company, string first_Name,
// string middle_Name, string last_Naemm, string phone_1,
// string phone_2, string from_Date, string to_Date)
//{
// System.Data.DataSet ds = new System.Data.DataSet();
// //_is_Single_Transaction = false;
// try
// {
// DataAccessLayer.Consumer.Consumer cons = new DataAccessLayer.Consumer.Consumer(start, count, totalCount,
// UCI, company, first_Name, middle_Name, last_Naemm, phone_1, phone_2, from_Date, to_Date);
// cons.SetConnection();
// _db = cons.GetDatabase();
// ds = cons.GetPage();
// totalCount = cons._ID;
// }
// catch
// {
// //_base.RollBackTransaction();
// //throw;
// }
// return ds;
//}
//public DataSet.DSParameter GetCaseByConsumer(int consumer_ID)
//{
// DataSet.DSParameter ds = new DataSet.DSParameter();
// //_is_Single_Transaction = false;
// try
// {
// DataAccessLayer.Consumer.Case Cons = new DataAccessLayer.Consumer.Case();
// Cons.SetConnection();
// _db = Cons.GetDatabase();
// Cons._ID = consumer_ID;
// ds.Load(Cons.GetItemByConsumer(), LoadOption.OverwriteChanges, ds.Case.TableName);
// }
// catch
// {
// //_base.RollBackTransaction();
// //throw;
// }
// return ds;
//}
#endregion
public System.Data.DataSet GetDistributorStateCount()
{
DataAccessLayer.Distributor.Distributor obj = new DataAccessLayer.Distributor.Distributor();
System.Data.DataSet ds = new System.Data.DataSet();
obj.SetConnection();
ds.Load(obj.GetStateCount(), LoadOption.OverwriteChanges, "List");
return ds;
}
