public Entity.Offer GetDiscount(string id)
{
string query = string.Format("SELECT Offer.OfferID, Offer.DiscountPercentage FROM Offer WHERE Offer.MemberTypeID = '{0}'", id);
SqlDataReader reader = DataAccess.GetData(query);
reader.Read();
Entity.Offer offer = null;
if (reader.HasRows)
{
offer = new Entity.Offer(reader["OfferID"].ToString());
offer.DiscountPercentage = Convert.ToDouble(reader["DiscountPercentage"]);
}
else
{
MessageBox.Show("No Offer Found!");
}
return(offer);
}
public List <Entity.Offer> GetAll()
{
string query = "SELECT OfferID, OfferName, Description, DiscountPercentage, OfferGiven, OfferValid, ItemCode, CategoryID, MemberTypeID FROM Offer";
SqlDataReader reader = DataAccess.GetData(query);
Entity.Offer offer = null;
List <Entity.Offer> offerList = new List <Entity.Offer>();
while (reader.Read())
{
offer = new Entity.Offer(reader["OfferID"].ToString());
offer.OfferName = reader["OfferName"].ToString();
offer.Description = reader["Description"].ToString();
offer.DiscountPercentage = Convert.ToDouble(reader["DiscountPercentage"]);
offer.OfferGiven = Convert.ToDateTime(reader["OfferGiven"]);;
offer.OfferValid = Convert.ToDateTime(reader["OfferValid"]);
offer.ItemCode = reader["ItemCode"].ToString();
offer.CategoryID = reader["CategoryID"].ToString();
offer.MemberTypeID = reader["MemberTypeID"].ToString();;
offerList.Add(offer);
}
return(offerList);
}
public int Edit(Entity.Offer offerService)
{
return(OfferService.offerDataAccess.Edit(offerService));
}
public int Add(Entity.Offer offerService)
{
return(OfferService.offerDataAccess.Add(offerService));
}
public int Edit(Entity.Offer offer)
{
string query = string.Format("UPDATE Offer SET OfferName='" + offer.OfferName + "', Description='" + offer.Description + "', DiscountPercentage='" + offer.DiscountPercentage + "', OfferGiven='" + offer.OfferGiven + "', OfferValid='" + offer.OfferValid + "', ItemCode='" + offer.ItemCode + "', CategoryID='" + offer.CategoryID + "', MemberTypeID='" + offer.MemberTypeID + "' WHERE OfferID='{0}'", offer.OfferID);
return(DataAccess.ExecuteQuery(query));
}
public int Add(Entity.Offer offer)
{
string query = string.Format("INSERT INTO Offer(OfferID, OfferName, Description, DiscountPercentage, OfferGiven, OfferValid, ItemCode, CategoryID, MemberTypeID) VALUES('{0}', '{1}', '{2}', {3}, '{4}', '{5}', '{6}', '{7}', '{8}')", offer.OfferID, offer.OfferName, offer.Description, offer.DiscountPercentage, offer.OfferGiven, offer.OfferValid, offer.ItemCode, offer.CategoryID, offer.MemberTypeID);
return(DataAccess.ExecuteQuery(query));
}
