public async Task <string> LogInDB(Login ObjLogin)
{
string ResponseMessage = "";
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@LoginId",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 200,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjLogin.LogID)?String.Empty:ObjLogin.LogID
},
new SqlParameter()
{
ParameterName = "@LoginDetail",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 200,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjLogin.LogInDetail)?String.Empty:ObjLogin.LogInDetail.ToUpper()
},
new SqlParameter()
{
ParameterName = "@Password",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = -1,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjLogin.Password)?String.Empty:ObjLogin.Password
},
new SqlParameter()
{
ParameterName = "@MessageStatus",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = -1,
Direction = System.Data.ParameterDirection.Output
}
};
Collection <SqlParameter[]> parameters = new Collection <SqlParameter[]>();
parameters.Add(param);
string queryString = "";
queryString = "sp_Login @LoginId,@LoginDetail,@Password,@MessageStatus Out";
ResponseMessage = await _IDBLayercs.ExecuteAsyncSql(param, queryString, 3);
//var _Context = new AuthenticationContext();
//int affectedRows = await _Context.Database.ExecuteSqlRawAsync("sp_Login @LoginId,@LoginDetail,@Password,@MessageStatus Out", param);
//ResponseMessage = Convert.ToString(param[3].Value);
}
catch (Exception ex)
{
ResponseMessage = ex.Message.ToString();
}
return(ResponseMessage);
}
