public static BaseHelper MenuGet(Model.Session data) { var retVal = new BaseHelper(); var objJSON = new Output.Session(); var objJSONMenu = new Output.Menu(); try { var entity = User.ValidateSession(data, objJSON); retVal.SQLElapsed = entity.SQLElapsed; retVal.SQLInfo($"sp : {entity.SQLDetail}, elapsed : {entity.SQLElapsed}"); if (objJSON.ResultCode == 1) { var dataMenu = new Model.User { UserID = objJSON.Content.Data[0].UserID, StampUser = objJSON.Content.Data[0].UserLogin }; var entityMenu = Dashboard.MenuGet(dataMenu, objJSONMenu); retVal.SQLElapsed += entityMenu.SQLElapsed; retVal.SQLInfo($"sp : {entityMenu.SQLDetail}, elapsed : {entityMenu.SQLElapsed}"); retVal.IsError = (entityMenu.ResultCode == 1) ? false : true; } else { objJSONMenu.ResultCode = objJSON.ResultCode; objJSONMenu.ErrorMessage = objJSON.ErrorMessage; } } 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.Menu>(objJSONMenu); } return(retVal); }
public static BaseHelper UserChangePassword(Model.Password data) { var retVal = new BaseHelper(); var objJSON = new Output.Session(); var objJSONPage = new Output.OutputBase(); try { var entity = User.ValidateSession(data, objJSON); retVal.SQLElapsed = entity.SQLElapsed; retVal.SQLInfo($"sp : {entity.SQLDetail}, elapsed : {entity.SQLElapsed}"); if (objJSON.ResultCode == 1) { data.StampUser = objJSON.Content.Data[0].UserLogin; data.UserID = objJSON.Content.Data[0].UserID; var entityPage = User.UpdateChangePassword(data, objJSONPage); retVal.SQLElapsed += entityPage.SQLElapsed; retVal.SQLInfo($"sp : {entityPage.SQLDetail}, elapsed : {entityPage.SQLElapsed}"); retVal.IsError = (entityPage.ResultCode == 1) ? false : true; } else { objJSONPage.ResultCode = objJSON.ResultCode; objJSONPage.ErrorMessage = objJSON.ErrorMessage; } } 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.OutputBase>(objJSONPage); } return(retVal); }
public static BasicEntity ValidateSession(Model.Session data, Output.Session obj) { var retVal = new BasicEntity(); retVal.AddParameter("@user_login", data.UserLogin); retVal.AddParameter("@session_token", data.SessionToken); retVal.AddParameter("@origin", "W"); data.SqlDetail = retVal.SQLCommandBuilder("spUserValidateSession"); 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.SessionData(); item.UserID = (reader.IsDBNull(0)) ? 0 : reader.GetInt32(0); item.SessionToken = (reader.IsDBNull(1)) ? string.Empty : reader.GetString(1); item.UserGroup = (reader.IsDBNull(2)) ? string.Empty : reader.GetString(2); item.isFirstLogin = (reader.IsDBNull(3)) ? string.Empty : reader.GetString(3); item.CompanyID = (reader.IsDBNull(4)) ? string.Empty : reader.GetString(4); item.OperatorID = (reader.IsDBNull(5)) ? string.Empty : reader.GetString(5); item.UserGuid = (reader.IsDBNull(6)) ? string.Empty : reader.GetString(6); item.AuthKey = (reader.IsDBNull(8)) ? string.Empty : reader.GetString(8); item.UserLogin = (reader.IsDBNull(9)) ? string.Empty : reader.GetString(9); obj.Content.Data.Add(item); } } reader.Close(); } retVal.Close(); return(retVal); }
public static BaseHelper Logout(Model.Session data) { var retVal = new BaseHelper(); var objJSON = new Output.Session(); try { var entity = User.Logout(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.OutputBase>(objJSON); } return(retVal); }