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