/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cb0_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ComboBox cb;
if (!string.IsNullOrEmpty(this.comboBox1.Text) && !string.IsNullOrEmpty(this.cbRef.Text))
{
RSFinanceToolsEntities db = new RSFinanceToolsEntities();
string p = this.comboBox1.SelectedValue.ToString();
string Value1 = this.comboBox1.SelectedValue.ToString();
Control[] ctlsr = this.panel3.Controls.Find("CriteriaLabel", true);
Control[] ctlcb = this.panel3.Controls.Find("CriteriaCB", true);
if (ctlsr.Length > 0)
{
var dt2 = new List <rsTemplateTransaction>();
cb = new ComboBox();
cb.FormattingEnabled = true;
cb.Location = new System.Drawing.Point(198, 35 * (0));
cb.Size = new System.Drawing.Size(229, 22);
cb.Name = "CriteriaCB";
string text1 = ((Label)ctlsr[0]).Text;
dt2 = (from FT_sett in db.rsTemplateTransactions
where FT_sett.TemplateID == p &&
FT_sett.Criteria1 == text1
select FT_sett).ToList();
DataTable newdt2 = ft.ToDataTable(dt2);
var query2 = from t in newdt2.AsEnumerable()
group t by new { t1 = t.Field <string>("Value1") } into m
select new
{
CriteriaValue = m.First().Field <string>("Value1"),
};
DataTable newdt3 = ft.ToDataTable(query2.ToList());
DataRow dr2 = newdt3.NewRow();
dr2["CriteriaValue"] = "";
newdt3.Rows.InsertAt(dr2, 0);
cb.DisplayMember = "CriteriaValue";
cb.DataSource = newdt3;
cb.ValueMember = "CriteriaValue";
cb.SelectedIndexChanged += new EventHandler(cb1_SelectedIndexChanged);
if (ctlcb.Length > 0)
{
for (int i = 0; i < ctlcb.Length; i++)
{
this.panel3.Controls.Remove(ctlcb[i]);
}
}
this.panel3.Controls.Add(cb);
cb1_SelectedIndexChanged(null, null);
}
}
CheckFinalDropDown();
}
catch (Exception ex)
{
string s = ex.Message;
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string formUserID = this.textBox1.Text;
string formPassword = this.textBox2.Text;
using (RSFinanceToolsEntities db = new RSFinanceToolsEntities())
{
try
{
var wUserID = (from FT_user in db
where FT_user.FormUserID == formUserID & FT_user.FormUserPassword == formPassword
select FT_user.ft_id).First();
var SunIP = (from FT_user in db.FinTools_Users
where FT_user.FormUserID == formUserID & FT_user.FormUserPassword == formPassword
select FT_user.SUNUserIP).First();
var SunUID = (from FT_user in db.FinTools_Users
where FT_user.FormUserID == formUserID & FT_user.FormUserPassword == formPassword
select FT_user.SUNUserID).First();
var SunUpass = (from FT_user in db.FinTools_Users
where FT_user.FormUserID == formUserID & FT_user.FormUserPassword == formPassword
select FT_user.SUNUserPass).First();
if (SessionInfo.UserInfo == null)
{
SessionInfo.UserInfo = new UserInfo();
}
SessionInfo.UserInfo.ID = wUserID.ToString();
SessionInfo.UserInfo.SunUserIP = SunIP;
SessionInfo.UserInfo.SunUserID = DEncrypt.Decrypt(SunUID);
SessionInfo.UserInfo.SunUserPass = DEncrypt.Decrypt(SunUpass);
if (pSender != null)
{
((Ribbon2)pSender).addfolders();
}
this.Close();
this.Dispose();
}
catch
{
MessageBox.Show("The user id or the password is invalid.", "Message - RSystems FinanceTools", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
/// <summary>
///
/// </summary>
private void InitialCriterias()
{
try
{
this.panel3.Controls.Clear();
Label l;
TextBox cb;
if (!string.IsNullOrEmpty(this.comboBox1.Text))
{
RSFinanceToolsEntities db = new RSFinanceToolsEntities();
string p = this.comboBox1.SelectedValue.ToString();
var dt = (from FT_sett in db.rsTemplateSettings
where FT_sett.TemplateID == p
select FT_sett).ToList();
DataTable newdt = ft.ToDataTable(dt);
var query = from t in newdt.AsEnumerable()
group t by new { t1 = t.Field <string>("CriteriaName") } into m
select new
{
CriteriaName = m.First().Field <string>("CriteriaName"),
};
int i = 0;
foreach (var employee in query)
{
l = new Label();
l.AutoSize = true;
l.Location = new System.Drawing.Point(28, 36 * (i));
l.Name = "CriteriaLabel";
l.Size = new System.Drawing.Size(89, 13);
l.Text = employee.CriteriaName;
cb = new TextBox();
cb.Location = new System.Drawing.Point(199, 36 * (i));
cb.Size = new System.Drawing.Size(325, 66);
cb.Name = "CriteriaCB";
this.panel3.Controls.Add(l);
this.panel3.Controls.Add(cb);
i++;
}
}
}
catch { }
}
/// <summary>
///
/// </summary>
private void CheckFinalDropDown()
{
if (!string.IsNullOrEmpty(this.comboBox1.Text))
{
RSFinanceToolsEntities db = new RSFinanceToolsEntities();
string p = this.comboBox1.SelectedValue.ToString();
Control[] ctlsr = this.panel3.Controls.Find("CriteriaLabel", true);
Control[] ctlcb = this.panel3.Controls.Find("CriteriaCB", true);
if (ctlsr.Length > 0)
{
var dt2 = new List <rsTemplateTransaction>();
string text5 = string.Empty;
string text4 = string.Empty;
string text3 = string.Empty;
string text2 = string.Empty;
string text1 = string.Empty;
string cbValue1 = string.Empty;
string cbValue2 = string.Empty;
string cbValue3 = string.Empty;
string cbValue4 = string.Empty;
string cbValue5 = string.Empty;
if (ctlsr[0] != null)
{
text1 = ((Label)ctlsr[0]).Text;
}
if (ctlsr.Length > 1 && ctlcb.Length > 1)
{
if (ctlsr[1] != null)
{
text2 = ((Label)ctlsr[1]).Text;
}
}
if (ctlsr.Length > 2 && ctlcb.Length > 2)
{
if (ctlsr[2] != null)
{
text3 = ((Label)ctlsr[2]).Text;
}
}
if (ctlsr.Length > 3 && ctlcb.Length > 3)
{
if (ctlsr[3] != null)
{
text4 = ((Label)ctlsr[3]).Text;
}
}
if (ctlsr.Length > 4 && ctlcb.Length > 4)
{
if (ctlsr[4] != null)
{
text5 = ((Label)ctlsr[4]).Text;
}
}
if (ctlcb[0] != null)
{
cbValue1 = ((ComboBox)ctlcb[0]).Text;
}
if (ctlcb.Length > 1)
{
if (ctlcb[1] != null)
{
cbValue2 = ((ComboBox)ctlcb[1]).Text;
}
}
if (ctlcb.Length > 2)
{
if (ctlcb[2] != null)
{
cbValue3 = ((ComboBox)ctlcb[2]).Text;
}
}
if (ctlcb.Length > 3)
{
if (ctlcb[3] != null)
{
cbValue4 = ((ComboBox)ctlcb[3]).Text;
}
}
if (ctlcb.Length > 4)
{
if (ctlcb[4] != null)
{
cbValue5 = ((ComboBox)ctlcb[4]).Text;
}
}
dt2 = (from FT_sett in db.rsTemplateTransactions
where FT_sett.TemplateID == p &&
FT_sett.Criteria5 == text5 &&
FT_sett.Criteria4 == text4 &&
FT_sett.Criteria3 == text3 &&
FT_sett.Criteria2 == text2 &&
FT_sett.Criteria1 == text1 &&
FT_sett.Value1 == cbValue1 &&
FT_sett.Value2 == cbValue2 &&
FT_sett.Value3 == cbValue3 &&
FT_sett.Value4 == cbValue4 &&
FT_sett.Value5 == cbValue5
select FT_sett).ToList();
DataTable newdt2 = ft.ToDataTable(dt2);
var query2 = from t in newdt2.AsEnumerable()
group t by new { t1 = t.Field <string>("TransactionName") } into m
select new
{
CriteriaValue = m.First().Field <string>("TransactionName"),
};
DataTable newdt3 = ft.ToDataTable(query2.ToList());
this.cbTransactionName.DataSource = newdt3;
this.cbTransactionName.DisplayMember = "CriteriaValue";
this.cbTransactionName.ValueMember = "CriteriaValue";
}
}
}
