public async Task <ActionResult> Create([Bind(Include = "Id,PicturePath,Name,Description,Cost,LifeStatus,Sex")] Character character)
{
if (!User.IsInRole("Admin"))
{
return(RedirectToAction("Login", "Account"));
}
if (ModelState.IsValid)
{
if (Request.Files[0].FileName != "")
{
character.PicturePath = Request.Files[0].FileName;
Request.Files[0].SaveAs(Server.MapPath("~") + "/Content/Images/" + character.PicturePath);
}
else
{
character.PicturePath = Server.MapPath("~") + "/Content/Images/peppa.jpg";
}
db.Characters.Add(character);
await db.SaveChangesAsync();
return(RedirectToAction("List", "Character"));
}
return(RedirectToAction("List", "Character"));
}
public async Task <string> SaveHotelTypeAsync(utblMstHotelType model)
{
try
{
if (model.HotelTypeID == 0)
{
db.utblMstHotelTypes.Add(model);
await db.SaveChangesAsync();
return("New Hotel Type Added");
}
else
{
utblMstHotelType curObj = await db.utblMstHotelTypes.FindAsync(model.HotelTypeID);
curObj.HotelTypeName = model.HotelTypeName;
curObj.BaseFare = model.BaseFare;
await db.SaveChangesAsync();
return("Hotel Type Details Updated");
}
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public virtual async Task <List <TEntity> > BulkInsert(List <TEntity> entity)
{
dbSet.AddRange(entity);
await context.SaveChangesAsync();
return(entity);
}
public async Task AddFlight(FlightModel flightModel)
{
var flight = _mapper.Map <Flight>(flightModel);
await _context.Flights.AddAsync(flight);
await _context.SaveChangesAsync();
}
public async Task <IActionResult> Create(ToDo todo)
{
todo.DateDue = todo.GetDateDue(todo.DateDue, todo.DateFor);
todo.Done = false;
todo.DateCreate = DateTime.UtcNow;
db.ToDo.Add(todo);
todo.LoginUser = User.Identity.Name;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task DeleteForAnybody(Guid messageId, string userId)
{
var message = await _context.Messages.FindAsync(messageId);
if ((message != null) && (message.AuthorId == userId))
{
_context.Messages.Attach(message);
_context.Messages.Remove(message);
await _context.SaveChangesAsync();
}
}
//public async Task<string> EditPackageOfferAsync(EditPackageOffer model)
//{
// try
// {
// var parPOffID = new SqlParameter("@PackageOfferID", model.PackageOffer.PackageOfferID);
// var parPacID = new SqlParameter("@PackageID", model.PackageOffer.PackageID);
// var parOfferDesc = new SqlParameter("@OfferDesc", model.PackageOffer.OfferDesc);
// var parPOffer = new SqlParameter("@OfferPercent", model.PackageOffer.OfferPercent);
// var parOfferImgPath = new SqlParameter("@OfferImagePath", model.PackageOffer.OfferImagePath);
// var parStart = new SqlParameter("@StartDate", model.PackageOffer.StartDate);
// var parEnd = new SqlParameter("@EndDate", model.PackageOffer.EndDate);
// return await db.Database.SqlQuery<string>("udspPackageOfferEdit @PackageOfferID,@PackageID,@OfferDesc, @OfferPercent,@OfferImagePath, @StartDate, @EndDate",
// parPOffID, parPacID, parOfferDesc, parPOffer, parOfferImgPath, parStart, parEnd).FirstOrDefaultAsync();
// }
// catch (Exception ex)
// {
// return "Error: " + ex.Message;
// }
//}
public async Task <string> DeletePackageOfferAsync(long POID)
{
try
{
utblPackageOffer curObj = await db.utblPackageOffers.FindAsync(POID);
db.utblPackageOffers.Remove(curObj);
await db.SaveChangesAsync();
return("Package Details Removed");
}
catch (SqlException ex)
{
if (ex.Errors.Count > 0) // Assume the interesting stuff is in the first error
{
switch (ex.Errors[0].Number)
{
case 547: // Foreign Key violation
return("This record has dependencies on other records, so cannot be removed.");
default:
return("Error: " + ex.Message);
}
}
return("Error while operation. Error Message: " + ex.Message);
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public async Task AddMark(string userId, Guid flightId)
{
var user = await _context.Users.FindAsync(userId);
var flight = await _context.Flights.FindAsync(flightId);
if ((user == null) || (flight == null))
{
throw new Exception("User of flight not found");
}
var userMark = new UserMark {
FlightId = flight.Id, UserId = user.Id
};
await _context.UserMarks.AddAsync(userMark);
await _context.SaveChangesAsync();
}
public async Task AddMessage(Guid chatId, string text, string authorId, Guid?isAnswerFor)
{
var chat = await _context.Chats.FindAsync(chatId);
var author = await _userManager.FindByIdAsync(authorId);
if ((text != null) && (text != "") && (chat != null) && (author != null))
{
_context.Messages.Add(new Message
{
Author = author,
DeletedForOwner = false,
ChatId = chat.Id,
IsAnswerForId = isAnswerFor,
TimeStamp = DateTime.Now,
Text = text
});
await _context.SaveChangesAsync();
}
}
public async Task ModifyUser(UserModel u)
{
var user = await _context.ApplicationsUsers.FindAsync(u.Id);
user.UserName = u.UserName;
user.Year = u.Year;
user.PremiumMarksCount = u.PremiumMarksCount;
user.Email = u.Email;
await _context.SaveChangesAsync();
}
public async Task <EUser> EnsureFakeUser(EFDBContext context)
{
EUser user = await context.Users.FirstOrDefaultAsync(u => u.Token == FAKE_USER_TOKEN);
if (user == null)
{
user = MakeFakeUser();
context.Users.Add(user);
await context.SaveChangesAsync();
}
return(user);
}
public async Task SaveFired(Fired Fired)
{
if (Fired.FiredId == 0)
{
await _context.Fireds.AddAsync(Fired);
}
else
{
_context.Entry(Fired).State = EntityState.Modified;
}
await _context.SaveChangesAsync();
}
public async Task SaveRank(Rank rank)
{
if (rank.RankId == 0)
{
await _context.Ranks.AddAsync(rank);
}
else
{
_context.Entry(rank).State = EntityState.Modified;
}
await _context.SaveChangesAsync();
}
public async Task <IActionResult> Login()
{
//DEV
var user = await new FakeAuthService().EnsureFakeUser(this.eFDBContext);
//DEV
await eFDBContext.SaveChangesAsync();
await Authenticate(user.Token);
return(RedirectToAction("Index", "Home"));
}
public async Task SaveDepartment(Department department)
{
if (department.DepartmentId == 0)
{
_context.Departments.Add(department);
}
else
{
_context.Entry(department).State = EntityState.Modified;
}
await _context.SaveChangesAsync();
}
public async Task SaveDecree(Decree decree)
{
if (decree.DecreeId == 0)
{
_context.Decrees.Add(decree);
}
else
{
_context.Entry(decree).State = EntityState.Modified;
}
await _context.SaveChangesAsync();
}
public async Task SavePosition(Position position)
{
if (position.PositionId == 0)
{
_context.Positions.Add(position);
}
else
{
_context.Entry(position).State = EntityState.Modified;
}
await _context.SaveChangesAsync();
}
public async Task SaveStaff(Staff staff)
{
if (staff.StaffId == 0)
{
await _context.Staffs.AddAsync(staff);
}
else
{
_context.Entry(staff).State = EntityState.Modified;
}
await _context.SaveChangesAsync();
}
public async Task <TicketModel> ReserveTicket(string userId, Guid flightId, TicketClass ticketClass = TicketClass.econom, int premiumMarksUsedCount = 0)
{
var flight = _context.Flights.Find(flightId);
var user = _context.ApplicationsUsers.Find(userId);
int endPrice = flight.Price;
if (ticketClass == TicketClass.vip)
{
endPrice = (int)(endPrice * 1.5f);
}
if ((user.PremiumMarksCount < premiumMarksUsedCount) || (premiumMarksUsedCount > endPrice))
{
return(null);
}
endPrice -= premiumMarksUsedCount;
user.PremiumMarksCount -= premiumMarksUsedCount;
var ticket = new Ticket
{
FlightId = flightId,
UserId = userId,
PremiumMarksUsedCount = premiumMarksUsedCount,
TicketClass = ticketClass,
EndPrice = endPrice,
IsBought = false
};
await _context.Tickets.AddAsync(ticket);
flight.PlacesCount += 1;
await _context.SaveChangesAsync();
return(_mapper.Map <TicketModel>(ticket));
}
public async Task <string> DeleteGuideAsync(long id)
{
try
{
utblTourGuide obj = await db.utblTourGuides.FindAsync(id);
db.utblTourGuides.Remove(obj);
await db.SaveChangesAsync();
return("Tour Guide Details Removed");
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public IActionResult Delete(string parametre)
{
Guid id = new Guid(parametre);
var file = _context.Docs.FirstOrDefault(d => d.Id == id);
var childFiles = _context.Docs.Where(d => d.ParentId == file.Id);
if (file != null)
{
foreach (var child in childFiles)
{
_context.Docs.Remove(child);
}
_context.Docs.Remove(file);
}
_context.SaveChangesAsync();
JsonResult json = new JsonResult(parametre);
return(json);
}
public async Task <string> UpdateClientEnquiryStatusAsync(ClientEnquiryView model)
{
try
{
utblClientEnquirie cmodel = await objDB.utblClientEnquiries.Where(x => x.EnquiryCode == model.EnquiryCode).FirstOrDefaultAsync();
cmodel.Status = "Submitted";
await objDB.SaveChangesAsync();
return("Status Updated");
}
catch (SqlException ex)
{
return("Error Message: " + ex.Message);
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public async Task <IActionResult> CreateDepartment(Department department)
{
if (department != null)
{
if (ModelState.IsValid)
{
await _context.Department.AddAsync(department);
await _context.SaveChangesAsync();
return(RedirectToAction("Index", "Home"));
}
}
return(View());
}
public async Task <IActionResult> Register(LoginAndRegisterModel model)
{
if (ModelState.IsValid)
{
User user = await context.User.FirstOrDefaultAsync(u => u.Email == model.registerModel.Email);
if (user == null)
{
context.User.Add(new Entity.User {
Email = model.registerModel.Email, Name = model.registerModel.Name, Password = model.registerModel.Password
});
await context.SaveChangesAsync();
await Authenticate(model.registerModel.Email);
return(RedirectToAction("Index", "Home"));
}
}
else
{
ModelState.AddModelError("", "Некорректные логин или пароль");
}
return(View(model));
}
public async Task <IActionResult> Create(Clothes clothes)
{
if (_userManager.GetUserId(User) == adminId)
{
if (ModelState.IsValid)
{
//save image to wwwroot/Image
string wwwRootPath = _hostEnvironment.WebRootPath;
string fileName = Path.GetFileNameWithoutExtension(clothes.Image.ImageFile.FileName);
string extention = Path.GetExtension(clothes.Image.ImageFile.FileName);
clothes.Image.ImageName = fileName = fileName + DateTime.Now.ToString("yymmssfff") + extention;
string path = Path.Combine(wwwRootPath + "/Image/", fileName);
using (var fileStream = new FileStream(path, FileMode.Create))
{
await clothes.Image.ImageFile.CopyToAsync(fileStream);
}
Image img = new Image
{
ImageName = clothes.Image.ImageName,
Title = clothes.Image.Title
};
await _context.Images.AddAsync(img);
await _context.SaveChangesAsync();
clothes.Image = null;
clothes.ImageId = _context.Images.FirstOrDefault(i => i.ImageName == img.ImageName).Id;
await _context.Clothes.AddAsync(clothes);
await _context.SaveChangesAsync();
}
return(RedirectToAction("Index"));
}
else
{
return(Permission());
}
}
public async Task <string> addCountriesAsync(utblMstCountries model)
{
try
{
if (model.CountryID == 0)
{
objDB.utblMstCountries.Add(model);
await objDB.SaveChangesAsync();
return("New Country Details Added");
}
else
{
utblMstCountries curObj = await objDB.utblMstCountries.FindAsync(model.CountryID);
curObj.CountryName = model.CountryName;
await objDB.SaveChangesAsync();
return("Country Details Updated");
}
}
catch (Exception ex)
{
return("Error: " + ex.Message);
}
}
public async Task PrefillPlaces()
{
if (eFDBContext.SportObjects.Count <ESportObject>() == 0)
{
EObjectCategory oc1 = new EObjectCategory()
{
Name = "Футбольный стадион"
};
eFDBContext.ObjectCategories.Add(oc1);
EObjectCategory oc2 = new EObjectCategory()
{
Name = "Баскетбольная площадка"
};
eFDBContext.ObjectCategories.Add(oc2);
EObjectCategory oc3 = new EObjectCategory()
{
Name = "Каток"
};
eFDBContext.ObjectCategories.Add(oc3);
EObjectCategory oc4 = new EObjectCategory()
{
Name = "Пустырь с кустами и пеньками"
};
eFDBContext.ObjectCategories.Add(oc4);
ESportObject s1 = new ESportObject()
{
Name = "Стадион Заря",
Description = "Спортивный объект, оборудованный по последнему слову техники",
Address = "Спортивная 21",
ObjectCategory = oc1,
MaxMinRentalUnitsType = 0,
MinRentalTime = 1,
MaxRentalTime = 10,
ImageLink = "",
MaxPerson = 100
};
eFDBContext.SportObjects.Add(s1);
ESportObject s2 = new ESportObject()
{
Name = "Каток ЛЁД",
Description = "Спортивный объект, оборудованный по последнему слову техники",
Address = "Спортивная 22",
ObjectCategory = oc2,
MaxMinRentalUnitsType = 0,
MinRentalTime = 1,
MaxRentalTime = 10,
ImageLink = "",
MaxPerson = 100
};
eFDBContext.SportObjects.Add(s2);
ESportObject s3 = new ESportObject()
{
Name = "Стадион Рассвет",
Description = "Спортивный объект, оборудованный по последнему слову техники",
Address = "Спортивная 23",
ObjectCategory = oc1,
MaxMinRentalUnitsType = 0,
MinRentalTime = 1,
MaxRentalTime = 10,
ImageLink = "",
MaxPerson = 100
};
eFDBContext.SportObjects.Add(s3);
}
if (eFDBContext.RentPlaces.Count <ERentPlace>() == 0)
{
ERentPlace r1 = new ERentPlace()
{
Name = "Прокат самокатов",
Description = "Здесь можно взять самокат на прокат",
Address = "Самокатная 11",
};
eFDBContext.RentPlaces.Add(r1);
ERentPlace r2 = new ERentPlace()
{
Name = "Прокат велосипедов",
Description = "Здесь можно взять велосипед на прокат",
Address = "Педальная 31",
};
eFDBContext.RentPlaces.Add(r2);
ERentPlace r3 = new ERentPlace()
{
Name = "Прокат лыж",
Description = "Здесь можно взять лыжи на прокат",
Address = "Лыжная 41",
};
eFDBContext.RentPlaces.Add(r3);
ERentPlace r4 = new ERentPlace()
{
Name = "Прокат сноубордов",
Description = "Здесь можно взять сноуборд на прокат",
Address = "Спусковая 12",
};
eFDBContext.RentPlaces.Add(r4);
ERentPlace r5 = new ERentPlace()
{
Name = "Прокат коньков",
Description = "Здесь можно взять коньки на прокат",
Address = "Конькобежная 56",
};
eFDBContext.RentPlaces.Add(r5);
}
await eFDBContext.SaveChangesAsync();
}