public JsonResult SaveEvent2(string EventID, string Subject, string Start, string End, string Description, string ThemeColor, string IsFullDay, string IdTransEst)
{
var status = false;
using (atripservicesEntities dc = new atripservicesEntities())
{
if (Convert.ToInt32(EventID) > 0)
{
//Update the event
var v = dc.Events.Where(a => a.EventID == Convert.ToInt32(EventID)).FirstOrDefault();
if (v != null)
{
v.Subject = Subject;
v.Start = Convert.ToDateTime(Start);
v.End = Convert.ToDateTime(End);
v.Description = Description;
v.IsFullDay = Convert.ToBoolean(IsFullDay);
v.ThemeColor = ThemeColor;
v.IdTransEst = Convert.ToInt32(IdTransEst);
dc.Events.AddOrUpdate(v);
status = true;
}
}
else
{
//dc.Events.Add(e);
}
dc.SaveChanges();
//status1 = true;
}
//return new JsonResult { Data = new { status = status1 } };
return(Json(new { success = true, status }, JsonRequestBehavior.AllowGet));
}
protected void LoadTypetransfer(DropDownList TypeTrans, string Language)
{
TypeTrans.Items.Clear();
atripservicesEntities DBTrip = new atripservicesEntities();
var dados = (from p in DBTrip.TypeTransfer
select p).ToList <TypeTransfer>();
if (DBTrip != null)
{
foreach (var item in dados)
{
if (item.DescType != "Open")
{
if (Language == "EN")
{
TypeTrans.Items.Add(new ListItem(item.DescType, item.IdTypeTransfer.ToString()));
}
else
{
TypeTrans.Items.Add(new ListItem(TypeTransfer(Language, item.IdTypeTransfer), item.IdTypeTransfer.ToString()));
}
}
}
}
}
public JsonResult SaveEvent(Event e)
{
var status = false;
using (atripservicesEntities dc = new atripservicesEntities())
{
if (e.EventID > 0)
{
//Update the event
var v = dc.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
}
}
else
{
dc.Events.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult GetDestination(string Id)
{
string address = "";
string contact = "";
string phone = "";
string mobile = "";
atripservicesEntities ctx = new atripservicesEntities();
int idt = Convert.ToInt32(Id);
var ids = idt;
var dados = (from p in ctx.Destination
where p.IdDestination == ids
select p).ToList <Destination>();
foreach (var temp in dados)
{
contact = temp.Name;
address = temp.Address;
mobile = temp.Mobile;
phone = temp.Phone;
}
return(Json(new { success = true, contact, address, mobile, phone },
JsonRequestBehavior.AllowGet));
}
protected void DeleteLastIdYesterday()
{
atripservicesEntities DB = new atripservicesEntities();
var dt = DateTime.Now.AddDays(-1);
DB.LastIPReservation.RemoveRange(DB.LastIPReservation.Where(p => p.DateReservation < dt));
DB.SaveChanges();
}
public JsonResult GetEvents()
{
using (atripservicesEntities dc = new atripservicesEntities())
{
var events = dc.Events.ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public ActionResult GetCity(string qtyPass, string QtyMlGr, string QtyMlPq, string IdCity)
{
decimal POne = 0;
decimal PTwo = 0;
decimal qtypassenger = Convert.ToDecimal(qtyPass);
decimal qtyMalaGr = Convert.ToDecimal(QtyMlGr);
decimal qtyMalaPq = Convert.ToDecimal(QtyMlPq);
decimal MaxMalaGr = 0;
decimal MaxMalaPq = 0;
decimal TotalMala = 0;
decimal TotalPass = 0;
decimal Total = 0;
atripservicesEntities ctx = new atripservicesEntities();
int idt = Convert.ToInt32(IdCity);
var ids = idt;
var dados = (from p in ctx.PriceCities
where p.IdCity == ids
select p).ToList <PriceCities>();
foreach (var temp in dados)
{
POne = Convert.ToDecimal(temp.PriceOne);
PTwo = Convert.ToDecimal(temp.Pricetwo);
}
//Calculo Passageiro
if (qtypassenger > 0)
{
if (qtypassenger == 1)
{
TotalPass = qtypassenger * POne;
}
else
{
TotalPass = POne + (PTwo * (qtypassenger - 1));
}
}
//Calculo Malas
MaxMalaGr = qtypassenger * 2;
MaxMalaPq = qtypassenger * 1;
TotalMala = ((qtyMalaGr - MaxMalaGr) + (qtyMalaPq - MaxMalaPq)) * 10;
Total = TotalPass + TotalMala;
//return this.Json(Total.ToString());
return(Json(new { TotalGeral = Total.ToString() }));
}
protected bool VerifyLastIP(string IP)
{
bool DubleIP = false;
atripservicesEntities DB = new atripservicesEntities();
var dados = DB.LastIPReservation
.Where(p => p.IP.Contains(IP)).ToList();
if (dados.Count == 0)
{
DubleIP = true;
}
return(DubleIP);
}
public static List <SelectListItem> GetCity()
{
List <SelectListItem> ls = new List <SelectListItem>();
atripservicesEntities ctx = new atripservicesEntities();
var dados = (from p in ctx.PriceCities
select p).ToList <PriceCities>();
foreach (var temp in dados)
{
ls.Add(new SelectListItem()
{
Text = temp.City, Value = temp.IdCity.ToString()
});
}
return(ls);
}
public JsonResult DeleteEvent(int eventID)
{
var status = false;
using (atripservicesEntities dc = new atripservicesEntities())
{
var v = dc.Events.Where(a => a.EventID == eventID).FirstOrDefault();
if (v != null)
{
dc.Events.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult AutoComplete(string prefix)
{
atripservicesEntities entities = new atripservicesEntities();
var customers = (from p in entities.Passenger
join t in entities.TypeVisa on p.IdTypeVisa equals t.IdTypeVisa
where p.Name.StartsWith(prefix)
select new
{
lName = p.Name,
lId = p.IdPassenger.ToString(),
lEmail = p.Email,
lPhone = p.Phone,
lPhone2 = p.Phone2,
lTypeVisa = t.DescTypeVisa.ToString()
}).ToList();
return(Json(customers));
}
protected void LoadPriciesCity(DropDownList City, string IdCity)
{
City.Items.Clear();
atripservicesEntities DBTrip = new atripservicesEntities();
var dados = (from p in DBTrip.PriceCities
orderby p.City
select p).ToList <PriceCities>();
if (DBTrip != null)
{
foreach (var item in dados)
{
City.Items.Add(new ListItem(item.City, item.IdCity.ToString()));
}
}
if (IdCity != "0")
{
City.SelectedValue = IdCity;
}
}
protected void LoadTypeDestination(DropDownList typeDestination, string IdTypeDes)
{
typeDestination.Items.Clear();
atripservicesEntities DBTrip = new atripservicesEntities();
var dados = (from p in DBTrip.TypeDestination
orderby p.DescTypeDestination
select p).ToList <TypeDestination>();
if (DBTrip != null)
{
foreach (var item in dados)
{
typeDestination.Items.Add(new ListItem(item.DescTypeDestination, item.IdTypeDestination.ToString()));
}
}
if (IdTypeDes != "0")
{
typeDestination.SelectedValue = IdTypeDes;
}
}
protected void LoadGrid()
{
using (var ctx = new atripservicesEntities())
{
//Seleciono o objeto cliente e crio um novo tipo
//Observe que o tipo anônimo criado tem as propriedades
//com o mesmo nome do campodatafield do gridview
//e depois atribuo a lista ao data source do grid
gvBudget.DataSource = (from c in ctx.TransferEstimate
select new
{
IdTransEst = c.IdTransEst,
FlightNumber = c.FlightNumber,
DateFligh = c.DateFligh,
TimeFligh = c.TimeFligh,
TimePiDo = c.TimePiDo,
QtyPassanger = c.QtyPassenger,
QtyMalaGr = c.QtyMalaGr,
QtyMalaPq = c.QtyMalaPq,
CityFromId = c.CityFromId,
CityToId = c.CityToId,
TransferAmount = c.TransferAmount,
DateTransEst = c.DateTransEst,
DateAprove = c.DateAprove,
NamePassenger = c.NamePassenger,
Phone = c.Phone,
Phone2 = c.Phone2,
Email = c.Email,
Note = c.Note,
Destination = c.Destination.Name,
SalesContact = c.SalesContact.Contact,
TypeTransfer = c.TypeTransfer.DescType,
TypePayment = c.TypePayment.DescTypePayment,
DescStatusPayment = c.StatusPayment.DescStatusPayment
}).ToList();
gvBudget.DataBind();
}
}
protected void LoadTypeVisa(DropDownList TypeVisa, string Language)
{
TypeVisa.Items.Clear();
atripservicesEntities DBTrip = new atripservicesEntities();
var dados = (from p in DBTrip.TypeVisa
select p).ToList <TypeVisa>();
if (DBTrip != null)
{
foreach (var item in dados)
{
if (Language == "EN")
{
TypeVisa.Items.Add(new ListItem(item.DescTypeVisa, item.IdTypeVisa.ToString()));
}
else
{
TypeVisa.Items.Add(new ListItem(Visa(Language, item.IdTypeVisa), item.IdTypeVisa.ToString()));
}
}
}
}
public ActionResult Create([Bind(Include = "IdLogin,Email,UserLog,Password,Active,Profile,Name,LastName,UserLogin")] ACCESS aCCESS)
{
if (ModelState.IsValid)
{
using (atripservicesEntities db = new atripservicesEntities())
{
var vLogin = db.ACCESS.Where(p => p.Email.Equals(aCCESS.Email)).FirstOrDefault();
if (vLogin != null)
{
ModelState.AddModelError("", "Already registered user!!! Please, use other email.");
return(View(new ACCESS()));
}
else
{
db.ACCESS.Add(aCCESS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
}
return(View(aCCESS));
}
protected void CalculateFinalPrice(string IdCityFrom, string IdCityTo, string qtyPass, string qtyLugagge, string qtyCarryon)
{
atripservicesEntities ctx = new atripservicesEntities();
FinalPrice = 0;
decimal POne = 0;
decimal PTwo = 0;
decimal qtypassenger = Convert.ToDecimal(qtyPass);
decimal qtyMalaGr = Convert.ToDecimal(qtyLugagge);
decimal qtyMalaPq = Convert.ToDecimal(qtyCarryon);
decimal MaxMalaGr = 0;
decimal MaxMalaPq = 0;
decimal TotalMala = 0;
decimal TotalPass = 0;
decimal DescSalesChannel = 0;
decimal TranferAmount = 0;
string IdCity = "";
int id = 0;
//bool SalesChannel = false;
if (String.IsNullOrEmpty(IdCityFrom) || String.IsNullOrEmpty(IdCityTo))
{
Library.DisplayAtertSweet(this, "O campo Cidade está!", "Por favor verifique a cidade!", Library.MessageType.Info);
//Library.DisplayAtertSweet(this, "City is Empty!", "There are no cities for this sales channel!", Library.MessageType.Info);
return;
}
if (IdCityFrom == IdCityTo)
{
Library.DisplayAtertSweet(this, "Verificar Cidade de Destino!", "A cidade de destino não pede ser a mesma do Transfer!", Library.MessageType.Info);
SameCity = true;
return;
}
//Verifica qual cidade nao e Aeroporto
id = Convert.ToInt32(IdCityFrom);
var cf = id;
var dadoscf = (from p in ctx.PriceCities
where p.IdCity == cf
select p).ToList <PriceCities>();
foreach (var temp in dadoscf)
{
if (temp.City.ToUpper() != "AIRPORT")
{
IdCity = temp.IdCity.ToString();
}
}
id = Convert.ToInt32(IdCityTo);
var ct = id;
var dadosct = (from p in ctx.PriceCities
where p.IdCity == ct
select p).ToList <PriceCities>();
foreach (var temp in dadosct)
{
if (temp.City.ToUpper() != "AIRPORT")
{
IdCity = temp.IdCity.ToString();
}
}
//Verifica o preco das cidades
id = Convert.ToInt32(IdCity);
var idp = id;
var dadosp = (from p in ctx.PriceCities
where p.IdCity == idp
select p).ToList <PriceCities>();
foreach (var temp in dadosp)
{
POne = Convert.ToDecimal(temp.PriceOne);
PTwo = Convert.ToDecimal(temp.Pricetwo);
}
//Calculo Passageiro
for (int i = 1; i <= qtypassenger; i++)
{
if (i == 1)
{
TotalPass = POne - DescSalesChannel;
}
else
{
TotalPass = TotalPass + (PTwo - DescSalesChannel);
}
}
//Calculo Malas
MaxMalaGr = qtypassenger * 2;
MaxMalaPq = qtypassenger;
if (qtyMalaGr > MaxMalaGr)
{
TotalMala = qtyMalaGr - MaxMalaGr;
}
if (qtyMalaPq > MaxMalaPq)
{
TotalMala = TotalMala + (qtyMalaPq - MaxMalaPq);
}
TotalMala = TotalMala * 10;
TranferAmount = TotalPass + TotalMala;
FinalPrice = TranferAmount;
}
public ActionResult GetCalculateTranfer(string qtyPass, string QtyMlGr, string QtyMlPq, string IdCityFrom, string IdCityTo)
{
decimal POne = 0;
decimal PTwo = 0;
decimal qtypassenger = Convert.ToDecimal(qtyPass);
decimal qtyMalaGr = Convert.ToDecimal(QtyMlGr);
decimal qtyMalaPq = Convert.ToDecimal(QtyMlPq);
decimal MaxMalaGr = 0;
decimal MaxMalaPq = 0;
decimal TotalMala = 0;
decimal TotalPass = 0;
decimal Total = 0;
string IdCity = "";
if (IdCityFrom != "1")
{
IdCity = IdCityFrom;
}
if (IdCityTo != "1")
{
IdCity = IdCityTo;
}
atripservicesEntities ctx = new atripservicesEntities();
int idt = Convert.ToInt32(IdCity);
var ids = idt;
var dados = (from p in ctx.PriceCities
where p.IdCity == ids
select p).ToList <PriceCities>();
foreach (var temp in dados)
{
POne = Convert.ToDecimal(temp.PriceOne);
PTwo = Convert.ToDecimal(temp.Pricetwo);
}
//Calculo Passageiro
if (qtypassenger > 0)
{
if (qtypassenger == 1)
{
TotalPass = qtypassenger * POne;
}
else
{
TotalPass = POne + (PTwo * (qtypassenger - 1));
}
}
//Calculo Malas
MaxMalaGr = qtypassenger * 2;
MaxMalaPq = qtypassenger;
if (qtyMalaGr > MaxMalaGr)
{
TotalMala = qtyMalaGr - MaxMalaGr;
}
if (qtyMalaPq > MaxMalaPq)
{
TotalMala = TotalMala + (qtyMalaPq - MaxMalaPq);
}
TotalMala = TotalMala * 10;
Total = TotalPass + TotalMala;
return(Json(new { success = true, oldval = Total.ToString() },
JsonRequestBehavior.AllowGet));
}
protected void SaveTranferTestimate()
{
atripservicesEntities DBTrip = new atripservicesEntities();
TransferEstimate te = new TransferEstimate();
Passenger pa = new Passenger();
ReservationRequest rr = new ReservationRequest();
LastIPReservation ip = new LastIPReservation();
DeleteLastIdYesterday();
if (VerifyLastIP(Request.UserHostAddress.ToString()) == false)
{
Library.DisplayAtertSweet(this, "Você já pediu uma reserva!", "Aguarde seu pedido ser processado, logo lhe enviaremos um email.", Library.MessageType.Info);
return;
}
//Transfer Estimate
te.FlightNumber = txtFlightNumber.Text.ToUpper();
if (!String.IsNullOrEmpty(txtDateVoo.Text))
{
te.DateFligh = Convert.ToDateTime(txtDateVoo.Text);
}
else
{
te.DateFligh = null;
}
if (!String.IsNullOrEmpty(txtTimeVoo.Text))
{
te.TimeFligh = txtTimeVoo.Text;
}
else
{
te.TimeFligh = null;
}
if (!String.IsNullOrEmpty(txtTime.Text))
{
te.TimePiDo = txtTime.Text;
}
else
{
te.TimePiDo = null;
}
if (!String.IsNullOrEmpty(txtDateEstimate.Text))
{
te.DateTransEst = Convert.ToDateTime(txtDateEstimate.Text);
}
else
{
te.DateTransEst = null;
}
te.DateAprove = null;
te.DateRequestEstimate = DateTime.Now;
te.Discount = 0;
te.IdMetingPoint = 1;
te.QtyPassenger = Convert.ToInt32(ddlQtyPassenger.SelectedValue);
te.QtyPassengerKids = Convert.ToInt32(ddlQtyKids.SelectedValue);
te.QtyMalaGr = Convert.ToInt32(ddlQtyLuggage.SelectedValue);
te.QtyMalaPq = Convert.ToInt32(ddlQtyCarryon.SelectedValue);
te.CityFromId = 1;
te.CityToId = Convert.ToInt32(ddlCityTo.SelectedValue);
te.TransferAmount = 0;
te.Discount = null;
te.FinalPrice = FinalPrice;
te.NamePassenger = txtNamePassenger.Text;
te.Phone = txtPhonePassenger.Text;
te.Phone2 = "";
te.Email = txtEmailPassenger.Text;
te.TypeVisa = ddlTypeVisa.SelectedItem.ToString();
te.Note = "Reservation Request";
te.IdAprove = 0;
te.IdTypeDestination = Convert.ToInt32(ddlTypeDestination.SelectedValue);
te.IdDestination = 1;
te.IdSales = 1;
te.IdTypeTransfer = Convert.ToInt32(ddlTypeTransfer.SelectedValue);
te.IdTypePayment = 0;
te.IdStatusPayment = 0;
DBTrip.TransferEstimate.Add(te);
DBTrip.SaveChanges();
var idte = te.IdTransEst;
//Verify IP
ip.IP = Request.UserHostAddress.ToString();
ip.DateReservation = DateTime.Now;
DBTrip.LastIPReservation.Add(ip);
DBTrip.SaveChanges();
//Passenger
pa.Name = txtNamePassenger.Text;
pa.Phone = txtPhonePassenger.Text;
pa.Phone2 = "";
pa.Email = txtEmailPassenger.Text;
pa.IdTypeVisa = Convert.ToInt32(ddlTypeVisa.SelectedValue);
DBTrip.Passenger.Add(pa);
DBTrip.SaveChanges();
var idpa = pa.IdPassenger;
//Reservation Request (Destination)
rr.NamePD = txtNameDestination.Text;
rr.AddressPD = txtAddress.Text;
rr.PostalCodePD = txtPostalCode.Text;
rr.PhonePD = txtPhoneContact.Text;
rr.MobilePD = "";
rr.IdCityPD = Convert.ToInt32(ddlCityTo.SelectedValue);
rr.IdTypeDestinationPD = Convert.ToInt32(ddlTypeDestination.SelectedValue);
rr.IdPassenger = idpa;
rr.IdTransferEst = idte;
DBTrip.ReservationRequest.Add(rr);
DBTrip.SaveChanges();
ClearReservation();
if (lblSend.Text == "Send")
{
Library.DisplayAtertSweet(this, "Success!", "Your reservation request was sent successfully! Wait for our contact.", Library.MessageType.Success);
}
if (lblSend.Text == "Enviar")
{
Library.DisplayAtertSweet(this, "Pedido Enviado!", "Seu pedido de reserva foi enviado com sucesso! Aguarde nosso contato.", Library.MessageType.Success);
}
if (lblSend.Text == "Enviar ")
{
Library.DisplayAtertSweet(this, "Éxito!", "Su solicitud de reserva fue enviada con éxito! Espera nuestro contacto.", Library.MessageType.Success);
}
ClearReservation();
}
