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