public IEnumerable <ApprovalTypeModel> ListData()
{
List <ApprovalTypeModel> result = null;
var sql = @"
SELECT
ApprovalTypeID, ApprovalTypeName
FROM
OFTA_ApprovalType ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
result = new List <ApprovalTypeModel>();
while (dr.Read())
{
var itemResult = new ApprovalTypeModel
{
ApprovalTypeID = dr["ApprovalTypeID"].ToString(),
ApprovalTypeName = dr["ApprovalTypeName"].ToString()
};
result.Add(itemResult);
}
}
}
return(result);
}
public ApprovalTypeModel GetData(IApprovalTypeKey key)
{
ApprovalTypeModel result = null;
var sql = @"
SELECT
ApprovalTypeName
FROM
OFTA_ApprovalType
WHERE
ApprovalTypeID = @ApprovalTypeID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@ApprovalTypeID", key.ApprovalTypeID, SqlDbType.VarChar);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new ApprovalTypeModel
{
ApprovalTypeID = key.ApprovalTypeID,
ApprovalTypeName = dr["ApprovalTypeName"].ToString()
};
}
}
return(result);
}
private ApprovalTypeModel Validate(ApprovalTypeModel approvalType)
{
approvalType.Empty().Throw("APPROVAL TYPE kosong");
approvalType.ApprovalTypeID.Empty().Throw("APPROVAL TYPE ID invalid");
approvalType.ApprovalTypeID.Length.GreaterThan(2).Throw("APPROVAL TYPE ID max length is 2");
approvalType.ApprovalTypeName.Empty().Throw("APPROVAL TYPE NAME invalid");
approvalType.ApprovalTypeName.Length.GreaterThan(20).Throw("APPROVAL TYPE NAME max length is 20");
return(approvalType);
}
public IHttpActionResult Update(ApprovalTypeModel approvalType)
{
try
{
var result = _approvalTypeBL.Update(approvalType);
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public IActionResult GetOneApprovalTypeByCode(string approvalCode)
{
try
{
ApprovalTypeModel approvalTypeModel = approvalTypesRepository.GetOneApprovalTypeByCode(approvalCode);
return(Ok(approvalTypeModel));
}
catch (Exception ex)
{
Errors errors = ErrorsHelper.GetErrors(ex);
return(StatusCode(StatusCodes.Status500InternalServerError, errors));
}
}
public ApprovalTypeModel Update(ApprovalTypeModel approvalType)
{
// INPUT VALIDATION
var kt = Validate(approvalType);
// BUSINESS VALIDATION
var approvalTypeDb = _approvalTypeDal.GetData(kt);
approvalTypeDb.Empty().Throw("APPROVAL TYPE ID not found");
// REPO-OP
_approvalTypeDal.Update(kt);
// RETURN
return(kt);
}
public ApprovalTypeModel Add(ApprovalTypeModel approvalType)
{
// INPUT VALIDATION
var kt = Validate(approvalType);
// BUSINESS VALIDATION
var approvalTypeDb = _approvalTypeDal.GetData(kt);
approvalTypeDb.NotEmpty().Throw("APPROVAL TYPE ID already exist");
// REPO-OP
_approvalTypeDal.Insert(kt);
// RETURN
return(kt);
}
public IHttpActionResult Delete(string approvalTypeID)
{
var jbtn = new ApprovalTypeModel {
ApprovalTypeID = approvalTypeID
};
try
{
_approvalTypeBL.Delete(jbtn);
return(Ok("Data has been deleted"));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public void Insert(ApprovalTypeModel entity)
{
var sql = @"
INSERT INTO
OFTA_ApprovalType (
ApprovalTypeID, ApprovalTypeName )
VALUES (
@ApprovalTypeID, @ApprovalTypeName)";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@ApprovalTypeID", entity.ApprovalTypeID, SqlDbType.VarChar);
cmd.AddParam("@ApprovalTypeName", entity.ApprovalTypeName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(ApprovalTypeModel entity)
{
var sql = @"
UPDATE
OFTA_ApprovalType
SET
ApprovalTypeName = @ApprovalTypeName
WHERE
ApprovalTypeID = @ApprovalTypeID ";
using (var conn = new SqlConnection(ConnStringHelper.Get()))
using (var cmd = new SqlCommand(sql, conn))
{
cmd.AddParam("@ApprovalTypeID", entity.ApprovalTypeID, SqlDbType.VarChar);
cmd.AddParam("@ApprovalTypeName", entity.ApprovalTypeName, SqlDbType.VarChar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IHttpActionResult GetData(string approvalTypeID)
{
var jbtn = new ApprovalTypeModel {
ApprovalTypeID = approvalTypeID
};
try
{
var result = _approvalTypeBL.GetData(jbtn);
if (result is null)
{
return(BadRequest("Data Not Found"));
}
return(Ok(result));
}
catch (ArgumentException ex)
{
return(BadRequest(ex.Message));
}
}
public IActionResult AddApprovalType(ApprovalTypeModel approvalTypeModel)
{
try
{
if (approvalTypeModel == null)
{
return(BadRequest("Data is null."));
}
if (!ModelState.IsValid)
{
Errors errors = ErrorsHelper.GetErrors(ModelState);
return(BadRequest(errors));
}
ApprovalTypeModel addedApprovalType = approvalTypesRepository.AddApprovalType(approvalTypeModel);
return(StatusCode(StatusCodes.Status201Created, addedApprovalType));
}
catch (Exception ex)
{
Errors errors = ErrorsHelper.GetErrors(ex);
return(StatusCode(StatusCodes.Status500InternalServerError, errors));
}
}
public IActionResult UpdateApprovalType(string approvalCode, ApprovalTypeModel approvalTypeModel)
{
try
{
if (approvalTypeModel == null)
{
return(BadRequest("Data is null."));
}
if (!ModelState.IsValid)
{
Errors errors = ErrorsHelper.GetErrors(ModelState);
return(BadRequest(errors));
}
approvalTypeModel.approvalCode = approvalCode;
ApprovalTypeModel updatedApprovalType = approvalTypesRepository.UpdateApprovalType(approvalTypeModel);
return(Ok(updatedApprovalType));
}
catch (Exception ex)
{
Errors errors = ErrorsHelper.GetErrors(ex);
return(StatusCode(StatusCodes.Status500InternalServerError, errors));
}
}
