public static Event SalectEventByUserId(int u_id)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Event.FirstOrDefault(e => e.user_id == u_id));
}
}
public static List <Guest> SelectGuestsByCatagory(string category)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Guest.Where(e => e.Guest_catagory.guest_catagory_des == category).ToList());
}
}
public static Event SalectEvent(int code)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Event.FirstOrDefault(e => e.event_id == code));
}
}
public static int GetHID()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Guest.Max(e => e.guest_id));
}
}
//public static int UpdateEvent(Event event)
//{
// try
// {
// using (YourPlaceEntities db = new YourPlaceEntities())
// {
// var q1=db.Event.FirstOrDefault(e => e.event_code==event.event_code);
// if (q1 == null)
// return 0;
// else
// {
// //עדכן
// ////ctx.Workers.Attach(worker);
// // ctx.Entry(worker).State = EntityState.Modified;
// q1.event_code = event.event_code;
// //שמור שינוי
// return db.SaveChanges();
// }
// }
// }
// catch
// {
// throw;
// }
//}
// public static int AddEvent(Event event)
// {
// try
// {
// using (YourPlaceEntities db = new YourPlaceEntities())
// {
// var q1 = db.Event.Add(event);
// //שמור שינוי
// db.SaveChanges();
// return 1;//יתכן שנשקול להוסיף את המספור האוטמטי החדש
// }
//}
// catch
//{
// throw;
//}
// }
public static int DeleteEvent(int code)
{
try
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
var q1 = db.Event.FirstOrDefault(e => e.event_id == code);
if (q1 == null)
{
return(0);
}
else
{
//מחק
db.Event.Remove(q1);
//שמור שינוי
db.SaveChanges();
//החזר 1
return(1);
}
}
}
catch
{
throw;
}
}
public static Users SalectUser(string mail)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Users.FirstOrDefault(u => u.user_email == mail));
}
}
public static int GetHID()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.guest_table_member.Max(e => e.table_members_id));
}
}
public static List <Guest> SelectGuestsById(int id)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Guest.Where(e => e.guest_id == id).ToList());
}
}
public static List <Guest> GetAllGuestByEventId(int eventId)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Guest.Where(e => e.event_id == eventId).ToList());
}
}
public static string SelectCategoryById(int g_id)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(GetCategoryByCId((int)db.Guest.FirstOrDefault(e => e.guest_id == g_id).guest_catagory_id));
}
}
public static string GetCategoryByCId(int c_id)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Guest_catagory.FirstOrDefault(e => e.guest_catagory_id == c_id).guest_catagory_des);
}
}
public static List <Event> SelectEvents()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Event.ToList());
}
}
public static string GetInvatation(int id)
{
try
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
Event event1 = db.Event.FirstOrDefault(e => e.event_id == id);
return((string)event1.invitation_file);
}
}
catch (Exception e)
{
throw e;
}
//using (YourPlaceEntities db = new YourPlaceEntities())
//{
// string invatation = null;
// string query = @"SELECT e.invitation_file FROM Event e where e.event_id=" + id + ";";
// SqlCommand cmd = new SqlCommand(query);
// SqlDataReader dr = cmd.ExecuteReader();
// if (dr.HasRows)
// while (dr.Read())
// invatation = dr.GetString(0);
// else
// Console.WriteLine("No data found.");
// return invatation;
//}
}
public static int UpdateEvent(Event event1)
{
//אמור להיות update
try
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
var ev = db.Event.FirstOrDefault(e => e.event_id == event1.event_id);
//שמור שינוי
ev.invitation_file = event1.invitation_file;
ev.event_type_id = event1.event_type_id;
ev.event_date = event1.event_date;
ev.event_des = event1.event_des;
ev.user_id = event1.user_id;
ev.due_date = event1.due_date;
ev.num_places_around_a_table = event1.num_places_around_a_table;
ev.num_tables = event1.num_tables;
db.SaveChanges();
return(1);
}
}
catch (Exception e)
{
throw e;
}
}
public static int DeleteGuest(Guest guest)
{
try
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
//אמור למחוק את האורח שקיבל
var q1 = db.Guest.FirstOrDefault();
if (q1 == null)
{
return(0);
}
else
{
//מחק
db.Guest.Remove(q1);
//שמור שינוי
db.SaveChanges();
//החזר 1
return(1);
}
}
}
catch
{
throw;
}
}
public static int GetHID()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
return(db.Users.Max(e => e.user_id));
}
}
public static int GetNumOfSeatsAroundTable()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
var o = db.Event.FirstOrDefault();
return((int)o.num_places_around_a_table);
}
}
public static List <Guest> GetAllGuestNotConfirmed()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
//אמור להיות כל מי שלא אישר השתתפות
return(db.Guest.Where(e => e.gender == "male").ToList());
}
}
public static List <Guest> GetAllGuestConfirmed()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
//tnur kvhu, to thar va,,pu,
return(db.Guest.Where(e => e.gender == "female").ToList());
}
}
public static List <EventType> SelectEventType()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
List <EventType> f = db.EventType.ToList();
return(f);
}
}
public static int SelectNumOfGuestsByCatagory(int category)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
List <Guest> L = new List <Guest>();
L = db.Guest.Where(e => e.Guest_catagory.guest_catagory_id == category).ToList();
return(L.Count());
}
}
public static List <Users> SelectUsers()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
//Context.Connection.Open();
// Content.Connection.Open();
return(db.Users.ToList());
}
}
public static List <Guest> SelectGuests()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
//לא נראה לי צריך שורות אלו
//Context.Connection.Open();
//Content.Connection.Open();
return(db.Guest.ToList());
}
}
public static List <Guest_catagory> SelectCatagoryList()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
//List<EventType> f = new List<EventType>();
//f.Add();
List <Guest_catagory> f = db.Guest_catagory.ToList();
return(f);
}
}
public static List <Event> SelectEvents()
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
//Context.Connection.Open();
//Content.Connection.Open();
return(db.Event.ToList());
}
}
public static bool SalectUser(string mail, string password)
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
Users q1 = db.Users.FirstOrDefault(u => u.user_email == mail & u.user_password == password);
if (q1 != null)
{
return(true);
}
return(false);
}
}
public static int GetGuest1priority(int guest_id)
{
try
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
guest_table_member tm1 = db.guest_table_member.FirstOrDefault(u => u.guest_id == guest_id & u.guestPriority == 1);
return((int)tm1.friend_id);
}
}
catch (Exception e)
{
throw e;
}
}
public static int GetPriorityByFriend(int id, int f_id)
{
try
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
guest_table_member tm = db.guest_table_member.Where(e => e.guest_id == id & e.friend_id == f_id).FirstOrDefault();
return((int)tm.guestPriority);
}
}
catch
{
return(0);
}
}
public static int GetPriority()
{
try
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
var o = db.guest_table_member.FirstOrDefault();
return((int)o.guestPriority);
}
}
catch (Exception e)
{
throw e;
}
}
public static bool GetstatusOfFById(int id, int f_id)
{
try
{
using (YourPlaceEntities db = new YourPlaceEntities())
{
var o = db.guest_table_member.Where(e => e.guest_id == id & e.friend_id == f_id).FirstOrDefault();
return((bool)o.like_or_not);
}
}
catch (Exception e)
{
throw e;
}
}