public static List <GetRequestByDay_Result> GetRequestByDay(long DayId)
{
using (var db = new EZER_LAYOLEDETEntities())
{
return(db.GetRequestByDay(DayId).ToList());
}
}
public static List <Users> selectUser()
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
return(db.Users.ToList());
}
}
public static List <VolunteerApproval_Result> VolunteerApproval(long ServiceManagmentId, long VolunteerId)
{
using (var db = new EZER_LAYOLEDETEntities())
{
return(db.VolunteerApproval(ServiceManagmentId, VolunteerId).ToList());
}
}
public static int GetNumOfMothers()
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
return(db.Mother.Count());
}
}
public static List <selectMotherByServiceAndDay_Result> selectMotherByServiceAndDay(long VolunteerId)
{
using (var db = new EZER_LAYOLEDETEntities())
{
return(db.selectMotherByServiceAndDay(VolunteerId).ToList());
}
}
public static List <Birth> CheckTimeOfBirth()
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
return(db.Birth.ToList());
}
}
public static List <GetRequestByService_Result> GetByService(long ServiceId)
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
return(db.GetRequestByService(ServiceId).ToList());
}
}
public static List <AllRequest_Result> GetAllReques()
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
return(db.AllRequest().ToList());
}
}
public static Users selectUserById(long id)
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
return(db.Users.FirstOrDefault(w => w.UserId == id));
}
}
public static List <SelectVolunteerByServiceNew_Result> SelectByService(long VolunteerId)
{
using (var db = new EZER_LAYOLEDETEntities())
{
return(db.SelectVolunteerByServiceNew(VolunteerId).ToList());
}
}
public static string GetDay(int id)
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var d = db.Days.FirstOrDefault(w => w.DayId == id);
return(d.Describe);
}
}
public static int GetStatusRequest(long ServiceManagmentId)
{
using (var db = new EZER_LAYOLEDETEntities())
{
var a = db.ServiceManagementToBirth.FirstOrDefault(w => w.ServiceManagementId == ServiceManagmentId);
return(a.StatusRequest);
}
}
public static void UpdateUsersActive(long MotherId)
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var a = db.Users.FirstOrDefault(w => w.UserId == MotherId);
a.Active = 0;
db.SaveChanges();
}
}
public static List <ServiceManagementToBirth> CheckActiveRequest(long BirthId)
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var selectByBirth =
from ServiceManagementToBirth in db.ServiceManagementToBirth
where ServiceManagementToBirth.BirthId == BirthId && ServiceManagementToBirth.StatusRequest == 1
select new { StatusRequest = ServiceManagementToBirth.StatusRequest };
return((List <ServiceManagementToBirth>)selectByBirth);
}
}
public static long PostServiceAndDayVolunteer(List <ServiceAndDaysToVolunteer> d)
{
using (var db = new EZER_LAYOLEDETEntities())
{
foreach (var item in d)
{
db.ServiceAndDaysToVolunteer.Add(item);
db.SaveChanges();
UserId = item.UserId;
}
return(UserId);
}
}
public static long AddBirth(Birth birth)
{
try
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var newBirth = db.Birth.Add(birth);
db.SaveChanges();
return(newBirth.UserId);
}
}
catch
{
throw;
}
}
public static void AddServiceVolunteerToBirth(ServiceVolunteerToBirth s)
{
try
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var q1 = db.ServiceVolunteerToBirth.Add(s);
db.SaveChanges();
// return q1.MotherId;
}
}
catch
{
throw;
}
}
public static int UpdatePassword(Users u, string pass)
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var q2 = db.Users.FirstOrDefault(w => w.UserId == u.UserId);
if (q2 == null)
{
return(0);
}
else
{
q2.Password = pass;
return(db.SaveChanges());
}
}
}
public static int AddUser(Users u)
{
try
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var q1 = db.Users.Add(u);
db.SaveChanges();
return((int)q1.UserId);
}
}
catch
{
throw;
}
}
public static void ChangeUserActiveAndStatusRequest(long MotherId)
{
List <ServiceManagementToBirth> b = new List <ServiceManagementToBirth>();
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var a = db.Users.FirstOrDefault(w => w.UserId == MotherId);
a.Active = 0;
var c = db.Birth.FirstOrDefault(w => w.UserId == MotherId);
var e = c.BirthId;
b = db.ServiceManagementToBirth.Where(w => w.BirthId == e).ToList();
foreach (var item in b)
{
item.StatusRequest = 0;
}
}
}
public static int UpdateUsers(Users u)
{
try
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var q2 = db.Users.FirstOrDefault(w => w.UserId == u.UserId);
if (q2 == null)
{
return(0);
}
else
{
// db.Users.Attach(u);
// db.Entry(u).State = EntityState.Modified;
q2.UserId = u.UserId;
q2.RoleId = u.RoleId;
q2.FirstName = u.FirstName;
q2.LastName = u.LastName;
q2.Password = u.Password;
q2.Email = u.Email;
q2.Phone = u.Phone;
q2.Address = u.Address;
q2.NumOfHouse = u.NumOfHouse;
q2.Locality = u.Locality;
q2.BirthDate = u.BirthDate;
q2.Active = u.Active;
return(db.SaveChanges());
}
}
}
catch
{
throw;
}
}
public static long AddMother(Mother mother, Birth birth, Kosher kosher1 = null, Kosher kosher2 = null, Kosher kosher3 = null)
{
try
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var user = db.Users.Add(mother.Users);
//var newKosher1 = db.Kosher.Add(kosher1);
//var newKosher2 = db.Kosher.Add(kosher2);
//var newKosher3 = db.Kosher.Add(kosher3);
var newMother = db.Mother.Add(mother);
//db.SaveChanges();
var newBirth = db.Birth.Add(birth);
newMother.Birth.Add(newBirth);
//newMother.Users = user;
//newMother.UserId = user.UserId;
//newMother.Kosher1 = newKosher1.KosherId;
//newMother.Kosher2 = newKosher2.KosherId;
//newMother.Kosher3 = newKosher3.KosherId;
//newMother.Kosher = newKosher1;
//newMother.Kosher4 = newKosher2;
//newMother.Kosher5 = newKosher3;
db.SaveChanges();
return(newMother.UserId);
}
}
catch (Exception ex)
{
throw new Exception();
}
}
public static int AddVolunteer(Users userToAdd)
{
try
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var user = db.Users.Add(userToAdd);
var volunteerToAdd = new Volunteer
{
UserId = user.UserId
};
var volunteer = db.Volunteer.Add(volunteerToAdd);
//var Day = db.DaysToVolunteer.Add(v.DaysToVolunteer);
//var Service = db.ServiceToVolunteer.Add(v.ServiceToVolunteer);
db.SaveChanges();
return((int)user.UserId);
}
}
catch
{
throw;
}
}
public static int DeleteUser(int id)
{
try
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var q3 = db.Users.FirstOrDefault(w => w.UserId == id);
if (q3 == null)
{
return(0);
}
else
{
db.Users.Remove(q3);
db.SaveChanges();
return(1);
}
}
}
catch
{
throw;
}
}
public static int UpdateRequest(long ServiceManagmentId)
{
try
{
using (EZER_LAYOLEDETEntities db = new EZER_LAYOLEDETEntities())
{
var q2 = db.ServiceManagementToBirth.FirstOrDefault(w => w.ServiceManagementId == ServiceManagmentId);
if (q2 == null)
{
return(0);
}
else
{
q2.StatusRequest = 0;
return(db.SaveChanges());
}
}
}
catch
{
throw;
}
}