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