public static int DeleteCustomerCoordinates(string custNum) { CustomerCoordinatesModel data = new CustomerCoordinatesModel { CustNum = custNum }; string sql = @"DELETE FROM dbo.Customers_Coordinates WHERE CustNum = @CustNum;"; return(SQLDataAccess.DeleteDataDatawarehouse(sql, data)); }
public static int InsertCustomerCoordinates(string custNum, string latitude, string longitude) { CustomerCoordinatesModel data = new CustomerCoordinatesModel { CustNum = custNum.ToUpper(), Latitude = latitude, Longitude = longitude }; string sql = @"INSERT INTO dbo.Customers_Coordinates (CustNum, Latitude, Longitude) VALUES (@CustNum, @Latitude, @Longitude);"; return(SQLDataAccess.InsertDataDatawarehouse(sql, data)); }
public static int UpdateCustomerCoordinates(string custNum, string latitude, string longitude) { CustomerCoordinatesModel data = new CustomerCoordinatesModel { CustNum = custNum, Latitude = latitude, Longitude = longitude }; string sql = @"UPDATE dbo.Customers_Coordinates SET Latitude = @Latitude, Longitude = @Longitude WHERE CustNum = @CustNum;"; return(SQLDataAccess.UpdateDataDatawarehouse(sql, data)); }