/// <summary>
/// to get Image File for DataBase
/// </summary>
/// <param name="householdID"></param>
/// <param name="PermanentStructureID"></param>
/// <returns></returns>
public GraveBO ShowPAPGRAVE(int householdID, int PermanentStructureID)
{
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_GET_GRAVE_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;
GraveBO objPAPGRAVE = new GraveBO();
objPAPGRAVE.Photo = papPhotoBytes;
return(objPAPGRAVE);
//return new System.IO.MemoryStream(papPhotoBytes);
}
catch (Exception ex)
{
return(null);
}
finally
{
myConnection.Close();
}
}
public GraveList GetGraveFinish()
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_GRAVEDATA";
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);
GraveBO BOobj = null;
GraveList Listobj = new GraveList();
while (dr.Read())
{
BOobj = new GraveBO();
BOobj.Grv_finishid = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRV_FINISHID"))));
BOobj.Grv_finishtype = dr.GetValue(dr.GetOrdinal("GRV_FINISHTYPE")).ToString();
Listobj.Add(BOobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// to fetch details and assign to textbox
/// </summary>
private void Getdatarow()
{
GraveBLL gravesaveBLLobj = new GraveBLL();
int Pap_graveid = 0;
if (ViewState["PAP_GRAVEID"] != null)
{
Pap_graveid = Convert.ToInt32(ViewState["PAP_GRAVEID"]);
}
GraveBO GraveBOobj = new GraveBO();
GraveBOobj = gravesaveBLLobj.Getdatarow(Pap_graveid);
gravefinishDropDownList.ClearSelection();
if (gravefinishDropDownList.Items.FindByValue(GraveBOobj.Grv_finishid.ToString()) != null)
{
gravefinishDropDownList.Items.FindByValue(GraveBOobj.Grv_finishid.ToString()).Selected = true;
}
lengthTextBox.Text = Convert.ToString(GraveBOobj.Grv_dimen_length);
widthTextBox.Text = Convert.ToString(GraveBOobj.Grv_dimen_width);
surfaceareaTextBox.Text = (GraveBOobj.Grv_dimen_length * GraveBOobj.Grv_dimen_width).ToString();
depreciatedvalueTextBox.Text = GraveBOobj.Depreciatedvalue.ToString();
otherfinishTextBox.Text = GraveBOobj.Othergravefinish.ToString();
}
/// <summary>
/// to fetch details
/// </summary>
/// <param name="Pap_graveid"></param>
/// <returns></returns>
public GraveBO Getdatarow(int Pap_graveid)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_GRAVE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("G_PAP_GRAVEID", Pap_graveid);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
GraveBO GraveBOobj = null;
GraveList GraveListobj = new GraveList();
GraveBOobj = new GraveBO();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("pap_graveid")))
{
GraveBOobj.Pap_graveid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_graveid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("grv_finishid")))
{
GraveBOobj.Grv_finishid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("grv_finishid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("grv_dimen_length")))
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("grv_dimen_length")));
}
if (!dr.IsDBNull(dr.GetOrdinal("grv_dimen_width")))
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("grv_dimen_width")));
}
if (!dr.IsDBNull(dr.GetOrdinal("depreciatedvalue")))
{
GraveBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("depreciatedvalue")));
}
if (!dr.IsDBNull(dr.GetOrdinal("othergravefinish")))
{
GraveBOobj.Othergravefinish = dr.GetString(dr.GetOrdinal("othergravefinish"));
}
}
dr.Close();
return(GraveBOobj);
}
/// <summary>
/// to insert data
/// </summary>
/// <param name="GraveBOobj"></param>
/// <returns></returns>
public int Insert(GraveBO GraveBOobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_INS_GRAVE", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
int count = Convert.ToInt32(dcmd.CommandType);
try
{
dcmd.Parameters.Add("HHID", GraveBOobj.HouseholdID);
// dcmd.Parameters.Add("GRV_FINISHID", GraveBOobj.Grv_finishid);
if (GraveBOobj.Grv_finishid > 0)
{
dcmd.Parameters.Add("GRV_FINISHID", GraveBOobj.Grv_finishid);
}
else
{
dcmd.Parameters.Add("GRV_FINISHID", DBNull.Value);
}
dcmd.Parameters.Add("OTHERGRAVEFINISH", GraveBOobj.Othergravefinish);
dcmd.Parameters.Add("GRV_DIMEN_LENGTH", GraveBOobj.Grv_dimen_length);
dcmd.Parameters.Add("GRV_DIMEN_WIDTH", GraveBOobj.Grv_dimen_width);
dcmd.Parameters.Add("DEPRECIATEDVALUE", GraveBOobj.Depreciatedvalue);
dcmd.Parameters.Add("CREATEDBY", GraveBOobj.CreatedBy);
if (GraveBOobj.Photo != null)
{
dcmd.Parameters.Add("GRAVEPHOTO_", OracleDbType.Blob).Value = GraveBOobj.Photo;
}
else
{
dcmd.Parameters.Add("GRAVEPHOTO_", Oracle.DataAccess.Types.OracleBlob.Null);
}
return(dcmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
}
/// <summary>
/// To Edit GRAVE
/// </summary>
/// <param name="GraveBOobj"></param>
/// <returns></returns>
public int EditGRAVE(GraveBO GraveBOobj)
{
GraveDAL gravedataDALobj = new GraveDAL(); //Data pass -to Database Layer
try
{
return(gravedataDALobj.EditGRAVE(GraveBOobj));
}
catch
{
throw;
}
finally
{
gravedataDALobj = null;
}
}
/// <summary>
/// To Insert into Database
/// </summary>
/// <param name="GraveBOobj"></param>
/// <returns></returns>
public int Insert(GraveBO GraveBOobj)
{
GraveDAL gravesaveDALobj = new GraveDAL(); //Data pass -to Database Layer
try
{
return(gravesaveDALobj.Insert(GraveBOobj));
}
catch
{
throw;
}
finally
{
gravesaveDALobj = null;
}
}
public System.IO.MemoryStream ShowPAPGRAVE(int householdID, int PermanentStructureID)
{
try
{
GraveBO objPAPGRAVE = (new GraveBLL()).ShowPAPGRAVE(householdID, PermanentStructureID);
if (objPAPGRAVE.Photo != null)
{
return(new System.IO.MemoryStream(objPAPGRAVE.Photo));
}
else
{
return(null);
}
}
catch (Exception ex)
{
// throw ex;
return(null);
}
}
/// <summary>
/// to fetch details
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public GraveList GetGravedata(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_GRAVE";
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);
GraveBO GraveBOobj = null;
GraveList GraveListobj = new GraveList();
while (dr.Read())
{
GraveBOobj = new GraveBO();
GraveBOobj.Pap_graveid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_GRAVEID")));
GraveBOobj.Grv_finishtype = dr.GetString(dr.GetOrdinal("GRV_FINISHTYPE"));
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("GRV_DIMEN_LENGTH")));
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("GRV_DIMEN_WIDTH")));
GraveBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DEPRECIATEDVALUE")));
GraveBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
GraveListobj.Add(GraveBOobj);
}
dr.Close();
return(GraveListobj);
}
/// <summary>
/// to save data to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
int count = 0;
GraveBLL gravesaveBLLobj = new GraveBLL();
GraveBO GraveBOobj = null;
if (Convert.ToInt32(ViewState["PAP_GRAVEID"]) > 0)
{
// update
try
{
// string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
GraveBOobj = new GraveBO();
GraveBOobj.Pap_graveid = Convert.ToInt32(ViewState["PAP_GRAVEID"]);
GraveBOobj.Grv_finishid = Convert.ToInt32(gravefinishDropDownList.SelectedValue);
if (otherfinishTextBox.Text != string.Empty)
{
GraveBOobj.Othergravefinish = otherfinishTextBox.Text;
}
else
{
GraveBOobj.Othergravefinish = "";
}
if (lengthTextBox.Text != string.Empty)
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(0);
}
if (widthTextBox.Text != string.Empty)
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(widthTextBox.Text);
}
else
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(0);
}
if (depreciatedvalueTextBox.Text != string.Empty)
{
GraveBOobj.Depreciatedvalue = Convert.ToDecimal(depreciatedvalueTextBox.Text);
}
else
{
GraveBOobj.Depreciatedvalue = 0;
}
// GraveBOobj.Othergravefinish = otherfinishTextBox.Text.ToString().Trim();
// GraveBOobj.Grv_dimen_length = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
// GraveBOobj.Grv_dimen_width = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
SetUpdateMode(false);
// GraveBOobj.Depreciatedvalue = Convert.ToInt32(depreciatedvalueTextBox.Text.ToString().Trim());
GraveBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
GraveBOobj.HouseholdID = Convert.ToInt32(hhid);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
GraveBOobj.Photo = fileBytes;
}
GraveBLL gravesaveBLL = new GraveBLL();
count = gravesaveBLLobj.EditGRAVE(GraveBOobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
gravesaveBLLobj = null;
}
}
else
{
// insert
try
{
// string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
GraveBOobj = new GraveBO();
GraveBOobj.Grv_finishid = Convert.ToInt32(gravefinishDropDownList.SelectedValue);
// GraveBOobj.Othergravefinish = otherfinishTextBox.Text.ToString().Trim();
if (otherfinishTextBox.Text != string.Empty)
{
GraveBOobj.Othergravefinish = otherfinishTextBox.Text;
}
else
{
GraveBOobj.Othergravefinish = "";
}
if (lengthTextBox.Text != string.Empty)
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(lengthTextBox.Text);
}
else
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(0);
}
if (widthTextBox.Text != string.Empty)
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(widthTextBox.Text);
}
else
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(0);
}
if (depreciatedvalueTextBox.Text != string.Empty)
{
GraveBOobj.Depreciatedvalue = Convert.ToDecimal(depreciatedvalueTextBox.Text);
}
else
{
GraveBOobj.Depreciatedvalue = 0;
}
//GraveBOobj.Grv_dimen_length = Convert.ToInt32(lengthTextBox.Text.ToString().Trim());
// GraveBOobj.Grv_dimen_width = Convert.ToInt32(widthTextBox.Text.ToString().Trim());
// GraveBOobj.Depreciatedvalue = Convert.ToInt32(depreciatedvalueTextBox.Text.ToString().Trim());
GraveBOobj.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
GraveBOobj.HouseholdID = Convert.ToInt32(hhid);
if (photoFileUpload.HasFile)
{
byte[] fileBytes = photoFileUpload.FileBytes;
GraveBOobj.Photo = fileBytes;
}
GraveBLL graveBLLobj = new GraveBLL();
count = graveBLLobj.Insert(GraveBOobj);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true);
clearfields();
BindGrid();
SetUpdateMode(false);
}
catch (Exception ex)
{
throw ex;
}
finally
{
gravesaveBLLobj = null;
}
}
ChangeRequestStatusGrave();
projectFrozen();
}
