public ActionResult Index(ValidateLogin login, FormCollection form)
{
ViewData["Result"] = "";
if (ModelState.IsValid)
{
RepositoryOBTRS mOBTRS = new RepositoryOBTRS();
List <tbl_Administrator> LogName = mOBTRS.Login(form.Get("email").Trim(), form.Get("password").Trim());
if (LogName == null)
{
//Khong the ket noi Database
ViewData["Result"] = "Can't connect to database server, please try again later!";
return(View(login));
}
else if (LogName.Count == 1)
{
if (LogName[0].Admin_Active != false)
{
if (form.Get("Remember").ToString().ToLower() != "false")
{
//Luu vao Cookie
//HttpCookie cookie = HttpContext.Response.Cookies.Get("cmsOBTRS");
HttpCookie cookie = new HttpCookie("cmsOBTRS");
cookie.Values["Username"] = LogName[0].Admin_Name;
cookie.Values["ID"] = LogName[0].Admin_ID.ToString();
cookie.Expires = DateTime.Now.AddDays(+14);
HttpContext.Response.Cookies.Set(cookie);
}
//Luu vào Session
Session["LogedName"] = LogName[0].Admin_Name;
Session["Admin_ID"] = LogName[0].Admin_ID;
//Lay Alias Role cua Admin dang nhap he thong
Session["Role"] = mOBTRS.CheckRole(LogName[0].Admin_RoleID);
string a = Session["Role"].ToString();
//Dang nhap thanh cong
if (!Response.IsRequestBeingRedirected)
{
Response.Redirect("/CMS/WelcomeAptech");
}
}
else
{
//Bi cam truy cap
ViewData["Result"] = "Access Denied!";
return(View(login));
}
}
else
{
//Login sai mat khau va ten dang nhap
ViewData["Result"] = "Username or password invalid.Login failure!";
return(View(login));
}
}
//Login unsuccessful
return(View(login));
}
public ActionResult AboutUs(FormCollection form)
{
if (Session["Role"].ToString() == "N")
{
Response.Write("Access denied!");
return(null);
}
else
{
RepositoryOBTRS db = new RepositoryOBTRS();
ViewData["Data"] = db.GetAboutUs();
if (form.Get("RichTextEditor") != null)
{
if (Session["Role"].ToString() == "R")
{
ViewData["Result"] = "Your role is readonly";
}
else
{
ViewData["Result"] = db.UpdateAboutUs(form.Get("RichTextEditor"));
ViewData["Data"] = db.GetAboutUs();
}
return(View());
}
else
{
ViewData["Result"] = "";
}
return(View());
}
}
/// <summary>
/// Chi tiet dich vu
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult DetailService(Guid id)
{
try
{
if (id != null)
{
RepositoryOBTRS db = new RepositoryOBTRS();
List <tbl_Service> service = db.GetServiceByID(id);
ViewData["Title"] = service[0].Services_Title;
ViewData["Content"] = service[0].Services_Content;
}
else
{
ViewData["Title"] = "";
ViewData["Content"] = "";
}
}
catch (Exception)
{
Response.Write("<strong style='font-size:12pt'>Have a error in during request to server!</strong>");
Response.Write("<br>Sorry for this inconvenience! Please<a href='/Home'> click here</a> to HOME PAGE.");
//throw;
return(null);
}
return(View());
}
public ActionResult AddService(FormCollection form)
{
RepositoryOBTRS db = new RepositoryOBTRS();
Boolean active = false;
if (form.Get("Active") != "false")
{
active = true;
}
db.AddService(form.Get("Title"), form.Get("RichTextEditor"), active);
return(Redirect("/CMS/ServicesManagement/"));
}
public ActionResult EditService(Guid id, FormCollection form)
{
RepositoryOBTRS db = new RepositoryOBTRS();
Boolean active = false;
if (form.Get("Active") != "false")
{
active = true;
}
db.UpdateService(id.ToString(), form.Get("Title"), form.Get("RichTextEditor"), active);
return(Redirect("/CMS/EditService/" + id));
}
//Ham lay danh sach Role
private List <SelectListItem> GetRoleForView()
{
List <SelectListItem> items = new List <SelectListItem>();
RepositoryOBTRS db = new RepositoryOBTRS();
List <tbl_Role> role = db.GetRole();
for (int i = 0; i < role.Count; i++)
{
items.Add(new SelectListItem {
Text = role[i].Role_Name, Value = role[i].Role_ID.ToString()
});
}
return(items);
}
//Danh sach cac tinh thanh la diem den
private List <SelectListItem> GetCityDestination(int StartID)
{
List <SelectListItem> items = new List <SelectListItem>();
RepositoryOBTRS db = new RepositoryOBTRS();
List <int> city = db.GetCityEnd(StartID);
for (int i = 0; i < city.Count; i++)
{
items.Add(new SelectListItem {
Text = db.GetCityName(city[i]), Value = city[i].ToString()
});
}
return(items);
}
/// <summary>
/// Privacy Policy
/// </summary>
/// <returns></returns>
public ActionResult PrivacyPolicy()
{
try
{
RepositoryOBTRS db = new RepositoryOBTRS();
ViewData["Data"] = db.GetPrivacyPolicy();
}
catch (Exception)
{
Response.Write("<strong style='font-size:12pt'>Have a error in during request to server!</strong>");
Response.Write("<br>Sorry for this inconvenience! Please<a href='/Home'> click here</a> to HOME PAGE.");
//throw;
return(null);
}
return(View());
}
public ActionResult BusDiagram_45(FormCollection form)
{
try
{
if (Session["Role"].ToString() == "N")
{
Response.Write("Access denied!");
return(null);
}
else
{
RepositoryOBTRS db = new RepositoryOBTRS();
//----------------- 45 Seats ------------------
//Lay du lieu diagram tu Database
ViewData["Data"] = db.GetBusDiagram(3);
//Cap nhat du lieu vao Database
if (form.Get("RichTextEditor") != null)
{
if (Session["Role"].ToString() == "R")
{
ViewData["Result"] = "Your role is readonly";
}
else
{
ViewData["Result"] = db.UpdateBusDiagram(form.Get("RichTextEditor"), 3);
//Lay du lieu diagram tu Database
ViewData["Data"] = db.GetBusDiagram(3);
}
return(View());
}
else
{
ViewData["Result"] = "";
}
//----------------------------------------------
return(View());
}
}
catch (Exception)
{
//Chuyen ve trang dang nhap
return(Redirect("/CMS/WelcomeAptech?logout=true"));
}
}
//[HttpGet]
public ActionResult EditAdmin(String adminID, ValidateAdmin vAdmin, FormCollection form)
{
try
{
ViewData["Role"] = GetRoleForView();
if (ModelState.IsValid)
{
RepositoryOBTRS db = new RepositoryOBTRS();
Boolean active = true;
if (form.Get("Active") == "false")
{
active = false;
}
String result = db.UpdateAdmin(
adminID,
form.Get("Role"),
form.Get("AdminName"),
DateTime.Parse(form.Get("DateOfBirth")),
form.Get("Password"),
form.Get("Address"),
form.Get("Phone"),
form.Get("Email"),
form.Get("Description"),
active
);
if (result == "")
{
//Neu cap nhat admin thanh cong
return(Redirect("/CMS/ManagerList"));
}
else
{
//Neu gap truc trac ko the cap nhat Admin
ViewData["Error"] = result;
return(View(vAdmin));
}
}
}
catch (Exception)
{
return(Redirect("/CMS/"));
}
//Neu gia tri nhap vao ko dung
return(View(vAdmin));
}
public ActionResult EditService(Guid id)
{
if (Session["Role"].ToString() == "N" || Session["Role"].ToString() == "R")
{
Response.Write("Access denied!");
return(null);
}
else
{
RepositoryOBTRS repData = new RepositoryOBTRS();
ViewData["NewsID"] = id;
List <tbl_Service> service = repData.GetServiceByID(id);
ViewData["Title"] = service[0].Services_Title;
ViewData["Data"] = service[0].Services_Content;
ViewData["Active"] = service[0].Services_Active;
return(View());
}
}
public ActionResult Payment(FormCollection form)
{
//Khai bao
//thong tin tuyen xe
List <String> RouteDetail = (List <String>)Session["RouteDetail"];
//Thong in ghe dang dat
ArrayList arrSeatNo = (ArrayList)Session["BookingSeats"];
//Mang luu tru cac ket qua booking
ArrayList ResultList = new ArrayList();
RepositoryOBTRS db = new RepositoryOBTRS();
try
{
if (form != null)
{
//Luu tat ca cac ve cua khach hang vao Database
for (int i = 0; i < (form.Count / 2); i++)
{
db_OBTRSDataContext discount = new db_OBTRSDataContext();
var dis = discount.sp_CalculateDiscount(decimal.Parse(RouteDetail[5].ToString()), int.Parse(form["Age" + i]));
Decimal CostDiscount = new Decimal();
foreach (sp_CalculateDiscountResult item in dis)
{
CostDiscount = (Decimal)item.Result;
}
String result = db.InsertBookingTicket(int.Parse(RouteDetail[6]), int.Parse(RouteDetail[7]), int.Parse(RouteDetail[8]), int.Parse(RouteDetail[9]), Session["UserID"].ToString(), form["NameCustomer" + i].ToString(), int.Parse(form["Age" + i]), CostDiscount, int.Parse(arrSeatNo[i].ToString()), DateTime.Parse(Session["DateDeparture"].ToString()));
ResultList.Add(result);
}
}
}
catch (Exception)
{
Response.Write("<strong style='font-size:12pt'>Have a error in during request to server!</strong>");
Response.Write("<br>Sorry for this inconvenience! Please<a href='/Home'> click here</a> to HOME PAGE.");
return(null);
}
return(View(ResultList));
}
private List <SelectListItem> GetCityDeparture(int CityDepartureID)
{
List <SelectListItem> items = new List <SelectListItem>();
RepositoryOBTRS db = new RepositoryOBTRS();
List <int> city = db.GetCityStart();
for (int i = 0; i < city.Count; i++)
{
if (Convert.ToInt32(city[i]) == CityDepartureID)
{
items.Add(new SelectListItem {
Text = db.GetCityName(city[i]), Value = city[i].ToString(), Selected = true
});
}
else
{
items.Add(new SelectListItem {
Text = db.GetCityName(city[i]), Value = city[i].ToString()
});
}
}
return(items);
}
//Hien thi chi tiet viec dat ve
public ActionResult BookingDetail()
{
//Kiem tra neu nguoi dung chua dang nhap thi hien thi thong bao yeu cau dang nhap
if (Session["UserID"] == null)
{
Response.Write("You can only find book ticket detail if you login!<br />");
Response.Write("Please <a href='/Home/SearchDetail'>back</a> home page to login or <a href='/Home/Register/'>register</a> is member of us");
return(null);
}
//Ket thuc kiem tra
try
{
int beginID = Convert.ToInt32(Request.Params["BeginID"]);
int endID = Convert.ToInt32(Request.Params["EndID"]);
int bustypeID = Convert.ToInt32(Request.Params["BusTypeID"]);
int startTime = Convert.ToInt32(Request.Params["StartTime"]);
RepositoryOBTRS db = new RepositoryOBTRS();
List <String> list = db.GetRouteDetail(beginID, endID, bustypeID, startTime);
ViewData["RouteDetail"] = list;
//Setup Session RouteDetail - danh sach chi tiet tuyen xe ma khach hang chon
Session["RouteDetail"] = list;
if (list[1].ToString() == "12")
{
ViewData["BusDiagram"] = db.GetBusDiagram(1);
}
else if (list[1].ToString() == "24")
{
ViewData["BusDiagram"] = db.GetBusDiagram(2);
}
else
{
ViewData["BusDiagram"] = db.GetBusDiagram(3);
}
//Lay tong so ghe da dc dat
db_OBTRSDataContext tbl = new db_OBTRSDataContext();
DateTime date = DateTime.Parse(Request.Params["Date"]);
var sumSeat = tbl.sp_GetSelectedSeat(beginID, endID, bustypeID, startTime, date);
//Luu tru danh sach ghe ngoi
ArrayList BookedSeatList = new ArrayList();
foreach (sp_GetSelectedSeatResult name in sumSeat)
{
BookedSeatList.Add(name.Seat);
}
//Lay danh sach cac ghe da dat cho
//Session["BookedSeatList"] = BookedSeatList;
//Tam thoi ko su dung--------
ViewData["BookedSeat"] = BookedSeatList;
}
catch (Exception e)
{
Response.Write("<strong style='font-size:12pt'>Have a error in during request to server!</strong>");
Response.Write("<br>Sorry for this inconvenience! Please<a href='/Home'> click here</a> to HOME PAGE.");
//throw;
return(null);
}
return(View());
}
public ActionResult SearchDetail(FormCollection form)
{
try
{
//Kiem tra va lay ID cua dia diem khoi hanh
if (form["CityDeparture"] != null)
{
//Lay thong tin dia diem di va den truyen cho Title
RepositoryOBTRS dbrep = new RepositoryOBTRS();
int cityDepart = Convert.ToInt16(form["CityDeparture"]);
ViewData["Title_Departure"] = dbrep.GetCityName(cityDepart);
int cityDesti = Convert.ToInt16(form["CityDestination"]);
ViewData["Title_Destination"] = dbrep.GetCityName(cityDesti);
//Ket thuc lay thong tin
int id = Convert.ToInt16(form["CityDeparture"]);
ViewData["CityStart"] = GetCityDeparture(id);
if (form["CityDestination"] != null)
{
int DestinationID = Convert.ToInt16(form["CityDestination"]);
ViewData["CityEnd"] = GetCityDestination(id, DestinationID);
}
else
{
ViewData["CityEnd"] = GetCityDestination(id);
//ViewData["CityDestination"] = "?";
}
}
else
{
ViewData["CityStart"] = GetCityDeparture();
ViewData["CityEnd"] = GetCityDestination(1);
}
if (form["CityDeparture"] != null && form["CityDestination"] != null)
{
db_OBTRSDataContext db = new db_OBTRSDataContext();
int Departure = Convert.ToInt32(form["CityDeparture"]);
int Destination = Convert.ToInt32(form["CityDestination"]);
string Depart = "%%";
if (form["txtDepartureDate"] != null && form["txtDepartureDate"] != "")
{
DateTime dt = DateTime.Parse(form["txtDepartureDate"].ToString());
Depart = "%" + dt.DayOfWeek.ToString().Substring(0, 2).ToUpper() + "%";
}
var tblRoute = db.sp_GetRouteMatch(Departure, Destination, Depart);
ViewData["DataRoute"] = tblRoute;
}
else
{
ViewData["DataRoute"] = null;
}
if (form["txtDepartureDate"] == null)
{
String currentDate = DateTime.Now.ToShortDateString();
ViewData["DateDepart"] = currentDate;
//Setup session date ngay ma khach hang chon khoi hanh
Session["DateDeparture"] = currentDate;
}
else
{
ViewData["DateDepart"] = form["txtDepartureDate"];
Session["DateDeparture"] = form["txtDepartureDate"];
}
}catch (Exception)
{
Response.Write("<strong style='font-size:12pt'>Have a error in during request to server!</strong>");
Response.Write("<br>Sorry for this inconvenience! Please<a href='/Home'> click here</a> to HOME PAGE.");
//throw;
return(null);
}
return(View());
}
