public static DataSet GetDropDownListAllCustomer()
{
DataSet customers = new DataSet();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customers = sqlCustomerProvider.GetDropDownLisAllCustomer();
return customers;
}
public static Customer GetIncomeByIncomeID(int IncomeID)
{
Customer customer = new Customer();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customer = sqlCustomerProvider.GetCustomerByIncomeID(IncomeID);
return customer;
}
public static DataSet GetAllCustomersWithRelation()
{
DataSet customers = new DataSet();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customers = sqlCustomerProvider.GetAllCustomers();
return customers;
}
public static Customer GetCustomerByCustomerID(int CustomerID)
{
Customer customer = new Customer();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customer = sqlCustomerProvider.GetCustomerByCustomerID(CustomerID);
return customer;
}
public static Customer GetCustomerByCustomerID(int CustomerID)
{
Customer customer = new Customer();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customer = sqlCustomerProvider.GetCustomerByCustomerID(CustomerID);
return(customer);
}
public static Customer GetRelationshipByRelationshipID(int RelationshipID)
{
Customer customer = new Customer();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customer = sqlCustomerProvider.GetCustomerByRelationshipID(RelationshipID);
return(customer);
}
public static Customer GetIncomeByIncomeID(int IncomeID)
{
Customer customer = new Customer();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customer = sqlCustomerProvider.GetCustomerByIncomeID(IncomeID);
return(customer);
}
public static DataSet GetAllCustomersWithRelation()
{
DataSet customers = new DataSet();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customers = sqlCustomerProvider.GetAllCustomers();
return(customers);
}
public static DataSet GetDropDownListAllCustomer()
{
DataSet customers = new DataSet();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customers = sqlCustomerProvider.GetDropDownLisAllCustomer();
return(customers);
}
public static void LoadCustomerPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
DataSet ds = sqlCustomerProvider.GetCustomerPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
customersPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static Customer GetRelationshipByRelationshipID(int RelationshipID)
{
Customer customer = new Customer();
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
customer = sqlCustomerProvider.GetCustomerByRelationshipID(RelationshipID);
return customer;
}
public static bool DeleteCustomer(int customerID)
{
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
return sqlCustomerProvider.DeleteCustomer(customerID);
}
public static bool DeleteCustomer(int customerID)
{
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
return(sqlCustomerProvider.DeleteCustomer(customerID));
}
public static int InsertCustomer(Customer customer)
{
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
return(sqlCustomerProvider.InsertCustomer(customer));
}
public static int InsertCustomer(Customer customer)
{
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
return sqlCustomerProvider.InsertCustomer(customer);
}
public static bool UpdateCustomer(Customer customer)
{
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
return sqlCustomerProvider.UpdateCustomer(customer);
}
public static void LoadCustomerPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
DataSet ds = sqlCustomerProvider.GetCustomerPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
customersPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static bool UpdateCustomer(Customer customer)
{
SqlCustomerProvider sqlCustomerProvider = new SqlCustomerProvider();
return(sqlCustomerProvider.UpdateCustomer(customer));
}
