public static BasicEntity CreateAccountLoginUser(Model.UserLoginAdd data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@userlogin", data.UserLogin);
retVal.AddParameter("@password", data.Password);
retVal.AddParameter("@level", data.Level);
retVal.AddParameter("@mobileNumber", data.MobileNumber);
data.SqlDetail = retVal.SQLCommandBuilder("spCreateAccountLoginUser");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity Registration(Model.UserLoginAdd data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@mobileNumber", data.MobileNumber);
retVal.AddParameter("@firstName", data.FirstName);
retVal.AddParameter("@lastName", data.LastName);
retVal.AddParameter("@dateOfBirth", data.DateOfBirth);
retVal.AddParameter("@gender", data.Gender);
retVal.AddParameter("@email", data.Email);
data.SqlDetail = retVal.SQLCommandBuilder("spRegistration");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity UserDelete(Model.User data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@authorization_id", data.AuthorizationID);
retVal.AddParameter("@user_id", data.UserID);
data.SqlDetail = retVal.SQLCommandBuilder("spUserDelete");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity UserAdd(Model.User data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@level_id", data.LevelAdd);
retVal.AddParameter("@CompanyID", data.CompanyAdd);
retVal.AddParameter("@OperatorID", data.OperatorAdd);
retVal.AddParameter("@UserLogin", data.UserLoginAdd);
retVal.AddParameter("@Password", data.PasswordAdd);
retVal.AddParameter("@UserName", data.UserNameAdd);
retVal.AddParameter("@Email", data.EmailAdd);
retVal.AddParameter("@authorization_id", data.AuthorizationID);
retVal.AddParameter("@user_id", data.UserID);
data.SqlDetail = retVal.SQLCommandBuilder("spUserAdd");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity EmployeeEdit(Model.Employees data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@ID", data.ID);
retVal.AddParameter("@NIK", data.NIK);
retVal.AddParameter("@FirstName", data.FirstName);
retVal.AddParameter("@LastName", data.LastName);
retVal.AddParameter("@Address", data.Address);
retVal.AddParameter("@Gender", data.Gender);
retVal.AddParameter("@PlaceOfBirth", data.PlaceOfBirth);
retVal.AddParameter("@DateOfBirth", data.DateOfBirth);
retVal.AddParameter("@Email", data.Email);
retVal.AddParameter("@Phone", data.Phone);
retVal.AddParameter("@JobTitleID", data.JobTitleID);
retVal.AddParameter("@HireDate", data.HireDate);
data.SqlDetail = retVal.SQLCommandBuilder("spEditEmployee");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity EmployeeDelete(Model.Employees data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@id", data.ID);
retVal.AddParameter("@nik", data.NIK);
data.SqlDetail = retVal.SQLCommandBuilder("spDeleteEmployee");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity MasterLoanBookAdd(Model.MasterLoanBookAdd data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@title", data.Title);
retVal.AddParameter("@price", data.Price);
data.SqlDetail = retVal.SQLCommandBuilder("spMasterDataBookAdd");
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;
}
reader.Close();
}
retVal.Close();
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 BaseHelper EmployeeAdd(Model.Employees data)
{
var retVal = new BaseHelper();
var objJSONPage = new Output.OutputBase();
try
{
var entityPage = GetEmployees.EmployeeAdd(data, objJSONPage);
if (objJSONPage.ResultCode == 1)
{
retVal.SQLElapsed += entityPage.SQLElapsed;
retVal.SQLInfo($"sp : {entityPage.SQLDetail}, elapsed : {entityPage.SQLElapsed}");
retVal.IsError = (entityPage.ResultCode == 1) ? false : true;
}
else
{
objJSONPage.ResultCode = objJSONPage.ResultCode;
objJSONPage.ErrorMessage = objJSONPage.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;
objJSONPage.ResultCode = 69998;
objJSONPage.ErrorMessage = "SQL Exception";
}
else
{
objJSONPage.ResultCode = 69999;
objJSONPage.ErrorMessage = "Unknown Error";
}
}
finally
{
retVal.SerializeObject <Output.OutputBase>(objJSONPage);
}
return(retVal);
}
public static BasicEntity Logout(Model.Session data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@session_token", data.SessionToken);
data.SqlDetail = retVal.SQLCommandBuilder("spUserLogout");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity UpdateChangePassword(Model.Password data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@UserID", data.UserID);
retVal.AddParameter("@OldPassword", data.OldPassword);
retVal.AddParameter("@NewPassword", data.NewPassword);
data.SqlDetail = retVal.SQLCommandBuilder("spUserChangePassword");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
public static BasicEntity TransactionLoanBookReturn(Model.TransactionsLoanBookList data, Output.OutputBase obj)
{
var retVal = new BasicEntity();
retVal.AddParameter("@username", data.UserLogin);
retVal.AddParameter("@bookID", data.BookID);
data.SqlDetail = retVal.SQLCommandBuilder("spReturnBook");
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;
}
reader.Close();
}
retVal.Close();
return(retVal);
}
