public void addNewShopVoucher(ShopVoucher shop) //Insert the hotel details into db
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "INSERT INTO ShopVoucher (voucherQty, voucherType, voucherStatus, membershipCategory, foodCategory, nameFilter, voucherCost, shopImage, shopDesc, voucherName, voucherPopularity)" +
"VALUES (@paravoucherqty, @paravouchertype, @paravoucherstatus, @membershipcategory, @foodcategory, @namefilter, @paravouchercost, @shopimage, @shopdesc, @vouchername, @voucherpopularity)";
SqlCommand sqlCmd = new SqlCommand(sqlStmt, myConn);
sqlCmd.Parameters.AddWithValue("@paravoucherqty", shop.voucherQty);
sqlCmd.Parameters.AddWithValue("@paravouchertype", shop.voucherType);
sqlCmd.Parameters.AddWithValue("@paravoucherstatus", shop.voucherStatus);
sqlCmd.Parameters.AddWithValue("@membershipcategory", shop.membershipCategory);
sqlCmd.Parameters.AddWithValue("@foodcategory", shop.foodCategory);
sqlCmd.Parameters.AddWithValue("@namefilter", shop.nameFilter);
sqlCmd.Parameters.AddWithValue("@paravouchercost", shop.voucherCost);
sqlCmd.Parameters.AddWithValue("@shopimage", shop.shopImage);
sqlCmd.Parameters.AddWithValue("@shopdesc", shop.shopDesc);
sqlCmd.Parameters.AddWithValue("@vouchername", shop.voucherName);
sqlCmd.Parameters.AddWithValue("@voucherpopularity", shop.voucherPopularity);
myConn.Open();
sqlCmd.ExecuteNonQuery();
myConn.Close();
}
protected bool validatePurchase()
{
Session["user_id"] = Session["tourist_id"];
string user_id = Session["user_id"].ToString();
// Retrieve Reward records by account
Reward td = new Reward();
td = td.GetRewardById(user_id);
int creditBalance = td.creditBalance;
// Retrieve ShopVoucher records by account
ShopVoucher ts = new ShopVoucher();
bool result;
if (creditBalance > voucherCost)
{
result = true;
}
else
{
result = false;
}
return(result);
}
private void shopRepeater()
{
ShopVoucher shop = new ShopVoucher();
shopList = shop.GetAllShop();
repeatShop.DataSource = shopList;
repeatShop.DataBind();
}
public List <ShopVoucher> newFilter()
{
//Step 1 - Define a connection to the database by getting
// the connection string from web.config
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
//Step 2 - Create a DataAdapter to retrieve data from the database table
string sqlStmt = "Select * from ShopVoucher " + " WHERE voucherStatus = 'Available' " +
"ORDER BY voucher_id DESC ";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
//Step 3 - Create a DataSet to store the data to be retrieved
DataSet ds = new DataSet();
//Step 4 - Use the DataAdapter to fill the DataSet with data retrieved
da.Fill(ds);
//Step 5 - Read data from DataSet to List
List <ShopVoucher> empList = new List <ShopVoucher>();
int rec_cnt = ds.Tables[0].Rows.Count;
for (int i = 0; i < rec_cnt; i++)
{
DataRow row = ds.Tables[0].Rows[i]; // Sql command returns only one record
int voucher_id = Convert.ToInt32(row["voucher_id"]);
int voucherQty = Convert.ToInt32(row["voucherQty"]);
string voucherType = row["voucherType"].ToString();
string voucherStatus = row["voucherStatus"].ToString();
bool membershipCategory = Convert.ToBoolean(row["membershipCategory"]);
bool foodCategory = Convert.ToBoolean(row["foodCategory"]);
string nameFilter = row["nameFilter"].ToString();
int voucherCost = Convert.ToInt32(row["voucherCost"]);
string shopImage = row["shopImage"].ToString();
string shopDesc = row["shopDesc"].ToString();
string voucherName = row["voucherName"].ToString();
int voucherPopularity = Convert.ToInt32(row["voucherPopularity"]);
ShopVoucher obj = new ShopVoucher(voucher_id, voucherQty, voucherType, voucherStatus, membershipCategory, foodCategory, nameFilter, voucherCost, shopImage, shopDesc, voucherName, voucherPopularity);
empList.Add(obj);
}
return(empList);
}
private void filterRepeater()
{
if (filterSearch.SelectedItem.Value == "Search By Category")
{
ShopVoucher shop = new ShopVoucher();
shopList = shop.GetAllShop();
Repeat1.DataSource = shopList;
Repeat1.DataBind();
}
else if (filterSearch.SelectedItem.Value == "Popular")
{
ShopVoucher filter = new ShopVoucher();
shopList = filter.getPopularFilter();
Repeat1.DataSource = shopList;
Repeat1.DataBind();
}
else if (filterSearch.SelectedItem.Value == "Newest")
{
ShopVoucher filter = new ShopVoucher();
shopList = filter.getNewFilter();
Repeat1.DataSource = shopList;
Repeat1.DataBind();
}
else if (filterSearch.SelectedItem.Value == "Low Price")
{
ShopVoucher filter = new ShopVoucher();
shopList = filter.getLowFilter();
Repeat1.DataSource = shopList;
Repeat1.DataBind();
}
else if (filterSearch.SelectedItem.Value == "High Price")
{
ShopVoucher filter = new ShopVoucher();
shopList = filter.getHighFilter();
Repeat1.DataSource = shopList;
Repeat1.DataBind();
}
}
public ShopVoucher SelectByShop(string shopId)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlstmt = "Select * from ShopVoucher where voucher_id = @paraId";
SqlDataAdapter da = new SqlDataAdapter(sqlstmt, myConn);
da.SelectCommand.Parameters.AddWithValue("@paraId", shopId);
DataSet ds = new DataSet();
da.Fill(ds);
int rec_cnt = ds.Tables[0].Rows.Count;
ShopVoucher td = null;
if (rec_cnt > 0)
{
DataRow row = ds.Tables[0].Rows[0];
int voucher_id = Convert.ToInt32(row["voucher_id"]);
int voucherQty = Convert.ToInt32(row["voucherQty"]);
string voucherType = row["voucherType"].ToString();
string voucherStatus = row["voucherStatus"].ToString();
bool membershipCategory = Convert.ToBoolean(row["membershipCategory"]);
bool foodCategory = Convert.ToBoolean(row["foodCategory"]);
string nameFilter = row["nameFilter"].ToString();
int voucherCost = Convert.ToInt32(row["voucherCost"]);
string shopImage = row["shopImage"].ToString();
string shopDesc = row["shopDesc"].ToString();
string voucherName = row["voucherName"].ToString();
int voucherPopularity = Convert.ToInt32(row["voucherPopularity"]);
td = new ShopVoucher(voucher_id, voucherQty, voucherType, voucherStatus, membershipCategory, foodCategory, nameFilter, voucherCost, shopImage, shopDesc, voucherName, voucherPopularity);
}
return(td);
}
protected void Repeat1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
RepeaterItem item1 = e.Item;
int voucher_id;
int quantity;
int voucherStock;
string voucherStatus;
string voucherName;
int genId;
//DropDownList filterSearch = (DropDownList)item1.FindControl("filterSearch");
//if (filterSearch.SelectedItem.Value == "Popular")
//{
// ShopVoucher filter = new ShopVoucher();
// shopList = filter.getPopularFilter();
// Repeat1.DataSource = shopList;
// Repeat1.DataBind();
//}
//else if (filterSearch.SelectedItem.Value == "Newest")
//{
// ShopVoucher filter = new ShopVoucher();
// shopList = filter.getNewFilter();
// Repeat1.DataSource = shopList;
// Repeat1.DataBind();
//}
//else if (filterSearch.SelectedItem.Value == "Low Price")
//{
// ShopVoucher filter = new ShopVoucher();
// shopList = filter.getLowFilter();
// Repeat1.DataSource = shopList;
// Repeat1.DataBind();
//}
//else if (filterSearch.SelectedItem.Value == "High Price")
//{
// ShopVoucher filter = new ShopVoucher();
// shopList = filter.getHighFilter();
// Repeat1.DataSource = shopList;
// Repeat1.DataBind();
//}
Session["user_id"] = Session["tourist_id"].ToString();
string user_id = Session["user_id"].ToString();
int user_idInt = Convert.ToInt32(user_id);
// Retrieve ShopVoucher records by account
Reward td = new Reward();
td = td.GetRewardById(user_id);
int creditBalance = Convert.ToInt32(td.creditBalance);
HiddenField getId = (HiddenField)item1.FindControl("voucher_id");
Session["voucher_id"] = getId.Value;
voucher_id = Convert.ToInt32(getId.Value);
HiddenField getMembershipCategory = (HiddenField)item1.FindControl("membershipCategory");
Session["getMembershipCategory"] = getMembershipCategory.Value;
string MembershipCategory = getMembershipCategory.Value;
HiddenField getFoodCategory = (HiddenField)item1.FindControl("foodCategory");
Session["getFoodCategory"] = getFoodCategory.Value;
string foodCategory = getFoodCategory.Value;
DropDownList getDropDown = (DropDownList)item1.FindControl("voucherQuantity");
Session["voucherQuantity"] = getDropDown.SelectedValue;
quantity = Convert.ToInt32(getDropDown.SelectedValue);
Label getVoucherCost = (Label)item1.FindControl("voucherCost");
Session["voucherCost"] = getVoucherCost.Text;
voucherCost = Convert.ToInt32(getVoucherCost.Text);
Label getVoucherName = (Label)item1.FindControl("voucherName");
Session["voucherName"] = getVoucherName.Text;
voucherName = getVoucherName.Text;
Label getVoucherStock = (Label)item1.FindControl("voucherQty");
Session["voucherName"] = getVoucherStock.Text;
voucherStock = Convert.ToInt32(getVoucherStock.Text);
HiddenField getVoucherPopularity = (HiddenField)item1.FindControl("voucherPopularity");
Session["voucherPopularity"] = getVoucherPopularity.Value;
int voucherPopularity = Convert.ToInt32(getVoucherPopularity.Value);
Label getVoucherStatus = (Label)item1.FindControl("voucherStatus");
Session["voucherStatus"] = getVoucherStatus.Text;
voucherStatus = getVoucherStatus.Text;
if (td.creditBalance < (voucherCost * quantity) || voucherStatus != "Available" || voucherStock < quantity)
{
string labelF = "Purchase Failed";
Session["labelFail"] = labelF;
Response.Redirect("Shop.aspx");
}
else
{
Label1.Visible = false;
int totalcost = voucherCost * quantity;
int credit = creditBalance - totalcost;
Reward emp = new Reward(user_idInt, credit);
int result = emp.UpdateAccount(emp);
//Insert transaction into Transation Table
genId = new Random().Next(100000, 999999);
string stats = "Available";
DateTime date = DateTime.Now;
TimeSpan duration = new TimeSpan(30, 0, 0, 0);
DateTime expiry = date.Add(duration);
int confirmcode = new Random().Next(100000, 999999);
int userId = Convert.ToInt32(user_id);
string name = voucherName;
string voucherCategory;
ShopVoucher ts = new ShopVoucher();
if (MembershipCategory == "True")
{
voucherCategory = "Membership";
int totalDiscount = 5;
string membershipTier = "Silver";
Transactions trans = new Transactions(genId, stats, expiry, confirmcode, userId, date, totalcost, quantity, name, voucherCategory);
trans.insertTrans();
td.membershipSubscription(userId, totalDiscount, membershipTier);
}
else if (foodCategory == "True")
{
voucherCategory = "Food";
Transactions trans = new Transactions(genId, stats, expiry, confirmcode, userId, date, totalcost, quantity, name, voucherCategory);
trans.insertTrans();
}
else
{
voucherCategory = "Others";
Transactions trans = new Transactions(genId, stats, expiry, confirmcode, userId, date, totalcost, quantity, name, voucherCategory);
trans.insertTrans();
}
int newVoucherQty = voucherStock - quantity;
int newVoucherPopularity = voucherPopularity + 1;
ShopVoucher updateShopVoucher = new ShopVoucher();
if (newVoucherQty <= 0)
{
voucherStatus = "Not Available";
updateShopVoucher.updateVoucherStatus(voucher_id, newVoucherQty, voucherStatus, newVoucherPopularity);
}
else if (newVoucherQty > 0)
{
voucherStatus = "Available";
updateShopVoucher.updateVoucherStatus(voucher_id, newVoucherQty, voucherStatus, newVoucherPopularity);
}
string labelS = "Purchase successful";
Session["labelSuccess"] = labelS;
Response.Redirect("Shop.aspx");
return;
}
Response.Redirect("Shop.aspx");
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
int voucherQty;
string voucherType;
string voucherStatus;
bool membershipCategory;
bool foodCategory;
string nameFilter;
int voucherPrice = 0;
string attImage = LbImage.Text;
string shopDesc;
string voucherName;
int voucherPopularity = 0;
if (TbVoucherStock.Text != "" && TbVoucherType.Text != "" && CBVoucherCategory.SelectedIndex != -1 && TbPrice.Text != "0" && TbName.Text != "")
{
voucherQty = Convert.ToInt32(TbVoucherStock.Text);
voucherType = TbVoucherType.Text;
voucherStatus = "Available";
shopDesc = TbVoucherDesc.Text;
voucherName = TbName.Text;
nameFilter = "";
voucherPrice = Convert.ToInt32(TbPrice.Text);
if (CBVoucherCategory.Items[0].Selected && CBVoucherCategory.Items[1].Selected)
{
membershipCategory = true;
foodCategory = true;
ShopVoucher shop = new ShopVoucher(voucherQty, voucherType, voucherStatus, membershipCategory, foodCategory, nameFilter, voucherPrice, attImage, shopDesc, voucherName, voucherPopularity);
shop.addShopVoucher(shop);
Response.Redirect("AdminPageRewardSystem.aspx");
}
else if (CBVoucherCategory.Items[0].Selected)
{
foodCategory = false;
membershipCategory = true;
ShopVoucher shop = new ShopVoucher(voucherQty, voucherType, voucherStatus, membershipCategory, foodCategory, nameFilter, voucherPrice, attImage, shopDesc, voucherName, voucherPopularity);
shop.addShopVoucher(shop);
Response.Redirect("AdminPageRewardSystem.aspx");
}
else if (CBVoucherCategory.Items[1].Selected)
{
foodCategory = true;
membershipCategory = false;
ShopVoucher shop = new ShopVoucher(voucherQty, voucherType, voucherStatus, membershipCategory, foodCategory, nameFilter, voucherPrice, attImage, shopDesc, voucherName, voucherPopularity);
shop.addShopVoucher(shop);
Response.Redirect("AdminPageRewardSystem.aspx");
}
}
else
{
if (TbName.Text != "")
{
LblMsgName.Visible = false;
LblMsgName.Text = "";
}
if (TbPrice.Text != "0")
{
LblMsgPrice.Visible = false;
LblMsgPrice.Text = "";
}
if (TbVoucherStock.Text != "")
{
LblMsgQty.Visible = false;
LblMsgQty.Text = "";
}
if (TbVoucherType.Text != "")
{
LblMsgVoucherType.Visible = false;
LblMsgVoucherType.Text = "";
}
if (CBVoucherCategory.SelectedIndex != -1)
{
LblMsgVoucherCategory.Visible = false;
LblMsgVoucherType.Text = "";
}
if (TbName.Text == "")
{
LblMsgName.Visible = true;
LblMsgName.ForeColor = Color.Red;
LblMsgName.Text = "Voucher Name cannot be empty" + Environment.NewLine;
}
if (TbPrice.Text == "0")
{
LblMsgPrice.Visible = true;
LblMsgPrice.ForeColor = Color.Red;
LblMsgPrice.Text = "Voucher Price cannot be 0" + Environment.NewLine;
}
if (TbVoucherStock.Text == "")
{
LblMsgQty.Visible = true;
LblMsgQty.ForeColor = Color.Red;
LblMsgQty.Text = "Voucher quantity cannot be empty" + Environment.NewLine;
}
if (TbVoucherType.Text == "")
{
LblMsgVoucherType.Visible = true;
LblMsgVoucherType.ForeColor = Color.Red;
LblMsgVoucherType.Text = "Voucher type cannot be empty" + Environment.NewLine;
}
if (CBVoucherCategory.SelectedIndex == -1)
{
LblMsgVoucherCategory.Visible = true;
LblMsgVoucherCategory.ForeColor = Color.Red;
LblMsgVoucherCategory.Text = "Please select at least one of the voucher category" + Environment.NewLine;
}
}
}
