public bool checkLogin(ClientsModel model)
{
using (var context = new TravelAgencyEntities())
{
bool isvalid = context.tbl_Clients.Any(x => x.Username == model.Username && x.Password == model.Password);
return(isvalid);
}
}
public void AddCountry(string _CountryName)
{
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Countries.Add(new Country {
CountryName = _CountryName
});
db.SaveChanges();
}
}
public void AddClient(string _FIO, string _email, string _phone, DateTime _dayBirt)
{
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Clients.Add(new Client {
FIO = _FIO, Email = _email, PhoneNumber = _phone, DateOfBirth = _dayBirt
});
db.SaveChanges();
}
}
public List <Client> GetClients()
{
List <Client> temp = new List <Client>();
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
temp = (from i in db.Clients
select i).ToList() /*as ObservableCollection<Client>*/;
}
return(temp);
}
public List <Country> GetCountryes()
{
List <Country> temp = new List <Country>();
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
temp = (from i in db.Countries
select i).ToList();
}
return(temp);
}
public void AddCity(string _cityName, int _countryId)
{
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Cities.Add(new City {
CityName = _cityName, CountryId = _countryId
});
db.SaveChanges();
}
}
public List <Hotel> GetHotels()
{
List <Hotel> temp = new List <Hotel>();
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
temp = (from i in db.Hotels
select i).ToList();
}
return(temp);
}
public List <ShowPlace> GetShowPlace()
{
List <ShowPlace> temp = new List <ShowPlace>();
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
temp = (from i in db.ShowPlaces
select i).ToList();
}
return(temp);
}
public List <AgencyWorker> GetWorker()
{
List <AgencyWorker> temp = new List <AgencyWorker>();
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
temp = (from i in db.AgencyWorkers
select i).ToList();
}
return(temp);
}
public List <Tour> GetToursActual()
{
List <Tour> temp = new List <Tour>();
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
temp = (from i in db.Tours
where i.StartDate > DateTime.Today
select i).ToList();
}
return(temp);
}
public void SetCity(int _id, string _cityName, int _countryId)
{
var temp = new City {
Id = _id, CityName = _cityName, CountryId = _countryId
};
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Entry(temp).State = EntityState.Modified;
db.SaveChanges();
}
}
public void DelClient(Client client)
{
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
Client temp = db.Clients.FirstOrDefault(x => x.Id == client.Id);
if (temp != null)
{
db.Clients.Remove(temp);
db.SaveChanges();
}
}
}
public List <Tour> GetToursEnded()
{
List <Tour> temp = new List <Tour>();
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
temp = (from i in db.Tours
where i.StartDate < DateTime.Today
select i).ToList() /*as ObservableCollection<Tour>*/;
}
return(temp);
}
public void SetCountry(int _id, string _CountryName)
{
var temp = new Country {
Id = _id, CountryName = _CountryName
};
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Entry(temp).State = EntityState.Modified;
db.SaveChanges();
}
}
public List <DestinationModel> GetAllDest()
{
using (var context = new TravelAgencyEntities())
{
var result = context.tbl_Destination.Select(x => new DestinationModel()
{
Name = x.Name,
Price = x.Price,
Description = x.Description,
ImagePath = x.ImagePath,
IsOffer = x.IsOffer
}
).ToList();
return(result);
}
}
public void AddWorker(string _FIO, string _position, string _email, string _phone, DateTime _dayOfRecrut)
{
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.AgencyWorkers.Add(new AgencyWorker
{
FIO = _FIO,
Position = _position,
Email = _email,
PhoneNumber = _phone,
DateOfRecruitment = _dayOfRecrut.Date
});
db.SaveChanges();
}
}
public void SetClient(int _id, string _FIO, string _email, string _phone, DateTime _dayBirt)
{
var temp = new Client
{
Id = _id,
FIO = _FIO,
Email = _email,
PhoneNumber = _phone,
DateOfBirth = _dayBirt
};
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Entry(temp).State = EntityState.Modified;
db.SaveChanges();
}
}
public void AddTour(string _TourName, DateTime _start, DateTime _end, double _price,
int _max_tourist, int _sale)
{
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Tours.Add(new Tour
{
TourName = _TourName,
StartDate = _start.Date,
EndDate = _end.Date,
Price = Convert.ToDecimal(_price),
MaxTourists = _max_tourist,
IsDeleted = false,
Sale = _sale
});
db.SaveChanges();
}
}
public void SetWorker(int _id, string _FIO, string _position, string _email, string _phone, DateTime _dayOfRecrut)
{
var temp = new AgencyWorker
{
Id = _id,
FIO = _FIO,
Position = _position,
Email = _email,
PhoneNumber = _phone,
DateOfRecruitment = _dayOfRecrut.Date
};
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Entry(temp).State = EntityState.Modified;
db.SaveChanges();
}
}
public int AddContacts(ContactModel model)
{
using (var context = new TravelAgencyEntities())
{
tbl_Contact contact = new tbl_Contact()
{
Name = model.Name,
Email = model.Email,
Subject = model.Subject,
MessageBody = model.MessageBody,
EmailSent = true,
TimeStamp = System.DateTime.Now
};
context.tbl_Contact.Add(contact);
context.SaveChanges();
return(contact.Id);
}
}
public void SetTour(int _id, string _TourName, DateTime _start, DateTime _end, double _price,
int _max_tourist, bool _isDel, int _sale)
{
var temp = new Tour
{
Id = _id,
TourName = _TourName,
StartDate = _start.Date,
EndDate = _end.Date,
Price = Convert.ToDecimal(_price),
MaxTourists = _max_tourist,
IsDeleted = _isDel,
Sale = _sale
};
using (TravelAgencyEntities db = new TravelAgencyEntities())
{
db.Entry(temp).State = EntityState.Modified;
db.SaveChanges();
}
}
public int AddClient(ClientsModel model)
{
using (var context = new TravelAgencyEntities())
{
tbl_Clients clients = new tbl_Clients()
{
FirstName = model.FirstName,
LastName = model.LastName,
Username = model.EmailId,
EmailId = model.EmailId,
MobileNo = model.MobileNo,
Address = model.Address,
City = model.City,
State = model.State,
Password = model.Password
};
context.tbl_Clients.Add(clients);
context.SaveChanges();
return(clients.Id);
}
}
