/// <summary> /// To Update /// </summary> /// <param name="oBO"></param> /// <returns></returns> public String Update(PublicConsultationBO oBO) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_PCDD", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("consultationid_", oBO.CONSULTATIONID); dcmd.Parameters.Add("DISTRICT_", oBO.District); dcmd.Parameters.Add("COUNTY_", oBO.County); dcmd.Parameters.Add("SUBCOUNTY_", oBO.SubCounty); dcmd.Parameters.Add("PARISH_", oBO.Parish); dcmd.Parameters.Add("VILLAGE_", oBO.Village); dcmd.Parameters.Add("NAMEOFPERSON_", oBO.NameOfPerson); dcmd.Parameters.Add("ADDRESS_", oBO.Address); dcmd.Parameters.Add("TELEPHONE_", oBO.Telephone); dcmd.Parameters.Add("STAKEHOLDINGCATEG_", oBO.StakeholdingCategory); if (oBO.ConsultationDate != DateTime.MinValue) { dcmd.Parameters.Add("CONSULTATIONDATE_", oBO.ConsultationDate.ToString(UtilBO.DateFormatDB)); } else { dcmd.Parameters.Add("CONSULTATIONDATE_", DBNull.Value); } dcmd.Parameters.Add("PURPOSEOFMEETING_", oBO.PurposeOfMeeting); dcmd.Parameters.Add("ISSUES_", oBO.Issues); dcmd.Parameters.Add("REMEDIES_", oBO.Remedies); dcmd.Parameters.Add("OFFICERINCHARGE_", oBO.OfficerIncharge); dcmd.Parameters.Add("updatedby_", oBO.UpdatedBy); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); String result = dcmd.Parameters["errorMessage_"].Value.ToString(); return(result); } catch (Exception ex) { throw ex; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } }
/// <summary> /// To Update /// </summary> /// <param name="BOobj"></param> /// <returns></returns> public String Update(PublicConsultationBO BOobj) { PublicConsultationDAL DALobj = new PublicConsultationDAL(); //Data pass -to Database Layer try { return(DALobj.Update(BOobj)); } catch (Exception ex) { throw ex; } finally { DALobj = null; } }
/// <summary> /// Get Data /// </summary> private void GetData() { PublicConsultationBLL oBLL = new PublicConsultationBLL(); int CONSULTATIONID = 0; if (ViewState["CONSULTATIONID"] != null) { CONSULTATIONID = Convert.ToInt32(ViewState["CONSULTATIONID"]); } PublicConsultationBO oBO = new PublicConsultationBO(); oBO = oBLL.GetData(CONSULTATIONID); if (oBO != null) { txtbxPurposeofMeeting.Text = oBO.PurposeOfMeeting; txtbxIssuesArising.Text = oBO.Issues; txtbxProposedRem.Text = oBO.Remedies; txtbxCategoryofStakeholding.Text = oBO.StakeholdingCategory; txtbxAddress.Text = oBO.Address; txtbxNameofthePersonGroup.Text = oBO.NameOfPerson; txtbxTelephoneContact.Text = oBO.Telephone; txtConsultationDate.Text = oBO.ConsultationDate.ToString(UtilBO.DateFormat); ddlDistrict.ClearSelection(); if (ddlDistrict.Items.FindByText(oBO.District) != null) { ddlDistrict.Items.FindByText(oBO.District).Selected = true; } if (ddlDistrict.SelectedIndex > 0) { BindCounties(ddlDistrict.SelectedItem.Value); if (Convert.ToString(oBO.County) != "") { ddlCounty.ClearSelection(); if (ddlCounty.Items.FindByText(oBO.County) != null) { ddlCounty.Items.FindByText(oBO.County).Selected = true; } } } if (ddlCounty.SelectedIndex > 0) { BindSubCounties(ddlCounty.SelectedItem.Value); if (Convert.ToString(oBO.SubCounty) != "") { ddlSubCounty.ClearSelection(); if (ddlSubCounty.Items.FindByText(oBO.SubCounty) != null) { ddlSubCounty.Items.FindByText(oBO.SubCounty).Selected = true; } } } if (ddlSubCounty.SelectedIndex > 0) { BindVillages(ddlSubCounty.SelectedItem.Value); if (Convert.ToString(oBO.Village) != "") { ddlVillage.ClearSelection(); if (ddlVillage.Items.FindByText(oBO.Village) != null) { ddlVillage.Items.FindByText(oBO.Village).Selected = true; } } BindParish(ddlSubCounty.SelectedItem.Value); if (oBO.Parish != null || Convert.ToString(oBO.Parish) != "") { ddlParish.ClearSelection(); if (ddlParish.Items.FindByText(Convert.ToString(oBO.Parish).ToUpper()) != null) { ddlParish.Items.FindByText(Convert.ToString(oBO.Parish).ToUpper()).Selected = true; } } } ddlOfficerInCharge.ClearSelection(); if (ddlOfficerInCharge.Items.FindByValue(oBO.OfficerIncharge.ToString()) != null) { ddlOfficerInCharge.Items.FindByValue(oBO.OfficerIncharge.ToString()).Selected = true; } } }
/// <summary> /// Save and Update /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { int count = 0; if (ViewState["CONSULTATIONID"].ToString() == "0") { PublicConsultationBLL oBLL = new PublicConsultationBLL(); try { string uID = Session["USER_ID"].ToString(); PublicConsultationBO oBO = new PublicConsultationBO(); oBO.ProjectID = Convert.ToInt32(Session["PROJECT_ID"]); oBO.District = ddlDistrict.SelectedItem.Text; oBO.County = ddlCounty.SelectedItem.Text; oBO.SubCounty = ddlSubCounty.SelectedItem.Text; oBO.Parish = ddlParish.SelectedItem.Text; oBO.Village = ddlVillage.SelectedItem.Text; oBO.NameOfPerson = txtbxNameofthePersonGroup.Text.Trim(); string strMax = txtbxAddress.Text.ToString().Trim(); if (strMax.Trim().Length >= 500) { strMax = txtbxAddress.Text.ToString().Trim().Substring(0, 500); } oBO.Address = strMax; oBO.Telephone = txtbxTelephoneContact.Text.Trim(); oBO.StakeholdingCategory = txtbxCategoryofStakeholding.Text.Trim(); oBO.ConsultationDate = Convert.ToDateTime(txtConsultationDate.Text); oBO.OfficerIncharge = Convert.ToInt32(ddlOfficerInCharge.SelectedItem.Value); oBO.PurposeOfMeeting = txtbxPurposeofMeeting.Text; string strngMax = txtbxIssuesArising.Text.ToString().Trim(); if (strngMax.Trim().Length >= 2000) { strngMax = txtbxIssuesArising.Text.ToString().Trim().Substring(0, 2000); } oBO.Issues = strngMax; string strngMaxstr = txtbxProposedRem.Text.ToString().Trim(); if (strngMax.Trim().Length >= 2000) { strngMaxstr = txtbxProposedRem.Text.ToString().Trim().Substring(0, 2000); } oBO.Remedies = strngMaxstr; oBO.CreatedBy = Convert.ToInt32(uID); String Message = oBLL.Insert(oBO); BindGrid(true, true); if (String.IsNullOrEmpty(Message) || Message == "null") { ClearData(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data Saved successfully');", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "NotAdded", "alert('" + Message + "');", true); } } catch (Exception ex) { throw ex; } finally { oBLL = null; } } else { PublicConsultationBLL oBLL = new PublicConsultationBLL(); try { string uID = Session["USER_ID"].ToString(); PublicConsultationBO oBO = new PublicConsultationBO(); oBO.CONSULTATIONID = Convert.ToInt32(ViewState["CONSULTATIONID"]); oBO.ProjectID = Convert.ToInt32(Session["PROJECT_ID"]); oBO.District = ddlDistrict.SelectedItem.Text; oBO.County = ddlCounty.SelectedItem.Text; oBO.SubCounty = ddlSubCounty.SelectedItem.Text; oBO.Parish = ddlParish.SelectedItem.Text; oBO.Village = ddlVillage.SelectedItem.Text; oBO.NameOfPerson = txtbxNameofthePersonGroup.Text.Trim(); oBO.Address = txtbxAddress.Text.Trim(); oBO.Telephone = txtbxTelephoneContact.Text.Trim(); oBO.StakeholdingCategory = txtbxCategoryofStakeholding.Text.Trim(); oBO.ConsultationDate = Convert.ToDateTime(txtConsultationDate.Text); oBO.OfficerIncharge = Convert.ToInt32(ddlOfficerInCharge.SelectedItem.Value); oBO.PurposeOfMeeting = txtbxPurposeofMeeting.Text; oBO.Issues = txtbxIssuesArising.Text; oBO.Remedies = txtbxProposedRem.Text; oBO.UpdatedBy = Convert.ToInt32(uID); //PublicConsultationBLL oBLL1 = new PublicConsultationBLL(); String Message = oBLL.Update(oBO); // ClearData(); BindGrid(true, true); SetUpdateMode(false); if (String.IsNullOrEmpty(Message) || Message == "null") { ClearData(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data Updated successfully');", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "NotAdded", "alert('" + Message + "');", true); } } catch (Exception ex) { throw ex; } finally { oBLL = null; } } }
/// <summary> /// To Get Public Consultation /// </summary> /// <param name="projectID"></param> /// <returns></returns> public PublicConsultationList GetPublucConsultation(int projectID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_SEL_PCDD"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("projectID_", projectID); cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); PublicConsultationBO oBO = null; PublicConsultationList listobj = new PublicConsultationList(); while (dr.Read()) { oBO = new PublicConsultationBO(); oBO.CONSULTATIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONSULTATIONID"))); if (!dr.IsDBNull(dr.GetOrdinal("DISTRICT"))) { oBO.District = dr.GetString(dr.GetOrdinal("DISTRICT")); } if (!dr.IsDBNull(dr.GetOrdinal("COUNTY"))) { oBO.County = dr.GetString(dr.GetOrdinal("COUNTY")); } if (!dr.IsDBNull(dr.GetOrdinal("SUBCOUNTY"))) { oBO.SubCounty = dr.GetString(dr.GetOrdinal("SUBCOUNTY")); } if (!dr.IsDBNull(dr.GetOrdinal("PARISH"))) { oBO.Parish = dr.GetString(dr.GetOrdinal("PARISH")); } if (!dr.IsDBNull(dr.GetOrdinal("VILLAGE"))) { oBO.Village = dr.GetString(dr.GetOrdinal("VILLAGE")); } if (!dr.IsDBNull(dr.GetOrdinal("NAMEOFPERSON"))) { oBO.NameOfPerson = dr.GetString(dr.GetOrdinal("NAMEOFPERSON")); } if (!dr.IsDBNull(dr.GetOrdinal("ADDRESS"))) { oBO.Address = dr.GetString(dr.GetOrdinal("ADDRESS")); } if (!dr.IsDBNull(dr.GetOrdinal("TELEPHONE"))) { oBO.Telephone = dr.GetString(dr.GetOrdinal("TELEPHONE")); } if (!dr.IsDBNull(dr.GetOrdinal("STAKEHOLDINGCATEG"))) { oBO.StakeholdingCategory = dr.GetString(dr.GetOrdinal("STAKEHOLDINGCATEG")); } if (!dr.IsDBNull(dr.GetOrdinal("CONSULTATIONDATE"))) { oBO.ConsultationDate = dr.GetDateTime(dr.GetOrdinal("CONSULTATIONDATE")); } if (!dr.IsDBNull(dr.GetOrdinal("PURPOSEOFMEETING"))) { oBO.PurposeOfMeeting = dr.GetString(dr.GetOrdinal("PURPOSEOFMEETING")); } if (!dr.IsDBNull(dr.GetOrdinal("ISSUES"))) { oBO.Issues = dr.GetString(dr.GetOrdinal("ISSUES")); } if (!dr.IsDBNull(dr.GetOrdinal("REMEDIES"))) { oBO.Remedies = dr.GetString(dr.GetOrdinal("REMEDIES")); } if (!dr.IsDBNull(dr.GetOrdinal("OFFICERINCHARGENAME"))) { oBO.OfficerInchargeName = dr.GetString(dr.GetOrdinal("OFFICERINCHARGENAME")); } listobj.Add(oBO); } dr.Close(); return(listobj); }