public bool AddLoyalityPoint(TemporaryLoyalityPoint lPoint, double lp)
{
bool isAdd = false;
SqlConnection sqlConnection = new SqlConnection(connectionString);
string commandString = @"INSERT INTO TemporaryLoyalityPoint VALUES(" + lPoint.CustomerId + "," + lp + ")";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
sqlConnection.Open();
int isExecute = sqlCommand.ExecuteNonQuery();
if (isExecute > 0)
{
isAdd = true;
}
sqlConnection.Close();
return(isAdd);
}
public List <TemporaryLoyalityPoint> SelectTempLoyality(int customerId)
{
List <TemporaryLoyalityPoint> temporaryLoyalityPoints = new List <TemporaryLoyalityPoint>();
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
string query = "SELECT LoyalityPoint FROM TemporaryLoyalityPoint WHERE CustomerId = " + customerId + "";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
TemporaryLoyalityPoint temporaryLoyalityPoint = new TemporaryLoyalityPoint();
temporaryLoyalityPoint.LoyalityPoint = Convert.ToDouble(sqlDataReader["LoyalityPoint"].ToString());
temporaryLoyalityPoints.Add(temporaryLoyalityPoint);
}
sqlConnection.Close();
return(temporaryLoyalityPoints);
}
public bool AddLoyalityPoint(TemporaryLoyalityPoint lPoint, double lp)
{
return(_saleModuleRepository.AddLoyalityPoint(lPoint, lp));
}
