public ActionResult ProcessConfirmTransferMoney() { int MemberID = Convert.ToInt32(Session["CurrentUserID"]); string OwnWallet = db.getStringByQuery("select * from Wallet where MemberID=" + MemberID, "WalletNumber"); string WalletToTransfer = Request.Form["WalletToTransfer"]; int AmountToTransfer = Convert.ToInt32(Request.Form["AmountToTransfer"]); t.TransferMoney(OwnWallet, WalletToTransfer, AmountToTransfer); //Insert to Transfer History int ReceiverID = db.getIntByQuery("select * from Wallet where WalletNumber=N'" + WalletToTransfer + "'", "MemberID"); string SenderName = db.getStringByQuery("select * from Member where ID=" + MemberID, "Name"); string ReceiverName = db.getStringByQuery("select * from Member where ID=" + ReceiverID, "Name"); db.ChangeByQuery("insert into TransferHistory values(" + ReceiverID + "," + MemberID + "," + AmountToTransfer + ",'" + DateTime.Now + "')"); int TransactionID = db.getIntByQuery("select * from TransferHistory where SenderID=" + MemberID + " order by ID asc", "ID"); //Send Email //Get Email of sender and receiver string MailBodyForSender = "Dear " + SenderName + ",<br><br>You have successfully sent " + AmountToTransfer + " Kyats to " + WalletToTransfer + "(" + ReceiverName + "). Transaction ID is " + TransactionID + ". Remember Transaction ID for further reference.<br><br>Kind Regards,<br>Myanmar IT Star Company Limited"; string MailModyForReceiver = "Dear " + ReceiverName + ",<br><br>You Received " + AmountToTransfer + " Kyats From " + OwnWallet + "(" + SenderName + ").<br><br>Kind Regards,<br>Myanmar IT Star Company Limited"; t.SendEmail("Transfer Money-Myanmar IT Star Company Limited", MailBodyForSender, db.getStringByQuery("select * from Member where ID=" + MemberID, "Email")); t.SendEmail("Transfer Money-Myanmar IT Star Company Limited", MailModyForReceiver, db.getStringByQuery("select * from Member where ID=" + ReceiverID, "Email")); Session["TransferMoneySession"] = "successful"; return(RedirectToAction("TransferMoney")); }
public ActionResult DeletePost() { int ID = Convert.ToInt32(Request.QueryString["ID"]); string Cover = db.getStringByQuery("select * from Post where ID=" + ID, "ImageName"); DeleteCover(Cover); db.ChangeByQuery("delete from Post where ID=" + ID); return(RedirectToAction("AllPost")); }
public ActionResult AddEventData(HttpPostedFileBase file, HttpPostedFileBase fileMap) { EOrgID = Convert.ToInt32(Session["CurrentUserID"]); string ImageName = ""; String ImageNameMap = ""; if (file.ContentLength > 0) { var fileName = System.IO.Path.GetFileName(file.FileName); ImageName = fileName; var path = System.IO.Path.Combine(Server.MapPath("~/Image/Cover"), fileName); file.SaveAs(path); } if (fileMap.ContentLength > 0) { var fileNameMap = System.IO.Path.GetFileName(fileMap.FileName); ImageNameMap = fileNameMap; var path = System.IO.Path.Combine(Server.MapPath("~/Image/Seat_Map"), fileNameMap); fileMap.SaveAs(path); } string Name = Request.Form["Name"]; string Category = Request.Form["Category"]; string Date = Request.Form["Date"]; string Time = Request.Form["Time"]; string Place = Request.Form["Place"]; string Email = Request.Form["Email"]; string Phone = Request.Form["Phone"]; string IsFree = Request.Form["isFree"]; string IsPublic = Request.Form["isPublic"]; string TownID = Request.Form["Town"]; string Town = d.getStringByQuery("select * from Town where ID=" + TownID, "Name"); int Row = Convert.ToInt16(Request["Row"]); int TotalTicket = 0;//Convert.ToInt32(Request.Form["TotalTicket"]); string Description = Request.Form["Description"]; //Get EOrgID. Set to 1 in unit testing int ECategoryID = Convert.ToInt32(Category); DateTime EDate = Convert.ToDateTime(Date); d.ChangeByQuery("insert into Event(EOrgID,ECategoryID,Name,ImageName,Place,EDate,Email,Phone,TotalTicket,IsFree,Description,Row,SeatMap,Time,Town,IsPublic) values(" + EOrgID + "," + ECategoryID + ",N'" + Name + "','" + ImageName + "','" + Place + "','" + EDate + "','" + Email + "','" + Phone + "','" + TotalTicket + "','" + IsFree + "','" + Description + "'," + Row + ",'" + ImageNameMap + "','" + Time + "','" + Town + "','" + IsPublic + "')"); int EID = d.getIntByQuery("select top 1 * From Event where EOrgID=" + EOrgID + " order by ID desc", "ID"); Row r = new Row(); r.set(EID, Row); //Seat s = new Seat(); //s.setTotalTicket(TotalTicket, 1); //s.setFirstTimeSeat(); return(RedirectToAction("Manage")); }
public ActionResult AcceptRequestByBank() { if (Session["CurrentUserID"] == null) { Response.Redirect("~/Account/LoginForm"); } int ID = Convert.ToInt32(Request.QueryString["ID"]); int MemberID = Convert.ToInt32(Request.QueryString["MemberID"]); string Email = db.getStringByQuery("select * from Member where ID=" + MemberID, "Email"); db.ChangeByQuery("update RequestActiveDepositHistory set Proof='True' where ID=" + ID); db.ChangeByQuery("delete from InactiveCount where MemberID=" + ID); db.ChangeByQuery("update Member set Active='True' where ID=" + MemberID); //Send Mail string MailBody = "Dear " + db.getStringByQuery("select * from Member where ID=" + MemberID, "Name") + ",<br><br> We approved your active request deposited by bank.Your Account is now worked account. Your Account should turn to green. If it is not green, contact us.<br><br>Kind Regards,<br>Myanmar IT Star Company Limited"; t.SendEmail("Request Active By Bank-DM Group", MailBody, Email); return(RedirectToAction("SeeRequestActiveByBank")); }
public ActionResult BookSeat() { int TotalCost = 0; String TransferBill = ""; string SeatList = ""; string passedInfo = "success"; int EID = Convert.ToInt32(Request.Form["EventID"]); //Get EOrgID first via EID to retrieve its username int EOrgID = d.getIntByQuery("select * from Event where ID=" + EID, "EOrgID"); string Username = d.getStringByQuery("select * from Login where AllID=" + EOrgID + " and AccessLevel=2", "UserName"); string EOrgPhone = d.getStringByQuery("select * from Event where ID=" + EID, "Phone"); string SelectedSeat = Request.Form["SelectedSeat"]; string Name = Request.Form["Name"]; string Phone = Request.Form["Phone"]; string Operator = Request.Form["Operator"]; string[] separater = { "," }; string[] selectedSeat = SelectedSeat.Split(separater, StringSplitOptions.RemoveEmptyEntries); int i = 0; if (selectedSeat.Length > 0) { foreach (var word in selectedSeat) { //In case of two parallel action, check Seat Status (Owner is Sold and User is Book) if (d.getStringByQuery("select * from Seat where EID=" + EID + " and Name='" + selectedSeat[i] + "'", "Status").Equals("Sold")) { i = i + 1; passedInfo = "justSold"; continue; } d.ChangeByQuery("update Seat set Status='Book' where EID=" + EID + " and Name='" + selectedSeat[i] + "'"); int SeatID = d.getIntByQuery("select * from Seat where EID=" + EID + " and Name='" + selectedSeat[i] + "'", "ID"); d.ChangeByQuery("insert into CustomerTicket(Name, Phone, SeatID, InsertedDate) values(N'" + Name + "',N'" + Phone + "'," + SeatID + ",'" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "')"); TotalCost = TotalCost + d.getIntByQuery("select * from Seat where ID=" + SeatID, "Price"); SeatList = SeatList + selectedSeat[i] + "/"; i = i + 1; passedInfo = "success"; } } else { passedInfo = "noSeat"; } //Get Phone //Get Operator //amount - Total Price /* * MPT - *223*amount*number# * Ooredoo - *155*amount*number# * MEC - *110*amount*number# */ //Check Operator for tranferring phone bill if (passedInfo.Equals("success")) { if (Operator.Equals("mpt")) { TransferBill = "*223*" + TotalCost + "*" + EOrgPhone + "%23"; } else if (Operator.Equals("ooredoo")) { TransferBill = "*155*" + TotalCost + "*" + EOrgPhone + "%23"; } else if (Operator.Equals("mec")) { TransferBill = "*110*" + TotalCost + "*" + EOrgPhone + "%23"; } Session["passedInfo"] = passedInfo; string url = Session["userurl"].ToString(); ViewBag.Username = Username; ViewBag.TransferBill = TransferBill; ViewBag.FromPhone = Phone; ViewBag.ToPhone = EOrgPhone; ViewBag.TotalCost = TotalCost; ViewBag.SeatList = SeatList; return(View()); } else { Session["passedInfo"] = passedInfo; string url = Session["userurl"].ToString(); Response.Redirect(url); return(View()); } }