private void SignInCommandExecute(object obj)
{
try
{
string password = (obj as PasswordBox).Password;
doctor = dataBaseService.FindDoctorCredentials(UserName, password);
patient = dataBaseService.FindPatientCredentials(UserName, password);
if (doctor != null)
{
DoctorView doctorView = new DoctorView(doctor);
login.Close();
doctorView.Show();
return;
}
else if (patient != null)
{
PatientView patientView = new PatientView(patient);
login.Close();
patientView.Show();
return;
}
else
{
MessageBox.Show("Wrong usename or password");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public ActionResult Details()
{
string un = TempData.Peek("username").ToString();
tblDoctor doctor = entities.tblDoctors.Where(d => d.username == un).FirstOrDefault();
return(View(doctor));
}
public ActionResult Edit(int id)
{
TempData["UpdateId"] = id;
tblDoctor ad = dc.tblDoctors.SingleOrDefault(ob => ob.DoctorId == id);
return(View(ad));
}
public ActionResult Save(tblDoctor Doctor)
{
if (Doctor.idDoctor == 0)
{
db.Database.ExecuteSqlCommand("INSERT INTO tblDoctor VALUES " +
"(@idEspecialidad, @nombre, @cedula, @fechanacimiento, @correo, @telefono, @direccion)",
new SqlParameter("idEspecialidad", Doctor.idEspecialidad),
new SqlParameter("nombre", Doctor.nombreDoctor),
new SqlParameter("cedula", Doctor.cedulaDoctor),
new SqlParameter("fechanacimiento", Doctor.fechaNacimientoDoctor),
new SqlParameter("correo", Doctor.correoDoctor),
new SqlParameter("telefono", Doctor.telefonoDoctor),
new SqlParameter("direccion", Doctor.direccionDoctor)
);
}
else
{
var elDoctor = db.tblDoctors.SqlQuery("SELECT * FROM tblDoctor WHERE idDoctor = " + Doctor.idDoctor).SingleOrDefault();
elDoctor.nombreDoctor = Doctor.nombreDoctor;
elDoctor.cedulaDoctor = Doctor.cedulaDoctor;
elDoctor.fechaNacimientoDoctor = Doctor.fechaNacimientoDoctor;
elDoctor.correoDoctor = Doctor.correoDoctor;
elDoctor.telefonoDoctor = Doctor.telefonoDoctor;
elDoctor.direccionDoctor = Doctor.direccionDoctor;
elDoctor.idEspecialidad = Doctor.idEspecialidad;
}
db.SaveChanges();
return(RedirectToAction("Index", "Doctor"));
}
public ActionResult DeleteConfirmed(int id)
{
tblDoctor tblDoctor = db.tblDoctors.Find(id);
db.tblDoctors.Remove(tblDoctor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id)
{
tblDoctor ad = dc.tblDoctors.SingleOrDefault(ob => ob.DoctorId == id);
dc.tblDoctors.Remove(ad);
dc.SaveChanges();
return(RedirectToAction("Index", "Doctor"));
}
public ActionResult Edit([Bind(Include = "Id,Name,Address,Office,Email,Telephone")] tblDoctor tblDoctor)
{
if (ModelState.IsValid)
{
db.Entry(tblDoctor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblDoctor));
}
public ActionResult Edit([Bind(Include = "Doctor_Id,Doctor_Name,Doctor_Surname,Doctor_Email,Doctor_ContactNO,Doctor_ID_NO,Doctor_Type,Doctor_Image,Doctor_Code")] tblDoctor tblDoctor)
{
if (ModelState.IsValid)
{
db.Entry(tblDoctor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblDoctor));
}
public ActionResult Create([Bind(Include = "Doctor_Id,Doctor_Name,Doctor_Surname,Doctor_Email,Doctor_ContactNO,Doctor_ID_NO,Doctor_Type,Doctor_Image,Doctor_Code")] tblDoctor tblDoctor)
{
if (ModelState.IsValid)
{
db.tblDoctors.Add(tblDoctor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblDoctor));
}
public ActionResult Create([Bind(Include = "Id,Name,Address,Office,Email,Telephone")] tblDoctor tblDoctor)
{
if (ModelState.IsValid)
{
db.tblDoctors.Add(tblDoctor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblDoctor));
}
public ActionResult Authenticate(LoginModel L)
{
tblLogin t = db.tblLogins.SingleOrDefault(x => (x.strEmail == L.Email && x.strPassword == L.Password));
if (t != null)
{
if (t.strPassword == L.Password)
{
Session["usertype"] = t.strUserType.ToLower();
Session["loginid"] = t.intLoginid;
Session["email"] = t.strEmail;
if (t.strUserType.ToLower() == "admin")
{
return(RedirectToAction("Index", "Admin"));
}
else if (t.strUserType.ToLower() == "doctor")
{
tblDoctor d = db.tblDoctors.SingleOrDefault(x => x.intLoginID == t.intLoginid);
if (d != null)
{
Session["doctorid"] = d.intDoctorID;
return(RedirectToAction("Index", "DoctorUser"));
}
else
{
ViewBag.Error = "Invalid Details";
}
}
else if (t.strUserType.ToLower() == "member")
{
tblMember T = db.tblMembers.SingleOrDefault(x => x.intLoginID == t.intLoginid);
if (T != null)
{
Session["memberid"] = T.intMemberID;
return(RedirectToAction("Index", "MemberUser"));
}
else
{
ViewBag.Error = "Invalid Details";
}
}
}
else
{
ViewBag.Error = "Invalid Details";
}
}
else
{
ViewBag.Error = "Invalid Details";
}
return(View());
}
public ActionResult Create(E_health_care.Models.DoctorRegister Dr, HttpPostedFileBase file)
{
string _FileName = "";
try
{
if (file.ContentLength > 0)
{
_FileName = Path.GetFileName(file.FileName);
string _path = Path.Combine(Server.MapPath("~/UploadedFiles"), _FileName);
file.SaveAs(_path);
}
ViewBag.Message = "File Uploaded Successfully!!";
}
catch
{
ViewBag.Message = "File upload failed!!";
}
E_health_careModels.LoginModel L = Dr.login;
L.UserType = "Doctor";
tblLogin ln = new tblLogin();
ln.intLoginid = L.Loginid;
ln.strEmail = L.Email;
ln.strPassword = L.Password;
ln.strUserType = L.UserType;
db.tblLogins.Add(ln);
db.SaveChanges();
DoctorModel D = Dr.doctor;
tblDoctor dr = new tblDoctor();
dr.intDoctorID = D.DoctorID;
dr.intLoginID = ln.intLoginid;
dr.strDoctorName = D.DoctorName;
dr.intTypeID = D.TypeID;
dr.strDetails = D.Details;
dr.strPhoto = _FileName;
db.tblDoctors.Add(dr);
db.SaveChanges();
return(RedirectToAction("Authenticate", "Login"));
}
public ActionResult Edit(FormCollection form)
{
int id = Convert.ToInt32(TempData["UpdateId"]);
tblDoctor ad = dc.tblDoctors.SingleOrDefault(ob => ob.DoctorId == id);
ad.FirstName = form["FirstName"];
ad.LastName = form["LastName"];
ad.Email = form["Email"];
ad.ContactNo = form["ContactNo"];
ad.Address = form["Address"];
dc.SaveChanges();
return(RedirectToAction("list"));
}
// GET: Doctors/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblDoctor tblDoctor = db.tblDoctors.Find(id);
if (tblDoctor == null)
{
return(HttpNotFound());
}
return(View(tblDoctor));
}
public JsonResult Active(int id)
{
tblDoctor ad = dc.tblDoctors.SingleOrDefault(ob => ob.DoctorId == id);
if (ad.IsActive == true)
{
ad.IsActive = false;
}
else
{
ad.IsActive = true;
}
dc.SaveChanges();
return(Json(ad.IsActive, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(int?id)
{
tblDoctor D = db.tblDoctors.SingleOrDefault(x => x.intDoctorID == id);
DoctorModel N = new DoctorModel()
{
DoctorID = D.intDoctorID,
LoginID = (int)D.intLoginID,
DoctorName = D.strDoctorName,
TypeID = (int)D.intTypeID,
Details = D.strDetails,
Photo = D.strPhoto,
};
return(View(N));
}
public ActionResult Edit(DoctorModel dm)
{
tblDoctor d = db.tblDoctors.SingleOrDefault(x => x.intDoctorID == dm.DoctorID);
if (d != null)
{
d.intDoctorID = dm.DoctorID;
d.intLoginID = dm.LoginID;
d.strDoctorName = dm.DoctorName;
d.intTypeID = dm.TypeID;
d.strDetails = dm.Details;
d.strPhoto = dm.Photo;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public void Add()
{
var tblDoctor = new tblDoctor
{
Specialty_Id = DSpecialtyId,
County_Id = DCountyId,
Doctor_Id = DDoctorId,
Name = DDoctorName,
Family = DDoctorFamily,
Sex = DSex,
Address = DAddress,
PhoneNumber = DPhoneNumber,
MobileNumber = DMobileNumber,
Description = DDescription
};
_dbVisitorEntities.tblDoctor.Add(tblDoctor);
_dbVisitorEntities.SaveChanges();
}
public ActionResult Add(FormCollection form, HttpPostedFileBase txtFile)
{
string name = "txtFile";
if (txtFile != null)
{
int size = (int)txtFile.ContentLength / 1024;
var extension = System.IO.Path.GetExtension(txtFile.FileName);
if (size <= 1024 && (extension.ToLower().Equals(".jpg") || extension.ToLower().Equals(".jpeg") || extension.ToLower().Equals(".png")))
{
name = code() + "" + extension;
string path = Server.MapPath("~/Areas/image/");
txtFile.SaveAs(path + "" + name);
}
}
tblDoctor ad = new tblDoctor();
ad.FirstName = form["FirstName"];
ad.LastName = form["LastName"];
ad.Password = form["Password"];
ad.Email = form["Email"];
ad.Gender = form["gen"];
ad.ContactNo = form["ContactNo"];
ad.DOB = Convert.ToDateTime(form["DOB"]);
ad.Address = form["Address"];
ad.CityID = Convert.ToInt32(form["ddCity"]);
ad.Degree = form["Degree"];
ad.YearOfExperience = Convert.ToInt32(form["YearOfExp"]);
ad.IsActive = true;
ad.IsVerified = true;
ad.IsMobileVerified = true;
ad.ApprovedBy = Convert.ToInt32(form["ApprovedBy"]);
ad.ApprovedOn = DateTime.Now;
ad.Specialization = form["Specialization"];
ad.ProfileImageUrl = name.ToString();
dc.tblDoctors.Add(ad);
dc.SaveChanges();
return(RedirectToAction("Index", "Doctor"));
//return View();
}
public AddDoctorViewModel(AddDoctorView doctorView)
{
addDoctor = doctorView;
doctor = new tblDoctor();
}
public DoctorViewModel(DoctorView doctorViewOpen, tblDoctor doctorInstance)
{
doctorView = doctorViewOpen;
Doctor = doctorInstance;
}
public DoctorView(tblDoctor doctorUser)
{
InitializeComponent();
DataContext = new DoctorViewModel(this, doctorUser);
tbDoctor.Text = "Doctor: " + doctorUser.UserName;
}
public ActionResult Detail(int id)
{
tblDoctor ad = dc.tblDoctors.SingleOrDefault(ob => ob.DoctorId == id);
return(View(ad));
}
public LoginViewModel(LoginView viewLogin)
{
login = viewLogin;
doctor = new tblDoctor();
}
