/// <summary> /// Set edit mode for edit comand /// Delete data from the database for delete comand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdHealtCenter_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ViewState["HEALTHCENTERID"] = e.CommandArgument; GetHealthcenterDetails(); SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { HealthCenterBLL HealthCenterBLLobj = new HealthCenterBLL(); message = HealthCenterBLLobj.DeleteHealthCenter(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data Deleted successfully"; } SetUpdateMode(false); BindGrid(false, true); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void BindGrid(bool addRow, bool deleteRow) { HealthCenterBLL HealthCenterBLLobj = new HealthCenterBLL(); grdHealtCenter.DataSource = HealthCenterBLLobj.GetALLHealthCenter(); grdHealtCenter.DataBind(); }
/// <summary> /// Update Database Make data as Obsoluted /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void IsObsolete_CheckedChanged(Object sender, EventArgs e) { string message = string.Empty; try { CheckBox chk = (CheckBox)sender; GridViewRow gr = (GridViewRow)chk.Parent.Parent; string HEALTHCENTERID = ((Literal)gr.FindControl("litHEALTHCENTERID")).Text; int HEALTHCENTERID_ = Convert.ToInt32(HEALTHCENTERID); HealthCenterBLL HealthCenterBLLobj = new HealthCenterBLL(); message = HealthCenterBLLobj.ObsoleteHealthCenter(HEALTHCENTERID_, Convert.ToString(chk.Checked)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; } BindGrid(false, true); if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } } catch (Exception ex) { throw ex; } }
/// <summary> /// to get the HealthCenter Data /// </summary> private void GetHealthCenter() { HealthCenterBLL BLLobj = new HealthCenterBLL(); ddlNearestHealthCentre.DataSource = BLLobj.GetHealthCenter(); ddlNearestHealthCentre.DataTextField = "healthcentername"; ddlNearestHealthCentre.DataValueField = "healthcenterid"; ddlNearestHealthCentre.DataBind(); }
/// <summary> /// To fetch details from database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void GetHealthcenterDetails() { HealthCenterBLL HealthCenterBLLobj = new HealthCenterBLL(); int HealthCenterId = 0; if (ViewState["HEALTHCENTERID"] != null) { HealthCenterId = Convert.ToInt32(ViewState["HEALTHCENTERID"]); } HealthCenterBO HealthCenterBOobj = new HealthCenterBO(); HealthCenterBOobj = HealthCenterBLLobj.GetHealthCenterById(HealthCenterId); HealthCenterNameTextBox.Text = HealthCenterBOobj.HEALTHCENTERNAME; }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; if (ViewState["HEALTHCENTERID"].ToString() == "0") { HealthCenterBLL HealthCenterBLLobj = new HealthCenterBLL(); try { string uID = Session["USER_ID"].ToString(); HealthCenterBO HealthCenterBOobj = new HealthCenterBO(); HealthCenterBOobj.HEALTHCENTERNAME = HealthCenterNameTextBox.Text.ToString().Trim(); HealthCenterBOobj.CREATEDBY = Convert.ToInt32(uID); HealthCenterBLL BLLobj = new HealthCenterBLL(); message = BLLobj.Insert(HealthCenterBOobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearAll(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { HealthCenterBLLobj = null; } } else { HealthCenterBLL HealthCenterBLLobj = new HealthCenterBLL(); try { string uID = Session["USER_ID"].ToString(); HealthCenterBO HealthCenterBOobj = new HealthCenterBO(); HealthCenterBOobj.HEALTHCENTERNAME = HealthCenterNameTextBox.Text.ToString().Trim(); HealthCenterBOobj.HEALTHCENTERID = Convert.ToInt32(ViewState["HEALTHCENTERID"]); HealthCenterBOobj.CREATEDBY = Convert.ToInt32(uID); HealthCenterBLL BLLobj = new HealthCenterBLL(); message = BLLobj.Edit(HealthCenterBOobj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearAll(); BindGrid(true, true); SetUpdateMode(false); } } catch (Exception ex) { throw ex; } finally { HealthCenterBLLobj = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }