/// <summary>
/// To fetch details by ID
/// </summary>
/// <param name="DwellingID"></param>
/// <returns></returns>
public DwellingBO GetDwellingById(int DwellingID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETDWELLINGBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("p_DWELLINGID", DwellingID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DwellingBO DwellingBOobj = null;
DwellingList Users = new DwellingList();
DwellingBOobj = new DwellingBO();
while (dr.Read())
{
if (ColumnExists(dr, "dwellingtype") && !dr.IsDBNull(dr.GetOrdinal("dwellingtype")))
{
DwellingBOobj.DwellingType = dr.GetString(dr.GetOrdinal("dwellingtype"));
}
if (ColumnExists(dr, "dwellingid") && !dr.IsDBNull(dr.GetOrdinal("dwellingid")))
{
DwellingBOobj.DwellingID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("dwellingid")));
}
}
dr.Close();
return(DwellingBOobj);
}
/// <summary>
/// To fetch details
/// </summary>
/// <returns></returns>
public DwellingList GetDwelling()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GETDWELLING";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
DwellingBO objUser = null;
DwellingList Users = new DwellingList();
while (dr.Read())
{
objUser = new DwellingBO();
objUser.DwellingID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("dwellingid")));
objUser.DwellingType = dr.GetString(dr.GetOrdinal("dwellingtype"));
Users.Add(objUser);
}
dr.Close();
return(Users);
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private string Insert()
{
string message = string.Empty;
string uID = Session["USER_ID"].ToString();
DwellingBOobj = new DwellingBO();
DwellingBOobj.DwellingType = txtDwelling.Text.ToString();
DwellingBOobj.Createdby = Convert.ToInt32(uID);
DwellingBLL DwellingBLLObj = new DwellingBLL();
try
{
message = DwellingBLLObj.Insert(DwellingBOobj);
}
catch (Exception ex)
{
string errorMsg = ex.Message.ToString();
Response.Write(errorMsg);
}
finally
{
DwellingBLLObj = null;
}
return(message);
}
/// <summary>
/// calls method save details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string AlertMessage = string.Empty;
string message = string.Empty;
if (ConcernIDTextBox.Text == string.Empty)
{
message = Insert();
AlertMessage = "alert('" + message + "');";
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
cleardetails();
BindGrid(true, true);
}
//BindGrid(true, true);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Dwelling details added successfully');", true);
//cleardetails();
}
else
{
string uID = Session["USER_ID"].ToString();
int reasonid = Convert.ToInt32(ViewState["DwellingID"]);
DwellingBOobj = new DwellingBO();
DwellingBOobj.DwellingType = txtDwelling.Text.ToString();
DwellingBOobj.Createdby = Convert.ToInt32(uID);
DwellingBLL DwellingBLLObj = new DwellingBLL();
message = DwellingBLLObj.Update(DwellingBOobj, reasonid);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
// ClearDetails();
cleardetails();
BindGrid(true, true);
SetUpdateMode(false);
}
//BindGrid(true, true);
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Dwelling details updated successfully');", true);
//cleardetails();
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
/// <summary>
/// to get details
/// </summary>
/// <returns></returns>
private void GetDwellingDetails()
{
DwellingBLL DwellingBLLObj = new DwellingBLL();
int DwellingID = 0;
if (ViewState["DwellingID"] != null)
{
DwellingID = Convert.ToInt32(ViewState["DwellingID"]);
}
DwellingBOobj = new DwellingBO();
DwellingBOobj = DwellingBLLObj.GetDwellingbyID(DwellingID);
txtDwelling.Text = DwellingBOobj.DwellingType;
ConcernIDTextBox.Text = DwellingBOobj.DwellingID.ToString();
//int ConcernID_test = Convert.ToInt32(ConcernObj.ConcernID);
}
/// <summary>
/// To Update
/// </summary>
/// <param name="DwellingBOobj"></param>
/// <param name="DwellingID"></param>
/// <returns></returns>
public string Update(DwellingBO DwellingBOobj, int DwellingID)
{
DwellingDAL DwellingDALobj = new DwellingDAL();
try
{
return(DwellingDALobj.Update(DwellingBOobj, DwellingID));
}
catch (Exception ex)
{
throw ex;
}
finally
{
DwellingDALobj = null;
}
}
/// <summary>
/// To Insert
/// </summary>
/// <param name="DwellingBOobj"></param>
/// <returns></returns>
public string Insert(DwellingBO DwellingBOobj)
{
DwellingDAL DwellingDALobj = new DwellingDAL(); //Data pass -to Database Layer
try
{
return(DwellingDALobj.Insert(DwellingBOobj));
}
catch (Exception ex)
{
throw ex;
}
finally
{
DwellingDALobj = null;
}
}
/// <summary>
/// To update details to database
/// </summary>
/// <param name="DwellingBOobj"></param>
/// <param name="DwellingID"></param>
/// <returns></returns>
public string Update(DwellingBO DwellingBOobj, int DwellingID)
{
string returnResult = string.Empty;
OracleConnection conn = new OracleConnection(AppConfiguration.ConnectionString);
conn.Open();
OracleCommand dCmd = new OracleCommand("USP_MST_UPDATEDWELLING", conn);
dCmd.CommandType = CommandType.StoredProcedure;
try
{
dCmd.Parameters.Add("p_SCH_DRP_REASONID", DwellingID);
dCmd.Parameters.Add("p_SCH_DRP_REASON", DwellingBOobj.DwellingType);
dCmd.Parameters.Add("p_CREATEDBY", DwellingBOobj.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 (Exception ex)
{
throw ex;
}
finally
{
dCmd.Dispose();
conn.Close();
conn.Dispose();
}
return(returnResult);
}
/// <summary>
/// To save data to database
/// </summary>
/// <param name="DwellingBOobj"></param>
/// <returns></returns>
public string Insert(DwellingBO DwellingBOobj)
{
string returnResult = string.Empty;
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
con.Open();
OracleCommand dcmd = new OracleCommand("USP_MST_INSERTDWELLING", con);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("p_DWELLINGTYPE", DwellingBOobj.DwellingType);
dcmd.Parameters.Add("p_CREATEDBY", DwellingBOobj.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 (Exception ex)
{
throw ex;;
}
finally
{
dcmd.Dispose();
con.Close();
con.Dispose();
}
return(returnResult);
}
