/// <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 GrdSocialdisease_RowCommand(object sender, GridViewCommandEventArgs e) { string message = string.Empty; if (e.CommandName == "EditRow") { ShowHideSections(true, false); ViewState["DiSEASEID"] = e.CommandArgument; DiseaseBLL objDiseaseBLL = new DiseaseBLL(); DiseaseBO objDisease = objDiseaseBLL.GetDiseaseByDiseaseID(Convert.ToInt32(ViewState["DiSEASEID"])); txtDisease.Text = objDisease.DiseaseName; SetUpdateMode(true); ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true); } else if (e.CommandName == "DeleteRow") { DiseaseBLL objDiseaseBLL = new DiseaseBLL(); message = objDiseaseBLL.DeleteDisease(Convert.ToInt32(e.CommandArgument)); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data deleted successfully"; } ClearDetails(); SetUpdateMode(false); BindGrid(); } if (message != "") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); } }
/// <summary> /// to insert details to datbase /// </summary> /// <param name="objDisease"></param> /// <returns></returns> public string AddDisease(DiseaseBO objDisease) { string returnResult = string.Empty; int result = 0; { OracleConnection myConnection; OracleCommand myCommand; myConnection = new OracleConnection(AppConfiguration.ConnectionString); myCommand = new OracleCommand("USP_MST_INSERTDISEASE", myConnection); myCommand.Connection = myConnection; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("@DiseaseNameIN", objDisease.DiseaseName); myCommand.Parameters.Add("@ISDELETEDIN", "False"); myCommand.Parameters.Add("@USERIDIN", objDisease.CreatedBy); myConnection.Open(); //result = myCommand.ExecuteNonQuery(); myCommand.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; myCommand.ExecuteNonQuery(); if (myCommand.Parameters["errorMessage_"].Value != null) { returnResult = myCommand.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } myConnection.Close(); } return(returnResult); }
/// <summary> /// To fetch details from database /// </summary> /// <param name="DiseaseName"></param> /// <returns></returns> public DiseaseList SearchDisease(string DiseaseName) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_DISEASES"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("DiseaseNameIN", DiseaseName); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DiseaseBO objDisease = null; DiseaseList Diseases = new DiseaseList(); while (dr.Read()) { objDisease = new DiseaseBO(); objDisease.DiseaseID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("diseaseid"))); objDisease.DiseaseName = dr.GetString(dr.GetOrdinal("diseasename")); objDisease.Isdeleted = dr.GetString(dr.GetOrdinal("isdeleted")); Diseases.Add(objDisease); } dr.Close(); return(Diseases); }
/// <summary> /// calls method save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_Save_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; DiseaseBO objDisease = new DiseaseBO(); objDisease.DiseaseID = Convert.ToInt32(ViewState["DiSEASEID"]); objDisease.DiseaseName = txtDisease.Text.Trim(); DiseaseBLL objDiseaseBLL = new DiseaseBLL(); if (objDisease.DiseaseID == 0) { objDisease.CreatedBy = Convert.ToInt32(Session["USER_ID"]); message = objDiseaseBLL.AddDisease(objDisease); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully."; ClearDetails(); BindGrid(); } } else { objDisease.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); message = objDiseaseBLL.UpdateDisease(objDisease); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully."; ClearDetails(); BindGrid(); SetUpdateMode(false); } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }
/// <summary> /// to fetch details based on ID /// </summary> /// <param name="diseaseID"></param> /// <returns></returns> public DiseaseBO GetDiseaseByDiseaseID(int diseaseID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETDISEASEBYDISEASEID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DiseaseIdIN", diseaseID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); DiseaseBO obDisease = null; while (dr.Read()) { obDisease = new DiseaseBO(); obDisease.DiseaseID = dr.GetInt32(dr.GetOrdinal("DiseaseId")); obDisease.DiseaseName = dr.GetString(dr.GetOrdinal("DiseaseName")); } dr.Close(); return(obDisease); }
/// <summary> /// To Update Disease /// </summary> /// <param name="objDisease"></param> /// <returns></returns> public string UpdateDisease(DiseaseBO objDisease) { DiseaseDAL objDiseaseDAL = new DiseaseDAL(); return(objDiseaseDAL.UpdateDisease(objDisease)); }
/// <summary> /// To Add Disease /// </summary> /// <param name="objDisease"></param> /// <returns></returns> public string AddDisease(DiseaseBO objDisease) { DiseaseDAL objDiseaseDAL = new DiseaseDAL(); return(objDiseaseDAL.AddDisease(objDisease)); }