//עדכון משתמש
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 VeterinarDetailsView GetVet(string vetName, string vetPhone)
{
try
{
Entities context = new Entities();
VeterinarDetailsView veterinarD = null;
var veterinar = context.veterinarTbl
.Where(v => v.VeterinarName == vetName && v.VeterinarPhone1 == vetPhone).FirstOrDefault();
if (veterinar != null)
{
veterinarD = new VeterinarDetailsView();
veterinarD.VeterinarName = veterinar.VeterinarName;
veterinarD.VeterinarPhone1 = veterinar.VeterinarPhone1;
veterinarD.VeterinarId = veterinar.VeterinarId;
}
return(veterinarD);
}
catch (Exception ex)
{
throw ex;
}
}
//הוספת משתמש
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; }
}
