public ActionResult Create(DoctorPersonalInfoViewModel _doctorPersonalInfoVM)
{
try
{
if (ModelState.IsValid)
{
_doctorPersonalInfoVM.LoginId = Convert.ToInt32(Session["Doctor"]);
var existingUser = db.DoctorsPersonals.FirstOrDefault(u => u.LoginId == _doctorPersonalInfoVM.LoginId);
//Insert the remain data in DoctorPersonalInformation
var newDoctor = new DoctorPersonalInformation();
newDoctor.LoginId = Convert.ToInt32(Session["Doctor"]);
if (ReferenceEquals(existingUser, null))
{
newDoctor.MiddleName = _doctorPersonalInfoVM.MiddleName;
newDoctor.Qualification = _doctorPersonalInfoVM.Qualification;
newDoctor.Qualification1 = _doctorPersonalInfoVM.Qualification1;
newDoctor.RegistrationNo = _doctorPersonalInfoVM.RegistrationNo;
newDoctor.Affiliation = _doctorPersonalInfoVM.Affiliation;
newDoctor.AboutMe = _doctorPersonalInfoVM.AboutMe;
newDoctor.ExperienceInYear = _doctorPersonalInfoVM.ExperienceInYear;
newDoctor.ExperienceInMonth = _doctorPersonalInfoVM.ExperienceInMonth;
newDoctor.InactiveFlag = "N";
newDoctor.CreatedByID = 1;
newDoctor.CreatedDate = DateTime.Now;
newDoctor.ModifiedByID = 1;
newDoctor.ModifiedDate = DateTime.Now;
//insert if not exit
doctorPersonalInfoRepository.InsertDoctor(newDoctor);
doctorPersonalInfoRepository.Save();
}
else
{
existingUser.MiddleName = _doctorPersonalInfoVM.MiddleName;
existingUser.Qualification = _doctorPersonalInfoVM.Qualification;
existingUser.Qualification1 = _doctorPersonalInfoVM.Qualification1;
existingUser.RegistrationNo = _doctorPersonalInfoVM.RegistrationNo;
existingUser.Affiliation = _doctorPersonalInfoVM.Affiliation;
existingUser.AboutMe = _doctorPersonalInfoVM.AboutMe;
existingUser.ExperienceInYear = _doctorPersonalInfoVM.ExperienceInYear;
existingUser.ExperienceInMonth = _doctorPersonalInfoVM.ExperienceInMonth;
existingUser.InactiveFlag = "N";
existingUser.CreatedByID = 1;
existingUser.CreatedDate = DateTime.Now;
existingUser.ModifiedByID = 1;
existingUser.ModifiedDate = DateTime.Now;
existingUser.LoginId = Convert.ToInt32(Session["Doctor"]);
//Update if already exit
doctorPersonalInfoRepository.UpdateDoctorPersonalInfo(existingUser);
doctorPersonalInfoRepository.Save();
}
//find the data in table using loginId
var existUserlogin = db.UserLogins.FirstOrDefault(u => u.LoginId == newDoctor.LoginId);
existUserlogin.FirstName = _doctorPersonalInfoVM.FirstName;
existUserlogin.LastName = _doctorPersonalInfoVM.LastName;
existUserlogin.EmailID = _doctorPersonalInfoVM.EmailID;
existUserlogin.UserPhone = _doctorPersonalInfoVM.UserPhone;
doctorPersonalInfoRepository.UpdateDocUserLogin(existUserlogin);
doctorPersonalInfoRepository.Save();
//find the data in table using loginId
var ExistUserLogSpeciality = db.UserLoginSpecialitys.FirstOrDefault(u => u.LoginId == newDoctor.LoginId);
ExistUserLogSpeciality.SpecialityID = _doctorPersonalInfoVM.SpecialityID;
doctorPersonalInfoRepository.UpdateDocSpeciality(ExistUserLogSpeciality);
doctorPersonalInfoRepository.Save();
@TempData["SuccessMessage"] = "Succsessfully save data";
}
}
catch (Exception)
{
// ModelState.AddModelError(string.Empty, "Unable to save changes. Try again, and if the problem persists contact your system administrator.");
@TempData["Message"] = "Unable to save changes. Try again, and if the problem persists contact your system administrator.";
}
return(RedirectToAction("Create"));
}
public ActionResult Create(DoctorPersonalInfoViewModel _doctorPersonalInfoVM, HttpPostedFileBase file)
{
try
{
ModelState.Clear();
if (ModelState.IsValid)
{
_doctorPersonalInfoVM.LoginId = Convert.ToInt32(Session["EditDoctor"]);
var existingUser = db.DoctorsPersonals.FirstOrDefault(u => u.LoginId == _doctorPersonalInfoVM.LoginId);
//Insert the remain data in DoctorPersonalInformation
var newDoctor = new DoctorPersonalInformation();
newDoctor.LoginId = Convert.ToInt32(Session["EditDoctor"]);
if (ReferenceEquals(existingUser, null))
{
if (!ReferenceEquals(newDoctor.MiddleName, null))
{
newDoctor.MiddleName = _doctorPersonalInfoVM.MiddleName;
}
newDoctor.Qualification = _doctorPersonalInfoVM.Qualification;
if (!ReferenceEquals(newDoctor.Qualification1, null))
{
newDoctor.Qualification1 = _doctorPersonalInfoVM.Qualification1;
}
newDoctor.RegistrationNo = _doctorPersonalInfoVM.RegistrationNo;
if (!ReferenceEquals(newDoctor.Affiliation, null))
{
newDoctor.Affiliation = _doctorPersonalInfoVM.Affiliation;
}
if (!ReferenceEquals(newDoctor.AboutMe, null))
{
newDoctor.AboutMe = _doctorPersonalInfoVM.AboutMe;
}
if (!ReferenceEquals(newDoctor.ExperienceInYear, null))
{
newDoctor.ExperienceInYear = _doctorPersonalInfoVM.ExperienceInYear;
}
if (!ReferenceEquals(newDoctor.ExperienceInMonth, null))
{
newDoctor.ExperienceInMonth = _doctorPersonalInfoVM.ExperienceInMonth;
}
newDoctor.InactiveFlag = "N";
newDoctor.CreatedByID = 1;
newDoctor.CreatedDate = DateTime.Now;
newDoctor.ModifiedByID = 1;
newDoctor.ModifiedDate = DateTime.Now;
if (file != null)
{
string[] formats = new string[] { "image/jpeg", "image/png", "image/gif", "image/Bmp" };
int CheckImgType = Convert.ToInt32(formats.Contains(file.ContentType));
if (CheckImgType != 0)
{
string Imgpath = "~/Media/" + file.FileName;
string path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Media/") + file.FileName);
file.SaveAs(path);
newDoctor.FolderFilePath = Imgpath;
newDoctor.UploadType = file.ContentType;
}
}
//insert if not exit
doctorPersonalInfoRepository.InsertDoctor(newDoctor);
doctorPersonalInfoRepository.Save();
}
else
{
existingUser.MiddleName = _doctorPersonalInfoVM.MiddleName;
existingUser.Qualification = _doctorPersonalInfoVM.Qualification;
existingUser.Qualification1 = _doctorPersonalInfoVM.Qualification1;
existingUser.RegistrationNo = _doctorPersonalInfoVM.RegistrationNo;
existingUser.Affiliation = _doctorPersonalInfoVM.Affiliation;
existingUser.AboutMe = _doctorPersonalInfoVM.AboutMe;
existingUser.ExperienceInYear = _doctorPersonalInfoVM.ExperienceInYear;
existingUser.ExperienceInMonth = _doctorPersonalInfoVM.ExperienceInMonth;
existingUser.InactiveFlag = "N";
existingUser.CreatedByID = 1;
existingUser.CreatedDate = DateTime.Now;
existingUser.ModifiedByID = 1;
existingUser.ModifiedDate = DateTime.Now;
existingUser.LoginId = Convert.ToInt32(Session["EditDoctor"]);
if (file != null)
{
string[] formats = new string[] { "image/jpeg", "image/png", "image/gif", "image/Bmp" };
int CheckImgType = Convert.ToInt32(formats.Contains(file.ContentType));
if (CheckImgType != 0)
{
string Imgpath = "~/Media/" + file.FileName;
string path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Media/") + file.FileName);
file.SaveAs(path);
existingUser.FolderFilePath = Imgpath;
existingUser.UploadType = file.ContentType;
}
}
//Update if already exit
doctorPersonalInfoRepository.UpdateDoctorPersonalInfo(existingUser);
doctorPersonalInfoRepository.Save();
}
//find the data in Login table using loginId
var NewUserlogin = db.UserLogins.FirstOrDefault(x => x.LoginId == newDoctor.LoginId);
NewUserlogin.FirstName = _doctorPersonalInfoVM.FirstName;
NewUserlogin.LastName = _doctorPersonalInfoVM.LastName;
NewUserlogin.EmailID = _doctorPersonalInfoVM.EmailID;
NewUserlogin.UserPhone = _doctorPersonalInfoVM.UserPhone;
doctorPersonalInfoRepository.UpdateDocUserLogin(NewUserlogin);
doctorPersonalInfoRepository.Save();
ViewBag.Message1 = "Record Update Succsessfully ..";
//find the data in Login_Speciality table using loginId
var NewUserLogSpeciality = db.UserLoginSpecialitys.FirstOrDefault(x => x.LoginId == newDoctor.LoginId);
NewUserLogSpeciality.SpecialityID = _doctorPersonalInfoVM.SpecialityID;
doctorPersonalInfoRepository.UpdateDocSpeciality(NewUserLogSpeciality);
doctorPersonalInfoRepository.Save();
// ViewBag.Message2 = " Update Login Speciality Succsessfully ..";
@TempData["SuccessMessage"] = "Record Saved Successfully";
}
}
catch (DbEntityValidationException ex)
{
// ModelState.AddModelError(string.Empty, "Unable to save changes. Try again, and if the problem persists contact your system administrator.");
var errorMessages = string.Join("; ", ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage));
// var newException = new FormattedDbEntityValidationException(ex);
@TempData["Message"] = errorMessages;
return(RedirectToAction("Create", "DoctorInfo"));
}
return(RedirectToAction("Create", "DoctorClinicInfo"));
}
public void UpdateDoctor(DoctorPersonalInformation Doctor)
{
DBcontext.Entry(Doctor).State = EntityState.Modified;
}
public void DeleteDoctor(int DoctorId)
{
DoctorPersonalInformation Doctors = DBcontext.DoctorsPersonals.Find(DoctorId);
DBcontext.DoctorsPersonals.Remove(Doctors);
}
public void InsertDoctor(DoctorPersonalInformation Doctor)
{
DBcontext.DoctorsPersonals.Add(Doctor);
}
