protected void btnLogIn_Click1(object sender, EventArgs e)
{
try
{
UserClass uc = new UserClass();
EntryUserClass euc = new EntryUserClass();
DataTable dt = uc.Checklogin(txtboxUsername.Text, txtboxPasswd.Text);
if (dt.Rows.Count > 0)
{
ltrMessage.Text = "";
Session["username"] = txtboxUsername.Text;
Session["userPasswd"] = txtboxPasswd.Text;
String userType = dt.Rows[0]["userType"].ToString();
Session["userType"] = dt.Rows[0]["userType"].ToString();
Session["userId"] = dt.Rows[0]["userId"].ToString();
String userIdString = dt.Rows[0]["userId"].ToString();
int userId = Convert.ToInt32(userIdString);
if (userType == "Patient")
{
Response.Redirect("Home_Patient.aspx");
}
else if (userType == "Entry")
{
/*Check if the Entry User is Active or not*/
DataTable dtEntryUser = euc.SelectAllEntryUserFromUserId(userId);
if (dtEntryUser.Rows.Count > 0)
{
String entryUserInactiveOrActive = dtEntryUser.Rows[0]["entryUserInactiveOrActive"].ToString();
if (entryUserInactiveOrActive == "Active")
{
Response.Redirect("Home_EntryUser.aspx");
}
else
{
ltrMessage.Text = "The User is Inactive!";
}
}
}
else if (userType == "Other")
{
Response.Redirect("Home_OtherUser.aspx");
}
}
else
{
ltrMessage.Text = "Invalid Username or Password!";
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
/*Insert on Log_EntryUserWholeField table with the insert Operation */
public void insertOn_Log_EntryUserWholeField_WithInsertOperation(String username)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
String entryUserWholeFieldLog_Date;
String entryUserWholeFieldLog_Operation = "Insert";
/*Current date and time calculated*/
DateTime currentDateNTime = DateTime.Now;
entryUserWholeFieldLog_Date = currentDateNTime.ToString("dd/MM/yyyy hh:mm:ss tt");
cmd.CommandText = "sp_Log_entryUserWholeField";
cmd.CommandType = CommandType.StoredProcedure;
/*Getting Patient Id from Patient's username and putting that userId value*/
try
{
UserClass uc = new UserClass();
EntryUserClass euc = new EntryUserClass();
int userId, entryUserId;
DataTable dt = uc.GetUserIdFromUsername(username);
if (dt.Rows.Count > 0)
{
String userIdString = dt.Rows[0]["userId"].ToString();
userId = Convert.ToInt32(userIdString);
cmd.Parameters.Add("@userId", userId);
/*Getting entryUserId from EntryUser's userId*/
DataTable dtEntryUser = euc.SelectAllEntryUserFromUserId(userId);
if (dtEntryUser.Rows.Count > 0)
{
String entryUserIdString = dtEntryUser.Rows[0]["entryUserId"].ToString();
entryUserId = Convert.ToInt32(entryUserIdString);
cmd.Parameters.Add("@entryUserId", entryUserId);
}
}
}
catch (Exception ex)
{
throw ex;
}
cmd.Parameters.Add("@entryUserWholeFieldLog_Date", entryUserWholeFieldLog_Date);
cmd.Parameters.Add("@entryUserWholeFieldLog_Operation", entryUserWholeFieldLog_Operation);
cmd.ExecuteNonQuery();
}
protected void btnOk_CurrentHospital_Click(object sender, EventArgs e)
{
int selectedRow_UserId;
UserClass uc = new UserClass();
UserEntryUserClass uouc = new UserEntryUserClass();
EntryUserClass euc = new EntryUserClass();
LogEntryUserClass leuc = new LogEntryUserClass();
String entryUserIndivFieldLog_Operation = "Update";
String entryUserIndivFieldLog_Field = "entryUserContact";
String entryUserIndivFieldLog_DataLater = dropdownlist_Hospital.SelectedValue;
String entryUserIndivFieldLog_DataBefore = Session["selectedRow_EntryUserHospital"].ToString();;
/*Update Record of EntryUser's Current Hospital
* Insert values on Log_UsersIndivField table*/
try
{
selectedRow_UserId = Convert.ToInt32(Session["selectedRow_UserId"]);
DataTable dtEntryUser = euc.SelectAllEntryUserFromUserId(selectedRow_UserId);
if (dtEntryUser.Rows.Count > 0)
{
uouc.updateProfile_EntryUser_entryUserHospital(selectedRow_UserId, dropdownlist_Hospital.SelectedValue);
int userId = Convert.ToInt32(Session["userId"]);
leuc.insertOn_Log_EntryUserIndivField_WithUpdateOperation(entryUserIndivFieldLog_Operation,
selectedRow_UserId, entryUserIndivFieldLog_Field, entryUserIndivFieldLog_DataBefore,
entryUserIndivFieldLog_DataLater, userId);
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
finally
{
Session["selectedRow_EntryUserHospital"] = dropdownlist_Hospital.SelectedValue;
lblHospital.Text = dropdownlist_Hospital.SelectedValue;
dropdownlist_Hospital.Visible = false;
btnOk_Hospital.Visible = false;
}
}
protected void Load()
{
/*Getting values from Users and EntryUser tables*/
try
{
int selectedRow_UserId;
UserClass uc = new UserClass();
EntryUserClass euc = new EntryUserClass();
String selectedRow_Username = Session["selectedRow_Username"].ToString();
hprlnk_header.Text = "Edit Entry User: "******"'s Record";
/*Getting userId of Users table*/
DataTable dtUsers = uc.SelectAllUsersFromUsername(selectedRow_Username);
if (dtUsers.Rows.Count > 0)
{
Session["selectedRow_UserId"] = dtUsers.Rows[0]["userId"].ToString();
}
/*Getting values of EntryUser table*/
selectedRow_UserId = Convert.ToInt32(Session["selectedRow_UserId"]);
DataTable dtEntryUser = euc.SelectAllEntryUserFromUserId(selectedRow_UserId);
if (dtEntryUser.Rows.Count > 0)
{
//Session["selectedRow_EntryUserId"] = dtEntryUser.Rows[0]["entryUserId"].ToString();
Session["selectedRow_EntryUserHospital"] = dtEntryUser.Rows[0]["entryUserHospital"].ToString();
Session["selectedRow_EntryUserInactiveOrActive"] = dtEntryUser.Rows[0]["entryUserInactiveOrActive"].ToString();
}
}
catch (Exception ex)
{
throw ex;
}
lblHospital.Visible = true;
lblHospital.Text = Session["selectedRow_EntryUserHospital"].ToString();
lblHospitalLabel.Visible = false;
lblStatus.Visible = true;
lblStatus.Text = Session["selectedRow_EntryUserInactiveOrActive"].ToString();
lblStatusLabel.Visible = false;
}