protected void Insert_Click(object sender, EventArgs e)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
try
{
Physician__Patient relation = new Physician__Patient();
relation.CP_ID = cpid;
relation.P_ID = pid;
relation.UpdatedBy = Profile.UserName;
relation.UpdateDateTime = DateTime.Now;
relation.UpdateUserName = Profile.Name;
myEntities.AddToPhysician__Patient(relation);
myEntities.SaveChanges();
}
catch (Exception ex)
{
Notification.Text = ex.Message;
}
}
Response.Redirect(String.Format("~/Hospital/PatientInfo/Physicians.aspx?PID={0}", RegID.Text));
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
try
{
int did = Convert.ToInt32(((Literal)e.Item.FindControl("DID")).Text);
var dept = from r in myEntities.Hospital__Department
where (r.D_ID == did && r.H_ID == hid)
select r;
myEntities.DeleteObject(dept.Single());
myEntities.SaveChanges();
}
catch (Exception ex)
{
notify = true;
note = ex.Message;
}
}
Response.Redirect("~/Hospital/Management/Departments.aspx");
}
}
protected void PhSearch_Click(object sender, EventArgs e)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
var hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
cpid = (from r in myEntities.Hospital__Physician
where (r.CP_ID == PhSearchBox.Text && r.H_ID == hid)
select r.CP_ID).SingleOrDefault();
if (cpid != null)
{
Result.Text = "ID: " + cpid + "\tName: " + Profile.GetProfile(cpid).Name;
ResultPanel.Visible = true;
Notification.Visible = false;
}
else
{
Notification.Text = "Physician with ID: " + PhSearch.Text + " does not exist, or is not " +
"attached to this hospital.";
Notification.Visible = true;
}
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
try
{
if (e.CommandName == "Delete")
{
string cp_id = ((Literal)e.Item.FindControl("CPID")).Text;
Physician__Patient cp = (from r in myEntities.Physician__Patient
where (r.CP_ID == cp_id && r.P_ID == pid)
select r).SingleOrDefault();
myEntities.DeleteObject(cp);
myEntities.SaveChanges();
}
Response.Redirect(String.Format("~/Hospital/PatientInfo/Physicians.aspx?PID={0}", pid));
}
catch (Exception ex)
{
//notify = true;
//note = ex.Message;
}
}
}
protected void Insert_Click(object sender, EventArgs e)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
try
{
Hospital__Physician relation = new Hospital__Physician();
relation.CP_ID = cpid;
relation.H_ID = hid;
relation.UpdatedBy = Profile.UserName;
relation.UpdateDateTime = DateTime.Now;
relation.UpdateUserName = Profile.Name;
myEntities.AddToHospital__Physician(relation);
myEntities.SaveChanges();
}
catch (Exception ex)
{
Notification.Text = ex.Message;
}
}
Response.Redirect("~/Hospital/Management/Physicians.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!User.IsInRole("Administrator") && !User.IsInRole("Hospital Superuser") && !User.IsInRole("Hospital Management"))
{
Response.Redirect("~/Account/Login.aspx");
}
else
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (hid == null)
{
hid = Profile.UserName;
}
}
}
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
Repeater1.DataSource = from r in myEntities.Hospital__Physician
join cp in myEntities.Physician__Profile on r.CP_ID equals cp.Physician_ID
where r.H_ID == hid
orderby r.CP_ID ascending
select new { r.CP_ID, cp.Name, r.Unit };
Repeater1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
pid = Request.QueryString.Get("PID");
if (!Page.IsPostBack && pid != null)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
// Select patient based on registration id
var p = (from r in myEntities.Patient__Profile
where r.Registration_ID == pid
select r).SingleOrDefault();
string hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (p != null && p.H_ID == hid)
{
RegID.Text = pid;
PName.Text = p.PatientName;
PBed.Text = (p.CurrentBedNo == null) ? "Unoccupied" : p.CurrentBedNo;
MultiView1.ActiveViewIndex = 0;
Diagnosis.Text = p.Diagnosis;
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
try
{
string cp_id = ((Literal)e.Item.FindControl("CPID")).Text;
Hospital__Physician cp = (from r in myEntities.Hospital__Physician
where r.CP_ID == cp_id && r.H_ID == hid
select r).SingleOrDefault();
switch (e.CommandName)
{
case "Delete":
myEntities.DeleteObject(cp);
myEntities.SaveChanges();
break;
case "Save":
cp.Unit = ((TextBox)e.Item.FindControl("CPUnit")).Text;
myEntities.SaveChanges();
break;
}
Response.Redirect("~/Hospital/Management/Physicians.aspx");
}
catch (Exception ex)
{
//notify = true;
//note = ex.Message;
}
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
try
{
string bed = ((Literal)e.Item.FindControl("Bed")).Text;
var beds = (from r in myEntities.Hospital__Bed
where (r.H_ID == hid && r.BedNo == bed)
select r).Single();
if (beds.Occupied == false)
{
myEntities.DeleteObject(beds);
}
myEntities.SaveChanges();
}
catch (Exception ex)
{
//notify = true;
//note = ex.Message;
}
}
Response.Redirect("~/Hospital/Management/Beds.aspx");
}
}
protected void Insert_Click(object source, EventArgs e)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
try
{
Hospital__Department relation = new Hospital__Department();
relation.D_ID = Convert.ToInt32(DSearchList.SelectedValue);
relation.H_ID = hid;
relation.UpdatedBy = Profile.UserName;
relation.UpdateDateTime = DateTime.Now;
relation.UpdateUserName = Profile.Name;
myEntities.AddToHospital__Department(relation);
myEntities.SaveChanges();
}
catch (Exception ex)
{
notify = true;
note = ex.Message;
}
}
Response.Redirect("~/Hospital/Management/Departments.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!User.IsInRole("Administrator") && !User.IsInRole("Hospital Superuser") && !User.IsInRole("Hospital Management"))
{
Response.Redirect("~/Account/Login.aspx");
}
else
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (hid == null)
{
hid = Profile.UserName;
}
}
}
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
// Select hospital profile by ID
var h = (from r in myEntities.Hospital__Profile
where r.Hospital_ID == hid
select r).SingleOrDefault();
// Initialize form from database
HospitalID.Text = h.Hospital_ID;
Name.Text = h.HospitalName;
SetLogo.Visible = String.IsNullOrEmpty(h.LogoUrl);
DeleteLogo.Visible = !String.IsNullOrEmpty(h.LogoUrl);
Logo.ImageUrl = h.LogoUrl;
ESTD.Text = h.ESTD.ToString();
Website.Text = h.Website;
Email.Text = h.Email;
Address.Text = h.Address;
City.Text = h.City;
Pincode.Text = h.Pincode;
State.Text = h.State;
Country.Text = h.Country;
Phone1.Text = h.Phone1;
Phone2.Text = h.Phone2;
Phone3.Text = h.Phone3;
Phone4.Text = h.Phone4;
Fax.Text = h.Fax;
}
}
}
protected void Save_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
Hospital__Staff profile;
if (sid != null)
{
profile = (from r in myEntities.Hospital__Staff
where r.Staff_ID == sid
select r).SingleOrDefault();
if (profile != null)
{
// Update profile information
profile.StaffName = Name.Text;
profile.PhotoURL = Photo.ImageUrl;
profile.Designation = Designation.Text;
profile.Qualification = Qualification.Text;
profile.RelevantInfo = Info.Text;
profile.Address = Address.Text;
profile.State = State.Text;
profile.Country = Country.Text;
profile.Pincode = Pincode.Text;
profile.Phone1 = Contact1.Text;
profile.Phone2 = Contact2.Text;
profile.Email = Email.Text;
profile.UpdateDateTime = DateTime.Now;
profile.UpdatedBy = Profile.UserName;
profile.UpdateUserName = Profile.Name;
myEntities.SaveChanges();
//Notification.Text = "Changes saved successfully.";
//System.Threading.Thread.Sleep(5000);
//Notification.Text = null;
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
}
Response.Redirect(String.Format("~/Hospital/Management/StaffProfile.aspx?SID={0}", StfID.Text));
}
protected void Search_Click(object sender, EventArgs e)
{
string PID = SearchBox.Text;
if (SearchBy.SelectedIndex == 1)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
PID = (from r in myEntities.Patient__Profile
where r.CurrentBedNo == PID
select r.Registration_ID).SingleOrDefault();
}
}
Response.Redirect(String.Format("~/Hospital/PatientInfo/Physicians.aspx?PID={0}", PID));
}
protected void Search_Click(object sender, EventArgs e)
{
string SID = SearchBox.Text;
if (SearchBy.SelectedIndex == 1)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
SID = (from r in myEntities.Hospital__Staff
where r.StaffName.Contains(SID)
select r.Staff_ID).FirstOrDefault();
}
}
Response.Redirect(String.Format("~/Hospital/Management/StaffProfile.aspx?SID={0}", SID));
}
protected void Search_Click(object sender, EventArgs e)
{
string pid = SearchBox.Text;
if (SearchBy.SelectedIndex == 1)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
pid = (from r in myEntities.Patient__Profile
where r.CurrentBedNo == pid
select r.Registration_ID).SingleOrDefault();
}
}
Response.Redirect(String.Format("~/ClinicalMonitoring/IntakeOutput.aspx?PID={0}", pid));
}
protected void StaffIDInvalid_ServerValidate(object source, ServerValidateEventArgs args)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
var profile = (from record in myEntities.Hospital__Staff
where record.Staff_ID == UserName.Text
select record).SingleOrDefault();
if (profile != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
}
protected void RegistrationIDInvalid_ServerValidate(object source, ServerValidateEventArgs args)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
var profile = (from record in myEntities.Patient__Profile
where record.Registration_ID == UserName.Text
select record).SingleOrDefault();
if (profile != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!User.IsInRole("Administrator") && !User.IsInRole("Hospital Superuser") && !User.IsInRole("Hospital Management"))
{
Response.Redirect("~/Account/Login.aspx");
}
else
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (hid == null)
{
hid = Profile.UserName;
}
}
}
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
var types = (from r in myEntities.Hospital__Bed
where r.H_ID == hid
select r.Type).Distinct();
var beds = from r in types
select new
{
type = r,
bno = from s in myEntities.Hospital__Bed
where (s.H_ID == hid && s.Type == r)
select new { s.BedNo }
};
Repeater2.DataSource = beds;
Repeater2.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!User.IsInRole("Administrator") && !User.IsInRole("Hospital Superuser") && !User.IsInRole("Hospital Management"))
{
Response.Redirect("~/Account/Login.aspx");
}
else
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (hid == null)
{
hid = Profile.UserName;
}
}
}
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
Repeater1.DataSource = from r in myEntities.Hospital__Department
join d in myEntities.Module__Department on r.D_ID equals d.Department_ID
where r.H_ID == hid
select new { d.Department_ID, d.Name };
Repeater1.DataBind();
}
if (notify == true)
{
Notification.Text = note;
notify = false;
}
else
{
Notification.Text = "";
}
}
}
protected void Add_Click(object sender, EventArgs e)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
Hospital__Bed bed = new Hospital__Bed();
bed.BedNo = BedNoA.Text;
bed.Type = TypeA.Text;
bed.H_ID = hid;
bed.Occupied = false;
bed.UpdateDateTime = DateTime.Now;
bed.UpdatedBy = Profile.UserName;
bed.UpdateUserName = Profile.Name;
myEntities.AddToHospital__Bed(bed);
myEntities.SaveChanges();
}
Response.Redirect("~/Hospital/Management/Beds.aspx");
}
protected void Save_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
Patient__Profile profile;
if (pid != null)
{
profile = (from r in myEntities.Patient__Profile
where r.Registration_ID == pid
select r).SingleOrDefault();
if (profile != null)
{
profile.Diagnosis = Diagnosis.Text;
profile.UpdateDateTime = DateTime.Now;
profile.UpdatedBy = Profile.UserName;
profile.UpdateUserName = Profile.Name;
myEntities.SaveChanges();
Notification.Text = "Changes saved successfully.";
System.Threading.Thread.Sleep(10000);
Notification.Text = null;
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!User.IsInRole("Administrator") && !User.IsInRole("Hospital Superuser") && !User.IsInRole("Hospital Management"))
{
Response.Redirect("~/Account/Login.aspx");
}
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
// Select Hospital based on current Staff ID
hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (hid == null)
{
hid = Profile.UserName;
}
}
}
}
protected void Add_Click(object sender, EventArgs e)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
try
{
Module__Department relation = new Module__Department();
relation.Name = AddDept.Text.Trim();
relation.UpdatedBy = Profile.UserName;
relation.UpdateDateTime = DateTime.Now;
relation.UpdateUserName = Profile.Name;
myEntities.AddToModule__Department(relation);
myEntities.SaveChanges();
}
catch (Exception ex)
{
notify = true;
note = ex.Message;
}
}
}
protected void Save_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
Hospital__Profile hospital = (from r in myEntities.Hospital__Profile
where r.Hospital_ID == hid
select r).SingleOrDefault();
// Update hospital information
hospital.Hospital_ID = HospitalID.Text;
hospital.HospitalName = Name.Text;
hospital.LogoUrl = Logo.ImageUrl;
hospital.ESTD = Convert.ToInt16(ESTD.Text);
hospital.Website = Website.Text;
hospital.Email = Email.Text;
hospital.Address = Address.Text;
hospital.City = City.Text;
hospital.Pincode = Pincode.Text;
hospital.State = State.Text;
hospital.Country = Country.Text;
hospital.Phone1 = Phone1.Text;
hospital.Phone2 = Phone2.Text;
hospital.Phone3 = Phone3.Text;
hospital.Phone4 = Phone4.Text;
Fax.Text = hospital.Fax;
hospital.UpdateDateTime = DateTime.Now;
hospital.UpdatedBy = Profile.UserName;
hospital.UpdateUserName = Profile.Name;
myEntities.SaveChanges();
}
}
Response.Redirect("~/Hospital/Management/EditInfo.aspx");
}
protected void Register_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
// Create account and assign role 'Patient'
string pswd = Password.Text;
if (RndPswd.Checked)
{
pswd = Membership.GeneratePassword(Membership.MinRequiredPasswordLength,
Membership.MinRequiredNonAlphanumericCharacters);
}
Membership.CreateUser(UserName.Text, pswd, Email.Text);
ProfileCommon pc = new ProfileCommon();
pc.Initialize(UserName.Text, true);
pc.Name = PatientName.Text;
pc.Save();
Roles.AddUserToRole(UserName.Text, "Patient");
// Send account confirmation email
string fileName = Server.MapPath("~/App_Data/AccountConfirmation.txt");
string mailBody = File.ReadAllText(fileName);
mailBody = mailBody.Replace("##Name##", PatientName.Text);
mailBody = mailBody.Replace("##Role##", "Patient");
mailBody = mailBody.Replace("##Username##", UserName.Text);
mailBody = mailBody.Replace("##Password##", pswd);
MailMessage emailMessage = new MailMessage();
emailMessage.Subject = "New Account Confirmation";
emailMessage.Body = mailBody;
emailMessage.From = new MailAddress("*****@*****.**", "NMHC");
emailMessage.To.Add(new MailAddress(Email.Text, PatientName.Text));
SmtpClient mySmtpClient = new SmtpClient();
mySmtpClient.Send(emailMessage);
// Register above patient
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
Patient__Profile profile = new Patient__Profile();
profile.Registration_ID = UserName.Text;
profile.PatientName = PatientName.Text;
profile.RegistrationDateTime = DateTime.Now;
profile.Email = Email.Text;
profile.H_ID = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
profile.UpdatedBy = Profile.UserName;
profile.UpdateUserName = Profile.Name;
profile.UpdateDateTime = profile.RegistrationDateTime;
myEntities.AddToPatient__Profile(profile);
myEntities.SaveChanges();
}
Notification.Text = "Your account has been created successfully. " +
"An email has been sent to " + Email.Text + " containing your Username and Password.";
}
catch (Exception ex)
{
Notification.Text = ex.Message;
Back.Visible = true;
Continue.Visible = false;
// Delete partially created user data in case of exception
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
var profile = (from r in myEntities.Patient__Profile
where r.Registration_ID == UserName.Text
select r).SingleOrDefault();
if (profile != null)
{
myEntities.Patient__Profile.DeleteObject(profile);
}
myEntities.SaveChanges();
}
if (Membership.GetUser(UserName.Text) != null)
{
Membership.DeleteUser(UserName.Text, true);
}
}
MultiView1.ActiveViewIndex = 1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
pid = Request.QueryString.Get("PID");
if (!Page.IsPostBack && pid != null)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
// Select patient based on registration id
var p = (from r in myEntities.Patient__Profile
where r.Registration_ID == pid
select r).SingleOrDefault();
string hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (p != null && p.H_ID == hid)
{
RegID.Text = pid;
PName.Text = p.PatientName;
PBed.Text = (p.CurrentBedNo == null) ? "Unoccupied" : p.CurrentBedNo;
MultiView1.ActiveViewIndex = 0;
// Select department ids having selected patient's hospital id
var dids = from r in myEntities.Hospital__Department
where r.H_ID == p.H_ID
select r.D_ID;
// Select department names corresponding to selected department ids
Department.DataSource = from d in myEntities.Module__Department
join i in dids on d.Department_ID equals i
orderby d.Name ascending
select d.Name;
Department.DataBind();
// Selext beds correspinding to selected patient's hospital id
var beds = (from r in myEntities.Hospital__Bed
where (r.H_ID == hid && (r.Occupied == false || r.BedNo == p.CurrentBedNo))
orderby r.BedNo ascending
select r.BedNo).ToList();
beds.Add("Unoccupied");
Bed.DataSource = beds;
Bed.DataBind();
// Initialize form from database
Department.SelectedValue = p.Department;
Bed.SelectedValue = (p.CurrentBedNo == null) ? "Unoccupied" : p.CurrentBedNo;
Name.Text = p.PatientName;
SetPicture.Visible = String.IsNullOrEmpty(p.PhotoURL);
DeletePicture.Visible = !String.IsNullOrEmpty(p.PhotoURL);
Photo.ImageUrl = p.PhotoURL;
Sex.SelectedValue = p.Sex;
AgeValue.Text = p.Age.ToString();
AgeUnit.SelectedValue = p.AgeUnit;
Weight.Text = p.BodyWeight.ToString();
Height.Text = p.Height.ToString();
MaritalStatus.SelectedValue = p.MaritalStatus;
Co.Text = p.C_o;
CoRelation.SelectedValue = p.C_o_Relation;
MotherName.Text = p.MothersName;
MLC.Text = p.MLC_No;
RName.Text = p.ReferredBy;
RContact.Text = p.RefContactNo;
PrevTreated.Checked = (p.IfPreviouslyTreated == true);
PrevID.Text = p.LastTreatedRegistration_ID;
Occupation.Text = p.Occupation;
Financing.Text = p.Financing;
LAddress.Text = p.LocalAddress;
LState.Text = p.LState;
LCountry.Text = p.LCountry;
LPincode.Text = p.LPincode;
LContact1.Text = p.LContactNo1;
LContact2.Text = p.LContactNo2;
LEmail.Text = p.Email;
PAddress.Text = p.PermanentAddress;
PState.Text = p.PState;
PCountry.Text = p.PCountry;
PPincode.Text = p.PPincode;
PContact1.Text = p.PContactNo1;
PContact2.Text = p.PContactNo2;
CName.Text = p.EmergencyContactPerson;
CRelation.Text = p.CPRelationship;
CAddress.Text = p.CPAddress;
CContact1.Text = p.CPContactNo1;
CContact2.Text = p.CPContactNo2;
CEmail.Text = p.CPEmail;
AName.Text = p.AdmittingPerson;
ARelation.Text = p.APRelationship;
AAddress.Text = p.APAddress;
AContact1.Text = p.APContactNo1;
AContact2.Text = p.APContactNo2;
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
}
}
protected void Save_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
Patient__Profile profile;
if (pid != null)
{
profile = (from r in myEntities.Patient__Profile
where r.Registration_ID == pid
select r).SingleOrDefault();
if (profile != null)
{
// Update profile information
profile.Department = Department.SelectedValue;
profile.CurrentBedNo = (Bed.SelectedValue == "Unoccupied") ? null : Bed.SelectedValue;
profile.PatientName = Name.Text;
profile.PhotoURL = Photo.ImageUrl;
profile.Sex = Sex.SelectedValue;
profile.Age = Convert.ToInt16(AgeValue.Text);
profile.AgeUnit = AgeUnit.SelectedValue;
profile.BodyWeight = Convert.ToInt16(Weight.Text);
profile.Height = Convert.ToInt16(Height.Text);
profile.MaritalStatus = MaritalStatus.SelectedValue;
profile.C_o = Co.Text;
profile.C_o_Relation = CoRelation.SelectedValue;
profile.MothersName = MotherName.Text;
profile.MLC_No = MLC.Text;
profile.ReferredBy = RName.Text;
profile.RefContactNo = RContact.Text;
profile.IfPreviouslyTreated = PrevTreated.Checked;
profile.LastTreatedRegistration_ID = PrevID.Text;
profile.Occupation = Occupation.Text;
profile.Financing = Financing.Text;
profile.LocalAddress = LAddress.Text;
profile.LState = LState.Text;
profile.LCountry = LCountry.Text;
profile.LPincode = LPincode.Text;
profile.LContactNo1 = LContact1.Text;
profile.LContactNo2 = LContact2.Text;
profile.Email = LEmail.Text;
profile.PermanentAddress = PAddress.Text;
profile.PState = PState.Text;
profile.PCountry = PCountry.Text;
profile.PPincode = PPincode.Text;
profile.PContactNo1 = PContact1.Text;
profile.PContactNo2 = PContact2.Text;
profile.EmergencyContactPerson = CName.Text;
profile.CPRelationship = CRelation.Text;
profile.CPAddress = CAddress.Text;
profile.CPContactNo1 = CContact1.Text;
profile.CPContactNo2 = CContact2.Text;
profile.CPEmail = CEmail.Text;
profile.AdmittingPerson = AName.Text;
profile.APRelationship = ARelation.Text;
profile.APAddress = AAddress.Text;
profile.APContactNo1 = AContact1.Text;
profile.APContactNo2 = AContact2.Text;
profile.UpdateDateTime = DateTime.Now;
profile.UpdatedBy = Profile.UserName;
profile.UpdateUserName = Profile.Name;
// Update bed information
Hospital__Bed b = (from r in myEntities.Hospital__Bed
where (r.H_ID == profile.H_ID && r.BedNo == PBed.Text)
select r).SingleOrDefault();
if (b != null)
{
b.Occupied = false; // Previous bed occupied status: false
}
b = (from r in myEntities.Hospital__Bed
where (r.H_ID == profile.H_ID && r.BedNo == Bed.SelectedValue)
select r).SingleOrDefault();
if (b != null)
{
b.Occupied = true; // Current Bed occupied status: true if selected value is not "Unoccupied"
}
myEntities.SaveChanges();
//Notification.Text = "Changes saved successfully.";
//System.Threading.Thread.Sleep(5000);
//Notification.Text = null;
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
}
Response.Redirect(String.Format("~/Hospital/PatientInfo/EditInfo.aspx?PID={0}", RegID.Text));
}
protected void Page_Load(object sender, EventArgs e)
{
pid = Request.QueryString.Get("PID");
if (!Page.IsPostBack && pid != null)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
// Select patient based on registration id
var p = (from r in myEntities.Patient__Profile
where r.Registration_ID == pid
select r).SingleOrDefault();
string hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (p != null && p.H_ID == hid)
{
RegID.Text = pid;
PName.Text = p.PatientName;
PBed.Text = (p.CurrentBedNo == null) ? "Unoccupied" : p.CurrentBedNo;
MultiView1.ActiveViewIndex = 0;
// Initialize form from database
Department.Text = p.Department;
Bed.Text = (p.CurrentBedNo == null) ? "Unoccupied" : p.CurrentBedNo;
Name.Text = p.PatientName;
Photo.ImageUrl = p.PhotoURL;
Sex.Text = p.Sex;
AgeValue.Text = p.Age.ToString();
AgeUnit.Text = p.AgeUnit;
Weight.Text = p.BodyWeight.ToString();
Height.Text = p.Height.ToString();
MaritalStatus.Text = p.MaritalStatus;
Co.Text = p.C_o;
CoRelation.Text = p.C_o_Relation;
MotherName.Text = p.MothersName;
MLC.Text = p.MLC_No;
RName.Text = p.ReferredBy;
RContact.Text = p.RefContactNo;
PrevTreated.Visible = PrevID.Visible = Label32.Visible = (p.IfPreviouslyTreated.HasValue == true) ? p.IfPreviouslyTreated.Value : false;
PrevID.Text = p.LastTreatedRegistration_ID;
Occupation.Text = p.Occupation;
Financing.Text = p.Financing;
LAddress.Text = p.LocalAddress;
LState.Text = p.LState;
LCountry.Text = p.LCountry;
LPincode.Text = p.LPincode;
LContact1.Text = p.LContactNo1;
LContact2.Text = p.LContactNo2;
LEmail.Text = p.Email;
PAddress.Text = p.PermanentAddress;
PState.Text = p.PState;
PCountry.Text = p.PCountry;
PPincode.Text = p.PPincode;
PContact1.Text = p.PContactNo1;
PContact2.Text = p.PContactNo2;
CName.Text = p.EmergencyContactPerson;
CRelation.Text = p.CPRelationship;
CAddress.Text = p.CPAddress;
CContact1.Text = p.CPContactNo1;
CContact2.Text = p.CPContactNo2;
CEmail.Text = p.CPEmail;
AName.Text = p.AdmittingPerson;
ARelation.Text = p.APRelationship;
AAddress.Text = p.APAddress;
AContact1.Text = p.APContactNo1;
AContact2.Text = p.APContactNo2;
IfDischarged.Text = (p.IfDischarged == true) ? "DISCHARGED" : null;
// Calculate BMI and class
if (Weight.Text != null && Height.Text != null)
{
double bmi = double.Parse(Weight.Text) / Math.Pow(double.Parse(Height.Text), 2) * 10000;
BMI.Text = bmi.ToString();
string bmiclass;
if (bmi < 16)
{
bmiclass = "Severely Underweight";
}
else if (bmi < 17)
{
bmiclass = "Moderately Underweight";
}
else if (bmi < 18)
{
bmiclass = "Mild Underweight";
}
else if (bmi < 25)
{
bmiclass = "Normal";
}
else if (bmi < 30)
{
bmiclass = "Pre Obese (Mild)";
}
else if (bmi < 35)
{
bmiclass = "Class I Obese (Moderate)";
}
else if (bmi < 45)
{
bmiclass = "Class II Obese (Severe)";
}
else
{
bmiclass = "Class III Obese (Morbid)";
}
BMIClass.Text = bmiclass;
}
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string PID = Request.QueryString.Get("PID");
if (!Page.IsPostBack)
{
if (!User.IsInRole("Administrator") && !User.IsInRole("Hospital Superuser") && !User.IsInRole("Hospital Management") && !User.IsInRole("Nurse"))
{
Response.Redirect("~/Account/Login.aspx");
}
else
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (hid == null)
{
hid = Profile.UserName;
}
}
}
if (PID != null)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
var p = (from r in myEntities.Patient__Profile
where r.Registration_ID == PID
select r).SingleOrDefault();
if (p != null && p.H_ID == hid)
{
RegID.Text = PID;
PName.Text = p.PatientName;
PBed.Text = p.CurrentBedNo;
var dates = (from r in myEntities.Clinical_Monitoring__Intake_Output
where r.P_ID == PID
select r.LogDate).Distinct();
var orderedDates = from r in dates
orderby r descending
select r;
List <String> datelist = new List <String>();
foreach (var d in orderedDates)
{
datelist.Add(d.ToShortDateString());
}
DateFilter.DataSource = datelist;
DateFilter.DataBind();
MultiView1.ActiveViewIndex = 0;
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
}
else
{
MultiView1.ActiveViewIndex = -1;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
sid = Request.QueryString.Get("SID");
if (!Page.IsPostBack)
{
if (!User.IsInRole("Administrator") && !User.IsInRole("Hospital Superuser") && !User.IsInRole("Hospital Management"))
{
Response.Redirect("~/Account/Login.aspx");
}
else
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
hid = (from r in myEntities.Hospital__Staff
where r.Staff_ID == Profile.UserName
select r.H_ID).SingleOrDefault();
if (hid == null)
{
hid = Profile.UserName;
}
}
}
if (sid != null)
{
using (NMHCDatabaseEntities myEntities = new NMHCDatabaseEntities())
{
// Select staff based on staff id
var s = (from r in myEntities.Hospital__Staff
where r.Staff_ID == sid
select r).SingleOrDefault();
if (s != null && s.H_ID == hid)
{
StfID.Text = sid;
SName.Text = s.StaffName;
MultiView1.ActiveViewIndex = 0;
// Initialize form from database
Name.Text = s.StaffName;
Photo.ImageUrl = s.PhotoURL;
SetPicture.Visible = String.IsNullOrEmpty(s.PhotoURL);
DeletePicture.Visible = !String.IsNullOrEmpty(s.PhotoURL);
Designation.Text = s.Designation;
Qualification.Text = s.Qualification;
Info.Text = s.RelevantInfo;
Address.Text = s.Address;
State.Text = s.State;
Country.Text = s.Country;
Pincode.Text = s.Pincode;
Contact1.Text = s.Phone1;
Contact2.Text = s.Phone2;
Email.Text = s.Email;
}
else
{
MultiView1.ActiveViewIndex = 1;
}
}
}
}
}
