public void Cap_Nhat(HT_DM_Tuan_Chi_Tiet myHT_DM_Tuan_Chi_Tiet)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("HT_DM_Tuan_Cap_Nhat", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pMa_Tuan = new SqlParameter("@Ma_Tuan", SqlDbType.Int, 4);
pMa_Tuan.Value = myHT_DM_Tuan_Chi_Tiet.Ma_Tuan;
myCommand.Parameters.Add(pMa_Tuan);
SqlParameter pTuan_So = new SqlParameter("@Tuan_So", SqlDbType.Int, 4);
pTuan_So.Value = myHT_DM_Tuan_Chi_Tiet.Tuan_So;
myCommand.Parameters.Add(pTuan_So);
SqlParameter pNam_Tinh = new SqlParameter("@Nam_Tinh", SqlDbType.Int, 4);
pNam_Tinh.Value = myHT_DM_Tuan_Chi_Tiet.Nam_Tinh;
myCommand.Parameters.Add(pNam_Tinh);
SqlParameter pTu_Ngay = new SqlParameter("@Tu_Ngay", SqlDbType.DateTime, 8);
pTu_Ngay.Value = myHT_DM_Tuan_Chi_Tiet.Tu_Ngay;
myCommand.Parameters.Add(pTu_Ngay);
SqlParameter pDen_Ngay = new SqlParameter("@Den_Ngay", SqlDbType.DateTime, 8);
pDen_Ngay.Value = myHT_DM_Tuan_Chi_Tiet.Den_Ngay;
myCommand.Parameters.Add(pDen_Ngay);
myConnection.Open();
myCommand.ExecuteNonQuery();
}
}
}
public HT_DM_Tuan_Chi_Tiet Lay(int Ma_Tuan)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("HT_DM_Tuan_Lay", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pMa_Tuan = new SqlParameter("@Ma_Tuan", SqlDbType.Int, 4);
pMa_Tuan.Value = Ma_Tuan;
myCommand.Parameters.Add(pMa_Tuan);
SqlParameter pTuan_So = new SqlParameter("@Tuan_So", SqlDbType.Int, 4);
pTuan_So.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(pTuan_So);
SqlParameter pNam_Tinh = new SqlParameter("@Nam_Tinh", SqlDbType.Int, 4);
pNam_Tinh.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(pNam_Tinh);
SqlParameter pTu_Ngay = new SqlParameter("@Tu_Ngay", SqlDbType.DateTime, 8);
pTu_Ngay.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(pTu_Ngay);
SqlParameter pDen_Ngay = new SqlParameter("@Den_Ngay", SqlDbType.DateTime, 8);
pDen_Ngay.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(pDen_Ngay);
myConnection.Open();
myCommand.ExecuteNonQuery();
HT_DM_Tuan_Chi_Tiet myHT_DM_Tuan_Chi_Tiet = new HT_DM_Tuan_Chi_Tiet();
myHT_DM_Tuan_Chi_Tiet.Ma_Tuan = Ma_Tuan;
myHT_DM_Tuan_Chi_Tiet.Tuan_So = (int)pTuan_So.Value;
myHT_DM_Tuan_Chi_Tiet.Nam_Tinh = (int)pNam_Tinh.Value;
myHT_DM_Tuan_Chi_Tiet.Tu_Ngay = (DateTime)pTu_Ngay.Value;
myHT_DM_Tuan_Chi_Tiet.Den_Ngay = (DateTime)pDen_Ngay.Value;
return(myHT_DM_Tuan_Chi_Tiet);
}
}
}
