/// <summary>
/// To Get Health Center By Id
/// </summary>
/// <param name="HEALTHCENTERID"></param>
/// <returns></returns>
public HealthCenterBO GetHealthCenterById(int HEALTHCENTERID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_HEALTH";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("H_HEALTHCENTERID", HEALTHCENTERID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
HealthCenterBO HealthCenterBOobj = null;
HealthCenterList HealthCenterListobj = new HealthCenterList();
HealthCenterBOobj = new HealthCenterBO();
while (dr.Read())
{
if (ColumnExists(dr, "HEALTHCENTERNAME") && !dr.IsDBNull(dr.GetOrdinal("HEALTHCENTERNAME")))
{
HealthCenterBOobj.HEALTHCENTERNAME = dr.GetString(dr.GetOrdinal("HEALTHCENTERNAME"));
}
if (ColumnExists(dr, "HEALTHCENTERID") && !dr.IsDBNull(dr.GetOrdinal("HEALTHCENTERID")))
{
HealthCenterBOobj.HEALTHCENTERID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HEALTHCENTERID")));
}
}
dr.Close();
return(HealthCenterBOobj);
}
/// <summary>
/// To Get Health Center
/// </summary>
/// <returns></returns>
public HealthCenterList GetHealthCenter()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SEL_HEALTH";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
HealthCenterBO HealthCenterBOobj = null;
HealthCenterList HealthCenterListobj = new HealthCenterList();
while (dr.Read())
{
HealthCenterBOobj = new HealthCenterBO();
HealthCenterBOobj.HEALTHCENTERID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("healthcenterid")));
HealthCenterBOobj.HEALTHCENTERNAME = dr.GetString(dr.GetOrdinal("healthcentername"));
// Vaccinationobj.ISDELETED = dr.GetString(dr.GetOrdinal("isdeleted"));
HealthCenterListobj.Add(HealthCenterBOobj);
}
dr.Close();
return(HealthCenterListobj);
}
/// <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 Edit in Database
/// </summary>
/// <param name="HealthCenterBOobj"></param>
/// <returns></returns>
public string Edit(HealthCenterBO HealthCenterBOobj)
{
HealthCenterDAL HealthCenterDALobj = new HealthCenterDAL();//Data pass -to Database Layer
try
{
return(HealthCenterDALobj.Edit(HealthCenterBOobj));
}
catch
{
throw;
}
finally
{
HealthCenterDALobj = null;
}
}
/// <summary>
/// To Edit
/// </summary>
public string Edit(HealthCenterBO HealthCenterBOobj)
{
string returnResult = string.Empty;
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_UPD_HEALTHCENTER", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("H_HEALTHCENTERNAME", HealthCenterBOobj.HEALTHCENTERNAME);
dcmd.Parameters.Add("H_HEALTHCENTERID", HealthCenterBOobj.HEALTHCENTERID);
dcmd.Parameters.Add("H_UPDATEDBY", HealthCenterBOobj.CREATEDBY);
//return dcmd.ExecuteNonQuery();
dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dcmd.ExecuteNonQuery();
if (dcmd.Parameters["errorMessage_"].Value != null)
{
returnResult = dcmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
return(returnResult);
}
/// <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);
}
