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); } }