private void btnOppInactive_Click(object sender, EventArgs e)
{
try
{
clsOpportunities clsOpportunity = new clsOpportunities();
DataRow[] dataRowArray = ((DataTable)this.grdOppList.DataSource).Select("Flag='Y'");
if ((int)dataRowArray.Length == 0)
{
RadMessageBox.Show(this, "Active/Inactive at least one Opportunity.", "Information", MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
else if (RadMessageBox.Show(this, "Do you wish to Active/Inactive selected Campaign(s)?", "Confirmation", MessageBoxButtons.YesNo, RadMessageIcon.Info, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
ArrayList arrayLists = new ArrayList();
string str = "";
int num = 0;
while (num < (int)dataRowArray.Length)
{
str = dataRowArray[num]["OPP_NAME"].ToString();
if (!this.ClsObj.fnCheckOPPHasInRanking(str, Common.iProjectID))
{
str = (!(bool)dataRowArray[num]["Active"] ? string.Concat(str, ";0") : string.Concat(str, ";1"));
arrayLists.Add(str);
num++;
}
else
{
RadMessageBox.Show(this, "This opportunity is selected in Ranking, you can not Inactive this Opportunity", "Confirmation", MessageBoxButtons.OK, RadMessageIcon.Info, MessageBoxDefaultButton.Button1);
break;
}
}
if (arrayLists.Count > 0)
{
int num1 = 0;
while (num1 < arrayLists.Count)
{
if (clsOpportunity.fnActiveOpportunities(arrayLists[num1].ToString()))
{
num1++;
}
else
{
return;
}
}
}
this.fnLoadOpportunity();
}
}
catch (Exception exception1)
{
Exception exception = exception1;
RadMessageBox.Show(this, exception.Message, exception.TargetSite.Name.ToString(), MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void fnShowOpportunityRanking()
{
try
{
clsOpportunities clsObj = new clsOpportunities();
bool bIsOpplist = false;
dt = clsObj.fnGetOpportunity(Common.iProjectID, Common.iUserID, bIsOpplist);
ddlOppRank4.Enabled = false;
ddlOppRank3.Enabled = false;
ddlOppRank2.Enabled = false;
bDonotFireSelectionChange = true;
ddlOppRank1.DataSource = dt;
ddlOppRank1.SelectedValue = "";
ddlOppRank1.SelectedText = "";
ddlOppRank1.ValueMember = "OPPORTUNITY_ID";
ddlOppRank1.DisplayMember = "OPP_NAME";
ddlOppRank2.BindingContext = new BindingContext();
ddlOppRank2.DataSource = dt;
ddlOppRank2.SelectedValue = "";
ddlOppRank2.SelectedText = "";
ddlOppRank2.ValueMember = "OPPORTUNITY_ID";
ddlOppRank2.DisplayMember = "OPP_NAME";
ddlOppRank3.BindingContext = new BindingContext();
ddlOppRank3.DataSource = dt;
ddlOppRank3.SelectedValue = "";
ddlOppRank3.SelectedText = "";
ddlOppRank3.ValueMember = "OPPORTUNITY_ID";
ddlOppRank3.DisplayMember = "OPP_NAME";
ddlOppRank4.BindingContext = new BindingContext();
ddlOppRank4.DataSource = dt;
ddlOppRank4.SelectedValue = "";
ddlOppRank4.SelectedText = "";
ddlOppRank4.ValueMember = "OPPORTUNITY_ID";
ddlOppRank4.DisplayMember = "OPP_NAME";
bDonotFireSelectionChange = false;
}
catch (Exception ex)
{
throw ex;
}
}
private void pctPotential_Click(object sender, EventArgs e)
{
try
{
clsOpportunities clsObj = new clsOpportunities();
// frmExpressEditor frm = new frmExpressEditor();
DataTable dt = new DataTable();
DataTable dtSource = clsObj.fnGetBaseColumns(ref dt);
//if (dtSource.Rows.Count == 0)
//{
// Telerik.WinControls.RadMessageBox.Show(this, " First you need to set Threshold. ", "Information", MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
// //pgVRecommendation.SelectedPage = pgThresholds;
// return;
//}
// dtSource.Columns.Add(new DataColumn("OPPValue", typeof(decimal)));
using (var frm = new frmExpressEditor((int)Enums.ExpressionType.Opp_ptnl, "ETS_TRE_BASE2", strPntlExpression))
{
frm._fieldDict = Common.GetDict(dtSource);
frm.AvailableFields = frm._fieldDict.ToList <KeyValuePair <string, Type> >();
frm.dtSource = dt;
var res = frm.ShowDialog();
if (res == System.Windows.Forms.DialogResult.OK)
{
bIsPtnlModified = true;
strPntlExpression = frm.strExpression.Replace("FIELD.", "").Trim();
strPntlExpression = frm.strExpression.Replace("FIELD!", "").Trim();
//clsTre_Details clsTObj = new clsTre_Details();
//clsTObj.fnSaveOPPPotential(Common.sOpportunityName, iOpportunityId, Common.strTableName, strPntlExpression);
}
}
}
catch (Exception ex)
{
Telerik.WinControls.RadMessageBox.Show(this, ex.Message, ex.TargetSite.Name.ToString(), MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
}
void fnLoadOpportunity()
{
this.Cursor = Cursors.WaitCursor;
try
{
clsOpportunities clsObj = new clsOpportunities();
bool bIsOpplist = true;
DataTable dt = clsObj.fnGetOpportunity(Common.iProjectID, Common.iUserID, bIsOpplist);
dt.Columns.Add(new DataColumn("Select", typeof(bool)));
dt.Columns.Add(new DataColumn("Active", typeof(bool)));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["Select"] = false;
if (dt.Rows[i]["ISACTIVEID"].ToString() == "1")
{
dt.Rows[i]["Active"] = true;
}
else
{
dt.Rows[i]["Active"] = false;
}
}
if (dt.Rows.Count == 0)
{
for (int i = 0; i < 15; i++)
{
dt.NewRow();
}
}
dt.Columns["Select"].SetOrdinal(0);
grdOppList.DataSource = dt;
grdOppList.Columns["OPPORTUNITY_ID"].IsVisible = false;
grdOppList.Columns["ISACTIVEID"].IsVisible = false;
grdOppList.Columns["Flag"].IsVisible = false;
grdOppList.Columns["FORMULA"].IsVisible = false;
grdOppList.Columns["Project_ID"].IsVisible = false;
grdOppList.Columns["CREATEDBY"].IsVisible = false;
grdOppList.Columns["T1"].IsVisible = false;
grdOppList.Columns["T2"].IsVisible = false;
grdOppList.Columns["ISONMAIN"].IsVisible = true;
grdOppList.Columns["DESCRIPTION"].Width = 200;
for (int i = 1; i < dt.Columns.Count - 1; i++)
{
if (dt.Columns[i].ColumnName != "Select")
{
grdOppList.MasterTemplate.Columns[i].ReadOnly = true;
}
}
grdOppList.CellFormatting += new CellFormattingEventHandler(grdOppList_CellFormatting);
}
catch (Exception ex)
{
throw ex;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void btnOppInactive_Click(object sender, EventArgs e)
{
try
{
clsOpportunities clsObj = new clsOpportunities();
DataTable dt = ((DataTable)grdOppList.DataSource);
DataRow[] drRow = dt.Select("Flag='Y'");
if (drRow.Length == 0)
{
Telerik.WinControls.RadMessageBox.Show(this, "Active/Inactive at least one Opportunity.", "Information", MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
return;
}
else
{
DialogResult ds = Telerik.WinControls.RadMessageBox.Show(this, "Do you wish to Active/Inactive selected Campaign(s)?", "Confirmation", MessageBoxButtons.YesNo, RadMessageIcon.Info, MessageBoxDefaultButton.Button1);
if (ds != DialogResult.Yes)
{
return;
}
ArrayList recForInactive = new ArrayList();
string strId = "";
for (int i = 0; i < drRow.Length; i++)
{
strId = drRow[i]["OPP_NAME"].ToString();
if (ClsObj.fnCheckOPPHasInRanking(strId, Common.iProjectID))
{
Telerik.WinControls.RadMessageBox.Show(this, "This opportunity is selected in Ranking, you can not Inactive this Opportunity", "Confirmation", MessageBoxButtons.OK, RadMessageIcon.Info, MessageBoxDefaultButton.Button1);
break;
}
if ((bool)drRow[i]["Active"])
{
strId += ";1";
}
else
{
strId += ";0";
}
recForInactive.Add(strId);
}
if (recForInactive.Count > 0)
{
for (int i = 0; i < recForInactive.Count; i++)
{
if (!clsObj.fnActiveOpportunities(recForInactive[i].ToString()))
{
return;
}
}
}
fnLoadOpportunity();
}
}
catch (Exception ex)
{
Telerik.WinControls.RadMessageBox.Show(this, ex.Message, ex.TargetSite.Name.ToString(), MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
}
