private void SetTypeAhead(string strID, TypeAhead txt, string strDefault, Int32 intVal)
{
List <HRLData.p_DropDown_Result> q2 = db
.p_DropDown(this.APPID, this.tblNav.NAVID, strID, this.Parm1, this.RexAssoc.ASID)
.ToList <HRLData.p_DropDown_Result>();
txt.ParentForm = this;
txt.DefaultText = strDefault;
txt.DataSource = q2.ToDictionary(pl => pl.ID, pl => pl.Display);
txt.lstWidth = txt.Width;
if (intVal > 0)
{
txt.SelectedValue = Convert.ToInt32(intVal);
try
{
var q = (from ct in txt.DataSource
where ct.Key == intVal
select ct).First();
txt.Text = q.Value.ToString();
}
catch (Exception ex)
{
}
}
else
{
txt.Text = strDefault;
}
}
public static void DropDownTBL(clsForm frm, TypeAhead txt, Int32 intAPPID, Int32 intNAVID, string strCol, string strCriteria, int intASID, string strDefault, int intVal)
{
var dy = new Dictionary <int, string>();
try
{
string strSQL = "p_DropDown_TBL " + intAPPID.ToString() + ", " + intNAVID.ToString() + ", " + strCol + ", '" + strCriteria + "', " + intASID.ToString();
DataSet ds = clsDAL.ProcessSQL(strSQL, "HRL");
if (clsDAL.dsHasData(ds))
{
DataTable dt = ds.Tables[0];
dy = dt.AsEnumerable()
.ToDictionary <DataRow, int, string>(row => row.Field <int>(0),
row => row.Field <string>(1));
}
else
{
HRLEntities db = clsStart.efdb();
string strDebug = "p_DropDown " + intAPPID.ToString() + ", " + intNAVID.ToString() + ", " + strCol + ", '', " + intASID.ToString();
Debug.Print(strDebug);
var q = db.p_DropDown(intAPPID, intNAVID, strCol, "", intASID);
var qry = (from ct in q
select ct).ToList();
dy = qry.ToDictionary(x => x.ID, x => x.Display);
}
if (strDefault + "" != "")
{
dy = (new Dictionary <int, string> {
{ 0, strDefault }
}).Concat(dy).ToDictionary(k => k.Key, v => v.Value);
}
txt.ParentForm = frm;
txt.DefaultText = strDefault;
txt.Text = strDefault;
txt.DataSource = dy;
txt.lstWidth = txt.Width; // * intVal;
if (intVal > 0)
{
txt.SelectedValue = intVal;
try
{
var q = (from ct in txt.DataSource
where ct.Key == intVal
select ct).First();
txt.Text = q.Value.ToString();
}
catch (Exception ex)
{
}
}
}
catch (Exception ex)
{
}
}