/// <summary>
/// Tarile
/// </summary>
/// <returns></returns>
private string GetSirTari()
{
string sirTari = "";
string sirTariText = "[";
string sirTariValue = "[";
Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
DataSet ds = tari.LoadInfoTari();
for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
sirTariText += "'" + dr["NumeTara"].ToString() + "', ";
sirTariValue += dr["TaraID"].ToString() + ", ";
}
if (ds.Tables[0].Rows.Count > 0)
{
sirTariText += "'" + ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["NumeTara"].ToString() + "']";
sirTariValue += ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["TaraID"].ToString() + "]";
sirTari = "[" + sirTariText + "," + sirTariValue + "]";
}
else
{
sirTari = "[[],[]]";
}
return(sirTari);
}
/// <summary>
/// Este populat combo care contine tarile
/// </summary>
private void BindComboTara()
{
Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
ddlTara.DataSource = tari.LoadInfoTari();
ddlTara.DataTextField = "NumeTara";
ddlTara.DataValueField = "TaraID";
ddlTara.DataBind();
}
/// <summary>
/// Valorile judetelor
/// </summary>
/// <returns></returns>
private string GetSirJudeteValue()
{
string sirJudVal = "";
string sirJudValFinal = "";
Salaries.Business.AdminTari tari = new Salaries.Business.AdminTari();
DataSet dsTari = tari.LoadInfoTari();
foreach (DataRow drTari in dsTari.Tables[0].Rows)
{
Salaries.Business.AdminJudete judete = new Salaries.Business.AdminJudete();
judete.TaraId = int.Parse(drTari["TaraID"].ToString());
DataSet ds = judete.GetAllJudeteTara();
if (ds.Tables[0].Rows.Count > 0)
{
sirJudVal = "[";
for (int i = 0; i < ds.Tables[0].Rows.Count - 1; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
sirJudVal += dr["JudetID"].ToString() + ", ";
}
sirJudVal += ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["JudetID"].ToString() + "]";
}
else
{
sirJudVal = "[]";
}
//sirTari = "["+sirTariText+","+sirTariValue+"]";
sirJudValFinal += sirJudVal + ", ";
}
if (sirJudValFinal == "")
{
sirJudValFinal += "[[]]";
}
else
{
sirJudValFinal = sirJudValFinal.Substring(0, sirJudValFinal.Length - 2);
sirJudValFinal = "[" + sirJudValFinal + "]";
}
return(sirJudValFinal);
}
