protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
txtboxFirstName.Focus();
HospitalClass hc = new HospitalClass();
try
{
DataTable dt = hc.selectAllHospitalFullName();
if (dt.Rows.Count > 0)
{
dropdownlist_Hospital.DataSource = dt;
dropdownlist_Hospital.DataValueField = "hospitalFullName";
dropdownlist_Hospital.DataTextField = "hospitalFullName";
dropdownlist_Hospital.DataBind();
dropdownlist_Hospital.Items.Insert(0, new ListItem("", ""));
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
}
protected void lnkbtn_N_Click(object sender, EventArgs e)
{
try
{
HospitalClass hc = new HospitalClass();
DataTable dt = hc.SelectForViewHospitalRecords_SpecificLetter("N");
if (dt.Rows.Count > 0)
{
ltrMessage.Text = "";
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
//dt.Rows.Add(dt.NewRow());
GridView1.DataSource = dt;
GridView1.DataBind();
//int columncount = GridView1.Rows[0].Cells.Count;
ltrMessage.Text = "No data found!";
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
//protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// if (e.Row.RowType == DataControlRowType.DataRow)
// {
// // Click to highlight row
// Button lnkSelect = (Button)e.Row.FindControl("lnkSelect");
// if (lnkSelect != null)
// {
// lnkSelect.Attributes.Add("onclick", "javascript:return deleteConfirm('" + Session["selectedRow_HospitalName"].ToString() + "')");
// }
// }
//}
//protected void lnkSelect_Click(object sender, EventArgs e)
//{
//}
protected void btnOk_Click(object sender, EventArgs e)
{
try
{
int hospitalId;
HospitalClass hc = new HospitalClass();
LogHospitalClass lhc = new LogHospitalClass();
/*Delete Hospital's record
* Insert values on Log_HospitalWholeFieldWithName table*/
/*Getting HospitalId from HospitalName table*/
DataTable dt = hc.SelectAllHospitalFromHospitalFullName(Session["selectedRow_HospitalName"].ToString());
if (dt.Rows.Count > 0)
{
Session["hospitalId"] = dt.Rows[0]["hospitalId"].ToString();
hospitalId = Convert.ToInt32(Session["hospitalId"]);
lhc.insertOn_Log_HospitalWholeFieldWithName_WithDeleteOperation(Session["selectedRow_HospitalName"].ToString());
hc.delete_hospitalFrom_hospitalId(hospitalId);
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
finally
{
//Session["selectedRow_HospitalName"] = txtboxName.Text;
ltrDelMsg.Visible = false;
btnOk.Visible = false;
loadData();
}
}
protected void lnkbtnEdit_CurrentHospital_Click(object sender, EventArgs e)
{
lblHospital.Visible = false;
lblStatus.Visible = true;
lblHospitalLabel.Visible = true;
lblStatusLabel.Visible = false;
dropdownlist_Hospital.Visible = true;
btnOk_Hospital.Visible = true;
dropdownlistStatus.Visible = false;
btnOk_Status.Visible = false;
dropdownlist_Hospital.Text = lblHospital.Text;
HospitalClass hc = new HospitalClass();
try
{
DataTable dt = hc.selectAllHospitalFullName();
if (dt.Rows.Count > 0)
{
dropdownlist_Hospital.DataSource = dt;
dropdownlist_Hospital.DataValueField = "hospitalFullName";
dropdownlist_Hospital.DataTextField = "hospitalFullName";
dropdownlist_Hospital.DataBind();
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
protected void lnkbtn_Z_Click(object sender, EventArgs e)
{
ltrDelMsg.Visible = false;
btnOk.Visible = false;
try
{
HospitalClass hc = new HospitalClass();
DataTable dt = hc.SelectForViewHospitalRecords_SpecificLetter("Z");
if (dt.Rows.Count > 0)
{
ltrMessage.Text = "";
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
GridView1.DataSource = dt;
GridView1.DataBind();
ltrMessage.Text = "No data found!";
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
/*Making this function to work independently for Loading Data*/
protected void loadData()
{
try
{
HospitalClass hc = new HospitalClass();
DataTable dt = hc.SelectForViewHospitalRecords();
if (dt.Rows.Count > 0)
{
ltrMessage.Text = "";
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
GridView1.DataSource = dt;
GridView1.DataBind();
ltrMessage.Text = "No data found!";
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
protected void btnOk_Address_Click(object sender, EventArgs e)
{
if (txtboxHouseAdd.Text != lblHouseAdd.Text ||
txtboxDistrict.Text != lblDistrict.Text ||
txtboxCity.Text != lblCity.Text)
{
try
{
int hospitalId;
HospitalClass hc = new HospitalClass();
LogHospitalClass lhc = new LogHospitalClass();
String hospitalIndivFieldLog_Operation = "Update";
String hospitalIndivFieldLog_Field = "hospitalAddress";
String hospitalIndivFieldLog_DataLater = txtboxHouseAdd.Text
+ "; " + txtboxDistrict.Text
+ "; " + txtboxCity.Text;
String hospitalIndivFieldLog_DataBefore = lblHouseAdd.Text
+ "; " + lblDistrict.Text
+ "; " + lblCity.Text;;
/*Update Hospital's Address on Hospital table
* Insert values on Log_HospitalIndivField table*/
/*Getting HospitalId from HospitalName table*/
DataTable dt = hc.SelectAllHospitalFromHospitalFullName(Session["selectedRow_HospitalName"].ToString());
if (dt.Rows.Count > 0)
{
Session["hospitalId"] = dt.Rows[0]["hospitalId"].ToString();
hospitalId = Convert.ToInt32(Session["hospitalId"]);
hc.update_hospitalAddressFrom_hospitalId(hospitalId, txtboxHouseAdd.Text,
txtboxDistrict.Text, txtboxCity.Text);
lhc.insertOn_Log_HospitalIndivField_WithUpdateOperation(hospitalIndivFieldLog_Operation,
hospitalId, hospitalIndivFieldLog_Field, hospitalIndivFieldLog_DataBefore,
hospitalIndivFieldLog_DataLater);
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
finally
{
Session["selectedRow_HospitalHouseAddress"] = txtboxHouseAdd.Text;
Session["selectedRow_HospitalDistrict"] = txtboxDistrict.Text;
Session["selectedRow_HospitalCity"] = txtboxCity.Text;
lblHouseAdd.Text = txtboxHouseAdd.Text;
lblDistrict.Text = txtboxDistrict.Text;
lblCity.Text = txtboxCity.Text;
txtboxHouseAdd.Visible = false;
txtboxDistrict.Visible = false;
txtboxCity.Visible = false;
btnOk_Address.Visible = false;
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
ltrMessage.Text = "";
//ltrMessageGreen.Text = "";
HospitalClass hc = new HospitalClass();
LogHospitalClass lhc = new LogHospitalClass();
/*Current date and time calculated*/
String currentDateNTimeString;
DateTime currentDateNTime = DateTime.Now;
currentDateNTimeString = currentDateNTime.ToString("dd/MM/yyyy hh:mm:ss tt");
String hospitalFullName, hospitalType, hospitalHouseAdd, hospitalDistrict, hospitalCity, hospitalDescrip;
int hospitalRegdBy;
hospitalFullName = txtboxName.Text;
hospitalType = dropdownlistType.SelectedValue;
hospitalHouseAdd = txtboxHouseAdd.Text;
hospitalDistrict = txtboxDistrict.Text;
hospitalCity = txtboxCity.Text;
hospitalDescrip = txtboxDescrip.Text;
/*Getting userId from Session*/
String userIdString = Session["userId"].ToString();
int userId = Convert.ToInt32(userIdString);
hospitalRegdBy = userId;
/*Inserting and putting the values in Log*/
hc.InsertHospital(hospitalFullName, hospitalType, hospitalHouseAdd, hospitalDistrict,
hospitalCity, hospitalDescrip, hospitalRegdBy);
lhc.insertOn_Log_HospitalWholeField_WithInsertOperation(hospitalFullName);
Response.Redirect("Hospital_OtherUserMaster.aspx");
txtboxName.Text = "";
dropdownlistType.SelectedValue = "";
txtboxHouseAdd.Text = "";
txtboxDistrict.Text = "";
txtboxCity.Text = "";
txtboxDescrip.Text = "";
//ltrMessageGreen.Text = "Record added!";
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
try
{
GlobalConnection gc = new GlobalConnection();
HospitalClass hc = new HospitalClass();
DataTable dt = hc.selectForViewHospitalRecords_ForReport();
if (dt.Rows.Count > 0)
{
ltrMessage.Text = "";
ReportViewer1.Reset();
// OR Set Report Path
ReportViewer1.LocalReport.ReportPath = HttpContext.Current.Server.MapPath("Report_Hospital_OtherUserMaster.rdlc");
// Clear the Data Source
ReportViewer1.LocalReport.DataSources.Clear();
// Set a DataSource to the report
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewer1.DataBind();
// Refresh and Display Report
ReportViewer1.LocalReport.Refresh();
}
else
{
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
ltrMessage.Text = "No data found!";
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
ReportViewer1.DataBind();
ReportViewer1.LocalReport.Refresh();
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
String selectedRow_HospitalName = GridView1.SelectedRow.Cells[2].Text;
Session["selectedRow_HospitalName"] = selectedRow_HospitalName;
String selectedRow_HospitalType = GridView1.SelectedRow.Cells[3].Text;
Session["selectedRow_HospitalType"] = selectedRow_HospitalType;
String selectedRow_HospitalAddress = GridView1.SelectedRow.Cells[4].Text;
try
{
HospitalClass hc = new HospitalClass();
DataTable dt = hc.SelectAddressFromHospitalFullName(selectedRow_HospitalName);
if (dt.Rows.Count > 0)
{
Session["selectedRow_HospitalHouseAddress"] = dt.Rows[0]["hospitalHouseAdd"].ToString();
Session["selectedRow_HospitalDistrict"] = dt.Rows[0]["hospitalDistrict"].ToString();
Session["selectedRow_HospitalCity"] = dt.Rows[0]["hospitalCity"].ToString();
}
//else
//{
// Session["selectedRow_HospitalHouseAddress"] = "";
// Session["selectedRow_HospitalDistrict"] = "";
// Session["selectedRow_HospitalCity"] = "";
//}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
String selectedRow_HospitalDescription = GridView1.SelectedRow.Cells[5].Text;
Session["selectedRow_HospitalDescription"] = selectedRow_HospitalDescription;
//ltrMessage.Text = "Selected: " + selectedRow_HospitalName + " "
//+ Session["selectedRow_HospitalHouseAddress"];
Response.Redirect("Hospital_Edit_OtherUserMaster.aspx");
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
String selectedRow_HospitalName = GridView1.SelectedRow.Cells[2].Text;
Session["selectedRow_HospitalName"] = selectedRow_HospitalName;
String selectedRow_HospitalType = GridView1.SelectedRow.Cells[3].Text;
Session["selectedRow_HospitalType"] = selectedRow_HospitalType;
String selectedRow_HospitalAddress = GridView1.SelectedRow.Cells[4].Text;
try
{
HospitalClass hc = new HospitalClass();
DataTable dt = hc.SelectAddressFromHospitalFullName(selectedRow_HospitalName);
if (dt.Rows.Count > 0)
{
Session["selectedRow_HospitalHouseAddress"] = dt.Rows[0]["hospitalHouseAdd"].ToString();
Session["selectedRow_HospitalDistrict"] = dt.Rows[0]["hospitalDistrict"].ToString();
Session["selectedRow_HospitalCity"] = dt.Rows[0]["hospitalCity"].ToString();
}
else
{
ltrMessage.Text = "Error";
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
String selectedRow_HospitalDescription = GridView1.SelectedRow.Cells[5].Text;
Session["selectedRow_HospitalDescription"] = selectedRow_HospitalDescription;
//ltrMessage.Text = "Selected: "+selectedRow_HospitalName+Session["selectedRow_HospitalDistrict"];
ltrDelMsg.Visible = true;
ltrDelMsg.Text = "Do you want to delete the record of " + " '"
+ Session["selectedRow_HospitalName"].ToString() + "'" + "?";
btnOk.Visible = true;
//Response.Redirect("Hospital_Edit_OtherUserMaster.aspx");
}
protected void btnOk_Type_Click(object sender, EventArgs e)
{
if (dropdownlistType.SelectedValue != lblType.Text)
{
try
{
int hospitalId;
HospitalClass hc = new HospitalClass();
LogHospitalClass lhc = new LogHospitalClass();
String hospitalIndivFieldLog_Operation = "Update";
String hospitalIndivFieldLog_Field = "hospitalType";
String hospitalIndivFieldLog_DataLater = dropdownlistType.SelectedValue;
String hospitalIndivFieldLog_DataBefore = lblType.Text;
/*Update Hospital's Type on Hospital table
* Insert values on Log_HospitalIndivField table*/
/*Getting HospitalId from HospitalName table*/
DataTable dt = hc.SelectAllHospitalFromHospitalFullName(Session["selectedRow_HospitalName"].ToString());
if (dt.Rows.Count > 0)
{
Session["hospitalId"] = dt.Rows[0]["hospitalId"].ToString();
hospitalId = Convert.ToInt32(Session["hospitalId"]);
hc.update_hospitalTypeFrom_hospitalId(hospitalId, dropdownlistType.Text);
lhc.insertOn_Log_HospitalIndivField_WithUpdateOperation(hospitalIndivFieldLog_Operation,
hospitalId, hospitalIndivFieldLog_Field, hospitalIndivFieldLog_DataBefore,
hospitalIndivFieldLog_DataLater);
}
}
catch (Exception ex)
{
ltrMessage.Text = ex.Message;
}
finally
{
Session["selectedRow_HospitalType"] = dropdownlistType.SelectedValue;
lblType.Text = dropdownlistType.SelectedValue;
dropdownlistType.Visible = false;
btnOk_Type.Visible = false;
}
}
}
/*Insert on Log_HospitalWholeFieldWithName table with the delete Operation */
public void insertOn_Log_HospitalWholeFieldWithName_WithDeleteOperation(String hospitalFullName)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
String hospitalWholeFieldLogWithName_Date;
String hospitalWholeFieldLogWithName_Operation = "Delete";
/*Current date and time calculated*/
DateTime currentDateNTime = DateTime.Now;
hospitalWholeFieldLogWithName_Date = currentDateNTime.ToString("dd/MM/yyyy hh:mm:ss tt");
cmd.CommandText = "sp_Log_hospitalWholeFieldWithName";
cmd.CommandType = CommandType.StoredProcedure;
/*Getting Hospital Id from Hospital's username and putting that userId value*/
try
{
HospitalClass hc = new HospitalClass();
int hospitalId;
/*Getting Hospital Id from Hospital's userId*/
DataTable dtHospital = hc.SelectAllHospitalFromHospitalFullName(hospitalFullName);
if (dtHospital.Rows.Count > 0)
{
String hospitalIdString = dtHospital.Rows[0]["hospitalId"].ToString();
hospitalId = Convert.ToInt32(hospitalIdString);
cmd.Parameters.Add("@hospitalId", hospitalId);
}
}
catch (Exception ex)
{
throw ex;
}
cmd.Parameters.Add("@hospitalFullName", hospitalFullName);
cmd.Parameters.Add("@hospitalWholeFieldLogWithName_Date", hospitalWholeFieldLogWithName_Date);
cmd.Parameters.Add("@hospitalWholeFieldLogWithName_Operation", hospitalWholeFieldLogWithName_Operation);
cmd.ExecuteNonQuery();
}
