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); }