コード例 #1
0
    public static CUSTOMER GetCUSTOMERByID(int id)
    {
        CUSTOMER            cUSTOMER            = new CUSTOMER();
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        cUSTOMER = sqlCUSTOMERProvider.GetCUSTOMERByID(id);
        return(cUSTOMER);
    }
コード例 #2
0
    public static List <CUSTOMER> GetAllCUSTOMERsForSearchByID(int customerID)
    {
        List <CUSTOMER>     cUSTOMERs           = new List <CUSTOMER>();
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        cUSTOMERs = sqlCUSTOMERProvider.GetAllCUSTOMERsForSearchByID(customerID);
        return(cUSTOMERs);
    }
コード例 #3
0
    public static List <CUSTOMER> GetAllCUSTOMERsForSearchByName(string customerFName)
    {
        List <CUSTOMER>     cUSTOMERs           = new List <CUSTOMER>();
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        cUSTOMERs = sqlCUSTOMERProvider.GetAllCUSTOMERsForSearchByName(customerFName);
        return(cUSTOMERs);
    }
コード例 #4
0
    public static List <CUSTOMER> GetAllCUSTOMERsByCUSTIDNUMBER_CUSTDOB(string cUSTIDNUMBER, DateTime cUSTDOB)
    {
        List <CUSTOMER>     cUSTOMERs           = new List <CUSTOMER>();
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        cUSTOMERs = sqlCUSTOMERProvider.GetAllCUSTOMERsForSearch(cUSTIDNUMBER, cUSTDOB);
        return(cUSTOMERs);
    }
コード例 #5
0
    public static List <CUSTOMER> GetAllCUSTOMERsForSearch(int customerID, string phoneNumber, string drivingLicense, string ssn, string customerFName, string customerMName, string customerLName)
    {
        List <CUSTOMER>     cUSTOMERs           = new List <CUSTOMER>();
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        cUSTOMERs = sqlCUSTOMERProvider.GetAllCUSTOMERsForSearch(customerID, phoneNumber, drivingLicense, ssn, customerFName, customerMName, customerLName);
        return(cUSTOMERs);
    }
コード例 #6
0
    public static List <CUSTOMER> GetAllCUSTOMERs()
    {
        List <CUSTOMER>     cUSTOMERs           = new List <CUSTOMER>();
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        cUSTOMERs = sqlCUSTOMERProvider.GetAllCUSTOMERs();
        return(cUSTOMERs);
    }
コード例 #7
0
    public static bool UpdateSUS_CUSTOMER(string ids, string date)
    {
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        return(sqlCUSTOMERProvider.UpdateSUS_CUSTOMER(ids, date));
    }
コード例 #8
0
    public static bool DeleteCUSTOMER(int cUSTOMERID)
    {
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        return(sqlCUSTOMERProvider.DeleteCUSTOMER(cUSTOMERID));
    }
コード例 #9
0
    public static bool UpdateCUSTOMER(CUSTOMER cUSTOMER)
    {
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        return(sqlCUSTOMERProvider.UpdateCUSTOMER(cUSTOMER));
    }
コード例 #10
0
    public static int InsertCUSTOMER(CUSTOMER cUSTOMER)
    {
        SqlCUSTOMERProvider sqlCUSTOMERProvider = new SqlCUSTOMERProvider();

        return(sqlCUSTOMERProvider.InsertCUSTOMER(cUSTOMER));
    }