public Country GetCountryById(string id)
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Country
orderby q.CountryID == id
select q).SingleOrDefault());
}
}
public IEnumerable <Origin> GetAll()
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Origin
orderby q.OriginName
select q).ToList());
}
}
public IEnumerable <Country> GetAll()
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Country
orderby q.CountryName
select q).ToList());
}
}
public IEnumerable <UnitType> GetAll()
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.UnitType
orderby q.UnitName
select q).ToList());
}
}
public Origin GetOriginById(string id)
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Origin
orderby q.OriginId == id
select q).SingleOrDefault());
}
}
public IEnumerable <Notification> GetAll()
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Notification
orderby q.NotificationName
select q).ToList());
}
}
public Notification GetNotificationById(string id)
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Notification
orderby q.NotificationID == id
select q).SingleOrDefault());
}
}
public Branch GetBranchById(string id)
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Branch
orderby q.BranchID == id
select q).SingleOrDefault());
}
}
public IEnumerable <Branch> GetAll()
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Branch
orderby q.BranchName
select q).ToList());
}
}
public Notification Edit(Notification notification)
{
using (CargoDBEntities db = new CargoDBEntities())
{
db.Entry(notification).State = EntityState.Modified;
db.SaveChanges();
return(notification);
}
}
public Origin Edit(Origin origin)
{
using (CargoDBEntities db = new CargoDBEntities())
{
db.Entry(origin).State = EntityState.Modified;
db.SaveChanges();
return(origin);
}
}
public Branch Edit(Branch branch)
{
using (CargoDBEntities db = new CargoDBEntities())
{
db.Entry(branch).State = EntityState.Modified;
db.SaveChanges();
return(branch);
}
}
public Country Edit(Country country)
{
using (CargoDBEntities db = new CargoDBEntities())
{
db.Entry(country).State = EntityState.Modified;
db.SaveChanges();
return(country);
}
}
public UnitType Edit(UnitType unitType)
{
using (CargoDBEntities db = new CargoDBEntities())
{
db.Entry(unitType).State = EntityState.Modified;
db.SaveChanges();
return(unitType);
}
}
public IEnumerable <Post> GetAll(string userId)
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Post
join u in db.PostUser on q.PostID equals u.Fk_Post
where u.Fk_User == userId
orderby q.PubDate descending
select q).ToList());
}
}
public string Save(Branch branch)
{
using (CargoDBEntities db = new CargoDBEntities())
{
branch.BranchID = IDGenerator.NewId();
db.Branch.Add(branch);
db.SaveChanges();
return(branch.BranchID);
}
}
public string Save(UnitType unitType)
{
using (CargoDBEntities db = new CargoDBEntities())
{
unitType.UnitTypeId = IDGenerator.NewId();
db.UnitType.Add(unitType);
db.SaveChanges();
return(unitType.UnitTypeId);
}
}
public IEnumerable <Comment> GetCommentsByPostId(string id)
{
using (CargoDBEntities db = new CargoDBEntities())
{
return((from q in db.Comment
//join u in db.AspNetUsers on q.Fk_User equals u.Id
where q.Fk_Post == id && !q.Deleted && q.Active
orderby q.Date ascending
select q).ToList());
}
}
public string Save(Origin origin)
{
using (CargoDBEntities db = new CargoDBEntities())
{
origin.OriginId = IDGenerator.NewId();
db.Origin.Add(origin);
db.SaveChanges();
return(origin.OriginId);
}
}
public Country Delete(Country country)
{
using (CargoDBEntities db = new CargoDBEntities())
{
country.Deleted = !country.Deleted;
db.Entry(country).State = EntityState.Modified;
db.SaveChanges();
return(country);
}
}
public string Save(Country country)
{
using (CargoDBEntities db = new CargoDBEntities())
{
country.CountryID = IDGenerator.NewId();
db.Country.Add(country);
db.SaveChanges();
return(country.CountryID);
}
}
public string Save(Notification notification)
{
using (CargoDBEntities db = new CargoDBEntities())
{
notification.NotificationID = IDGenerator.NewId();
db.Notification.Add(notification);
db.SaveChanges();
return(notification.NotificationID);
}
}
public string Create(Post post)
{
using (CargoDBEntities db = new CargoDBEntities())
{
post.PostID = IDGenerator.NewId();
post.PubDate = DateTime.Now;
db.Post.Add(post);
db.SaveChanges();
return(post.PostID);
}
}
public Country ToggleState(Country country)
{
using (CargoDBEntities db = new CargoDBEntities())
{
if (country.Active == true)
{
country.Active = false;
}
else
{
country.Active = true;
}
db.Entry(country).State = EntityState.Modified;
db.SaveChanges();
return(country);
}
}
public Origin ToggleState(Origin origin)
{
using (CargoDBEntities db = new CargoDBEntities())
{
if (origin.Active == true)
{
origin.Active = false;
}
else
{
origin.Active = true;
}
db.Entry(origin).State = EntityState.Modified;
db.SaveChanges();
return(origin);
}
}
public Branch ToggleState(Branch branch)
{
using (CargoDBEntities db = new CargoDBEntities())
{
if (branch.Active == true)
{
branch.Active = false;
}
else
{
branch.Active = true;
}
db.Entry(branch).State = EntityState.Modified;
db.SaveChanges();
return(branch);
}
}
public Notification ToggleState(Notification notification)
{
using (CargoDBEntities db = new CargoDBEntities())
{
if (notification.Activate == true)
{
notification.Activate = false;
}
else
{
notification.Activate = true;
}
db.Entry(notification).State = EntityState.Modified;
db.SaveChanges();
return(notification);
}
}
