private void PatientProfileById(int Id, string OTP)
{
string FirstName = string.Empty;
string LastName = string.Empty;
string Email = string.Empty;
string MailBody = string.Empty;
SqlParameter[] parameterList =
{
new SqlParameter("@Id", Id)
};
dbConnection db = new dbConnection();
DataSet ds = new DataSet();
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_LoadPatientProfileById", parameterList);
if (ds.Tables[0].Rows.Count > 0)
{
FirstName = ds.Tables["Table"].Rows[0]["First_Name"].ToString();
LastName = ds.Tables["Table"].Rows[0]["Last_Name"].ToString();
}
MailBody = FirstName + " " + LastName + "'s OTP is " + OTP;
SendMail(txtEmail.Value.Trim(), FirstName, LastName, "EHR OTP", MailBody);
}
private void CountNewRequest()
{
SqlParameter[] parameterList =
{
new SqlParameter("@Account_Id", Session["AccountId"].ToString()),
new SqlParameter("@Status", Status.Request.New)
};
dbConnection db = new dbConnection();
DataSet ds = new DataSet();
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_CountAllRequest", parameterList);
if (ds.Tables[0].Rows.Count > 0)
{
Int32 i = Convert.ToInt32(ds.Tables[0].Rows[0]["TotalNewRequests"]);
if (i > 0)
{
hyplnkCount.Text = "You have " + ds.Tables[0].Rows[0]["TotalNewRequests"] + " New Request";
}
else
{
hyplnkCount.Visible = false;
}
}
}
private void LoadPatients()
{
dbConnection db = new dbConnection();
DataSet ds = new DataSet();
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_LoadAllPatients");
grvPatients.DataSource = ds;
grvPatients.DataBind();
}
private void LoadRequests()
{
SqlParameter[] parameterList =
{
new SqlParameter("@Account_Id", Session["AccountId"].ToString())
};
dbConnection db = new dbConnection();
DataSet ds = new DataSet();
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_LoadRequests", parameterList);
grvRequests.DataSource = ds;
grvRequests.DataBind();
}
private void LoadPatientProfile(int Id)
{
SqlParameter[] parameterList =
{
new SqlParameter("@Id", Id)
};
dbConnection db = new dbConnection();
DataSet ds = new DataSet();
//Byte[] data = new Byte[0];
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_LoadPatientProfileById", parameterList);
Byte[] imgbyte = (Byte[])(ds.Tables[0].Rows[0]["Image"]);
Response.BinaryWrite(imgbyte);
}
private void LoadMedication(int FromId, int ToId)
{
SqlParameter[] parameterList =
{
new SqlParameter("@Account_Id", FromId),
new SqlParameter("@ToId", ToId)
};
dbConnection db = new dbConnection();
DataSet ds = new DataSet();
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_LoadMedication", parameterList);
if (ds.Tables[0].Rows.Count > 0)
{
grvMedication.DataSource = ds;
grvMedication.DataBind();
}
}
private void LoadDoctorProfile(int Id)
{
SqlParameter[] parameterList =
{
new SqlParameter("@Id", Id)
};
dbConnection db = new dbConnection();
DataSet ds = new DataSet();
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_LoadDoctorProfileById", parameterList);
if (ds.Tables[0].Rows.Count > 0)
{
lblFirstName.Text = ds.Tables["Table"].Rows[0]["First_Name"].ToString();
lblLastName.Text = ds.Tables["Table"].Rows[0]["Last_Name"].ToString();
lblHospital.Text = ds.Tables["Table"].Rows[0]["Hospital_Name"].ToString();
lblPhone.Text = ds.Tables["Table"].Rows[0]["Phone"].ToString();
txtEmail.Value = ds.Tables["Table"].Rows[0]["Email"].ToString();
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Session.RemoveAll();
DataSet ds = new DataSet();
SqlParameter[] parameterList =
{
new SqlParameter("@Email", txtEmail.Text.Trim()),
new SqlParameter("@Pwd", EHRDataManager.Encrypt(txtPassword.Text.Trim(),"gftj-5dx7-lsavv1")),
new SqlParameter("@Role", hdnRole.Value.Trim())
};
dbConnection db = new dbConnection();
#region Patient Login
// 1 Means Patient
if (Convert.ToInt32(hdnRole.Value.Trim()) == 1)
{
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_PatientLogin", parameterList);
if (ds.Tables[0].Rows.Count > 0)
{
if (Convert.ToInt32(ds.Tables[0].Rows[0]["Account_Id"]) != 0)
{
Session["AccountId"] = ds.Tables[0].Rows[0]["Id"];
Session["Role"] = ds.Tables[0].Rows[0]["Role"];
Response.Redirect("frmMyDoctors.aspx");
}
else
{
Response.Redirect("frmPatientProfile.aspx");
}
}
else
{
Response.Write("<script>alert('Invalid User');</script>");
}
}
#endregion
#region Doctor Login
// 2 Means Doctor
if (Convert.ToInt32(hdnRole.Value.Trim()) == 2)
{
ds = db.ExecuteQuery(CommandType.StoredProcedure, "usp_DoctorLogin", parameterList);
if (ds.Tables[0].Rows.Count > 0)
{
if (Convert.ToInt32(ds.Tables[0].Rows[0]["Account_Id"]) != 0)
{
Session["AccountId"] = ds.Tables[0].Rows[0]["Id"];
Session["Role"] = ds.Tables[0].Rows[0]["Role"];
Response.Redirect("frmMyPatients.aspx");
}
else
{
Response.Redirect("frmDoctorProfile.aspx");
}
}
else
{
Response.Write("<script>alert('Invalid User');</script>");
}
}
#endregion
}