// to get Image File for DataBase
public NonPermanentStructureBO ShowPAPNPBImage(int householdID, int PermanentStructureID)
{
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_GET_PAPNPS_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;
NonPermanentStructureBO objPAPNPS = new NonPermanentStructureBO();
objPAPNPS.Photo = papPhotoBytes;
return(objPAPNPS);
//return new System.IO.MemoryStream(papPhotoBytes);
}
catch (Exception ex)
{
return(null);
}
finally
{
myConnection.Close();
}
}
/// <summary>
/// To Get NPS
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public Non_perm_structureList GetNPS(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_NPS";
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);
NonPermanentStructureBO BOobj1 = null;
Non_perm_structureList Non_perm_structureListobj = new Non_perm_structureList();
while (dr.Read())
{
BOobj1 = new NonPermanentStructureBO();
BOobj1.NonPermanentStructureID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("NONPERM_STRUCTUREID")));
BOobj1.STR_TYPE = dr.GetString(dr.GetOrdinal("str_type"));
BOobj1.STR_CATEGORYNAME = dr.GetString(dr.GetOrdinal("str_categoryname"));
BOobj1.STR_CONDITION = dr.GetString(dr.GetOrdinal("str_condition"));
BOobj1.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
Non_perm_structureListobj.Add(BOobj1);
}
dr.Close();
return(Non_perm_structureListobj);
}
/// <summary>
/// To Update photo
/// </summary>
/// <param name="BOobj1"></param>
/// <returns></returns>
public int Updatephoto(NonPermanentStructureBO BOobj1)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PHOTO_NPS", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("N_NONPERM_STRUCTUREID", BOobj1.NonPermanentStructureID);
dcmd.Parameters.Add("N_HHID", BOobj1.HouseholdID);
dcmd.Parameters.Add(new OracleParameter("PAPPSPHOTO_", OracleDbType.Blob)).Value = BOobj1.Photo;
dcmd.Parameters.Add("N_UPDATEDBY", BOobj1.UpdatedBy);
return(dcmd.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
/// <summary>
/// To Edit NPS
/// </summary>
/// <param name="BOobj"></param>
/// <returns></returns>
public int EditNPS(NonPermanentStructureBO BOobj)
{
Non_perm_structureDAL NPSDALobj = new Non_perm_structureDAL(); //Data pass -to Database Layer
try
{
return(NPSDALobj.EditNPS(BOobj));
}
catch
{
throw;
}
finally
{
NPSDALobj = null;
}
}
/// <summary>
/// To Insert into Databse
/// </summary>
/// <param name="BOobj"></param>
/// <returns></returns>
public int Insert(NonPermanentStructureBO BOobj)
{
Non_perm_structureDAL structureDALobj = new Non_perm_structureDAL(); //Data pass -to Database Layer
try
{
return(structureDALobj.Insert(BOobj));
}
catch
{
throw;
}
finally
{
structureDALobj = null;
}
}
/// <summary>
/// To Update photo
/// </summary>
/// <param name="BOobj1"></param>
/// <returns></returns>
public int Updatephoto(NonPermanentStructureBO BOobj1)
{
Non_perm_structureDAL DALobj = new Non_perm_structureDAL(); //Data pass -to Database Layer
try
{
return(DALobj.Updatephoto(BOobj1));
}
catch (Exception ex)
{
throw ex;
}
finally
{
BOobj1 = null;
}
}
public System.IO.MemoryStream ShowPAPNPBImage(int householdID, int PermanentStructureID)
{
try
{
NonPermanentStructureBO objPAPNPS = (new Non_perm_structureBLL()).ShowPAPNPBImage(householdID, PermanentStructureID);
if (objPAPNPS.Photo != null)
{
return(new System.IO.MemoryStream(objPAPNPS.Photo));
}
else
{
return(null);
}
}
catch (Exception ex)
{
//throw ex;
return(null);
}
}
/// <summary>
/// To Edit NPS
/// </summary>
/// <param name="BOobj"></param>
/// <returns></returns>
public int EditNPS(NonPermanentStructureBO BOobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_NPS", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("N_NONPERM_STRUCTUREID", BOobj.NonPermanentStructureID);
dcmd.Parameters.Add("N_STR_TYPEID", BOobj.StructureTypeID);
dcmd.Parameters.Add("N_CATEGORYID", BOobj.CategoryID);
dcmd.Parameters.Add("N_STR_CONDITIONID", BOobj.StructureConditionID);
dcmd.Parameters.Add("N_OTHERSTRUCTURETYPE", BOobj.OtherStructureType);
dcmd.Parameters.Add("N_OWNER", BOobj.Owner);
dcmd.Parameters.Add("N_OWNERNAME", BOobj.OwnerName);
dcmd.Parameters.Add("N_OCCUPANT", BOobj.Occupant);
dcmd.Parameters.Add("N_OTHEROCCUPANTNAME", BOobj.OtherOccupantName);
dcmd.Parameters.Add("N_OCCUPANTSTATUSID", BOobj.OccupantStatusID);
dcmd.Parameters.Add("N_OTHEROCCUPANTSTATUS", BOobj.OtherOccupantStatus);
dcmd.Parameters.Add("N_DIMEN_LENGTH", BOobj.DimensionLength);
dcmd.Parameters.Add("N_DIMEN_WIDTH", BOobj.DimensionWidth);
dcmd.Parameters.Add("N_NOOFROOMS", BOobj.NoOfRooms);
dcmd.Parameters.Add("N_SURFACEAREA", BOobj.SurfaceArea);
dcmd.Parameters.Add("N_UPDATEDBY", BOobj.CreatedBy);
return(dcmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int count = 0;
Non_perm_structureBLL BLLobj = new Non_perm_structureBLL();
NonPermanentStructureBO BOobj = null;
if (Convert.ToInt32(ViewState["NONPERM_STRUCTUREID"]) > 0)
{
// update
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
try
{
if (photoFileUpload.HasFile)
{
NonPermanentStructureBO BOobj1 = new NonPermanentStructureBO();
byte[] fileBytes = photoFileUpload.FileBytes;
BOobj1.NonPermanentStructureID = Convert.ToInt32(IDTextBox1.Text);
BOobj1.HouseholdID = Convert.ToInt32(hhid);
BOobj1.UpdatedBy = Convert.ToInt32(uID);
BOobj1.Photo = fileBytes;
Non_perm_structureBLL pBLLobj = new Non_perm_structureBLL();
count = pBLLobj.Updatephoto(BOobj1);
}
BOobj = new NonPermanentStructureBO();
BOobj.NonPermanentStructureID = Convert.ToInt32(ViewState["NONPERM_STRUCTUREID"]);
BOobj.StructureTypeID = Convert.ToInt32(buildingtypeDropDownList.SelectedValue);
BOobj.CategoryID = Convert.ToInt32(categoryDropDownList.SelectedValue);
BOobj.StructureConditionID = Convert.ToInt32(conditionDropDownList.SelectedValue);
BOobj.OccupantStatusID = Convert.ToInt32(occupantstatusDropDownList.SelectedValue.ToString());
if (noofroomsTextBox.Text != string.Empty)
{
BOobj.NoOfRooms = Convert.ToInt32(noofroomsTextBox.Text);
}
else
{
BOobj.NoOfRooms = 0;
}
//BOobj.NoOfRooms = Convert.ToInt32(noofroomsTextBox.Text.ToString().Trim());
if (surfaceareaTextBox.Text != string.Empty)
{
BOobj.SurfaceArea = Convert.ToDecimal(surfaceareaTextBox.Text);
}
else
{
BOobj.SurfaceArea = 0;
}
//BOobj.SurfaceArea = Convert.ToInt32(surfaceareaTextBox.Text.ToString().Trim());
BOobj.OtherStructureType = otherspecifyTextBox.Text.ToString().Trim();
BOobj.DimensionLength = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
BOobj.DimensionWidth = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
BOobj.OtherOccupantStatus = occupantstatusTextBox.Text.ToString().Trim();
BOobj.CreatedBy = Convert.ToInt32(uID);;
if (RadioButton1.Checked == true)
{
BOobj.Owner = "Self";
//RadioButton2.Checked = false;
}
else if (RadioButton2.Checked == true)
{
BOobj.Owner = "Other";
BOobj.OwnerName = otherTextBox.Text;
}
if (RadioButton3.Checked == true)
{
BOobj.Occupant = "Self";
//RadioButton2.Checked = false;
}
else if (RadioButton4.Checked == true)
{
BOobj.Occupant = "Other";
BOobj.OtherOccupantName = otherselfoccupantTextBox.Text.ToString();
//RadioButton1.Checked = false;
}
//if (photoFileUpload.HasFile)
//{
// byte[] fileBytes = photoFileUpload.FileBytes;
// if (fileBytes != null)
// {
// BOobj.Photo = fileBytes;
// }
//}
BLLobj = new Non_perm_structureBLL();
count = BLLobj.EditNPS(BOobj);
projectFrozen();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
BLLobj = null;
}
}
else
{
// insert
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
//try
//{
BOobj = new NonPermanentStructureBO();
BOobj.StructureTypeID = Convert.ToInt32(buildingtypeDropDownList.SelectedValue.ToString());
if (otherspecifyTextBox.Text != string.Empty)
{
BOobj.OtherStructureType = otherspecifyTextBox.Text;
}
else
{
BOobj.OtherStructureType = "";
}
BOobj.CategoryID = Convert.ToInt32(categoryDropDownList.SelectedValue.ToString());
BOobj.StructureConditionID = Convert.ToInt32(conditionDropDownList.SelectedValue.ToString());
BOobj.OccupantStatusID = Convert.ToInt32(occupantstatusDropDownList.SelectedValue.ToString());
BOobj.OtherOccupantStatus = occupantstatusTextBox.Text.ToString().Trim();
if (lengthTextBox.Text != string.Empty)
{
BOobj.DimensionLength = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
BOobj.DimensionLength = Convert.ToDecimal(0);
}
if (widthTextBox.Text != string.Empty)
{
BOobj.DimensionWidth = Convert.ToDecimal(widthTextBox.Text);
}
else
{
BOobj.DimensionWidth = Convert.ToDecimal(0);
}
if (noofroomsTextBox.Text != string.Empty)
{
BOobj.NoOfRooms = Convert.ToInt32(noofroomsTextBox.Text);
}
else
{
BOobj.NoOfRooms = 0;
}
if (surfaceareaTextBox.Text != string.Empty)
{
BOobj.SurfaceArea = Convert.ToDecimal(surfaceareaTextBox.Text);
}
else
{
BOobj.SurfaceArea = 0;
}
if (RadioButton1.Checked == true || (RadioButton1.Checked == false && RadioButton2.Checked == false))
{
BOobj.Owner = "Self";
}
else if (RadioButton2.Checked == true)
{
BOobj.Owner = "Other";
BOobj.OwnerName = otherTextBox.Text.ToString();
}
if (RadioButton3.Checked == true || (RadioButton3.Checked == false && RadioButton4.Checked == false))
{
BOobj.Occupant = "Self";
}
else if (RadioButton4.Checked == true)
{
BOobj.Occupant = "Other";
BOobj.OtherOccupantName = otherselfoccupantTextBox.Text.ToString();
}
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
if (fileBytes != null)
{
BOobj.Photo = fileBytes;
}
}
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
if (fileBytes != null)
{
BOobj.Photo = fileBytes;
}
}
BOobj.CreatedBy = Convert.ToInt32(uID);
BOobj.HouseholdID = Convert.ToInt32(hhid);
Non_perm_structureBLL structureBLLobj = new Non_perm_structureBLL();
count = structureBLLobj.Insert(BOobj);
clearfields();
BindGrid();
SetUpdateMode(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
//}
//catch (Exception ex)
//{
// throw ex;
//}
//finally
//{
// BLLobj = null;
//}
}
ChangeRequestStatusNonPermStr();
projectFrozen();
}
/// <summary>
/// To fetch details and assign to textbox
/// </summary>
private void GetNPS1()
{
Non_perm_structureBLL BLLobj = new Non_perm_structureBLL();
int NonPermanentStructureID = 0;
if (ViewState["NONPERM_STRUCTUREID"] != null)
{
NonPermanentStructureID = Convert.ToInt32(ViewState["NONPERM_STRUCTUREID"]);
}
NonPermanentStructureBO BOobj = new NonPermanentStructureBO();
BOobj = BLLobj.GetNPSId(NonPermanentStructureID);
IDTextBox1.Text = BOobj.NonPermanentStructureID.ToString();
noofroomsTextBox.Text = BOobj.NoOfRooms.ToString();
lengthTextBox.Text = BOobj.DimensionLength.ToString();
widthTextBox.Text = BOobj.DimensionWidth.ToString();
surfaceareaTextBox.Text = BOobj.SurfaceArea.ToString();
otherspecifyTextBox.Text = BOobj.OtherStructureType.ToString();
otherTextBox.Enabled = false;
if (BOobj.Owner == "Self")
{
RadioButton1.Checked = true;
}
else
{
RadioButton2.Checked = true;
otherTextBox.Enabled = true;
otherTextBox.Text = BOobj.OwnerName.ToString();
}
otherselfoccupantTextBox.Enabled = false;
if (BOobj.Occupant == "Self")
{
RadioButton3.Checked = true;
}
else
{
RadioButton4.Checked = true;
otherselfoccupantTextBox.Enabled = true;
otherselfoccupantTextBox.Text = BOobj.OtherOccupantName.ToString();
}
buildingtypeDropDownList.ClearSelection();
if (buildingtypeDropDownList.Items.FindByValue(BOobj.StructureTypeID.ToString()) != null)
{
buildingtypeDropDownList.Items.FindByValue(BOobj.StructureTypeID.ToString()).Selected = true;
}
occupantstatusDropDownList.ClearSelection();
if (occupantstatusDropDownList.Items.FindByValue(BOobj.OccupantStatusID.ToString()) != null)
{
occupantstatusDropDownList.Items.FindByValue(BOobj.OccupantStatusID.ToString()).Selected = true;
}
categoryDropDownList.ClearSelection();
if (categoryDropDownList.Items.FindByValue(BOobj.CategoryID.ToString()) != null)
{
categoryDropDownList.Items.FindByValue(BOobj.CategoryID.ToString()).Selected = true;
}
conditionDropDownList.ClearSelection();
if (conditionDropDownList.Items.FindByValue(BOobj.StructureConditionID.ToString()) != null)
{
conditionDropDownList.Items.FindByValue(BOobj.StructureConditionID.ToString()).Selected = true;
}
}
/// <summary>
/// To Get Non Permanent Structure Id
/// </summary>
/// <param name="NonPermanentStructureID"></param>
/// <returns></returns>
public NonPermanentStructureBO GetNPSId(int NonPermanentStructureID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_NPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("S_NONPERM_STRUCTUREID", NonPermanentStructureID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
NonPermanentStructureBO BOobj1 = null;
Non_perm_structureList Non_perm_structureListobj = new Non_perm_structureList();
BOobj1 = new NonPermanentStructureBO();
while (dr.Read())
{
if (ColumnExists(dr, "nonperm_structureid") && !dr.IsDBNull(dr.GetOrdinal("nonperm_structureid")))
{
BOobj1.NonPermanentStructureID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("nonperm_structureid")));
}
if (ColumnExists(dr, "str_typeid") && !dr.IsDBNull(dr.GetOrdinal("str_typeid")))
{
BOobj1.StructureTypeID = dr.GetInt32(dr.GetOrdinal("str_typeid"));
}
if (ColumnExists(dr, "categoryid") && !dr.IsDBNull(dr.GetOrdinal("categoryid")))
{
BOobj1.CategoryID = dr.GetInt32(dr.GetOrdinal("categoryid"));
}
if (ColumnExists(dr, "str_conditionid") && !dr.IsDBNull(dr.GetOrdinal("str_conditionid")))
{
BOobj1.StructureConditionID = dr.GetInt32(dr.GetOrdinal("str_conditionid"));
}
if (ColumnExists(dr, "otherstructuretype") && !dr.IsDBNull(dr.GetOrdinal("otherstructuretype")))
{
BOobj1.OtherStructureType = dr.GetString(dr.GetOrdinal("otherstructuretype"));
}
if (ColumnExists(dr, "owner") && !dr.IsDBNull(dr.GetOrdinal("owner")))
{
BOobj1.Owner = dr.GetString(dr.GetOrdinal("owner"));
}
if (ColumnExists(dr, "ownername") && !dr.IsDBNull(dr.GetOrdinal("ownername")))
{
BOobj1.OwnerName = dr.GetString(dr.GetOrdinal("ownername"));
}
if (ColumnExists(dr, "occupant") && !dr.IsDBNull(dr.GetOrdinal("occupant")))
{
BOobj1.Occupant = dr.GetString(dr.GetOrdinal("occupant"));
}
if (ColumnExists(dr, "otheroccupantname") && !dr.IsDBNull(dr.GetOrdinal("otheroccupantname")))
{
BOobj1.OtherOccupantName = dr.GetString(dr.GetOrdinal("otheroccupantname"));
}
if (ColumnExists(dr, "occupantstatusid") && !dr.IsDBNull(dr.GetOrdinal("occupantstatusid")))
{
BOobj1.OccupantStatusID = dr.GetInt32(dr.GetOrdinal("occupantstatusid"));
}
if (ColumnExists(dr, "otheroccupantstatus") && !dr.IsDBNull(dr.GetOrdinal("otheroccupantstatus")))
{
BOobj1.OtherOccupantStatus = dr.GetString(dr.GetOrdinal("otheroccupantstatus"));
}
if (!dr.IsDBNull(dr.GetOrdinal("dimen_length")))
{
BOobj1.DimensionLength = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("dimen_length")));
}
if (!dr.IsDBNull(dr.GetOrdinal("dimen_width")))
{
BOobj1.DimensionWidth = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("dimen_width")));
}
if (!dr.IsDBNull(dr.GetOrdinal("noofrooms")))
{
BOobj1.NoOfRooms = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("noofrooms")));
}
if (!dr.IsDBNull(dr.GetOrdinal("surfacearea")))
{
BOobj1.SurfaceArea = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("surfacearea")));
}
}
dr.Close();
return(BOobj1);
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="BOobj"></param>
/// <returns></returns>
public int Insert(NonPermanentStructureBO BOobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_INS_NPS", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("HHID", BOobj.HouseholdID);
if (BOobj.StructureTypeID > 0)
{
dcmd.Parameters.Add("STR_TYPEID", BOobj.StructureTypeID);
}
else
{
dcmd.Parameters.Add("STR_TYPEID", DBNull.Value);
}
dcmd.Parameters.Add("OTHERSTRUCTURETYPE", BOobj.OtherStructureType);
if (BOobj.CategoryID > 0)
{
dcmd.Parameters.Add("CATEGORYID", BOobj.CategoryID);
}
else
{
dcmd.Parameters.Add("CATEGORYID", DBNull.Value);
}
if (BOobj.StructureConditionID > 0)
{
dcmd.Parameters.Add("STR_CONDITIONID", BOobj.StructureConditionID);
}
else
{
dcmd.Parameters.Add("STR_CONDITIONID", DBNull.Value);
}
// dcmd.Parameters.Add("CATEGORYID", BOobj.CategoryID);
// dcmd.Parameters.Add("STR_CONDITIONID", BOobj.StructureConditionID);
dcmd.Parameters.Add("OWNER", BOobj.Owner);
dcmd.Parameters.Add("OWNERNAME", BOobj.OwnerName);
dcmd.Parameters.Add("OCCUPANT", BOobj.Occupant);
dcmd.Parameters.Add("OTHEROCCUPANTNAME", BOobj.OtherOccupantName);
if (BOobj.OccupantStatusID > 0)
{
dcmd.Parameters.Add("OCCUPANTSTATUSID", BOobj.OccupantStatusID);
}
else
{
dcmd.Parameters.Add("OCCUPANTSTATUSID", DBNull.Value);
}
//dcmd.Parameters.Add("OCCUPANTSTATUSID", BOobj.OccupantStatusID);
dcmd.Parameters.Add("OTHEROCCUPANTSTATUS", BOobj.OtherOccupantStatus);
dcmd.Parameters.Add("DIMEN_LENGTH", BOobj.DimensionLength);
dcmd.Parameters.Add("DIMEN_WIDTH", BOobj.DimensionWidth);
dcmd.Parameters.Add("NOOFROOMS", BOobj.NoOfRooms);
dcmd.Parameters.Add("SURFACEAREA", BOobj.SurfaceArea);
dcmd.Parameters.Add("CREATEDBY", BOobj.CreatedBy);
if (BOobj.Photo != null)
{
dcmd.Parameters.Add(new OracleParameter("PAPNPPHOTO_", OracleDbType.Blob)).Value = BOobj.Photo;
}
else
{
dcmd.Parameters.Add("PAPNPPHOTO_", Oracle.DataAccess.Types.OracleBlob.Null);
}
return(dcmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
