public ActionResult Create(CarModel carModel, HttpPostedFileBase file)
{
string imageUrl = "";
if (file != null)
{
string imageName = System.IO.Path.GetFileName(file.FileName);
string physicalPath = Server.MapPath("~/images/" + imageName);
file.SaveAs(physicalPath);
imageUrl = imageName;
}
try
{
Mobil car = new Mobil()
{
MerkId = carModel.MerkId,
Tahun = carModel.Tahun,
Transmisi = carModel.Transmisi,
BBM = carModel.BBM,
NoPolisi = carModel.NoPolisi,
MasaBerlaku = carModel.MasaBerlaku,
Harga = carModel.Harga,
};
context.Mobils.InsertOnSubmit(car);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(carModel));
}
}
public ActionResult Pinjam(int id)
{
//int j = int.Parse(Session["User"].ToString());
DBukuModel mode = context.DBukus.Where(model => model.Id == id).Select(model => new DBukuModel()
{
Judul = model.Judul,
Penerbit = model.Penerbit,
LTerbit = model.LTerbit,
Pengarang = model.Pengarang,
Jumlah = model.Jumlah,
IdBuku = (int)model.IdBuku,
Images = model.Images,
Id = model.Id,
}).SingleOrDefault();
int ka = (int)Session["KTP"];
DateTime now = DateTime.Now;
Pinjam p = new Pinjam()
{
WPinjam = DateTime.Today,
IdUser = (int)Session["KTP"],
PBuku = mode.Judul,
IdBuku = mode.Id
};
context.Pinjams.InsertOnSubmit(p);
context.SubmitChanges();
return(RedirectToAction("DaftarBuku"));
}
public ActionResult Create(SongModel model)
{
try
{
// TODO: Add insert logic here
Song song = new Song()
{
Title = model.Title,
Writer = model.Writer,
Singer = model.Singer,
Year = model.Year,
GenreId = model.GenreID
};
context.Songs.InsertOnSubmit(song);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(PassengerModel model)
{
try
{
// TODO: Add insert logic here
PopulateBanks(model);
Passenger passenger = new Passenger()
{
UserID = User.Identity.GetUserId(),
FirstName = model.FirstName,
LastName = model.LastName,
PhoneNumber = model.PhoneNumber,
BankName = model.BankName,
BankAccountNumber = model.BankAccountNumber
};
context.Passengers.InsertOnSubmit(passenger);
context.SubmitChanges();
return(RedirectToAction("Index", "Home", new { area = "" }));
}
catch
{
return(View());
}
}
public ActionResult Create(MenuModel model, HttpPostedFileBase file)
{
string gambar = "";
if (file != null)
{
string ImageName = System.IO.Path.GetFileName(file.FileName);
string physicalPath = Server.MapPath("~/images/" + ImageName);
file.SaveAs(physicalPath);
gambar = ImageName;
}
try
{
// TODO: Add insert logic here
tMenu menu = new tMenu()
{
IdMenu = model.IdMenu,
Nama = model.Nama,
Harga = (int)model.Harga,
Stok = (int)model.Stok,
Images = gambar
};
context.tMenus.InsertOnSubmit(menu);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(BooksModel Z)
{
try
{
Book book = new Book()
{
Title = Z.Title,
Author = Z.Author,
Genre = Z.Genre,
Rating = Z.Rating,
Sinopsis = Z.Sinopis,
Price = Z.Price,
Stock = Z.Stock,
Shelves = Z.Shelves
};
context.Books.InsertOnSubmit(book);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(Z));
}
}
public ActionResult Purchase(PurchaseTicketViewModel ticket)
{
try
{
// TODO: Add insert logic here
var currentUserId = User.Identity.GetUserId();
var bus = context.BusVehicles
.Where(b => b.Id == ticket.Id)
.SingleOrDefault();
if (bus == null)
{
return(new HttpStatusCodeResult(404));
}
var viewModel = new AvailableBusViewModel()
{
Id = bus.Id,
Capacity = bus.Capacity,
Class = bus.Class,
Route = bus.Route,
Fare = bus.Fare,
DepartureTime = bus.DepartureTime,
};
if (bus.DepartureTime < DateTime.Now)
{
ViewBag.Error = "This bus has already departed.";
return(View(viewModel));
}
else if (bus.DepartureTime > DateTime.Now.AddDays(AppConstants.MAX_DAYS_BEFORE_RESERVATION))
{
ViewBag.Error = "You can only purchase tickets as late as two weeks before departure.";
return(View(viewModel));
}
Reservation reservation = new Reservation()
{
TotalSeat = ticket.PassengersCount,
PurchasedOn = DateTime.Now,
PassengerID = context.Passengers
.Where(u => u.UserID == currentUserId)
.Select(p => p.Id)
.SingleOrDefault(),
BusID = bus.Id,
TotalAmount = ticket.PassengersCount * bus.Fare,
IsConfirmed = false
};
context.Reservations.InsertOnSubmit(reservation);
context.SubmitChanges();
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public ActionResult Create(PesawatModel model)
{
Pesawat pesawat = new Pesawat()
{
MaskapaiId = model.MaskapaiId,
Jadwal = model.Jadwal,
TipeId = model.TipeId,
PilotId = model.PilotId
};
context.Pesawats.InsertOnSubmit(pesawat);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(UserModel model)
{
try
{
Users user = new Users()
{
name = model.Name,
surname = model.Surname,
dateOfBirth = model.DateOfBirth,
login = model.Login
};
context.Users.InsertOnSubmit(user);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(BusVehicleModel model)
{
try
{
// TODO: Add insert logic here
// Get all states again
var times = AppConstants.HOURS;
var classes = AppConstants.BusClasses;
// Set these states on the model. We need to do this because
// only the selected value from the DropDownList is posted back, not the whole
// list of states.
//model.DepartureTimes = GetSelectListItems(times.Keys);
//ViewBag.Hours = times;
model.Classes = GetSelectListItems(classes);
BusVehicle busVehicle = new BusVehicle()
{
Name = model.Name,
Class = model.Class,
Capacity = model.Capacity,
Fare = model.Fare,
DepartureTime = DateTime.Parse(model.DepartureTime),
RouteID = model.RouteID
};
context.BusVehicles.InsertOnSubmit(busVehicle);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
model = new BusVehicleModel();
PrepareBusVehicle(model);
// Create a list of SelectListItems so these can be rendered on the page
//model.DepartureTimes = GetSelectListItems(AppConstants.HOURS);
//ViewBag.Hours = AppConstants.HOURS;
model.Classes = GetSelectListItems(AppConstants.BusClasses);
return(View(model));
}
}
public ActionResult Create(PlaceModel model)
{
try
{
// TODO: Add insert logic here
Place place = new Place()
{
Name = model.Name
};
context.Places.InsertOnSubmit(place);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(RuteModel model)
{
try
{
Rute rute = new Rute()
{
MaskapaiId = model.MaskapaiId,
Keberangkatan = model.Keberangkatan,
Kedatangan = model.Kedatangan,
NomorPenerbangan = model.NomorPenerbangan
};
context.Rutes.InsertOnSubmit(rute);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(OrderModel model)
{
try
{
// TODO: Add insert logic here
tOrder order = new tOrder()
{
MejaId = model.MejaId,
MenuId = model.MenuId,
JumlahMenu = model.JumlahMenu
};
context.tOrders.InsertOnSubmit(order);
context.SubmitChanges();
return(RedirectToAction("Create"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(PemesananModel model)
{
try
{
Pemesanan pemesanan = new Pemesanan()
{
NamaPemesan = model.NamaPemesan,
TanggalPemesanan = model.TanggalPemesanan,
MaskapaiId = model.MaskapaiId,
RuteId = model.RuteId
};
context.Pemesanans.InsertOnSubmit(pemesanan);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Delete(int id, ShoppingCart Y)
{
ViewBag.Mes = "";
try
{
Cart cart = context.Carts.Where(xx => xx.ID_Cart == id).Single <Cart>();
Book update = context.Books.Single(e => e.ID_Book == cart.Book_ID);
context.Carts.DeleteOnSubmit(cart);
update.Stock += 1;
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.Mes = "Error!";
return(View(Y));
}
}
public ActionResult Add(QorderModel model, string idMenu, string idMeja)
{
tOrder order = new tOrder()
{
MejaId = idMeja,
MenuId = idMenu,
JumlahMenu = model.Jumlah
};
context.tOrders.InsertOnSubmit(order);
context.SubmitChanges();
return(RedirectToAction("PesanMenu"));
}
public ActionResult Create(BusVehicleModel model)
{
try
{
// TODO: Add insert logic here
// Get all states again
var times = GetAllTimesPerHour();
// Set these states on the model. We need to do this because
// only the selected value from the DropDownList is posted back, not the whole
// list of states.
model.DepartureTimes = GetSelectListItems(times);
BusVehicle busVehicle = new BusVehicle()
{
Name = model.Name,
AC = model.AC,
Fare = model.Fare,
DepartureTime = model.DepartureTime,
RouteID = model.RouteID
};
context.BusVehicles.InsertOnSubmit(busVehicle);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
model = new BusVehicleModel();
PrepareBusVehicle(model);
// Create a list of SelectListItems so these can be rendered on the page
model.DepartureTimes = GetSelectListItems(GetAllTimesPerHour());
return(View(model));
}
}
public ActionResult Create(UserRoleModel model)
{
try
{
// TODO: Add insert logic here
UserRole userRole = new UserRole()
{
Username = model.Username,
Password = model.Password,
RoleID = model.RoleID
};
context.UserRoles.InsertOnSubmit(userRole);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(RouteModel model)
{
try
{
// TODO: Add insert logic here
Route route = new Route()
{
Origin = model.OriginName,
Destination = model.DestinationName
};
context.Routes.InsertOnSubmit(route);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
model = new RouteModel();
PrepareRoute(model);
return(View(model));
}
}
public ActionResult Create(OrderModel model)
{
try
{
Order order = new Order()
{
Quantity = model.Quantity,
};
context.Orders.InsertOnSubmit(order);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Registration(UserModel user)
{
bool Status = false;
string message = "";
//
//Model Validation
if (ModelState.IsValid)
{
#region IF Username is already exist
var isExist = IsUsernameExist(user.username);
if (isExist)
{
ModelState.AddModelError("UsernameExist", "Username Already Exist");
return(View(user));
}
#endregion
#region Password Hashing
user.Password = Crypto.Hash(user.Password);
user.ConfirmPassword = Crypto.Hash(user.ConfirmPassword);
#endregion
#region Save to Database
Admin registration = new Admin()
{
Name = user.username,
Email = user.EmailID,
Password = user.Password
};
context.Admins.InsertOnSubmit(registration);
context.SubmitChanges();
#endregion
return(RedirectToAction("Login", "User"));
}
else
{
message = "Invalid Request";
return(View());
}
}
public ActionResult Create(GenreModel model)
{
try
{
Genre genre = new Genre()
{
Name = model.Name
};
context.Genres.InsertOnSubmit(genre);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(HandlerModel model)
{
try
{
PostalTerminalHandler handler = new PostalTerminalHandler()
{
PostalTerminals_Id = model.PostalTerminals_Id,
Handlers_User_id = model.Handlers_User_id
};
context.PostalTerminalHandlers.InsertOnSubmit(handler);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(TipeModel model)
{
try
{
Tipe tipe = new Tipe()
{
TipePesawat = model.TipePesawat
};
context.Tipes.InsertOnSubmit(tipe);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(PilotModel model)
{
try
{
Pilot pilot = new Pilot()
{
NamaPilot = model.NamaPilot
};
context.Pilots.InsertOnSubmit(pilot);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(MaskapaiModel model)
{
try
{
Maskapai maskapai = new Maskapai()
{
NamaMaskapai = model.NamaMaskapai
};
context.Maskapais.InsertOnSubmit(maskapai);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(model));
}
}
public ActionResult Create(DBukuModel model, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
return(RedirectToAction("Index"));
}
string imageUrl = "";
if (file != null)
{
string ImageName = System.IO.Path.GetFileName(file.FileName);
string physicalPath = Server.MapPath("~/images/" + ImageName);
file.SaveAs(physicalPath);
imageUrl = ImageName;
}
try
{
DBuku buku = new DBuku()
{
Judul = model.Judul,
Penerbit = model.Penerbit,
LTerbit = model.LTerbit,
Pengarang = model.Pengarang,
Jumlah = model.Jumlah,
IdBuku = model.IdBuku,
Images = imageUrl,
Id = model.Id
};
context.DBukus.InsertOnSubmit(buku);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Registration(Registration model)
{
try
{
Student std = new Student()
{
Name = model.Name,
Email = model.Email,
Phone = model.Phone,
Address = model.Address,
Password = model.Password
};
context.Students.InsertOnSubmit(std);
context.SubmitChanges();
return(RedirectToAction("index", "Home"));
}
catch
{
return(View(model));
}
}
public ActionResult Register(LoginUserModel loginuser)
{
try
{
LoginUser login = new LoginUser()
{
Nama = loginuser.Nama,
Pswd = loginuser.Password,
Alamat = loginuser.Alamat,
Email = loginuser.Email,
IdKTP = loginuser.IdKTP,
Pekerjaan = loginuser.Pekerjaan
};
context.LoginUsers.InsertOnSubmit(login);
context.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(loginuser));
}
}
private void BusVehicleSeed()
{
OperationDataContext context = new OperationDataContext();
var bandung = new PlaceModel {
Name = "Bandung"
};
var yogyakarta = new PlaceModel {
Name = "Yogyakarta"
};
var curup = new PlaceModel {
Name = "Curup"
};
var surabaya = new PlaceModel {
Name = "Surabaya"
};
var denpasar = new PlaceModel {
Name = "Denpasar"
};
var places = new List <PlaceModel>()
{
bandung, yogyakarta, curup, surabaya, denpasar
};
List <RouteModel> busRoutes = new List <RouteModel>();
// Generate list of busRoute
foreach (var origin in places)
{
foreach (var destination in places)
{
if (origin != destination)
{
busRoutes.Add(new RouteModel {
OriginName = origin.Name, DestinationName = destination.Name
});
}
}
}
if (context.Places.Count() == 0)
{
// Insert all places above to database
foreach (var item in places)
{
Place place = new Place()
{
Name = item.Name
};
context.Places.InsertOnSubmit(place);
context.SubmitChanges();
}
// Insert all busRoute to database
foreach (var item in busRoutes)
{
Route route = new Route()
{
Origin = item.OriginName,
Destination = item.DestinationName
};
context.Routes.InsertOnSubmit(route);
context.SubmitChanges();
}
}
if (context.BusVehicles.Count() == 0)
{
var dates = DateTimeGenerator.GetDaysInRange(DateTime.Today, DateTime.Today.AddDays(60));
var busses = new List <BusVehicleModel>();
var busNames = new List <string>()
{
"Primajasa", "MGI", "Budiman", "Putra Raflesia", "Lorena", "Haryanto"
};
var busClasses = AppConstants.BusClasses;
foreach (DateTime date in dates)
{
//var tes = date;
for (double i = 0; i < 24; i += 2)
{
foreach (var route in busRoutes)
{
int randName = rand.Next(busNames.Count);
int randClass = rand.Next(busClasses.Count);
busses.Add(BusGenerator.GenerateBus(route,
date.AddHours(rand.Next(0, 24)).AddMinutes(rand.Next(0, 60)),
busNames[randName],
busClasses[randClass]));
}
}
}
// Insert all busvehicle to database
// Belum bisa, masih ada errornya
foreach (var item in busses)
{
BusVehicle busVehicle = new BusVehicle()
{
Name = item.Name,
Class = item.Class,
DepartureTime = DateTime.Parse(item.DepartureTime),
RouteID = item.RouteID
};
//context.BusVehicles.InsertOnSubmit(busVehicle);
//context.SubmitChanges();
}
}
}
