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