private float tinhTong()
{
parametersDTO par = parBus.Selected();
return(float.Parse(tbTotalTime.Text) * GiaSan() + int.Parse(nUDWaterDrink.Value.ToString()) * giaNuoc + int.Parse(nUDRevieDrink.Value.ToString()) * giaRevive
+ int.Parse(nUDParkingCars.Value.ToString()) * par.GiaGiuXe /**par.GiaGiuXe*/ - float.Parse(tbDiscountMoney.Text));
}
public parametersDTO Selected()
{
parametersDTO res = new parametersDTO();
res = parametersDAL.selectedRegulations();
return(res);
}
public bool edit(parametersDTO pr)
{
parametersDAL parametersDAL = new parametersDAL();
bool res = parametersDAL.CapNhat(pr);
return(res);
}
public int getTimeofReader() //
{
int res;
parametersDTO para = new parametersDTO();
para = paraDAL.selectedRegulations();
res = para.ThoiHanThe;
return(res);
}
public int getMaxNumberofType() // to get max type
{
int maxType;
parametersDTO para = new parametersDTO();
para = parametersDAL.selectedRegulations();
maxType = para.SoTheLoaiToiDa;
return(maxType);
}
public int getMinAgeofReader() //
{
int res;
parametersDTO para = new parametersDTO();
para = paraDAL.selectedRegulations();
res = para.TuoiToiThieuDocGia;
return(res);
}
public int getMaxofBorrowBook() //
{
int res;
parametersDTO para = new parametersDTO();
para = paraDAL.selectedRegulations();
res = para.SoSachMuonToiDa;
return(res);
}
public int getMaxNumberofAuth() // to get max author;
{
int maxAuth;
parametersDTO para = new parametersDTO();
para = paraDAL.selectedRegulations();
maxAuth = para.SoTacGiaToiDa;
return(maxAuth);
}
public void loadInfo()
{
para = paraBUS.Selected();
tbFieldPriceDay.Text = para.GiaSanNgay.ToString();
tbFieldPriceNight.Text = para.GiaSanDem.ToString();
tbPriceParking.Text = para.GiaGiuXe.ToString();
tbSalary.Text = para.LuongNhanVien.ToString();
tbDeposit.Text = para.GiaCoc.ToString();
loadDrinks();
}
public double SoNgayMuonToiDa() //
{
double res;
paraDAL = new parametersDAL();
parametersDTO para = new parametersDTO();
para = paraDAL.selectedRegulations();
res = para.SoNgayMuonToiDa;
return(res);
}
public int getMaxOfYearExp() //
{
int res;
paraDAL = new parametersDAL();
parametersDTO para = new parametersDTO();
para = paraDAL.selectedRegulations();
res = para.NamXuatBanToiDa;
return(res);
}
private float GiaSan()
{
parametersDTO par = parBus.Selected();
if (int.Parse(DateTime.UtcNow.ToString("HH")) >= 19)
{
return(par.GiaSanDem);
}
else
{
return(par.GiaSanNgay);
}
}
public frmAddRule()
{
InitializeComponent();
paraBUS = new ParameterBUS();
para = paraBUS.Selected();
tbMinAgeReader.Text = para.TuoiToiThieuDocGia.ToString();
tbMaxAgeReader.Text = para.TuoiToiDaDocGia.ToString();
txTimeExpReader.Text = para.ThoiHanThe.ToString();
txNumberTitles.Text = para.SoTheLoaiToiDa.ToString();
tbYearPubish.Text = para.NamXuatBanToiDa.ToString();
tbMaxBookBorrow.Text = para.SoSachMuonToiDa.ToString();
tbMaxDayBorrow.Text = para.SoNgayMuonToiDa.ToString();
}
public parametersDTO selectedRegulations() // to select whole of regulations
{
string query = string.Empty;
query += "SELECT * ";
query += "FROM THAMSO";
para = new parametersDTO();
using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;"))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
para.TuoiToiDaDocGia = int.Parse(reader["TuoiToiDaDocGia"].ToString());
para.TuoiToiThieuDocGia = int.Parse(reader["TuoiToiThieuDocGia"].ToString());
para.ThoiHanThe = int.Parse(reader["ThoiHanThe"].ToString());
para.SoTheLoaiToiDa = int.Parse(reader["SoTheLoaiToiDa"].ToString());
para.SoTacGiaToiDa = int.Parse(reader["SoTacGiaToiDa"].ToString());
para.NamXuatBanToiDa = int.Parse(reader["NamXuatBanToiDa"].ToString());
para.SoSachMuonToiDa = int.Parse(reader["SoSachMuonToiDa"].ToString());
para.SoNgayMuonToiDa = int.Parse(reader["SoNgayMuonToiDa"].ToString());
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(para);
}
private void btnPay_Click(object sender, EventArgs e)
{
parametersDTO par = parBus.Selected();
HoaDonDTO hd = new HoaDonDTO();
hd.MaHD = hdBus.autogenerate_maHD();
hd.MaNhanVien = 1;
List <KhachHangDTO> listKH = khBus.select();
foreach (KhachHangDTO kh in listKH)
{
if (cbCusPhone.Text == kh.SoDT)
{
hd.MaKH = kh.MaKH;
}
}
hd.ngaytaohoadon = DateTime.UtcNow;
ChiTietHoaDonDTO cthdsan = new ChiTietHoaDonDTO();
ChiTietHoaDonDTO cthdnuoc = new ChiTietHoaDonDTO();
cthdsan.MaHD = hd.MaHD;
cthdsan.MaLoaiHoaDon = 1;
cthdsan.trigiaHoaDon = float.Parse(tbTotalTime.Text) * GiaSan() + int.Parse(nUDParkingCars.Value.ToString()) * par.GiaGiuXe;
if (int.Parse(nUDRevieDrink.Value.ToString()) != 0 || int.Parse(nUDWaterDrink.Value.ToString()) != 0)
{
cthdnuoc.MaHD = hd.MaHD;
cthdnuoc.MaLoaiHoaDon = 3;
cthdnuoc.trigiaHoaDon = int.Parse(nUDRevieDrink.Value.ToString()) * giaRevive + int.Parse(nUDWaterDrink.Value.ToString()) * giaNuoc;
}
//2. Insert into DB
bool kq1 = hdBus.taoHD(hd);
bool kq2 = cthdBus.taoCTHD(cthdsan) && cthdBus.taoCTHD(cthdnuoc);
if (kq1 == false || kq2 == false)
{
MessageBox.Show("Thanh toán thất bại. Vui lòng kiểm tra lại dũ liệu");
}
else
{
MessageBox.Show("Thanh toán thành công");
}
}
public bool CapNhat(parametersDTO pr)
{
string query = string.Empty;
query += "UPDATE THAMSO ";
query += "SET TuoiToiDaDocGia = @TuoiToiDaDocGia,TuoiToiThieuDocGia = @TuoiToiThieuDocGia,ThoiHanThe = @ThoiHanThe,SoTheLoaiToiDa = @SoTheLoaiToiDa,SoTacGiaToiDa = @SoTacGiaToiDa,NamXuatBanToiDa = @NamXuatBanToiDa,SoSachMuonToiDa = @SoSachMuonToiDa, SoNgayMuonToiDa = @SoNgayMuonToiDa ";
using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=LIBMANAGEMENT;")) //Init connection to host
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@TuoiToiDaDocGia", pr.TuoiToiDaDocGia);
cmd.Parameters.AddWithValue("@TuoiToiThieuDocGia", pr.TuoiToiThieuDocGia);
cmd.Parameters.AddWithValue("@ThoiHanThe", pr.ThoiHanThe);
cmd.Parameters.AddWithValue("@SoTheLoaiToiDa", pr.SoTheLoaiToiDa);
cmd.Parameters.AddWithValue("@SoTacGiaToiDa", pr.SoTacGiaToiDa);
cmd.Parameters.AddWithValue("@NamXuatBanToiDa", pr.NamXuatBanToiDa);
cmd.Parameters.AddWithValue("@SoSachMuonToiDa", pr.SoSachMuonToiDa);
cmd.Parameters.AddWithValue("@SoNgayMuonToiDa", pr.SoNgayMuonToiDa);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(false);
}
}
}
return(true);
}
public bool update(List <drinksDTO> drinksDTO, parametersDTO parametersDTO) // to update drinks and facilities
{
bool re = parametersDAL.updateDrinks(drinksDTO) && parametersDAL.updatePrice(parametersDTO);
return(re);
}
