public Users LoginUserDALForTrainer(string Email, long CompanyId)
{
DBGenerics db = new DBGenerics();
var parameters = new[] {
new SqlParameter()
{
ParameterName = "@Email", Value = Email
},
new SqlParameter()
{
ParameterName = "@companyId", Value = CompanyId
}
};
return(ExecuteSinglewithSP <Users>("TMS_Users_LoginUserForTrainer", parameters));
//List<Users> LoginUserAddGroups = new List<Users>();
//var conString = DBHelper.ConnectionString;
//using (var conn = new SqlConnection(conString))
//{
// conn.Open();
// string qry = @"TMS_Users_LoginUser";
// DynamicParameters param = new DynamicParameters();
// param.Add("@Email", Email);
// LoginUserAddGroups = conn.Query<Users>(qry.ToString(), param, commandType: System.Data.CommandType.StoredProcedure).AsList<Users>();
// conn.Close();
//}
//return LoginUserAddGroups;
}
/// <summary>
/// Logins the user dal.
/// </summary>
/// <param name="Email">The email.</param>
/// <returns>Users.</returns>
public Users LoginUserDAL(string Email)
{
DBGenerics db = new DBGenerics();
var parameters = new[] {
new SqlParameter()
{
ParameterName = "@Email", Value = Email
}
//new SqlParameter(){ ParameterName="@Password", Value=Password }
};
return(ExecuteSinglewithSP <Users>("TMS_Users_LoginUser", parameters));
}
