/// <summary>
/// Bind data to grid
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>
private void BindGrid(bool addRow, bool deleteRow)
{
int ProjectId = 0;
if (Session["PROJECT_ID"] != null)
{
ProjectId = Convert.ToInt32(Session["PROJECT_ID"]);
}
PublicConsultationBLL oBLL = new PublicConsultationBLL();
PublicConsultationList PublicConsul = oBLL.GetPublucConsultation(ProjectId);
if (PublicConsul.Count > 0)
{
p1Grid.Style.Add("display", "");
}
else
{
p1Grid.Style.Add("display", "none");
}
grdPublicConsultation.DataSource = oBLL.GetPublucConsultation(ProjectId);
grdPublicConsultation.DataBind();
p1Grid.Visible = true;
p1Grid.ScrollBars = ScrollBars.Horizontal;
}
/// <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;
}
}
}
