/// <summary>
/// To Insert into DATABASE
/// </summary>
/// <param name="FenceBOobj"></param>
/// <returns></returns>
public int Insert(OtherFenceBO FenceBOobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_INS_OTHERFENCE", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("HHID", FenceBOobj.HouseholdID);
dcmd.Parameters.Add("FIXTURETYPE_", FenceBOobj.Otherfencedescription);
dcmd.Parameters.Add("DIMEN_LENGTH_", FenceBOobj.DIMEN_LENGTH);
dcmd.Parameters.Add("DIMEN_WIDTH_", FenceBOobj.DIMEN_WIDTH);
dcmd.Parameters.Add("DEPRECIATEDVALUE_", FenceBOobj.Depreciatedvalue);
dcmd.Parameters.Add("CREATEDBY_", FenceBOobj.CreatedBy);
return(dcmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
// to get Image File for DataBase
public OtherFenceBO ShowPAPOHFIXImage(int householdID, int PermanentStructureID)
{
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_GETOTHERFENCEPHOTO", 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;
OtherFenceBO objPAPOTHFIX = new OtherFenceBO();
objPAPOTHFIX.Photo = papPhotoBytes;
return(objPAPOTHFIX);
//return new System.IO.MemoryStream(papPhotoBytes);
}
catch (Exception ex)
{
return(null);
}
finally
{
myConnection.Close();
}
}
/// <summary>
/// To Get Fence data
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public OtherFenceList GetFencedata(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_PAP_OTHERFIXTURES";
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);
OtherFenceBO FenceBOobj = null;
OtherFenceList FenceListobj = new OtherFenceList();
while (dr.Read())
{
FenceBOobj = new OtherFenceBO();
if (!dr.IsDBNull(dr.GetOrdinal("PAP_FIXTUREID")))
{
FenceBOobj.Pap_otherfenceid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_FIXTUREID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("FIXTURETYPE")))
{
FenceBOobj.Otherfencedescription = dr.GetString(dr.GetOrdinal("FIXTURETYPE"));
}
if (!dr.IsDBNull(dr.GetOrdinal("DIMEN_LENGTH")))
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DIMEN_LENGTH")));
}
if (!dr.IsDBNull(dr.GetOrdinal("DIMEN_WIDTH")))
{
FenceBOobj.DIMEN_WIDTH = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DIMEN_WIDTH")));
}
if (!dr.IsDBNull(dr.GetOrdinal("DEPRECIATEDVALUE")))
{
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DEPRECIATEDVALUE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
FenceBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
FenceListobj.Add(FenceBOobj);
}
dr.Close();
return(FenceListobj);
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="FenceBOobj"></param>
/// <returns></returns>
public int Insert(OtherFenceBO FenceBOobj)
{
OtherFenceDAL fencesaveDALobj = new OtherFenceDAL(); //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(OtherFenceBO FenceBOobj)
{
OtherFenceDAL FenceupdateDALobj = new OtherFenceDAL(); //Data pass -to Database Layer
try
{
return(FenceupdateDALobj.EditFence(FenceBOobj));
}
catch
{
throw;
}
finally
{
FenceupdateDALobj = null;
}
}
/// <summary>
/// used to fetch details and assign to textbox
/// </summary>
private void Getfencedatarow()
{
OtherFixturesBLL fenceBLLobj = new OtherFixturesBLL();
int Pap_fenceid = 0;
if (ViewState["PAP_FENCEID"] != null)
{
Pap_fenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
}
OtherFenceBO FenceBOobj = new OtherFenceBO();
FenceBOobj = fenceBLLobj.Getfencedatarow(Pap_fenceid);
//if( fixtureDescription.Text != "")
fixtureDescription.Text = FenceBOobj.Otherfencedescription.ToString();
lengthTextBox.Text = FenceBOobj.DIMEN_LENGTH.ToString();
heightTextBox.Text = FenceBOobj.DIMEN_WIDTH.ToString();
surfaceareaTextBox.Text = (FenceBOobj.DIMEN_LENGTH * FenceBOobj.DIMEN_WIDTH).ToString();
depreciatedvalueTextBox.Text = FenceBOobj.Depreciatedvalue.ToString();
}
//other Fixtures tab OtherFenceBO or OtherFixturesBLL
public System.IO.MemoryStream ShowPAPOHFIXImage(int householdID, int PermanentStructureID)
{
try
{
OtherFenceBO objPAPFIX = (new OtherFixturesBLL()).ShowPAPOHFIXImage(householdID, PermanentStructureID);
if (objPAPFIX.Photo != null)
{
return(new System.IO.MemoryStream(objPAPFIX.Photo));
}
else
{
return(null);
}
}
catch (Exception ex)
{
//throw ex;
return(null);
}
}
/// <summary>
/// To Edit Fence
/// </summary>
/// <param name="FenceBOobj"></param>
/// <returns></returns>
public int EditFence(OtherFenceBO FenceBOobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_OTHERFENCE", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("PAP_FIXTUREID_", FenceBOobj.Pap_otherfenceid);
dcmd.Parameters.Add("HHID", FenceBOobj.HouseholdID);
dcmd.Parameters.Add("FIXTURETYPE_", FenceBOobj.Otherfencedescription);
dcmd.Parameters.Add("DIMEN_LENGTH_", FenceBOobj.DIMEN_LENGTH);
dcmd.Parameters.Add("DIMEN_WIDTH_", FenceBOobj.DIMEN_WIDTH);
dcmd.Parameters.Add("DEPRECIATEDVALUE_", FenceBOobj.Depreciatedvalue);
dcmd.Parameters.Add("UPDATEDBY_", 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 save data into database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int count = 0;
OtherFixturesBLL fenceBLLobj = new OtherFixturesBLL();
OtherFenceBO 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 OtherFenceBO();
FenceBOobj.Pap_otherfenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
//FenceBOobj.Fenceid = Convert.ToInt32(fenceDropDownList.SelectedItem.Value);
if (fixtureDescription.Text.Trim() != null)
{
FenceBOobj.Otherfencedescription = fixtureDescription.Text;
}
if (lengthTextBox.Text != string.Empty)
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(0);
}
if (heightTextBox.Text != string.Empty)
{
FenceBOobj.DIMEN_WIDTH = Convert.ToDecimal(heightTextBox.Text);
}
else
{
FenceBOobj.DIMEN_WIDTH = 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.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
FenceBOobj.HouseholdID = Convert.ToInt32(hhid);
//if (photoFileUpload.HasFile)
//{
// byte[] fileBytes = photoFileUpload.FileBytes;
// FenceBOobj.Photo = fileBytes;
//}
OtherFixturesBLL fenceupdateBLLobj = new OtherFixturesBLL();
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 OtherFenceBO();
FenceBOobj.Pap_otherfenceid = Convert.ToInt32(ViewState["PAP_FENCEID"]);
// FenceBOobj.Fenceid = Convert.ToInt32(fenceDropDownList.SelectedValue);
if (fixtureDescription.Text.Trim() != null)
{
FenceBOobj.Otherfencedescription = fixtureDescription.Text;
}
if (lengthTextBox.Text != string.Empty)
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
FenceBOobj.DIMEN_LENGTH = Convert.ToDecimal(0);
}
if (heightTextBox.Text != string.Empty)
{
FenceBOobj.DIMEN_WIDTH = Convert.ToDecimal(heightTextBox.Text);
}
else
{
FenceBOobj.DIMEN_WIDTH = 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;
//}
OtherFixturesBLL fencesaveBLLobj = new OtherFixturesBLL();
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();
}
