public BoMonModel ChiTietBoMon(int BoMonID)
{
BoMonModel model = null;
try
{
model = BoMonDA.ChiTietBoMon(BoMonID);
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public ResponseResult SuaBoMon(BoMonModel model)
{
ResponseResult res = null;
try
{
res = BoMonDA.SuaBoMon(model);
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public ResponseResult ThemBoMon(BoMonModel model)
{
ResponseResult res = null;
try
{
model.NguoiTao = AccountUtils.CurrentUsername();
res = BoMonDA.ThemBoMon(model);
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public BoMonModel ChiTietBoMon(int BoMonID)
{
BoMonModel model = null;
try
{
List <SqlParameter> listParameter = new List <SqlParameter>();
listParameter.Add(new SqlParameter("@BoMonID", BoMonID));
model = DBUtils.ExecuteSP <BoMonModel>("SP_BoMon_ChiTiet", listParameter);
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public IHttpActionResult GetBoMonById(int IdBoMon)
{
BoMonModel bomon = null;
bomon = db.BoMons.Where(k => k.Id == IdBoMon)
.Select(k => new BoMonModel()
{
Id = k.Id,
Ma = k.Ma,
Ten = k.Ten
}).FirstOrDefault <BoMonModel>();
if (bomon == null)
{
return(NotFound());
}
return(Ok(bomon));
}
public ResponseResult ThemBoMon(BoMonModel model)
{
ResponseResult res = null;
try
{
List <SqlParameter> listParameter = new List <SqlParameter>();
listParameter.Add(new SqlParameter("@MaBoMon", model.MaBoMon));
listParameter.Add(new SqlParameter("@TenBoMon", model.TenBoMon));
listParameter.Add(new SqlParameter("@DonViID", model.DonViID));
listParameter.Add(new SqlParameter("@NguoiTao", model.NguoiTao));
res = DBUtils.ExecuteSP <ResponseResult>("SP_BoMon_Them", listParameter);
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public bool Update(BoMonModel model)
{
string msgError = "";
try
{
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "BoMon_update",
"@ID_BM", model.ID_BM,
"@Ten_BM", model.Ten_BM,
"@ID_Khoa", model.ID_Khoa);
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult SuaBoMon(BoMonModel model)
{
try
{
var result = BoMonService.SuaBoMon(model);
if (result != null && result.ResponseCode == 1)
{
return(Json(JsonResponseViewModel.CreateSuccess("Cập nhật bộ môn thành công.")));
}
else if (result != null && result.ResponseCode == -1)
{
return(Json(JsonResponseViewModel.CreateFail(result.ResponseMessage)));
}
else
{
return(Json(JsonResponseViewModel.CreateFail("Cập nhật bộ môn thất bại.")));
}
}
catch (Exception ex)
{
return(Json(JsonResponseViewModel.CreateFail(ex)));
}
}
public bool Update(BoMonModel model)
{
return(_res.Update(model));
}
public bool Create(BoMonModel model)
{
return(_res.Create(model));
}
public BoMonModel UpdateUser([FromBody] BoMonModel model)
{
_BoMonBLL.Update(model);
return(model);
}
public BoMonModel CreateItem([FromBody] BoMonModel model)
{
model.ID_BM = Guid.NewGuid().ToString();
_BoMonBLL.Create(model);
return(model);
}
