/// <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(); }