/// <summary> NewHours- the owner add the opening hours of his business to db public static List <BusinessOpeningHours_tbl> NewHours(List <BusinessOpeningHours_tbl> hdal) { foreach (var h in hdal) { try { using (projectDBEntities5 db = new projectDBEntities5()) { BusinessOpeningHours_tbl newHour = new BusinessOpeningHours_tbl { BusinessCode = h.BusinessCode, StartHour = h.StartHour, EndHour = h.EndHour, DayInWeek = h.DayInWeek, }; db.BusinessOpeningHours_tbl.Add(newHour); db.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e); return(null); } } return(hdal); }
/// <summary> - NewBusiness: add business to business tbl in db. public static Business__tbl NewBusiness(Business__tbl budal) { try { using (projectDBEntities5 db = new projectDBEntities5()) { Business__tbl newBusiness = new Business__tbl { BusinessCode = budal.BusinessCode, CategoryCode = budal.CategoryCode, BusinessOwnerCode = budal.BusinessOwnerCode, BusinessName = budal.BusinessName, FullAddress = budal.FullAddress, Phone = budal.Phone, BusinessDescription = budal.BusinessDescription, }; db.Business__tbl.Add(newBusiness); //db.Entry(newUser).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(newBusiness); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
/// <summary> - NewUser: add new user to user tbl in db. public static Users__tbl NewUser(Users__tbl udal) { try { using (projectDBEntities5 db = new projectDBEntities5()) { Users__tbl newUser = new Users__tbl { UserName = udal.UserName, UserLastName = udal.UserLastName, UserMail = udal.UserMail, UserPassword = udal.UserPassword, UserType = udal.UserType }; db.Users__tbl.Add(newUser); db.SaveChanges(); return(newUser); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
/// <summary> - NewSchedule: add new schedule to schedule tbl in db public static Schedule_tbl NewSchedule(Schedule_tbl sdal) { using (projectDBEntities5 db = new projectDBEntities5()) { try { Schedule_tbl existSchedule = db.Schedule_tbl.Where (x => x.ScheduleId == sdal.ScheduleId). Select(x => x).FirstOrDefault(); if (existSchedule != null) { existSchedule.EventCode = sdal.EventCode; existSchedule.BusinessCode = sdal.BusinessCode; existSchedule.EventDate = sdal.EventDate; existSchedule.Duration = sdal.Duration; existSchedule.Done = sdal.Done; existSchedule.Cost = sdal.Cost; existSchedule.Hour = sdal.Hour; existSchedule.Description = sdal.Description; existSchedule.Subject = sdal.Subject; db.SaveChanges(); return(existSchedule); } else { try { Schedule_tbl newSchedule = new Schedule_tbl { EventCode = sdal.EventCode, BusinessCode = sdal.BusinessCode, EventDate = sdal.EventDate, Duration = sdal.Duration, Done = sdal.Done, Cost = sdal.Cost, Hour = sdal.Hour, Description = sdal.Description, Subject = sdal.Subject, ScheduleId = sdal.ScheduleId }; db.Schedule_tbl.Add(newSchedule); db.SaveChanges(); return(newSchedule); } catch (Exception e) { Console.WriteLine(e); return(null); } } } catch (Exception e) { Console.WriteLine(e); return(null); } } }
public static List <BusinessOpeningHours_tbl> GetHoursByBusinessCode(int businessCode) { try { using (projectDBEntities5 db = new projectDBEntities5()) { List <BusinessOpeningHours_tbl> hourList = db.BusinessOpeningHours_tbl.Where(x => x.BusinessCode == businessCode).Select(x => x).ToList(); return(hourList); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
/// <summary> - GetAllByEventCode: get schedule list by event code public static List <Schedule_tbl> GetAllScheduleByEventCode(int eventCode) { try { using (projectDBEntities5 db = new projectDBEntities5()) { List <Schedule_tbl> scheduleList = db.Schedule_tbl.Where(x => x.EventCode == eventCode).Select(x => x).OrderBy(x => x.EventCode).ToList(); return(scheduleList); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
/// <summary> - Exist: check if user is exist. public static Users__tbl Exist(Users__tbl u) { try { using (projectDBEntities5 db = new projectDBEntities5()) { Users__tbl User = db.Users__tbl.Where(x => x.UserPassword == u.UserPassword && x.UserName == u.UserName).FirstOrDefault(); return(User); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
/// <summary> - GetAll: get list of users. public static List <Users__tbl> GetAll() { try { using (projectDBEntities5 db = new projectDBEntities5()) { List <Users__tbl> UserList = db.Users__tbl.Select(x => x).ToList(); return(UserList); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
public static Events__tbl GetEventByUserCode(int userCode) { try { using (projectDBEntities5 db = new projectDBEntities5()) { Events__tbl getEvent = db.Events__tbl.Where(x => x.UserCode == userCode).Select(x => x).FirstOrDefault(); return(getEvent); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
public static int GetCategoryCodeByBusinessCode(int code) { try { using (projectDBEntities5 db = new projectDBEntities5()) { var categoryCode = db.Business__tbl.Where(x => x.BusinessCode == code).Select(y => y.CategoryCode).FirstOrDefault(); return(Convert.ToInt32(categoryCode)); } } catch (Exception e) { Console.WriteLine(e); return(-1); } }
public static List <Business__tbl> GetBusinessByOwnerCode(string code) { try { using (projectDBEntities5 db = new projectDBEntities5()) { List <Business__tbl> BusinessList = db.Business__tbl.Where(x => x.BusinessOwnerCode == code).ToList(); return(BusinessList); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
public static int RemoveSchedule(string id) { try { using (projectDBEntities5 db = new projectDBEntities5()) { Schedule_tbl row = db.Schedule_tbl.Where(x => x.ScheduleId == id).Select(x => x).FirstOrDefault(); Schedule_tbl count = db.Schedule_tbl.Remove(row); db.SaveChanges(); return(1); } } catch (Exception e) { Console.WriteLine(e); return(0); } }
/// <summary> - GetLastScheduleId: get last row of schedule id in schedule list public static string GetLastScheduleId() { try { using (projectDBEntities5 db = new projectDBEntities5()) { string lastScheduleId = db.Schedule_tbl .OrderByDescending(x => x.ScheduleId) .Take(1).Select(x => x.ScheduleId).FirstOrDefault().ToString(); return(lastScheduleId); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
public static List <Category__tbl> GetAllCategory() { try { using (projectDBEntities5 db = new projectDBEntities5()) { List <Category__tbl> categoryList = db.Category__tbl. Include(c => c.Business__tbl). Include(c => c.Business__tbl.Select(b => b.Schedule_tbl)). Include(c => c.Business__tbl.Select(b => b.Schedule_tbl.Select(e => e.Events__tbl.Users__tbl))) .ToList(); return(categoryList); } } catch (Exception e) { Console.WriteLine(e); return(null); } }
/// <summary> - NewEvent: add new event in events tbl in db when user is register public static Events__tbl NewEvent(Events__tbl edal) { try { using (projectDBEntities5 db = new projectDBEntities5()) { Events__tbl newEvent = new Events__tbl { EventCode = edal.EventCode, UserCode = edal.UserCode, EventDate = edal.EventDate, GroomOrBride = edal.GroomOrBride }; db.Events__tbl.Add(newEvent); db.SaveChanges(); return(newEvent); } } catch (Exception e) { Console.WriteLine(e); return(null); } }