public ContractDetailViewModel EditContractDetail(int?id)
{
var listTravelDb = from c in _db.ContractDetails
join t in _db.Tours on c.TourId equals t.Id
join ct in _db.Contracts on c.ContractId equals ct.Id
join cs in _db.Customers on ct.CustomerId equals cs.Id
where c.Id == id
select new { t.Code, c.NameTour, cs.Name, ct.BeginDate, ct.Paid, t.Cost, t.Picture, c.PeopleGo, cs.Email, c.Id };
var detailBookTour = new ContractDetailViewModel();
foreach (var item in listTravelDb)
{
detailBookTour.Id = item.Id;
detailBookTour.Code = item.Code;
detailBookTour.NameTour = item.NameTour;
detailBookTour.NameCustomer = item.Name;
detailBookTour.BeginDate = item.BeginDate;
detailBookTour.Paid = item.Paid;
detailBookTour.Cost = item.Cost;
detailBookTour.Picture = item.Picture;
detailBookTour.PeopleGo = item.PeopleGo;
detailBookTour.Email = item.Email;
}
return(detailBookTour);
}
public ContractDetail(ContractDetailViewModel contractDetail)
{
this.Id = contractDetail.Id;
this.ContractId = contractDetail.Id;
this.PeopleGo = contractDetail.PeopleGo;
this.Cost = contractDetail.Cost;
this.NameTour = contractDetail.NameTour;
this.TourId = contractDetail.TourId;
}
public void EditContractDetail(ContractDetailViewModel viewModel)
{
var data = _db.ContractDetails.FirstOrDefault(n => n.Id == viewModel.Id);
if (viewModel.Paid == true)
{
var model = _db.Contracts.FirstOrDefault(n => n.Id == data.ContractId);
model.Paid = true;
_db.SaveChanges();
}
}
public IActionResult MarkAsPaid(ContractDetailViewModel detailViewModel)
{
string currentId = (TempData["currentId"]).ToString();
int[] data = detailViewModel.BankSlips.Where(x => x.IsSelected == true).Select(x => x.BankslipId).ToArray();
if (!data.Any())
{
return(RedirectToAction("Details", new { id = currentId, success = false }));
}
bool success = _blContract.MarkAsPaid(data);
return(RedirectToAction("Details", new { id = currentId }));
}
public void BookingTour(BookingTourCommand command)
{
var newCustomer = new Customer(command);
_db.Customers.Add(newCustomer);
_db.SaveChanges();
//Insert Contract
ContractViewModel contract = new ContractViewModel();
{
contract.CustomerId = newCustomer.Id;
contract.TourId = command.TourId;
contract.BeginDate = command.BeginDate;
contract.Paid = false;
contract.Content = command.Content;
}
var newContract = new Contract(contract);
_db.Contracts.Add(newContract);
_db.SaveChanges();
var tour = _db.Tours.FirstOrDefault(n => n.Id == command.TourId);
{
tour.Quantity = tour.Quantity - Convert.ToInt32(command.PeopleGo);
}
_db.SaveChanges();
//Insert ContractDetail
ContractDetailViewModel contractDetail = new ContractDetailViewModel();
{
contractDetail.TourId = tour.Id;
contractDetail.NameTour = tour.NameTour;
contractDetail.Cost = tour.Cost;
contractDetail.PeopleGo = Convert.ToInt32(command.PeopleGo);
contractDetail.ContractId = newContract.Id;
}
var newContractDetail = new ContractDetail();
{
newContractDetail.TourId = contractDetail.TourId;
newContractDetail.NameTour = contractDetail.NameTour;
newContractDetail.Cost = contractDetail.Cost;
newContractDetail.PeopleGo = contractDetail.PeopleGo;
newContractDetail.ContractId = contractDetail.ContractId;
}
_db.ContractDetails.Add(newContractDetail);
_db.SaveChanges();
}
public IActionResult Schedule(ContractDetailViewModel installments, bool success = true)
{
List <int> installmentsIds = installments.DelayedInstallments.Where(x => x.IsSelected == true).Select(x => x.InstallmentId).ToList();
string currentId = (TempData["currentId"]).ToString();
ViewBag.CurrentId = currentId;
if (!installmentsIds.Any())
{
return(RedirectToAction("Details", new { id = currentId, success = false }));
}
BankSlipScheduleViewModel bankSlipSchedule = _blContract.GetDetailsToSchedule(installmentsIds);
ViewBag.Success = success;
return(View(bankSlipSchedule));
}
public ContractDetailViewModel GetContractDetail(string contractId)
{
ContractDetailViewModel details = new ContractDetailViewModel();
Contract c = _context.Contracts.Where(x => x.ExternalId == contractId)
.Include(x => x.Installments)
.FirstOrDefault();
details.Contract = c;
details.DelayedInstallments = c.Installments.Where(x => x.Delayed == true).ToList();
int[] installmentsId = details.DelayedInstallments.Select(x => x.InstallmentId).ToArray();
details.BankSlips = (from bk in _context.BankSlips
where bk.BankSlipInstallment.Any(x => installmentsId.Contains(x.InstallmentId)) &&
bk.Status == BankSlipStatus.Pending
select bk).ToList();
return(details);
}
public List <ContractDetailViewModel> ListTravel()
{
var listTravelDb = from c in _db.ContractDetails
join t in _db.Tours on c.TourId equals t.Id
join ct in _db.Contracts on c.ContractId equals ct.Id
join cs in _db.Customers on ct.CustomerId equals cs.Id
select new { t.Code, c.NameTour, cs.Name, ct.BeginDate, ct.Paid, t.Cost, c.Id };
var listTravel = new List <ContractDetailViewModel>();
foreach (var item in listTravelDb)
{
ContractDetailViewModel viewModel = new ContractDetailViewModel();
viewModel.Id = item.Id;
viewModel.Code = item.Code;
viewModel.NameTour = item.NameTour;
viewModel.NameCustomer = item.Name;
viewModel.BeginDate = item.BeginDate;
viewModel.Paid = item.Paid;
viewModel.Cost = item.Cost;
listTravel.Add(viewModel);
}
return(listTravel);
}
public JsonResult Post(string consignorCode, int eventNumber, [FromBody] ContractDetailViewModel viewModel)
{
try
{
if (ModelState.IsValid)
{
var contractHeader = _repository.GetContractHeaderByCosignorCodeAndEventNumber(consignorCode, eventNumber);
if (contractHeader == null)
{
return(Json($"Error - Contract Header not found for Consignor->{consignorCode} and Event->{eventNumber}"));
}
// Map to the Entity
var newDetail = Mapper.Map <ContractDetail>(viewModel);
//Save to Database
_repository.AddContractDetail(consignorCode, eventNumber, newDetail);
if (_repository.SaveAll())
{
Response.StatusCode = (int)HttpStatusCode.Created;
return(Json(Mapper.Map <ContractDetailViewModel>(newDetail)));
}
}
}
catch (Exception ex)
{
_logger.LogError("Failed to save new contracts detail", ex);
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new { Message = ex.Message, Text = "Did not work!" }));
}
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json("Model Validation Failed!"));
}
public IActionResult EditContractDetail(ContractDetailViewModel viewModel)
{
this._travelService.EditContractDetail(viewModel);
return(RedirectToAction("Travel", "Admin"));
}
public void BookingTour(BookingTourCommand command)
{
var newCustomer = new Customer();
newCustomer.Name = command.Name;
newCustomer.Email = command.Email;
newCustomer.Address = command.Address;
newCustomer.Phone = command.Phone;
_db.Customers.Add(newCustomer);
_db.SaveChanges();
//Insert Contract
ContractViewModel contract = new ContractViewModel();
{
contract.CustomerId = newCustomer.Id;
contract.TourId = command.TourId;
contract.BeginDate = command.BeginDate;
contract.Paid = false;
contract.Content = command.Content;
}
var newContract = new Contract(contract);
_db.Contracts.Add(newContract);
_db.SaveChanges();
var tour = new Tour();
using (var connection = new SqlConnection(this._db.Database.GetDbConnection().ConnectionString))
{
connection.Open();
if (command != null)
{
tour = connection.Query <Tour>(@"select * from Tour").FirstOrDefault(n => n.Id == command.TourId);
}
connection.Close();
}
tour.Quantity = tour.Quantity - Convert.ToInt32(command.PeopleGo);
dbSet.Attach(tour);
_db.Entry(tour).State = EntityState.Modified;
_db.SaveChanges();
//Insert ContractDetail
ContractDetailViewModel contractDetail = new ContractDetailViewModel();
{
contractDetail.TourId = tour.Id;
contractDetail.NameTour = tour.NameTour;
contractDetail.Cost = tour.Cost;
contractDetail.PeopleGo = Convert.ToInt32(command.PeopleGo);
contractDetail.ContractId = newContract.Id;
}
var newContractDetail = new ContractDetail();
{
newContractDetail.TourId = contractDetail.TourId;
newContractDetail.NameTour = contractDetail.NameTour;
newContractDetail.Cost = contractDetail.Cost;
newContractDetail.PeopleGo = contractDetail.PeopleGo;
newContractDetail.ContractId = contractDetail.ContractId;
}
_db.ContractDetails.Add(newContractDetail);
_db.SaveChanges();
using (MailMessage emailMessage = new MailMessage())
{
emailMessage.From = new MailAddress("*****@*****.**", "Công ty du lịch");
emailMessage.To.Add(new MailAddress("*****@*****.**", "Account1"));
emailMessage.Subject = "Thông tin đặt tour";
emailMessage.Body = "TourId: " + contractDetail.TourId + Environment.NewLine + "Tên Tour: " + contractDetail.NameTour + Environment.NewLine + "Giá: " + contractDetail.Cost + Environment.NewLine + "Số người đi: " + contractDetail.PeopleGo;
emailMessage.Priority = MailPriority.Normal;
using (SmtpClient MailClient = new SmtpClient("smtp.gmail.com", 587))
{
MailClient.EnableSsl = true;
MailClient.Credentials = new System.Net.NetworkCredential("*****@*****.**", "tungvipro809");
MailClient.Send(emailMessage);
}
}
}
/// <summary>
/// Get all the details (delayed installments, bank slips, contract information) for a given contract
/// </summary>
/// <param name="contractId">The id of the desired contract</param>
/// <returns></returns>
public ContractDetailViewModel GetContractDetail(string contractId)
{
ContractDetailViewModel dt = _contractRepository.GetContractDetail(contractId);
return(dt);
}
