//עדכון משתמש 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 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; } }