public void BookCustom([FromBody] CustomPackageBooking packageBooking)
{
var userStore = new UserStore <ApplicationUser>(new ApplicationDbContext());
var userManager = new UserManager <ApplicationUser>(userStore);
CustomPackage customPackage = new CustomPackage();
customPackage.Id = userManager.FindByName(packageBooking.Booking.UserName).Id;
int packageID = packageManager.AddCustomPackage(customPackage, packageBooking.UserCustomizations);
PackageBooking booking = new PackageBooking();
booking.PackageID = packageID;
booking.Id = customPackage.Id;
booking.NumPeople = packageBooking.Booking.NumPeople;
booking.StartDate = packageBooking.Booking.StartDate.Date;
booking.EndDate = packageBooking.Booking.EndDate.Date;
booking.PaymentMethod = packageBooking.Booking.PaymentMethod;
booking.IsCustomized = packageBooking.Booking.IsCustomized;
booking.TotalCost = packageBooking.Booking.TotalCost;
booking.BookingStatus = packageBooking.Booking.BookingStatus;
bookingManager.BookPackage(booking);
// Increment number of trips taken by the user
var user = userManager.FindById(booking.Id);
user.NumberOfTrips++;
userManager.Update(user);
userStore.Context.SaveChanges();
// Decrement number available for package
packageManager.DecrementNumAvailable(packageBooking.Booking.PackageID, booking.NumPeople);
}
public JsonResult InsertPackage(Package Package)
{
//if (AppUtils.lstAccessList.Contains(AppUtils.MikrotikOptionEnable))
//{
// Mikrotik mikrotik = db.Mikrotik.Find(Package.MikrotikID);
// var ipPoolName = db.IPPool.Find(Package.IPPoolID).PoolName;
// try
// {//ITikConnection connection = ConnectionFactory.CreateConnection(TikConnectionType.Api);
// ITikConnection connection = ConnectionFactory.OpenConnection(TikConnectionType.Api, mikrotik.RealIP, 8728, mikrotik.MikUserName, mikrotik.MikPassword);
// connection.CreateCommandAndParameters("/ppp/profile/add", "name", Package.PackageName.Trim(), "local-address", Package.LocalAddress, "remote-address", ipPoolName, "incoming-filter", "mypppclients").ExecuteNonQuery();
// //add profile
// //var profileadd = connection.CreateCommandAndParameters("ppp/profile/add", "name", "test1", "local-address", "10.0.0.1", "remote-address", "sp", "incoming-filter", "mypppclients");
// //profileadd.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// return Json(new { Success = false, MikrotikFailed = true, Message = ex.Message }, JsonRequestBehavior.AllowGet);
// }
//}
int packageCount = db.Package.Count();
try
{
Package.CreatedBy = AppUtils.GetLoginEmployeeName();
Package.CreatedDate = AppUtils.GetDateTimeNow();
db.Package.Add(Package);
db.SaveChanges();
// var PoolName = db.IPPool.Where(s => s.IPPoolID == Package.IPPoolID).FirstOrDefault().PoolName;
//var packageInsertInformation = AppUtils.IgnoreCircularLoop(PackageInfo);
CustomPackage PackageInfo = new CustomPackage
{
PackageID = Package.PackageID,
PackageName = Package.PackageName,
BandWith = Package.BandWith,
PackagePrice = Package.PackagePrice.ToString(),
Client = db.ClientDetails.Where(ss => ss.PackageID == Package.PackageID).Count(),
//IPPoolName = (Package.IPPoolID != null) ? Package.IpPool.PoolName : "",
//LocalAddress = Package.LocalAddress,
//MikrotikName = db.Mikrotik.Find(Package.MikrotikID).MikName,
PackageUpdate = ISP_ManagementSystemModel.AppUtils.HasAccessInTheList(ISP_ManagementSystemModel.AppUtils.Update_Package) ? true : false,
};
return(Json(new { SuccessInsert = true, PackageInformation = PackageInfo, packageCount = packageCount }, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(new { SuccessInsert = false }, JsonRequestBehavior.AllowGet));
}
//return Json(new { SuccessInsert = false }, JsonRequestBehavior.AllowGet);
}
public InstallationPackage CreatePackage(string productLogic, string name)
{
InstallationPackage pkg = CustomPackage.CreateCustomPackage(productLogic, name);
pkg.HandleProgress = HandleProgressUpdate;
packageDictionary.Add(name, pkg);
return(pkg);
}
public int AddCustomPackage(CustomPackage package, List <UserCustomization> userCustomizations)
{
db.CustomPackages.Add(package);
db.SaveChanges();
foreach (UserCustomization itinerary in userCustomizations)
{
itinerary.CustomPackageID = package.CustomPackageID;
db.UserCustomizations.Add(itinerary);
db.SaveChanges();
}
var customID = package.CustomPackageID;
return(customID);
}
//[ValidateAntiForgeryToken]
public ActionResult UpdatePackage(Package PackageInfoForUpdate)
{
//if (AppUtils.lstAccessList.Contains(AppUtils.MikrotikOptionEnable))
//{
// Mikrotik mikrotik = db.Mikrotik.Find(PackageInfoForUpdate.MikrotikID);
// var ipPoolName = db.IPPool.Find(PackageInfoForUpdate.IPPoolID).PoolName;
// var oldPackageInfoForUpdate = db.Package.Find(PackageInfoForUpdate.PackageID);
// PackageInfoForUpdate.OldPackageName = oldPackageInfoForUpdate.PackageName;
// try
// {//ITikConnection connection = ConnectionFactory.CreateConnection(TikConnectionType.Api);
// ITikConnection connection = ConnectionFactory.OpenConnection(TikConnectionType.Api, mikrotik.RealIP, 8728, mikrotik.MikUserName, mikrotik.MikPassword);
// connection.CreateCommandAndParameters("/ppp/profile/set", ".id", oldPackageInfoForUpdate.PackageName, "name", PackageInfoForUpdate.PackageName.Trim(), "local-address", PackageInfoForUpdate.LocalAddress, "remote-address", ipPoolName, "incoming-filter", "mypppclients").ExecuteNonQuery();
// //add profile
// //var profileadd = connection.CreateCommandAndParameters("ppp/profile/add", "name", "test1", "local-address", "10.0.0.1", "remote-address", "sp", "incoming-filter", "mypppclients");
// //profileadd.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// return Json(new { Success = false, MikrotikFailed = true, Message = ex.Message }, JsonRequestBehavior.AllowGet);
// }
//}
Package package_Check = db.Package.Where(s => s.PackageID != PackageInfoForUpdate.PackageID && s.PackageName.ToLower() == PackageInfoForUpdate.PackageName.Trim().ToLower() && s.PackageForMyOrResellerUser == PackageInfoForUpdate.PackageForMyOrResellerUser).FirstOrDefault();
if (package_Check != null)
{
return(Json(new { UpdateSuccess = false, AlreadyInsert = true }, JsonRequestBehavior.AllowGet));
}
try
{
var Package = db.Package.Where(s => s.PackageID == PackageInfoForUpdate.PackageID);
PackageInfoForUpdate.CreatedBy = Package.FirstOrDefault().CreatedBy;
PackageInfoForUpdate.CreatedDate = Package.FirstOrDefault().CreatedDate;
PackageInfoForUpdate.UpdateBy = AppUtils.GetLoginEmployeeName();
PackageInfoForUpdate.UpdateDate = AppUtils.GetDateTimeNow();
PackageInfoForUpdate.PackageForMyOrResellerUser = Package.FirstOrDefault().PackageForMyOrResellerUser;
db.Entry(Package.SingleOrDefault()).CurrentValues.SetValues(PackageInfoForUpdate);
db.SaveChanges();
var package =
new CustomPackage()
{
PackageID = PackageInfoForUpdate.PackageID,
PackageName = PackageInfoForUpdate.PackageName,
BandWith = PackageInfoForUpdate.BandWith,
PackagePrice = PackageInfoForUpdate.PackagePrice.ToString(),
Client = db.ClientDetails.Where(ss => ss.PackageID == PackageInfoForUpdate.PackageID).Count(),
//IPPoolName = (PackageInfoForUpdate.IPPoolID != null) ? db.IPPool.Find(PackageInfoForUpdate.IPPoolID).PoolName : "",
//LocalAddress = PackageInfoForUpdate.LocalAddress,
//MikrotikName = db.Mikrotik.Find(PackageInfoForUpdate.MikrotikID).MikName,
PackageUpdate = ISP_ManagementSystemModel.AppUtils.HasAccessInTheList(ISP_ManagementSystemModel.AppUtils.Update_Package) ? true : false,
};
var JSON = Json(new { UpdateSuccess = true, PackageUpdateInformation = package }, JsonRequestBehavior.AllowGet);
JSON.MaxJsonLength = int.MaxValue;
return(JSON);
}
catch (Exception ex)
{
return(Json(new { UpdateSuccess = false, PackageUpdateInformation = "" }, JsonRequestBehavior.AllowGet));
}
}
