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