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