public void tblPackageTime_insert(PackageTimeDTO dt)
{
string sql = "INSERT INTO tblPackageTime (monthCount,discount) " +
"VALUES( @monthCount, @discount)";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@monthCount", SqlDbType.Int).Value = dt.monthCount;
cmd.Parameters.Add("@discount", SqlDbType.Int).Value = dt.discount;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void tblpackageTime_Update(PackageTimeDTO dt)
{
string sql = "UPDATE tblpackageTime SET " +
"monthCount = @monthCount, " +
"discount = @discount " +
" WHERE packageTimeId = @packageTimeId";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@packageTimeId", SqlDbType.Int).Value = dt.packageTimeId;
cmd.Parameters.Add("@monthCount", SqlDbType.Int).Value = dt.monthCount;
cmd.Parameters.Add("@discount", SqlDbType.Int).Value = dt.discount;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
private PackageTimeDTO getPackageDTO_update()
{
PackageTimeDTO sign = new PackageTimeDTO();
UserLoginDTO userLogin = getUserLogin();
if (userLogin != null)
{
sign.packageTimeId = Convert.ToInt32(hdfId.Value);
sign.monthCount = int.Parse(txtthoigian.Text);
sign.discount = int.Parse(txtdiscount.Text);
}
return sign;
}
private PackageTimeDTO getPackageDTO()
{
PackageTimeDTO sign = new PackageTimeDTO();
UserLoginDTO userLogin = getUserLogin();
if (userLogin != null)
{
sign.packageTimeId = userLogin.UserId;
sign.monthCount =int.Parse(txtthoigian.Text);
sign.discount = int.Parse(txtdiscount.Text);
}
return sign;
}
public void tblPackageTime_Update(PackageTimeDTO dt)
{
sign.tblpackageTime_Update(dt);
}
public void tblPackageTime_insert(PackageTimeDTO dt)
{
sign.tblPackageTime_insert(dt);
}
