Exemplo n.º 1
0
        public DienNuoc GetId(int maDN)
        {
            DienNuoc dn = new DienNuoc();

            using (SqlConnection connection = con())
            {
                dn = (DienNuoc)connection.Query <DienNuoc>("SELECT MaDN,DichVu.MaDV,SoCu,SoMoi,ngayChot,PHONGTRO.MaPhongTro,TenDV,TenPhongTro From DienNuoc,DichVu,PHONGTRO where DienNuoc.MaDV=DichVu.MaDV and PHONGTRO.MaPhongTro = DienNuoc.MaPhongTro and maDN=" + maDN).FirstOrDefault();
                return(dn);
            }
        }
Exemplo n.º 2
0
        public int Update(DienNuoc dn)
        {
            int count = 0;

            using (SqlConnection connection = con())
            {
                count = connection.Execute("UPDATE DienNuoc SET  MaDV= @MaDV, SoCu= @SoCu, SoMoi=@SoMoi,ngayChot=@ngayChot,MaPhongTro=@MaPhongTro WHERE MaDN=@MaDN", dn);
            }
            return(count);
        }
Exemplo n.º 3
0
        public IActionResult Post(DienNuoc dn)
        {
            if (unitOfWork.DienNuoc.Add(dn) == 0)
            {
                return(StatusCode(StatusCodes.Status500InternalServerError, new Reponse {
                    Status = "error", Massage = "error"
                }));
            }

            return(Ok(new Reponse {
                Status = "succes", Massage = "succes"
            }));
        }
Exemplo n.º 4
0
        public void SuaDienNuoc(string maptdn, string maphong, string sdtruoc, string sntruoc, string sdien, string snuoc, string dgdien, string dgnuoc, string tdien, string tnuoc, string thangthu, string masv, string manv, string ghichu)
        {
            int    SDT = int.Parse(sdtruoc);
            int    SNT = int.Parse(sntruoc);
            int    SD  = int.Parse(sdien);
            int    SN  = int.Parse(snuoc);
            double DGD = double.Parse(dgdien);
            double DGN = double.Parse(dgnuoc);
            double TD  = double.Parse(tdien);

            TD = (SD - SDT) * DGD;
            double TN = double.Parse(tnuoc);

            TN = (SN - SNT) * DGN;
            DN = new DienNuoc(maptdn, maphong, SDT, SNT, SD, SN, DGD, DGN, TD, TN, thangthu, masv, manv, ghichu);
            DNDAL.Suadiennuoc(DN);
        }
Exemplo n.º 5
0
        public int Add(DienNuoc dn)
        {
            int x;

            using (SqlConnection connection = con())
            {
                connection.Open();

                x = connection.Query <DienNuoc>($"SELECT MaDN From DienNuoc Where MaDV=@MaDV and MaPhongTro=@MaPhongTro", dn, commandType: CommandType.Text).Count();
                if (x <= 0)
                {
                    connection.Execute("insert DienNuoc values(@MaDV,@SoCu,@SoMoi,@ngayChot,@MaPhongTro)", dn);
                    return(1);
                }
                return(0);
            }
        }
Exemplo n.º 6
0
        public DienNuoc Laydiennuoctheoma(string MaPTDN)
        {
            DataTable dt = DNDAL.LayDNTheoMa(MaPTDN);
            DienNuoc  dn = new DienNuoc();

            dn.Maptdn      = dt.Rows[0][0].ToString();
            dn.Maphong     = dt.Rows[0][1].ToString();
            dn.Sodientruoc = int.Parse(dt.Rows[0][2].ToString());
            dn.Sonuoctruoc = int.Parse(dt.Rows[0][3].ToString());
            dn.Sodien      = int.Parse(dt.Rows[0][4].ToString());
            dn.Sonuoc      = int.Parse(dt.Rows[0][5].ToString());
            dn.Dongiadien  = double.Parse(dt.Rows[0][6].ToString());
            dn.Dongianuoc  = double.Parse(dt.Rows[0][7].ToString());
            dn.Tiendien    = double.Parse(dt.Rows[0][8].ToString());
            dn.Tiennuoc    = double.Parse(dt.Rows[0][9].ToString());
            dn.Thangthu    = dt.Rows[0][10].ToString();
            dn.Masinhvien  = dt.Rows[0][11].ToString();
            dn.Manhanvien  = dt.Rows[0][12].ToString();
            dn.Ghichu      = dt.Rows[0][13].ToString();
            return(dn);
        }
Exemplo n.º 7
0
 public IActionResult Put(DienNuoc dn)
 {
     unitOfWork.DienNuoc.Update(dn);
     return(Ok());
 }
Exemplo n.º 8
0
 public void XoaDienNuoc(string MaPTDN)
 {
     DN = new DienNuoc(MaPTDN, "", '0', '0', '0', '0', '0', '0', '0', '0', "", "", "", "");
     DNDAL.Xoadiennuoc(DN);
 }
Exemplo n.º 9
0
 public void Xoadiennuoc(DienNuoc dn)
 {
     strSQL = "Delete DienNuoc where MaPTDN='" + dn.Maptdn + "'";
     helper.ThucThiKN(strSQL);
 }
Exemplo n.º 10
0
 public void Suadiennuoc(DienNuoc dn)
 {
     strSQL = "Update DienNuoc set MaPhong='" + dn.Maphong + "',SoDienTruoc='" + dn.Sodientruoc + "',SoNuocTruoc='" + dn.Sonuoctruoc + "',SoDien='" + dn.Sodien + "',SoNuoc='" + dn.Sonuoc + "',DonGiaDien='" + dn.Dongiadien + "',DonGiaNuoc='" + dn.Dongianuoc + "',ThanhTienDien='" + dn.Tiendien + "',ThanhTienNuoc='" + dn.Tiennuoc + "',ThangThu='" + dn.Thangthu + "',MaSV='" + dn.Masinhvien + "',MaNV='" + dn.Manhanvien + "',GhiChu=N'" + dn.Ghichu + "' where MaPTDN='" + dn.Maptdn + "'";
     helper.ThucThiKN(strSQL);
 }
Exemplo n.º 11
0
 public void Themdiennuoc(DienNuoc dn)
 {
     strSQL = "Insert into DienNuoc values('" + dn.Maptdn + "','" + dn.Maphong + "','" + dn.Sodientruoc + "','" + dn.Sonuoctruoc + "','" + dn.Sodien + "','" + dn.Sonuoc + "','" + dn.Dongiadien + "','" + dn.Dongianuoc + "','" + dn.Tiendien + "','" + dn.Tiennuoc + "','" + dn.Thangthu + "','" + dn.Masinhvien + "','" + dn.Manhanvien + "',N'" + dn.Ghichu + "' )";
     helper.ThucThiKN(strSQL);
 }