//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 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 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; } } }