public void DeleteDog(DogDetailsView dog)
{
try
{
using (Entities context = new Entities())
{
var dogt = context.Set <UserDogs>().Find(dog.DogNumber);
if (dog != null)
{
dog.DogStatus = 22;
context.Entry(dogt).CurrentValues.SetValues(dog);
context.SaveChanges();
}
else
{
throw new Exception();
}
context.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
//שליפת כל ההזמנות העתידיות של לקוח מסוים עם כלב מסוים
public List <OrderDetailsView> GetOrders(DogDetailsView dogDetailsView)
{
try
{
Entities context = new Entities();
List <OrderDetailsView> orderslist = GetAllOrdersAndDogs();
for (int i = orderslist.Count - 1; i >= 0; i--)
{
if (orderslist[i].Userid != dogDetailsView.DogUserID || orderslist[i].FromDate.CompareTo(DateTime.Now.Date) < 0 || orderslist[i].OrderStatus == 13 || orderslist[i].OrderStatus == 14)
{
orderslist.RemoveAt(i);
}
else
{
List <DogsInOrderView> l = orderslist[i].mDogs.Where(d => d.DogNumber == dogDetailsView.DogNumber).ToList();
if (l.Count == 0)
{
orderslist.RemoveAt(i);
}
}
}
return(orderslist);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// הוספת כלב למשתמש
/// </summary>
/// <param name="dog"></param>
public void AddOneDogForUser(DogDetailsView dog)
{
try
{
Entities context = new Entities();
UserDogs userDogs = new UserDogs();
userDogs.DogBirthDate = dog.DogBirthDate;
userDogs.DogComments = dog.DogComments;
userDogs.DogDig = dog.DogDig;
userDogs.DogFriendlyWith = dog.DogFriendlyWith;
userDogs.DogGender = dog.DogGender;
userDogs.DogImage = dog.DogImage;
userDogs.DogJump = dog.DogJump;
userDogs.DogName = dog.DogName;
userDogs.DogNeuter = dog.DogNeuter;
userDogs.DogRabiesVaccine = dog.DogRabiesVaccine;
userDogs.DogShvav = dog.DogShvav;
userDogs.DogStatus = 21;
userDogs.DogType = dog.DogType;
userDogs.DogUserID = dog.DogUserID;
context.UserDogs.Add(userDogs);
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void RemoveDogFromFutureRoomSetting(DogDetailsView dog)
{
try
{
using (Entities context = new Entities())
{
context.RoomSetting.RemoveRange(context.RoomSetting.Where(x => x.DogNumber == dog.DogNumber && x.RoomFromDate > DateTime.Now));
context.SaveChanges();
}
}
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;
}
}
private bool checkUserExist(DogDetailsView dog, int userid)
{
Userservice userservice = new Userservice();
return(userservice.GetUser(userid) != null);
}
private bool checkGenderValues(DogDetailsView dog, string gender)
{
return(gender == "זכר" || gender == "נקבה");
}
