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