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());
}
}