public Object LoginValidate(string bankId, string password)
{
if ("".Equals(bankId))
{
return("Bank Id can't be blank");
}
if ("".Equals(password))
{
return("Password can't be blank");
}
var row = ctx.Set <User>().FirstOrDefault(u => u.bankId.Equals(bankId) && u.password.Equals(password));
if (row == null)
{
return("Invalid bankId / Password");
}
else
{
return(row);
}
}
public async Task <IDictionary <string, List <string> > > GetSectionFields()
{
IEnumerable <NamedBankingProductAttribute> list = await ctx.Set <NamedBankingProductAttribute>().AsNoTracking().ToListAsync();
//IQueryable<NamedBankingProductAttribute> qlist = list.AsQueryable();
//var o = (from n in qlist
// where n.section != null
// orderby n.section, n.description
// select new { n.section, n.description }).Distinct();
IDictionary <string, List <string> > di = new Dictionary <string, List <string> >();
foreach (NamedBankingProductAttribute n in list)
{
if (n.section != null)
{
if (di.ContainsKey(n.section))
{
List <string> tmp = di[n.section];
tmp.Add(n.description);
di[n.section] = tmp;
}
else
{
List <string> tmp = new List <string>();
tmp.Add(n.description);
di.Add(n.section, tmp);
}
//System.Diagnostics.Debug.WriteLine(n.section + " " + n.description);
}
}
return(di);
}
public async Task <IEnumerable <T> > GetAll()
{
var list = await ctx.Set <T>().AsNoTracking().ToListAsync();
return(list);
}
