public static BasicEntity Login(Model.Login data, Output.Login obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@Password", data.Password);
retVal.AddParameter("@UserLogin", data.UserLogin);
data.SqlDetail = retVal.SQLCommandBuilder("spUserLogin");
using (SqlDataReader reader = retVal.ExecReader())
{
while (reader.Read())
{
obj.ResultCode = (reader.IsDBNull(0)) ? 0 : reader.GetInt32(0);
obj.ErrorMessage = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1);
retVal.ResultCode = obj.ResultCode;
}
if (retVal.ResultCode == 1)
{
reader.NextResult();
while (reader.Read())
{
var item = new Output.LoginData();
item.UserID = (reader.IsDBNull(0)) ? string.Empty : reader.GetString(0);
item.SessionToken = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1);
item.Level = (reader.IsDBNull(2)) ? string.Empty : reader.GetString(2);
obj.Content.Data.Add(item);
}
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BaseHelper Login(Model.Login data)
{
var retVal = new BaseHelper();
var objJSON = new Output.Login();
try
{
var entity = User.Login(data, objJSON);
retVal.SQLElapsed = entity.SQLElapsed;
retVal.SQLInfo(entity.SQLDetail);
retVal.IsError = (entity.ResultCode == 1) ? false : true;
}
catch (Exception ex)
{
retVal.Exception = ex;
if (ex is System.Data.SqlClient.SqlException sqlEx)
{
retVal.SQLInfo($"sp:{sqlEx.Procedure}, line:{sqlEx.LineNumber}, detail:{data.SqlDetail}");
retVal.SQLException = true;
objJSON.ResultCode = 69998;
objJSON.ErrorMessage = "SQL Exception";
}
else
{
objJSON.ResultCode = 69999;
objJSON.ErrorMessage = "Unknown Error";
}
}
finally
{
retVal.SerializeObject <Output.Login>(objJSON);
}
return(retVal);
}
