/// <summary>
/// Getfencedatarow
/// </summary>
private void Getfencedatarow()
{
FenceBLL fenceBLLobj = new FenceBLL();
int Pap_fenceid = 0;
if (ViewState["PAP_FENCEID"] != null)
{
Pap_fenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
}
FenceBO FenceBOobj = new FenceBO();
FenceBOobj = fenceBLLobj.Getfencedatarow(Pap_fenceid);
fenceDropDownList.ClearSelection();
if (fenceDropDownList.Items.FindByValue(FenceBOobj.Fenceid.ToString()) != null)
{
fenceDropDownList.Items.FindByValue(FenceBOobj.Fenceid.ToString()).Selected = true;
}
lengthTextBox.Text = FenceBOobj.Fen_dimen_length.ToString();
heightTextBox.Text = FenceBOobj.Fen_dimen_height.ToString();
surfaceareaTextBox.Text = (FenceBOobj.Fen_dimen_length * FenceBOobj.Fen_dimen_height).ToString();
depreciatedvalueTextBox.Text = FenceBOobj.Depreciatedvalue.ToString();
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <returns></returns>
public FenceList GetFencedescription( )
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_FENCEDATA";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
FenceBO BOobj = null;
FenceList Listobj = new FenceList();
while (dr.Read())
{
BOobj = new FenceBO();
BOobj.Fenceid = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FENCEID"))));
BOobj.Fencedescription = dr.GetValue(dr.GetOrdinal("FENCEDESCRIPTION")).ToString();
Listobj.Add(BOobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// to get Image File for DataBase
/// </summary>
/// <param name="householdID"></param>
/// <param name="PermanentStructureID"></param>
/// <returns></returns>
public FenceBO ShowPAPGRAVE(int householdID, int PermanentStructureID)
{
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_GET_FENCE_PHOTO", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("HHID_", householdID);
myCommand.Parameters.Add("PermanentStructureID_", PermanentStructureID);
myCommand.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
myCommand.Connection.Open();
object img = myCommand.ExecuteScalar();
try
{
byte[] papPhotoBytes = (byte[])img;
FenceBO objPAPGRAVE = new FenceBO();
objPAPGRAVE.Photo = papPhotoBytes;
return(objPAPGRAVE);
//return new System.IO.MemoryStream(papPhotoBytes);
}
catch (Exception ex)
{
return(null);
}
finally
{
myConnection.Close();
}
}
/// <summary>
/// Getfencedatarow
/// </summary>
/// <param name="Pap_fenceid"></param>
/// <returns></returns>
public FenceBO Getfencedatarow(int Pap_fenceid)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_FENCE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("F_PAP_FENCEID", Pap_fenceid);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
FenceBO FenceBOobj = null;
FenceList FenceListobj = new FenceList();
FenceBOobj = new FenceBO();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("pap_fenceid")))
{
FenceBOobj.Pap_fenceid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_fenceid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("fenceid")))
{
FenceBOobj.Fenceid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("fenceid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("fen_dimen_length")))
{
FenceBOobj.Fen_dimen_length = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("fen_dimen_length")));
}
if (!dr.IsDBNull(dr.GetOrdinal("fen_dimen_height")))
{
FenceBOobj.Fen_dimen_height = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("fen_dimen_height")));
}
if (!dr.IsDBNull(dr.GetOrdinal("depreciatedvalue")))
{
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("depreciatedvalue")));
}
}
dr.Close();
return(FenceBOobj);
}
/// <summary>
/// to insert details to database
/// </summary>
/// <param name="FenceBOobj"></param>
/// <returns></returns>
public int Insert(FenceBO FenceBOobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_INS_FENCE", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("HHID", FenceBOobj.HouseholdID);
// dcmd.Parameters.Add("FENCEID", FenceBOobj.Fenceid);
if (FenceBOobj.Fenceid > 0)
{
dcmd.Parameters.Add("FENCEID", FenceBOobj.Fenceid);
}
else
{
dcmd.Parameters.Add("FENCEID", DBNull.Value);
}
dcmd.Parameters.Add("FEN_DIMEN_LENGTH", FenceBOobj.Fen_dimen_length);
dcmd.Parameters.Add("FEN_DIMEN_HEIGHT", FenceBOobj.Fen_dimen_height);
dcmd.Parameters.Add("DEPRECIATEDVALUE", FenceBOobj.Depreciatedvalue);
dcmd.Parameters.Add("CREATEDBY", FenceBOobj.CreatedBy);
if (FenceBOobj.Photo != null)
{
dcmd.Parameters.Add("FENCEPHOTO_", OracleDbType.Blob).Value = FenceBOobj.Photo;
}
else
{
dcmd.Parameters.Add("FENCEPHOTO_", Oracle.DataAccess.Types.OracleBlob.Null);
}
return(dcmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
/// <summary>
/// To Insert
/// </summary>
/// <param name="FenceBOobj"></param>
/// <returns></returns>
public int Insert(FenceBO FenceBOobj)
{
FenceDAL fencesaveDALobj = new FenceDAL(); //Data pass -to Database Layer
try
{
return(fencesaveDALobj.Insert(FenceBOobj));
}
catch
{
throw;
}
finally
{
fencesaveDALobj = null;
}
}
/// <summary>
/// To Edit Fence
/// </summary>
/// <param name="FenceBOobj"></param>
/// <returns></returns>
public int EditFence(FenceBO FenceBOobj)
{
FenceDAL FenceupdateDALobj = new FenceDAL(); //Data pass -to Database Layer
try
{
return(FenceupdateDALobj.EditFence(FenceBOobj));
}
catch
{
throw;
}
finally
{
FenceupdateDALobj = null;
}
}
public System.IO.MemoryStream ShowPAPFENCE(int householdID, int PermanentStructureID)
{
try
{
FenceBO objPAPFENCE = (new FenceBLL()).ShowPAPGRAVE(householdID, PermanentStructureID);
if (objPAPFENCE.Photo != null)
{
return(new System.IO.MemoryStream(objPAPFENCE.Photo));
}
else
{
return(null);
}
}
catch (Exception ex)
{
//throw ex;
return(null);
}
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public FenceList GetFencedata(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_FENCE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", householdID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
FenceBO FenceBOobj = null;
FenceList FenceListobj = new FenceList();
while (dr.Read())
{
FenceBOobj = new FenceBO();
FenceBOobj.Pap_fenceid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_FENCEID")));
FenceBOobj.Fencedescription = dr.GetString(dr.GetOrdinal("FENCEDESCRIPTION"));
FenceBOobj.Fen_dimen_length = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FEN_DIMEN_LENGTH")));
FenceBOobj.Fen_dimen_height = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FEN_DIMEN_HEIGHT")));
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DEPRECIATEDVALUE")));
FenceBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
FenceListobj.Add(FenceBOobj);
}
dr.Close();
return(FenceListobj);
}
/// <summary>
/// To save details todatabase
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int count = 0;
FenceBLL fenceBLLobj = new FenceBLL();
FenceBO FenceBOobj = null;
if (Convert.ToInt32(ViewState["PAP_FENCEID"]) > 0)
{
// update
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
FenceBOobj = new FenceBO();
FenceBOobj.Pap_fenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
FenceBOobj.Fenceid = Convert.ToInt32(fenceDropDownList.SelectedItem.Value);
if (lengthTextBox.Text != string.Empty)
{
FenceBOobj.Fen_dimen_length = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
FenceBOobj.Fen_dimen_length = Convert.ToDecimal(0);
}
if (heightTextBox.Text != string.Empty)
{
FenceBOobj.Fen_dimen_height = Convert.ToDecimal(heightTextBox.Text);
}
else
{
FenceBOobj.Fen_dimen_height = Convert.ToDecimal(0);
}
if (depreciatedvalueTextBox.Text != string.Empty)
{
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(depreciatedvalueTextBox.Text);
}
else
{
FenceBOobj.Depreciatedvalue = 0;
}
// FenceBOobj.Fen_dimen_length = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
// FenceBOobj.Fen_dimen_height = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
// FenceBOobj.Depreciatedvalue = Convert.ToInt32(depreciatedvalueTextBox.Text.ToString().Trim());
FenceBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
FenceBOobj.HouseholdID = Convert.ToInt32(hhid);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
FenceBOobj.Photo = fileBytes;
}
FenceBLL fenceupdateBLLobj = new FenceBLL();
count = fenceupdateBLLobj.EditFence(FenceBOobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
fenceBLLobj = null;
}
}
else
{
// insert
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
FenceBOobj = new FenceBO();
FenceBOobj.Pap_fenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
FenceBOobj.Fenceid = Convert.ToInt32(fenceDropDownList.SelectedValue);
if (lengthTextBox.Text != string.Empty)
{
FenceBOobj.Fen_dimen_length = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
FenceBOobj.Fen_dimen_length = Convert.ToDecimal(0);
}
if (heightTextBox.Text != string.Empty)
{
FenceBOobj.Fen_dimen_height = Convert.ToDecimal(heightTextBox.Text);
}
else
{
FenceBOobj.Fen_dimen_height = Convert.ToDecimal(0);
}
if (depreciatedvalueTextBox.Text != string.Empty)
{
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(depreciatedvalueTextBox.Text);
}
else
{
FenceBOobj.Depreciatedvalue = 0;
}
// FenceBOobj.Fen_dimen_length = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
// FenceBOobj.Fen_dimen_height = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
// FenceBOobj.Depreciatedvalue = Convert.ToInt32(depreciatedvalueTextBox.Text.ToString().Trim());
FenceBOobj.CreatedBy = Convert.ToInt32(uID);
FenceBOobj.HouseholdID = Convert.ToInt32(hhid);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
FenceBOobj.Photo = fileBytes;
}
FenceBLL fencesaveBLLobj = new FenceBLL();
count = fencesaveBLLobj.Insert(FenceBOobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
fenceBLLobj = null;
}
}
ChangeRequestStatusFence();
projectFrozen();
}