public int ThemSachMat(GhiNhanMatSachDTO gnms) { int nRow = 0; try { pro.Connect(); string strSql = "Insert into MATSACH values(@MaGNMatSach,@MaSach,@NgayGhiNhan,@MaDG,@TienPhat,@MaNV)"; nRow = pro.ExecuteNonQuery(CommandType.Text, strSql, new SqlParameter { ParameterName = "@MaGNMatSach", Value = gnms.MaGNMatSach }, new SqlParameter { ParameterName = "@MaSach", Value = gnms.MaSach }, new SqlParameter { ParameterName = "@NgayGhiNhan", Value = gnms.NgayGhiNhan }, new SqlParameter { ParameterName = "@MaDG", Value = gnms.MaDG }, new SqlParameter { ParameterName = "@TienPhat", Value = gnms.TienPhat }, new SqlParameter { ParameterName = "@MaNV", Value = gnms.MaNV } ); return(nRow); } catch (SqlException ex) { throw ex; } }
public int CapNhatPhieuTra(GhiNhanMatSachDTO gnms) { int nRow = 0; try { string strSql = "SP_CapNhatTienPhat"; pro.Connect(); nRow = pro.ExecuteNonQuery(CommandType.StoredProcedure, strSql, new SqlParameter { ParameterName = "@MaPT", Value = gnms.MaPT }, new SqlParameter { ParameterName = "@TienNo", Value = gnms.TienNo }, new SqlParameter { ParameterName = "@MaPM", Value = gnms.MaPM } ); } catch (SqlException ex) { throw ex; } finally { pro.DisConnect(); } return(nRow); }
public int ThemSachMat(GhiNhanMatSachDTO gnms) { try { GhiNhanMatSachDAO dao = new GhiNhanMatSachDAO(); return(dao.ThemSachMat(gnms)); } catch (SqlException ex) { throw ex; } }
public int CapNhatPhieuTra(GhiNhanMatSachDTO gnms) { try { GhiNhanMatSachDAO dao = new GhiNhanMatSachDAO(); return(dao.CapNhatPhieuTra(gnms)); } catch (SqlException ex) { throw ex; } }