/// <summary> /// to get Image File for DataBase /// </summary> /// <param name="householdID"></param> /// <param name="PermanentStructureID"></param> /// <returns></returns> public CulturPropertiesBO ShowPAPCPImage(int householdID, int PermanentStructureID) { OracleConnection myConnection; OracleCommand myCommand; myConnection = new OracleConnection(AppConfiguration.ConnectionString); myCommand = new OracleCommand("USP_TRN_GET_PAPCP_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; CulturPropertiesBO objPAPCP = new CulturPropertiesBO(); objPAPCP.Photo = papPhotoBytes; return(objPAPCP); //return new System.IO.MemoryStream(papPhotoBytes); } catch (Exception ex) { return(null); } finally { myConnection.Close(); } }
/// <summary> /// To fetch details from database /// </summary> /// <returns></returns> public CulturePropertiesList GetCulturalPropertyType() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_NAME_CULTURPROP"; 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); CulturPropertiesBO BOobj = null; CulturePropertiesList Listobj = new CulturePropertiesList(); while (dr.Read()) { BOobj = new CulturPropertiesBO(); BOobj.CULTUREPROPTYPEID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPEID")))); BOobj.CULTUREPROPTYP = dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPE")).ToString(); Listobj.Add(BOobj); } dr.Close(); return(Listobj); }
/// <summary> /// To insert details to database /// </summary> /// <param name="CulturPropertiesobj"></param> /// <returns></returns> public int Insert(CulturPropertiesBO CulturPropertiesobj) { //string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_TRN_INS_CULTURPROP", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("HHID", CulturPropertiesobj.HHID); dcmd.Parameters.Add("CULTUREPROPTYPEID", CulturPropertiesobj.CULTUREPROPTYPEID); dcmd.Parameters.Add("CULTUREPROPDESCRIPTION", CulturPropertiesobj.CULTUREPROPDESCRIPTION); dcmd.Parameters.Add("CULT_DIMEN_LENGTH", CulturPropertiesobj.CULT_DIMEN_LENGTH); dcmd.Parameters.Add("CULT_DIMEN_WIDTH", CulturPropertiesobj.CULT_DIMEN_WIDTH); dcmd.Parameters.Add("CULT_DEPRECIATEDVALUE", CulturPropertiesobj.CULT_DEPRECIATEDVALUE); dcmd.Parameters.Add("CULT_VALUATIONAMOUNT", CulturPropertiesobj.CULT_VALUATIONAMOUNT); dcmd.Parameters.Add("ISDELETED", CulturPropertiesobj.ISDELETED); dcmd.Parameters.Add("CREATEDBY", CulturPropertiesobj.CREATEDBY); if (CulturPropertiesobj.Photo != null) { dcmd.Parameters.Add("PAPCPPHOTO_", OracleDbType.Blob).Value = CulturPropertiesobj.Photo; } else { dcmd.Parameters.Add("PAPCPPHOTO_", Oracle.DataAccess.Types.OracleBlob.Null); } //dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; return(dcmd.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }
/// <summary> /// To update data to database /// </summary> /// <param name="CulturPropertiesobj"></param> /// <returns></returns> public int Update(CulturPropertiesBO CulturPropertiesobj) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_CULTURPROP", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("HHID_", CulturPropertiesobj.HHID); dcmd.Parameters.Add("c_CULTURALPROPID", CulturPropertiesobj.CULTURALPROPID); dcmd.Parameters.Add("c_CULTUREPROPTYPEID", CulturPropertiesobj.CULTUREPROPTYPEID); dcmd.Parameters.Add("c_CULTUREPROPDESCRIPTION", CulturPropertiesobj.CULTUREPROPDESCRIPTION); dcmd.Parameters.Add("c_CULT_DIMEN_LENGTH", CulturPropertiesobj.CULT_DIMEN_LENGTH); dcmd.Parameters.Add("c_CULT_DIMEN_WIDTH", CulturPropertiesobj.CULT_DIMEN_WIDTH); dcmd.Parameters.Add("c_CULT_DEPRECIATEDVALUE", CulturPropertiesobj.CULT_DEPRECIATEDVALUE); dcmd.Parameters.Add("c_CULT_VALUATIONAMOUNT", CulturPropertiesobj.CULT_VALUATIONAMOUNT); dcmd.Parameters.Add("c_UPDATEDBY", CulturPropertiesobj.CREATEDBY); if (CulturPropertiesobj.Photo != null) { dcmd.Parameters.Add("PAPCPPHOTO_", OracleDbType.Blob).Value = CulturPropertiesobj.Photo; } else { dcmd.Parameters.Add("PAPCPPHOTO_", Oracle.DataAccess.Types.OracleBlob.Null); } return(dcmd.ExecuteNonQuery()); } catch (Exception ex) { throw ex; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }
/// <summary> /// To Update /// </summary> /// <param name="CulturPropertiesobj"></param> /// <returns></returns> public int Update(CulturPropertiesBO CulturPropertiesobj) { CulturePropertiesDAL DALobj = new CulturePropertiesDAL(); //Data pass -to Database Layer try { return(DALobj.Update(CulturPropertiesobj)); } catch (Exception ex) { throw ex; } finally { DALobj = null; } }
/// <summary> /// To fetch details from database /// </summary> /// <param name="householdID"></param> /// <returns></returns> public CulturePropertiesList GetCultureProp(int householdID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_CULTURPROP"; 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); CulturPropertiesBO CulturPropertiesobj = null; CulturePropertiesList Listobj = new CulturePropertiesList(); while (dr.Read()) { CulturPropertiesobj = new CulturPropertiesBO(); CulturPropertiesobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("culturalpropid"))); if (!dr.IsDBNull(dr.GetOrdinal("cultureproptype"))) { CulturPropertiesobj.CULTUREPROPTYP = dr.GetString(dr.GetOrdinal("cultureproptype")); } if (!dr.IsDBNull(dr.GetOrdinal("culturepropdescription"))) { CulturPropertiesobj.CULTUREPROPDESCRIPTION = dr.GetString(dr.GetOrdinal("culturepropdescription")); } else { CulturPropertiesobj.CULTUREPROPDESCRIPTION = " "; } CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("cult_valuationamount"))); Listobj.Add(CulturPropertiesobj); } dr.Close(); return(Listobj); }
public System.IO.MemoryStream ShowPAPCPImage(int householdID, int PermanentStructureID) { try { CulturPropertiesBO objPAPCP = (new CulturePropertiesBLL()).ShowPAPCPImage(householdID, PermanentStructureID); if (objPAPCP.Photo != null) { return(new System.IO.MemoryStream(objPAPCP.Photo)); } else { return(null); } } catch (Exception ex) { return(null); } }
/// <summary> /// To fetch data and assign to textbox /// </summary> private void GetData() { CulturePropertiesBLL BLLobj = new CulturePropertiesBLL(); int culTURALPROPID = 0; if (ViewState["CULTURALPROPID"] != null) { culTURALPROPID = Convert.ToInt32(ViewState["CULTURALPROPID"]); } CulturPropertiesBO BOobj = new CulturPropertiesBO(); BOobj = BLLobj.GetData(culTURALPROPID); CULTURALPROPIDtxtbx.Text = BOobj.CULTURALPROPID.ToString(); ddlCulturePropertyType.ClearSelection(); if (ddlCulturePropertyType.Items.FindByValue(BOobj.CULTUREPROPTYPEID.ToString()) != null) { ddlCulturePropertyType.Items.FindByValue(BOobj.CULTUREPROPTYPEID.ToString()).Selected = true; } txtbxDescription.Text = BOobj.CULTUREPROPDESCRIPTION; if (BOobj.CULT_DIMEN_LENGTH.ToString() == "0") { txtbxlength.Text = ""; } else { txtbxlength.Text = BOobj.CULT_DIMEN_LENGTH.ToString(); } if (BOobj.CULT_DIMEN_WIDTH.ToString() == "0") { txtbxwidth.Text = ""; } else { txtbxwidth.Text = BOobj.CULT_DIMEN_WIDTH.ToString(); } if (BOobj.CULT_DEPRECIATEDVALUE.ToString() == "0") { txtbxwidth.Text = ""; } else { txtbxDepreciatedValue.Text = BOobj.CULT_DEPRECIATEDVALUE.ToString(); } if (BOobj.CULT_DEPRECIATEDVALUE.ToString() == "0") { txtbxwidth.Text = ""; } else { txtbxDepreciatedValue.Text = BOobj.CULT_DEPRECIATEDVALUE.ToString(); } if (BOobj.CULT_VALUATIONAMOUNT.ToString() == "0") { txtbxValuationAmount.Text = ""; } else { txtbxValuationAmount.Text = BOobj.CULT_VALUATIONAMOUNT.ToString(); } }
/// <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; if (CULTURALPROPIDtxtbx.Text == string.Empty) { CulturePropertiesBLL BLLobj = new CulturePropertiesBLL(); try { string uID = Session["USER_ID"].ToString(); string hhid = Session["HH_ID"].ToString(); CulturPropertiesBO CulturPropertiesobj = new CulturPropertiesBO(); CulturPropertiesobj.HHID = Convert.ToInt32(hhid); CulturPropertiesobj.CULTUREPROPTYPEID = Convert.ToInt32(ddlCulturePropertyType.SelectedValue); if (txtbxDescription.Text != string.Empty) { if (txtbxDescription.Text.Length > 250) { CulturPropertiesobj.CULTUREPROPDESCRIPTION = txtbxDescription.Text.Substring(0, 250); } else { CulturPropertiesobj.CULTUREPROPDESCRIPTION = txtbxDescription.Text; } } else { CulturPropertiesobj.CULTUREPROPDESCRIPTION = ""; } if (txtbxlength.Text.Trim() != "") { CulturPropertiesobj.CULT_DIMEN_LENGTH = Convert.ToInt32(txtbxlength.Text); } if (txtbxwidth.Text.Trim() != "") { CulturPropertiesobj.CULT_DIMEN_WIDTH = Convert.ToInt32(txtbxwidth.Text); } if (txtbxDepreciatedValue.Text.Trim() != "") { CulturPropertiesobj.CULT_DEPRECIATEDVALUE = Convert.ToDecimal(txtbxDepreciatedValue.Text); } if (txtbxValuationAmount.Text.Trim() != "") { CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(txtbxValuationAmount.Text); } CulturPropertiesobj.ISDELETED = "False"; CulturPropertiesobj.CREATEDBY = Convert.ToInt32(uID); //if (photoFileUpload.HasFile) //{ // byte[] fileBytes = photoFileUpload.FileBytes; // CulturPropertiesobj.Photo = fileBytes; //} CulturePropertiesBLL CulturePropertiesBLLobj = new CulturePropertiesBLL(); count = CulturePropertiesBLLobj.Insert(CulturPropertiesobj); ChangeRequestStatusCulturProperties(); projectFrozen(); ClearData(); BindGrid(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "ShowSaveMessage('');", true); } catch (Exception ex) { throw ex; } finally { BLLobj = null; } } else if (CULTURALPROPIDtxtbx.Text != string.Empty) { CulturePropertiesBLL BLLobj = new CulturePropertiesBLL(); try { string uID = Session["USER_ID"].ToString(); string hhid = Session["HH_ID"].ToString(); CulturPropertiesBO CulturPropertiesobj = new CulturPropertiesBO(); CulturPropertiesobj.HHID = Convert.ToInt32(hhid); CulturPropertiesobj.CULTURALPROPID = Convert.ToInt32(CULTURALPROPIDtxtbx.Text); CulturPropertiesobj.CULTUREPROPTYPEID = Convert.ToInt32(ddlCulturePropertyType.SelectedValue); if (txtbxDescription.Text.Length > 250) { CulturPropertiesobj.CULTUREPROPDESCRIPTION = txtbxDescription.Text.Substring(0, 250); } else { CulturPropertiesobj.CULTUREPROPDESCRIPTION = txtbxDescription.Text; } if (txtbxlength.Text.Trim() != "") { CulturPropertiesobj.CULT_DIMEN_LENGTH = Convert.ToInt32(txtbxlength.Text); } if (txtbxwidth.Text.Trim() != "") { CulturPropertiesobj.CULT_DIMEN_WIDTH = Convert.ToInt32(txtbxwidth.Text); } if (txtbxDepreciatedValue.Text.Trim() != "") { CulturPropertiesobj.CULT_DEPRECIATEDVALUE = Convert.ToDecimal(txtbxDepreciatedValue.Text); } if (txtbxValuationAmount.Text.Trim() != "") { CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(txtbxValuationAmount.Text); } CulturPropertiesobj.ISDELETED = "False"; CulturPropertiesobj.CREATEDBY = Convert.ToInt32(uID); //if (photoFileUpload.HasFile) //{ // byte[] fileBytes = photoFileUpload.FileBytes; // CulturPropertiesobj.Photo = fileBytes; //} CulturePropertiesBLL CulturePropertiesBLLobj = new CulturePropertiesBLL(); count = CulturePropertiesBLLobj.Update(CulturPropertiesobj); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "ShowUpdateMessage('');", true); ClearData(); BindGrid(); SetUpdateMode(false); } catch (Exception ex) { throw ex; } finally { BLLobj = null; } } }
/// <summary> /// To fetch details from database /// </summary> /// <param name="culTURALPROPID"></param> /// <returns></returns> public CulturPropertiesBO GetData(int culTURALPROPID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_CULTURPROP";//"USP_TRN_GET_DAMAGE_CROPS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("C_CULTURALPROPID", culTURALPROPID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CulturPropertiesBO CulturPropertiesobj = null; CulturePropertiesList Listobj = new CulturePropertiesList(); CulturPropertiesobj = new CulturPropertiesBO(); while (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("CULTURALPROPID"))) { CulturPropertiesobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTURALPROPID"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULTUREPROPTYPEID"))) { CulturPropertiesobj.CULTUREPROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPEID"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULTUREPROPDESCRIPTION"))) { CulturPropertiesobj.CULTUREPROPDESCRIPTION = dr.GetString(dr.GetOrdinal("CULTUREPROPDESCRIPTION")); } if (!dr.IsDBNull(dr.GetOrdinal("CULT_DIMEN_LENGTH"))) { CulturPropertiesobj.CULT_DIMEN_LENGTH = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULT_DIMEN_LENGTH"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULT_DIMEN_WIDTH"))) { CulturPropertiesobj.CULT_DIMEN_WIDTH = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULT_DIMEN_WIDTH"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULT_DEPRECIATEDVALUE"))) { CulturPropertiesobj.CULT_DEPRECIATEDVALUE = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CULT_DEPRECIATEDVALUE"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULT_VALUATIONAMOUNT"))) { CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CULT_VALUATIONAMOUNT"))); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { CulturPropertiesobj.ISDELETED = dr.GetString(dr.GetOrdinal("ISDELETED")); } } dr.Close(); return(CulturPropertiesobj); }