//הוספת כלבים למשתמש
public void AddDogsForUser(UserDetailsView userDetails)
{
try
{
Entities context = new Entities();
for (int i = 0; i < userDetails.UserarrayDogs.Count; i++)
{
AddOneDogForUser(userDetails.UserarrayDogs[i]);
//UserDogs userDogs = new UserDogs();
//userDogs.DogBirthDate = userDetails.UserarrayDogs[i].DogBirthDate;
//userDogs.DogComments = userDetails.UserarrayDogs[i].DogComments;
//userDogs.DogDig = userDetails.UserarrayDogs[i].DogDig;
//userDogs.DogFriendlyWith = userDetails.UserarrayDogs[i].DogFriendlyWith;
//userDogs.DogGender = userDetails.UserarrayDogs[i].DogGender;
//userDogs.DogImage = userDetails.UserarrayDogs[i].DogImage;
//userDogs.DogJump = userDetails.UserarrayDogs[i].DogJump;
//userDogs.DogName = userDetails.UserarrayDogs[i].DogName;
//userDogs.DogNeuter = userDetails.UserarrayDogs[i].DogNeuter;
//userDogs.DogRabiesVaccine = userDetails.UserarrayDogs[i].DogRabiesVaccine;
//userDogs.DogShvav = userDetails.UserarrayDogs[i].DogShvav;
//userDogs.DogStatus = 21;
//userDogs.DogType = userDetails.UserarrayDogs[i].DogType;
//userDogs.DogUserID = userDetails.UserID;
//context.UserDogs.Add(userDogs);
//context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
//שליפת משתמש
public UserDetailsView GetUser(int userid)
{
try
{
UserDetailsView userDetails = null;
Entities context = new Entities();
var User = context.UsersTbl
.Where(user => user.UserID == userid && user.UserStatusCode != 22).FirstOrDefault();
if (User != null)
{
userDetails = new UserDetailsView();
userDetails.Acceptmessages = User.Acceptmessages;
userDetails.DaysSumForDiscount = User.DaysSumForDiscount;
userDetails.UserFirstName = User.UserFirstName;
userDetails.UserLastName = User.UserLastName;
userDetails.UserEmail = User.UserEmail;
userDetails.UserID = User.UserID;
userDetails.UserPhone2 = User.UserPhone2;
userDetails.UserPhone1 = User.UserPhone1;
userDetails.UserComments = User.UserComments;
userDetails.UserCity = User.UserCity;
userDetails.UserAddress = User.UserAddress;
var dogs = context.UserDogs
.Where(userDog => userDog.DogUserID == User.UserID).Count();
userDetails.DogsNumber = dogs;
var reservations = context.OrdersTbl
.Where(userres => userres.OrderUserId == User.UserID).Count();
userDetails.ReservationsNumber = context.OrdersTbl.Count();
userDetails.UserName = User.UserName;
userDetails.UserStatusCode = User.UserStatusCode;
var vet = context.veterinarTbl
.Where(v => v.VeterinarId == User.UserVeterinarId).FirstOrDefault();
userDetails.UserVeterinarId = User.UserVeterinarId;
userDetails.VeterinarAddress = vet.VeterinarAddress;
userDetails.VeterinarCity = vet.VeterinarCity;
userDetails.VeterinarEmail = vet.VeterinarEmail;
userDetails.VeterinarName = vet.VeterinarName;
userDetails.VeterinarPhone1 = vet.VeterinarPhone1;
// GetUserDogs(userDetails); //שליפת כלבים למשתמש
// OrderService orderService = new OrderService();
// orderService.GetUserOrders(userDetails);//שליפת הזמנות למשתמש
// HttpContext.Current.Session["userDetails"] = userDetails;
}
return(userDetails);
}
catch (Exception ex)
{
throw ex;
}
}
public List <DogDetailsView> GetUserDogs(int userid)
{
try
{
UserDetailsView userDetailsView = new UserDetailsView(userid);
GetUserDogs(userDetailsView);
return(userDetailsView.UserarrayDogs);
}
catch (Exception ex)
{
throw ex;
}
}
//+כלבים שלו שליפת משתמש
public UserDetailsView GetUserWithDogs(string usereMail, string password)
{
// Entities context = new Entities();
// var User = context.UsersTbl
//.Where(user => user.UserEmail == usereMail && user.UserPaswrd == password).FirstOrDefault();
// if (User != null)
// {
// userDetails = new UserDetailsView();
// userDetails.UserFirstName = User.UserFirstName;
// userDetails.UserLastName = User.UserLastName;
// userDetails.UserEmail = User.UserEmail;
// userDetails.UserID = User.UserID;
// userDetails.UserPhone2 = User.UserPhone2;
// userDetails.UserPhone1 = User.UserPhone1;
// userDetails.UserComments = User.UserComments;
// userDetails.UserCityName = User.UserCity;
// userDetails.UserAddress = User.UserAddress;
// var dogs = context.UserDogs
// .Where(userDog => userDog.DogUserID == User.UserID).Count();
// userDetails.DogsNumber = dogs;
// var reservations = context.OrdersTbl
// .Where(userres => userres.OrderUserId == User.UserID).Count();
// userDetails.ReservationsNumber = context.OrdersTbl.Count();
try
{
UserDetailsView userDetails = GetUser(usereMail, password);
GetUserDogs(userDetails); //שליפת כלבים למשתמש
// HttpContext.Current.Session["userDetails"] = userDetails;
return(userDetails);
}
catch (Exception ex)
{
throw ex;
}
}
//עדכון משתמש
public void UpdateUserDetails(UserDetailsView userDetails)
{
try
{
using (Entities context = new Entities())
{
var user = context.Set <UsersTbl>().Find(userDetails.UserID);
userDetails.UserPaswrd = user.UserPaswrd;
//
//{
veterinarService veterinarService = new veterinarService();
VeterinarDetailsView vet = veterinarService.GetVet(userDetails.VeterinarName, userDetails.VeterinarPhone1);
if (vet == null) //אם עדין אין במאגר וטרינר כזה
{
veterinarTbl veterinarTbl = new veterinarTbl();
veterinarTbl.VeterinarAddress = userDetails.VeterinarAddress;
veterinarTbl.VeterinarCity = userDetails.VeterinarCity;
veterinarTbl.VeterinarEmail = userDetails.VeterinarEmail;
veterinarTbl.VeterinarName = userDetails.VeterinarName;
veterinarTbl.VeterinarPhone1 = userDetails.VeterinarPhone1;
context.veterinarTbl.Add(veterinarTbl);
context.SaveChanges();
// vet = veterinarService.GetVet(userDetails.VeterinarName, userDetails.VeterinarPhone1);
//userDetails.UserVeterinarId = vet.VeterinarId;
}
//}
//if (user.UserVeterinarId != userDetails.UserVeterinarId) //שינה את הוטרינר
//{
vet = veterinarService.GetVet(userDetails.VeterinarName, userDetails.VeterinarPhone1);
userDetails.UserVeterinarId = vet.VeterinarId;
//}
context.Entry(user).CurrentValues.SetValues(userDetails);
context.SaveChanges();
}
}
catch (SqlException ex)
{ throw ex; }
finally
{ }
}
public UserDetailsView GetUserOrders(int UserID)
{
UserDetailsView userDetails = new UserDetailsView();
// שליפת כל ההזמנות מטבלתOrdersTbl
try
{
Userservice userservice = new Userservice();
userDetails = userservice.GetUser(UserID);
OrdersForUserView ordersForUserView = GetUserOrdersList(UserID);
userDetails.UserReservations = ordersForUserView.UserReservations;
return(userDetails);
}
catch (Exception ex)
{
throw ex;
}
}
private static UserDetailsView getUserDetails(Entities context, UsersTbl User)
{
try
{
UserDetailsView userDetails = new UserDetailsView();
userDetails.DaysSumForDiscount = User.DaysSumForDiscount;
userDetails.Acceptmessages = User.Acceptmessages;
userDetails.UserFirstName = User.UserFirstName;
userDetails.UserLastName = User.UserLastName;
userDetails.UserEmail = User.UserEmail;
userDetails.UserID = User.UserID;
userDetails.UserPhone2 = User.UserPhone2;
userDetails.UserPhone1 = User.UserPhone1;
userDetails.UserComments = User.UserComments;
userDetails.UserCity = User.UserCity;
userDetails.UserAddress = User.UserAddress;
userDetails.UserName = User.UserName;
userDetails.UserStatusCode = User.UserStatusCode;
var vet = context.veterinarTbl
.Where(v => v.VeterinarId == User.UserVeterinarId).FirstOrDefault();
userDetails.UserVeterinarId = User.UserVeterinarId;
userDetails.VeterinarAddress = vet.VeterinarAddress;
userDetails.VeterinarCity = vet.VeterinarCity;
userDetails.VeterinarEmail = vet.VeterinarEmail;
userDetails.VeterinarName = vet.VeterinarName;
userDetails.VeterinarPhone1 = vet.VeterinarPhone1;
var dogs = context.UserDogs
.Where(userDog => userDog.DogUserID == User.UserID && userDog.DogStatus == 21).Count();
userDetails.DogsNumber = dogs;
var reservations = context.OrdersTbl
.Where(userres => userres.OrderUserId == User.UserID).Count();
userDetails.ReservationsNumber = context.OrdersTbl.Count();
//HttpContext.Current.Session["userDetails"] = userDetails;
return(userDetails);
}
catch (Exception ex)
{ throw ex; }
}
//שליפת כלבים למשתמש
private void GetUserDogs(UserDetailsView userDetails)
{
try
{
Entities context = new Entities();
var dogs = context.UserDogs.Where(p => p.DogUserID == userDetails.UserID && p.DogStatus == 21);
if (dogs != null)
{
userDetails.UserarrayDogs = new List <DogDetailsView>();
foreach (var dog in dogs)
{
DogDetailsView dogDetails = new DogDetailsView();
dogDetails.DogNumber = dog.DogNumber;
dogDetails.DogName = dog.DogName;
dogDetails.DogImage = dog.DogImage;
dogDetails.DogShvav = dog.DogShvav;
dogDetails.DogType = dog.DogType;
dogDetails.DogStatus = dog.DogStatus;
dogDetails.DogComments = dog.DogComments;
dogDetails.DogUserID = dog.DogUserID;
dogDetails.DogBirthDate = dog.DogBirthDate;
dogDetails.DogRabiesVaccine = dog.DogRabiesVaccine;
dogDetails.DogNeuter = dog.DogNeuter;
dogDetails.DogJump = (bool)dog.DogJump;
dogDetails.DogDig = (bool)dog.DogDig;
dogDetails.DogGender = dog.DogGender;
dogDetails.DogFriendlyWith = (int)dog.DogFriendlyWith;
userDetails.UserarrayDogs.Add(dogDetails);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
//שליפת משתמש
public UserDetailsView GetUser(string usereMail, string password)
{
try
{
UserDetailsView userDetails = null;
Entities context = new Entities();
var User = context.UsersTbl
.Where(user => user.UserEmail == usereMail && user.UserPaswrd == password && user.UserStatusCode != 22).FirstOrDefault();
if (User != null)
{
userDetails = getUserDetails(context, User);
}
return(userDetails);
}
catch (Exception ex)
{
throw ex;
}
}
private bool checkCityExist(UserDetailsView user, string City)
{
XmlService xmlService = new XmlService();
return(!xmlService.CheckCity(City));
}
private bool checkUserExist(UserDetailsView user, string mail)
{
Userservice userservice = new Userservice();
return(!userservice.GetUserByMail(mail));
}
//הוספת משתמש
public void InsertUserDetails(UserDetailsView userDetails)
{
try
{
using (Entities context = new Entities())
{
UsersTbl usersTbl = new UsersTbl();
usersTbl.UserAddress = userDetails.UserAddress;
usersTbl.UserCity = userDetails.UserCity;
usersTbl.UserComments = userDetails.UserComments;
usersTbl.UserEmail = userDetails.UserEmail;
usersTbl.UserFirstName = userDetails.UserFirstName;
usersTbl.UserLastName = userDetails.UserLastName;
usersTbl.UserPaswrd = userDetails.UserPaswrd;
usersTbl.UserPhone1 = userDetails.UserPhone1;
usersTbl.UserPhone2 = userDetails.UserPhone2;
usersTbl.UserStatusCode = 21;
usersTbl.UserName = userDetails.UserName;
usersTbl.Acceptmessages = userDetails.Acceptmessages;
usersTbl.DaysSumForDiscount = 0;
//int vet = GetVetID(userDetails.VeterinarName, userDetails.VeterinarPhone1);
//if (vet == 0) //אם עדין אין במאגר וטרינר כזה
//{
// veterinarTbl veterinarTbl = new veterinarTbl();
// veterinarTbl.VeterinarAddress = userDetails.VeterinarAddress;
// veterinarTbl.VeterinarCity = userDetails.VeterinarCity;
// veterinarTbl.VeterinarEmail = userDetails.VeterinarEmail;
// veterinarTbl.VeterinarName = userDetails.VeterinarName;
// veterinarTbl.VeterinarPhone1 = userDetails.VeterinarPhone1;
// context.veterinarTbl.Add(veterinarTbl);
// context.SaveChanges();
//}
veterinarService veterinarService = new veterinarService();
VeterinarDetailsView vet = veterinarService.GetVet(userDetails.VeterinarName, userDetails.VeterinarPhone1);
if (vet != null)
{
usersTbl.UserVeterinarId = vet.VeterinarId;
}
else
{
veterinarTbl veterinarTbl = new veterinarTbl();
veterinarTbl.VeterinarAddress = userDetails.VeterinarAddress;
veterinarTbl.VeterinarCity = userDetails.VeterinarCity;
veterinarTbl.VeterinarEmail = userDetails.VeterinarEmail;
veterinarTbl.VeterinarName = userDetails.VeterinarName;
veterinarTbl.VeterinarPhone1 = userDetails.VeterinarPhone1;
context.veterinarTbl.Add(veterinarTbl);
context.SaveChanges();
vet = veterinarService.GetVet(userDetails.VeterinarName, userDetails.VeterinarPhone1);
usersTbl.UserVeterinarId = vet.VeterinarId;
}
context.UsersTbl.Add(usersTbl);
context.SaveChanges();
}
}
catch (SqlException ex)
{ throw ex; }
}
