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