private void BindAccountContactGridView()
{
GridViewResult.DataSource = AccountContact.GetAccountContactListByAccountId(this.accountId);
GridViewResult.DataBind();
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
GridViewResult.DataSource = Employee.GetRepresentativeEmployeeListByFilter(TextBoxSearchValue.Text);
GridViewResult.DataBind();
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
GridViewResult.DataSource = Status.GetStatusListByFilter("%" + TextBoxSearch.Text + "%");
GridViewResult.DataBind();
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
GridViewResult.DataSource = InsightSupplierContact.GetInsightSupplierContactListByFilter("%" + TextBoxSearch.Text + "%");
GridViewResult.DataBind();
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
GridViewResult.DataSource = SPARInsightManagement.Web.Code.Account.GetAccountListByFilter("%" + TextBoxSearch.Text + "%");
GridViewResult.DataBind();
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
GridViewResult.DataSource = Product.GetProductListByFilter("%" + TextBoxSearchValue.Text + "%", supplierId);
GridViewResult.DataBind();
}
private void CloseSupplierAuthorization()
{
GridViewResult.DataSource = null;
GridViewResult.DataBind();
PanelSupplierAuthorization.Visible = false;
}
private void BindModelTypeSecurity()
{
PanelSupplierList.Visible = false;
//PanelSupplierParentList.Visible = false;
if (Convert.ToInt32(ViewState["InsightSupplierId"]) != 0)
{
BindInsightSupplierContactList();
BindInsightSupplierContactGridView();
BindLinkedSupplierGridView();
BindInsightSupplierContactList();
BindInsightSupplierContactGridView();
ButtonViewAuthorization.Enabled = true;
ButtonAddInsightSupplierContact.Visible = true;
ButtonConfigure.Visible = true;
ButtonAddCustom.Visible = true;
ButtonLinkCategory.Visible = false;
ButtonSave.Visible = true;
ButtonSaveNew.Visible = true;
PanelLinkedSupplier.Visible = true;
PanelCustomSupplierId.Visible = true;
PanelSupplierAuthorization.Visible = true;
PanelInsightSupplierContact.Visible = true;
PanelSupplierMerchandising.Visible = GridViewResultSupplier.Rows.Count > 0;
if (Convert.ToInt32(DropDownListModelType.SelectedValue) == 0)
{
DropDownListSupplierList.Enabled = false;
ButtonViewAuthorization.Enabled = false;
ButtonSaveAddSupplier.Enabled = false;
PanelSupplierAuthorization.Visible = false;
PanelSupplierList.Visible = false;
//PanelSupplierParentList.Visible = false;
GridViewResult.DataSource = null;
GridViewResult.DataBind();
ButtonViewAuthorization.Enabled = false;
ButtonSave.Visible = false;
ButtonSaveNew.Visible = false;
ButtonAddInsightSupplierContact.Visible = false;
ButtonConfigure.Visible = false;
ButtonAddCustom.Visible = false;
PanelSupplierAuthorization.Visible = false;
PanelInsightSupplierContact.Visible = false;
PanelSupplierMerchandising.Visible = false;
PanelLinkedSupplier.Visible = false;
PanelCustomSupplierId.Visible = false;
}
else if (Convert.ToInt32(DropDownListModelType.SelectedValue) == 4)//Custom
{
///ButtonSaveAddSupplier.Text = "Add Supplier";
PanelSupplierList.Visible = false;
//PanelSupplierParentList.Visible = false;
DropDownListModelType.Enabled = false;
DropDownListSupplierList.Enabled = true;
ButtonViewAuthorization.Enabled = false;
ButtonSaveAddSupplier.Enabled = false;
ButtonLinkCategory.Visible = true;
PanelSupplierAuthorization.Visible = false;
PanelLinkedSupplier.Visible = false;
GridViewResult.DataSource = null;
GridViewResult.DataBind();
}
else if (Convert.ToInt32(DropDownListModelType.SelectedValue) == 5)//Principle - Group
{
//ButtonSaveManageSupplier.Text = "Add Supplier";
PanelSupplierList.Visible = false;
//PanelSupplierParentList.Visible = true;
DropDownListModelType.Enabled = false;
//DropDownListSupplierParentList.Enabled = false;
ButtonViewAuthorization.Enabled = true;
PanelSupplierAuthorization.Visible = false;
GridViewResult.DataSource = null;
GridViewResult.DataBind();
}
else
{
ButtonSaveAddSupplier.Text = "Add Supplier";
PanelSupplierList.Visible = true;
//PanelSupplierParentList.Visible = false;
DropDownListModelType.Enabled = false;
DropDownListSupplierList.Enabled = true;
ButtonViewAuthorization.Enabled = true;
ButtonSaveAddSupplier.Enabled = true;
PanelSupplierAuthorization.Visible = false;
GridViewResult.DataSource = null;
GridViewResult.DataBind();
}
}
else
{
if (Convert.ToInt32(DropDownListModelType.SelectedValue) == 0)
{
DropDownListSupplierList.Enabled = false;
ButtonViewAuthorization.Enabled = false;
ButtonSaveAddSupplier.Enabled = false;
PanelSupplierAuthorization.Visible = false;
PanelSupplierList.Visible = false;
//PanelSupplierParentList.Visible = false;
GridViewResult.DataSource = null;
GridViewResult.DataBind();
ButtonViewAuthorization.Enabled = false;
ButtonSave.Visible = false;
ButtonSaveNew.Visible = false;
ButtonAddInsightSupplierContact.Visible = false;
ButtonConfigure.Visible = false;
ButtonAddCustom.Visible = false;
ButtonLinkCategory.Visible = false;
PanelSupplierAuthorization.Visible = false;
PanelInsightSupplierContact.Visible = false;
PanelSupplierMerchandising.Visible = false;
PanelLinkedSupplier.Visible = false;
PanelCustomSupplierId.Visible = false;
}
else if (Convert.ToInt32(DropDownListModelType.SelectedValue) == 4)//Custom
{
DropDownListSupplierList.Enabled = false;
ButtonViewAuthorization.Enabled = false;
ButtonSaveAddSupplier.Enabled = false;
PanelSupplierAuthorization.Visible = false;
PanelSupplierList.Visible = false;
//PanelSupplierParentList.Visible = false;
GridViewResult.DataSource = null;
GridViewResult.DataBind();
ButtonViewAuthorization.Enabled = false;
ButtonSave.Visible = true;
ButtonSaveNew.Visible = true;
ButtonAddInsightSupplierContact.Visible = false;
ButtonConfigure.Visible = false;
ButtonAddCustom.Visible = false;
ButtonLinkCategory.Visible = false;
PanelSupplierAuthorization.Visible = false;
PanelInsightSupplierContact.Visible = false;
PanelSupplierMerchandising.Visible = false;
PanelLinkedSupplier.Visible = false;
PanelCustomSupplierId.Visible = false;
}
else if (Convert.ToInt32(DropDownListModelType.SelectedValue) == 5)//Principle - Group - Logic removed on 2018/11/12
{
//ButtonSaveManageSupplier.Text = "Save and Manage Supplier";
PanelSupplierList.Visible = false;
//PanelSupplierParentList.Visible = true;
//DropDownListModelType.Enabled = false;
//DropDownListSupplierParentList.Enabled = false;
ButtonViewAuthorization.Enabled = true;
PanelSupplierAuthorization.Visible = false;
GridViewResult.DataSource = null;
GridViewResult.DataBind();
}
else
{
ButtonSaveAddSupplier.Text = "Save and Add Supplier";
PanelSupplierList.Visible = true;
//PanelSupplierParentList.Visible = false;
//DropDownListModelType.Enabled = false;
DropDownListSupplierList.Enabled = true;
ButtonViewAuthorization.Enabled = true;
ButtonSaveAddSupplier.Enabled = true;
PanelSupplierAuthorization.Visible = false;
GridViewResult.DataSource = null;
GridViewResult.DataBind();
}
}
}
protected void btnsearch_Click(object sender, EventArgs e)
{
string strwhere = " where ";
string strstate = "";
string strfips = "";
if (chkstatesch.Checked)
{
strstate = ddlstatesch.SelectedValue;
}
if (chkcountysch1.Checked)
{
strfips = ddlFipssch.SelectedItem.Text;
strwhere += "Issuetbl.FIPSCounty='" + strfips + "' and ";
}
if (chkFipssch.Checked)
{
strfips = ddlFipssch.SelectedItem.Text;
strwhere += "Issuetbl.FIPSCounty='" + strfips + "' and ";
}
if (chkIssueTypesch.Checked)
{
strwhere += "Issuetbl.IDIssueType=" + ddlIssuetypesch.SelectedValue + " and ";
}
if (chkFilesch.Checked)
{
strwhere += "Issuetbl.IDFileType=" + ddlFileTypesch.SelectedValue + " and ";
}
if (chkProcessingsch.Checked)
{
strwhere += "Issuetbl.IDProcessingType=" + ddlProcessingsch.SelectedValue + " and ";
}
if (chkEditionsch.Checked)
{
if (txtEditionsch.Text.Length > 0)
{
strwhere += "Issuetbl.Edition=" + txtEditionsch.Text.Split('/')[0] + " and ";
strwhere += "Issuetbl.Version=" + txtEditionsch.Text.Split('/')[1] + " and ";
}
}
if (chkRelatedICPsch.Checked)
{
if (txtRelatedICPsch.Text.Length > 0)
{
strwhere += "Issuetbl.ICP=" + txtRelatedICPsch.Text + " and ";
}
}
if (chkSubmittersch.Checked)
{
if (txtSubmittersch.Text.Length > 0)
{
strwhere += "Issuetbl.Submitter='" + txtSubmittersch.Text.Trim() + "' and ";
}
}
if (chkIssuedetailsch.Checked)
{
if (ddlwildcsh.SelectedValue != "0")
{
if (ddlwildcsh.SelectedValue == "Like")
{
if (txtchkIssuedetailsch.Text.Length > 0)
{
strwhere += "Issuetbl.IssueDetails Like '" + txtchkIssuedetailsch.Text + "' and ";
}
}
else if (ddlwildcsh.SelectedValue == "Not Like")
{
if (txtchkIssuedetailsch.Text.Length > 0)
{
strwhere += "Issuetbl.IssueDetails Not Like '" + txtchkIssuedetailsch.Text + "' and ";
}
}
else if (ddlwildcsh.SelectedValue == "Contains")
{
if (txtchkIssuedetailsch.Text.Length > 0)
{
strwhere += "CONTAINS(Issuetbl.IssueDetails , '" + txtchkIssuedetailsch.Text + "') and ";
}
}
}
else
{
if (txtchkIssuedetailsch.Text.Length > 0)
{
strwhere += "Issuetbl.IssueDetails='" + txtchkIssuedetailsch.Text.Trim() + "' and ";
}
}
}
int stlen = strwhere.Trim().Length;
if (strwhere.Length == 5)
{
strwhere = "";
}
else if (strwhere.IndexOf("and") > 0)
{
if (strwhere.Substring(stlen - 2, 3) == "and")
{
strwhere = strwhere.Substring(0, stlen - 3);
}
}
string strselect = "SELECT Issuetbl.IDIssue, Issuetbl.FIPSCounty, County.County, County.State, FileType.FileType," +
"IssueTypetbl.IssueType, ProcessingTypetbl.ProcessingType, Issuetbl.Edition, Issuetbl.Version, " +
"Issuetbl.Title, Issuetbl.IssueDetails, Issuetbl.Resolution, Issuetbl.Submitter, Issuetbl.Relatedlink," +
"Issuetbl.ICP,Issuetbl.IssueCreatedDate FROM County INNER JOIN Issuetbl ON County.FIPS = Issuetbl.FIPSCounty " +
"INNER JOIN FileType ON Issuetbl.IDFileType = FileType.IDFileType " +
"INNER JOIN IssueTypetbl ON Issuetbl.IDIssueType = IssueTypetbl.IssueType_ID " +
"INNER JOIN ProcessingTypetbl ON Issuetbl.IDProcessingType = ProcessingTypetbl.IDProcessingType " + strwhere;
SqlDataAdapter da;
DataSet ds = new DataSet();
try
{
SqlConnection conn = new SqlConnection(strconn);
da = new SqlDataAdapter(strselect, conn);
da.Fill(ds);
da.Dispose();
GridViewResult.DataSource = ds.Tables[0];
GridViewResult.DataBind();
}
catch (Exception ex)
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Button1.Text == "Clear")
{
Button1.Text = "Submit";
ddlstate_countynew.SelectedIndex = -1;
ddlfpisnew.SelectedIndex = -1;
ddlProcessingtypenew.SelectedIndex = -1;
ddlFileTypenew.SelectedIndex = -1;
ddlIssueTypenew.SelectedIndex = -1;
txtTitlenew.Text = "";
txtIssueDetailsnew.Text = "";
txtResolutionnew.Text = "";
txtEditionnew.Text = "";
txtVersionnew.Text = "";
txtSubmitternew.Text = "";
txtRelatedLinksnew.Text = "";
txtICPnew.Text = "";
Panel2.GroupingText = "Add New";
GridView5.SelectedIndex = -1;
GridView5.DataBind();
}
string FIPSCounty = "00000";
if (ddlstate_countynew.SelectedValue.ToString() == "NW")
{
FIPSCounty = "00000";
}
else if (ddlstate_countynew.SelectedValue.ToString() == "0")
{
if (ddlfpisnew.SelectedValue.ToString() != "0")
{
FIPSCounty = ddlfpisnew.SelectedValue.ToString();
}
}
else
{
FIPSCounty = ddlstate_countynew.SelectedValue.ToString();
}
string IDProcessingType = ddlProcessingtypenew.SelectedValue.ToString();
string IDFileType = ddlFileTypenew.SelectedValue.ToString();
string IDIssueType = ddlIssueTypenew.SelectedValue.ToString();
string Edition = txtEditionnew.Text;
string strVersion = txtVersionnew.Text;
string Title = txtTitlenew.Text;
string IssueDetails = txtIssueDetailsnew.Text;
string Resolution = txtResolutionnew.Text;
string Submitter = txtSubmitternew.Text;
string Relatedlink = txtRelatedLinksnew.Text;
string ICP = txtICPnew.Text;
string IssueCreatedDate = DateTime.Now.ToString("yyyy/MM/dd");
string command = "insert into [Issuetbl](FIPSCounty,IDProcessingType,IDFileType,IDIssueType,Edition,Version,Title,IssueDetails,Resolution," +
"Submitter,Relatedlink,ICP,IssueCreatedDate) " +
" Values('" + FIPSCounty + "'," + IDProcessingType + "," + IDFileType + "," + IDIssueType + "," + Edition + "," +
strVersion + ",'" + Title + "','" + IssueDetails + "','" + Resolution + "','" + Submitter + "','" + Relatedlink + "'," + ICP + ",'" +
IssueCreatedDate + "')";
try
{
SqlConnection conn = new SqlConnection(strconn);
SqlCommand cmd = new SqlCommand(command, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
ddlstate_countynew.SelectedIndex = 0;
ddlfpisnew.SelectedIndex = 0;
ddlProcessingtypenew.SelectedIndex = 0;
ddlFileTypenew.SelectedIndex = 0;
ddlIssueTypenew.SelectedIndex = 0;
txtEditionnew.Text = "";
txtVersionnew.Text = "";
txtTitlenew.Text = "";
txtIssueDetailsnew.Text = "";
txtResolutionnew.Text = "";
txtICPnew.Text = "";
txtSubmitternew.Text = "";
txtRelatedLinksnew.Text = "";
GridView5.DataBind();
//GridView6.DataBind();
GridViewResult.DataBind();
}
catch (Exception ex)
{
}
}
