public static List<BillDTO> GetBillByAccountID(string ID)
{
List<BillDTO> kq = new List<BillDTO>();
string query = "select * from db3c04c35a9c6b45918ba3a551005e16ee.bill where AccountID like '" + ID + "'";
DataTable dt = DataProvider.ExecuteQuery(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
BillDTO bill = new BillDTO();
bill.AccountID = (string)dt.Rows[i]["AccountID"];
bill.Price = (int)dt.Rows[i]["Price"];
bill.Date = (string)dt.Rows[i]["Date"];
bill.Validated = (string)dt.Rows[i]["Validated"];
kq.Add(bill);
}
return kq;
}
public static void SaveBill(BillDTO dto)
{
string query = "insert into db3c04c35a9c6b45918ba3a551005e16ee.bill "
+ "value ('" + dto.AccountID + "','" + dto.Price + "','" + dto.Date + "','" + dto.Validated + "')";
if (DataProvider.ExecuteNonQuery(query))
{
}
else
{
}
}
public ActionResult TradeSuccess()
{
string id = "";
if (Request.Cookies.AllKeys.Contains("userID"))
{
id = Request.Cookies["userID"].Value;
}
if (Request["userID"] != null)
{
id = Request["userID"];
}
string price = Request["Price"];
BillDTO dto = new BillDTO();
dto.AccountID = id;
dto.Price = int.Parse(price);
dto.Date = DateTime.Now.ToString();
dto.Validated = "not";
TradeDAO.SaveBill(dto);
ViewBag.userID = id;
var userCookie = new HttpCookie("userID", id);
userCookie.Expires.AddHours(1);
HttpContext.Response.Cookies.Add(userCookie);
return View();
}