public static bool UpdateDoctor(DoctorModel model)
{
using (TransactionScope ts = new TransactionScope())
{
using (LinqDBDataContext data = new LinqDBDataContext())
{
string workingDay = "";
foreach (int wd in model.WorkingDay)
{
workingDay = workingDay + wd + ',';
}
if (workingDay.Length > 0)
{
workingDay = workingDay.Substring(0, workingDay.Length - 1);
}
Doctor doctor = (from d in data.Doctors
where d.Doctor_ID == model.DoctorID
select d).SingleOrDefault();
if (doctor != null)
{
doctor.First_Name = model.FirstName;
doctor.Last_Name = model.LastName;
doctor.Gender = model.Gender == 1 ? true : false;
doctor.Degree = model.Degree;
doctor.Experience = model.Experience;
doctor.Working_Day = string.IsNullOrEmpty(workingDay) ? null : workingDay;
doctor.Is_Active = true;
data.SubmitChanges();
var dsList = (from ds in data.Doctor_Specialities
where ds.Doctor_ID == doctor.Doctor_ID
select ds);
data.Doctor_Specialities.DeleteAllOnSubmit(dsList);
data.SubmitChanges();
foreach (int specilityId in model.SpecialityList)
{
Doctor_Speciality ds = new Doctor_Speciality()
{
Doctor_ID = doctor.Doctor_ID,
Speciality_ID = specilityId,
Is_Active = true
};
data.Doctor_Specialities.InsertOnSubmit(ds);
data.SubmitChanges();
}
if (!string.IsNullOrEmpty(model.PhotoFilePath))
{
Photo photo = (from p in data.Photos
where p.Doctor_ID == doctor.Doctor_ID
select p).SingleOrDefault();
if (photo != null)
{
photo.File_Path = model.PhotoFilePath;
photo.Uploaded_Person = model.UploadedPerson;
data.SubmitChanges();
}
else
{
Photo newPhoto = new Photo()
{
File_Path = model.PhotoFilePath,
Caption = model.LastName + " " + model.FirstName,
Add_Date = DateTime.Now,
Doctor_ID = doctor.Doctor_ID,
Uploaded_Person = model.UploadedPerson,
Is_Active = true
};
data.Photos.InsertOnSubmit(newPhoto);
data.SubmitChanges();
}
}
}
ts.Complete();
}
}
return(true);
}
public static bool InsertDoctor(DoctorModel model)
{
using (TransactionScope ts = new TransactionScope())
{
using (LinqDBDataContext data = new LinqDBDataContext())
{
string workingDay = "";
foreach (int wd in model.WorkingDay)
{
workingDay = workingDay + wd + ',';
}
if (workingDay.Length > 0)
{
workingDay = workingDay.Substring(0, workingDay.Length - 1);
}
Doctor doctor = new Doctor()
{
First_Name = model.FirstName,
Last_Name = model.LastName,
Gender = model.Gender == 1 ? true : false,
Degree = model.Degree,
Experience = model.Experience,
Working_Day = string.IsNullOrEmpty(workingDay) ? null : workingDay,
Is_Active = true
};
data.Doctors.InsertOnSubmit(doctor);
data.SubmitChanges();
if (!string.IsNullOrEmpty(model.PhotoFilePath))
{
Photo photo = new Photo()
{
File_Path = model.PhotoFilePath,
Caption = model.LastName + " " + model.FirstName,
Add_Date = DateTime.Now,
Doctor_ID = doctor.Doctor_ID,
Uploaded_Person = model.UploadedPerson,
Is_Active = true
};
data.Photos.InsertOnSubmit(photo);
data.SubmitChanges();
}
foreach (int specilityId in model.SpecialityList)
{
Doctor_Speciality ds = new Doctor_Speciality()
{
Doctor_ID = doctor.Doctor_ID,
Speciality_ID = specilityId,
Is_Active = true
};
data.Doctor_Specialities.InsertOnSubmit(ds);
data.SubmitChanges();
}
Doctor_Hospital dh = new Doctor_Hospital()
{
Doctor_ID = doctor.Doctor_ID,
Hospital_ID = model.HospitalID,
Is_Active = true
};
data.Doctor_Hospitals.InsertOnSubmit(dh);
data.SubmitChanges();
ts.Complete();
}
}
return(true);
}
