//פונקציה זו מוסיפה מתנדב חדש למאגר public static int Register(ValunteerDto valunteerDto) { try { Valunteer valunteer = ValunteerDto.convertDtoToDB(valunteerDto); //להכניס את פרטי העיר Valunteer v = db.Valunteers.FirstOrDefault(f => f.tz == valunteer.tz); if (v != null) { return(3); } if (valunteer.tz.Equals('0') || valunteer.firstName.Equals('0') || valunteer.lastName.Equals('0') || valunteer.phone.Equals('0')) { return(0); } valunteer.PersonalSituation = db.PersonalSituations.First(p => p.personalSituationId == valunteer.personalSituationId); valunteer.DetailsValunteer = new DetailsValunteer(); valunteer.DetailsValunteer.statusValunteerId = db.StatusValunteers.FirstOrDefault(p => p.discribeStatusValunteer == "פעיל").statusValunteerId; valunteer.DetailsValunteer.silencingRingingFronDate = DateTime.Now; valunteer.DetailsValunteer.silencingRingingUntilDate = DateTime.Now; db.Valunteers.Add(valunteer); db.SaveChanges(); return(1); } catch (Exception ex) { return(0); } }
//פונקציה זו מחזירה את פרטי המנדב לפי ת.ז public static ValunteerDto getDetailsVolunteer(string volunteerTz) { Valunteer valunteer = db.Valunteers.FirstOrDefault(f => f.tz == volunteerTz); //valunteer.DetailsValunteer = db.DetailsValunteers.FirstOrDefault(f => f. == valunteer.id); return(DTO.ValunteerDto.convertDBToDto(valunteer)); }
public static bool option(string valunteerTz, int num) { try { Valunteer valen = db.Valunteers.First(p => p.tz == valunteerTz); valen.cityId = num; db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public static ValunteerDto convertDBToDto(Valunteer valunteer) { return(new ValunteerDto() { cityId = valunteer.cityId, firstName = valunteer.firstName, lastName = valunteer.lastName, personalSituationId = valunteer.personalSituationId, phone = valunteer.phone, tz = valunteer.tz, hieghtPointAddress = valunteer.hieghtPointAddress, widthPointAddress = valunteer.widthPointAddress, VolunteerDetail = DetailsValunteerDto.convertDBToDto(valunteer.DetailsValunteer), addressVolunteer = valunteer.addressVolunteer }); }