public ReturnResult <LoaiHoSo> GetLoaiHoSoByID(int LoaiHoSoId)
{
var result = new ReturnResult <LoaiHoSo>();
LoaiHoSo item = new LoaiHoSo();
DbProvider dbProvider = new DbProvider();
string outCode = String.Empty;
string outMessage = String.Empty;
int totalRows = 0;
try
{
dbProvider.SetQuery("LoaiHoSo_GET_BY_ID", CommandType.StoredProcedure)
.SetParameter("LoaiHoSoID", SqlDbType.Int, LoaiHoSoId, ParameterDirection.Input)
.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output)
.GetSingle <LoaiHoSo>(out item)
.Complete();
}
catch (Exception ex)
{
throw;
}
dbProvider.GetOutValue("ErrorCode", out outCode)
.GetOutValue("ErrorMessage", out outMessage);
return(new ReturnResult <LoaiHoSo>()
{
Item = item,
ErrorCode = outCode,
ErrorMessage = outMessage,
TotalRows = totalRows
});
}
public ReturnResult <LoaiHoSo> EditLoaiHoSo(LoaiHoSo LoaiHoSo)
{
ReturnResult <LoaiHoSo> result;
DbProvider db;
try
{
result = new ReturnResult <LoaiHoSo>();
db = new DbProvider();
db.SetQuery("LoaiHoSo_EDIT", CommandType.StoredProcedure)
.SetParameter("LoaiHoSoID", SqlDbType.Int, LoaiHoSo.LoaiHoSoID, ParameterDirection.Input)
.SetParameter("TenLoaiHoSo", SqlDbType.NVarChar, LoaiHoSo.TenLoaiHoSo, 50, ParameterDirection.Input)
.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output)
.ExcuteNonQuery()
.Complete();
db.GetOutValue("ErrorCode", out string errorCode)
.GetOutValue("ErrorMessage", out string errorMessage);
if (errorCode.ToString() == "0")
{
result.ErrorCode = "0";
result.ErrorMessage = "";
}
else
{
result.Failed(errorCode, errorMessage);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
private LoaiHoSoViewModel GetLoaiHoso(LoaiHoSo x)
{
var model = new LoaiHoSoViewModel
{
Id = x.Id,
Ten = x.Ten,
Ma = x.Ma,
HoSos = x.HoSos,
NgayTao = x.NgayTao,
NgayCapNhat = x.NgayCapNhat,
TrangThai = x.TrangThai
};
return(model);
}
public Dictionary <int, LoaiHoSo> GetAllTenHoSo(bool isSperm)
{
Dictionary <int, LoaiHoSo> listHS = new Dictionary <int, LoaiHoSo>();
foreach (var hs in (from s in dbFile.dtb_doc_types select s).ToList())
{
LoaiHoSo x = new LoaiHoSo();
x.FileId = hs.id;
x.TenHoSo = hs.doc_name;
if (isSperm && (hs.doc_type == 1 | hs.doc_type == 2))
{
listHS[Convert.ToInt32(hs.id)] = x;
}
else if (!isSperm && (hs.doc_type == 1 | hs.doc_type == 3))
{
listHS[Convert.ToInt32(hs.id)] = x;
}
}
return(listHS);
}
public ReturnResult <LoaiHoSo> CreateLoaiHoSo(LoaiHoSo LoaiHoSo)
{
DbProvider provider = new DbProvider();
var result = new ReturnResult <LoaiHoSo>();
string outCode = String.Empty;
string outMessage = String.Empty;
string totalRecords = String.Empty;
try
{
provider.SetQuery("LoaiHoSo_CREATE", System.Data.CommandType.StoredProcedure)
.SetParameter("TenLoaiHoSo", SqlDbType.NVarChar, LoaiHoSo.TenLoaiHoSo, 50, ParameterDirection.Input)
.SetParameter("ErrorCode", System.Data.SqlDbType.NVarChar, DBNull.Value, 100, System.Data.ParameterDirection.Output)
.SetParameter("ErrorMessage", System.Data.SqlDbType.NVarChar, DBNull.Value, 4000, System.Data.ParameterDirection.Output)
.GetSingle <LoaiHoSo>(out LoaiHoSo).Complete();
provider.GetOutValue("ErrorCode", out outCode)
.GetOutValue("ErrorMessage", out outMessage);
if (outCode != "0" || outCode == "")
{
result.ErrorCode = outCode;
result.ErrorMessage = outMessage;
}
else
{
result.Item = LoaiHoSo;
result.ErrorCode = outCode;
result.ErrorMessage = outMessage;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public ReturnResult <LoaiHoSo> DeleteLoaiHoSo(int id)
{
DbProvider provider = new DbProvider();
var result = new ReturnResult <LoaiHoSo>();
string outCode = String.Empty;
string outMessage = String.Empty;
string totalRecords = String.Empty;
LoaiHoSo item = new LoaiHoSo();
try
{
provider.SetQuery("LoaiHoSo_DELETE", CommandType.StoredProcedure)
.SetParameter("LoaiHoSoID", SqlDbType.Int, id, ParameterDirection.Input)
.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, System.Data.ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, System.Data.ParameterDirection.Output)
.ExcuteNonQuery().Complete();
provider.GetOutValue("ErrorCode", out outCode)
.GetOutValue("ErrorMessage", out outMessage);
if (outCode != "0")
{
result.Failed(outCode, outMessage);
}
else
{
result.ErrorCode = "0";
result.ErrorMessage = "";
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public IActionResult UpdateLoaiHoSo(LoaiHoSo LoaiHoSo)
{
var result = loaiHoSoBUS.EditLoaiHoSo(LoaiHoSo);
return(Ok(result));
}
public IActionResult CreateLoaiHoSo(LoaiHoSo LoaiHoSo)
{
var result = loaiHoSoBUS.CreateLoaiHoSo(LoaiHoSo);
return(Ok(result));
}
public ReturnResult <LoaiHoSo> EditLoaiHoSo(LoaiHoSo LoaiHoSo)
{
return(loaiHoSoDAL.EditLoaiHoSo(LoaiHoSo));
}
public ReturnResult <LoaiHoSo> CreateLoaiHoSo(LoaiHoSo LoaiHoSo)
{
return(loaiHoSoDAL.CreateLoaiHoSo(LoaiHoSo));
}
