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(); }