public static List <user_notification_tbl> GetByUserId(int userId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.user_notification_tbl.Where(b => b.user_id == userId).ToList()); } }
public static List <fault_tbl> GetFaultByBuilding(int buildingId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.fault_tbl.Where(f => f.building_id == buildingId).ToList()); } }
//get all //get by id //add //update //delete public static List <message_tbl> GetByBuilding(int buildingId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.message_tbl.Where(p => p.building_id == buildingId).ToList()); } }
public static List <expenditure_tbl> Get() { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.expenditure_tbl.ToList()); } }
public static fault_tbl GetById(int id) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.fault_tbl.Find(id)); } }
public static user_permissions_tbl GetUserPermissions(int id) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.user_permissions_tbl.FirstOrDefault(u => u.user_id == id)); } }
public static user_tbl GetByPassword(string user_name, string password) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.user_tbl.FirstOrDefault(u => u.password == password && u.user_name == user_name)); } }
public static List <session_tbl> GetByBuilding(int buildingId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.session_tbl.Include("user_tbl").Where(p => p.building_id == buildingId).ToList()); } }
public static List <Notification> GetByUserId(List <UserNotification> notifications) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { List <Notification> notificationList = new List <Notification>(); foreach (UserNotification not in notifications) { var query = from u in db.notification_tbl where u.id == not.notification_id select u; foreach (var item in query) { Notification notification = new Notification(); notification.id = item.id; notification.message = item.messege; notificationList.Add(notification); } } return(notificationList); } }
public static List <payment_tbl> Get() { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.payment_tbl.ToList()); } }
public static expenditure_tbl GetById(int id) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.expenditure_tbl.Find(id)); } }
public static List <payment_tbl> GetPaymentsByBuilding(int buildingId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.payment_tbl.Where(b => b.building_id == buildingId).ToList()); } }
public static void Delete(int id) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { // db.tenant_tbl.Find(id).remove(); } }
//get all //get by id //add //update //delete public static List <notification_tbl> Get() { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.notification_tbl.ToList()); } }
public static notification_tbl GetById(int id) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.notification_tbl.Find(id)); } }
public static List <tenant_payment_tbl> GetPaymentsForUser(int userId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.tenant_payment_tbl.Where(b => b.tenant_id == userId).ToList()); } }
public static List <building_tbl> Get() { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.building_tbl.ToList()); } }
public static List <message_tbl> Get() { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.message_tbl.ToList()); } }
public static tenant_tbl GetByUserId(int userId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.tenant_tbl.FirstOrDefault(x => x.user_id == userId)); } }
public static void RemoveTenant(tenant_tbl tenant) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { db.Entry(tenant).State = EntityState.Deleted; db.SaveChanges(); } }
public static user_notification_tbl GetByUsetIdAndNotificationId(NotificationForUser n) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.user_notification_tbl.Where(u => u.notification_id == n.notificationId && u.user_id == n.userId) .FirstOrDefault()); } }
public static List <SurveyHedear> GetSurveyByBuildingId(int buildingId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { List <SurveyHedear> sh = db.SurveyHedear.Include(e => e.SurveyDetails).Where(b => b.BuildingId == buildingId).ToList(); return(sh); } }
public static List <expenditure_tbl> GetByBuildingId(int buildingId) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.expenditure_tbl.Where(b => b.building_id == buildingId) .ToList()); } }
public static void RemoveUserNotification(user_notification_tbl u) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { //db.user_notification_tbl.Remove(u); db.Entry(u).State = EntityState.Deleted; db.SaveChanges(); } }
public static List <tenant_tbl> GetAllTenantByBuilding(int building_id) { try { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { return(db.tenant_tbl.Where(t => t.building_id == building_id).ToList()); } } catch (Exception e) { throw e; } }
public static int GetByPassword(string password, string name) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { user_tbl user = db.user_tbl.FirstOrDefault(u => u.password == password && u.user_name == name); return(user != null ? user.id : -1); //if(db.user_tbl.Where(u => String.Equals(u.password, password))!=null) // return true; // if (db.user_tbl.FirstOrDefault(u => String.Equals(u.password, password)) != null) //return false; // return db.user_tbl.FirstOrDefault(u => String.Equals(u.password, password)); } }
public static void Add(expenditure_tbl expenditure) { try { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { db.expenditure_tbl.Add(expenditure); } } catch { throw; } }
public static void Add(vote_tbl vote) { try { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { db.vote_tbl.Add(vote); db.SaveChanges(); } } catch (Exception e) { } }
public static void Add(survey_tbl survey) { try { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { db.survey_tbl.Add(survey); db.SaveChanges(); } } catch (Exception e) { } }
public static void Add(notification_tbl notification) { try { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { db.notification_tbl.Add(notification); db.SaveChanges(); } } catch (Exception e) { } }