public bool Cap_Nhat_Tra_Phong(CPhieuThuePhong ptp) { XmlDocument file = new XmlDocument(); file.Load(connection); XmlElement restaurant = file.DocumentElement; XmlNode oldnode = file.SelectSingleNode("/CNXML_SV_QLKS_2_Cach_1/PHIEU_THUE" + "[@ID ='" + ptp._ID + "']"); XmlElement updatenode = file.CreateElement("PHIEU_THUE"); updatenode.SetAttribute("ID", ptp._ID.ToString()); updatenode.SetAttribute("ID_PHONG", ptp._ID_Phong.ToString()); updatenode.SetAttribute("Ngay_Bat_dau", ptp._Ngay_Bat_Dau.ToString()); updatenode.SetAttribute("Ngay_Du_kien_Tra", ptp._Ngay_Du_Kien_Tra.ToString()); updatenode.SetAttribute("Ngay_Ket_thuc", ptp._Ngay_Ket_Thuc.ToString()); updatenode.SetAttribute("Tien_Tra", ptp._Tien_Tra.ToString()); try { restaurant.ReplaceChild(updatenode, oldnode); } catch { return(false); } file.Save(connection); return(true); }
public bool Them_Phieu_Thue_Phong(CPhieuThuePhong ptp) { XmlDocument file = new XmlDocument(); file.Load(connection); XmlElement doc = file.DocumentElement; //CNXML_SV_QLKS_2_Cach_1 XmlElement ptpnode = file.CreateElement(""); //ptpnode.SetAttribute("ID", ptp._ID.ToString()); //Tự phát sinh ID ptpnode.SetAttribute("ID", Phat_Sinh_ID_Phieu_Thue().ToString()); ptpnode.SetAttribute("ID_PHONG", ptp._ID_Phong.ToString()); ptpnode.SetAttribute("Ngay_Bat_dau", ptp._Ngay_Bat_Dau.ToString()); ptpnode.SetAttribute("Ngay_Du_kien_Tra", ptp._Ngay_Du_Kien_Tra.ToString()); ptpnode.SetAttribute("Ngay_Ket_thuc", ptp._Ngay_Ket_Thuc.ToString()); ptpnode.SetAttribute("Tien_Tra", ptp._Tien_Tra.ToString()); try { doc.AppendChild(ptpnode); } catch { return(false); } file.Save(connection); return(true); }
public List <CPhieuThuePhong> Tai_DS_Phieu_Thue() { List <CPhieuThuePhong> list = new List <CPhieuThuePhong>(); CPhieuThuePhong ptp; XmlDocument file = new XmlDocument(); file.Load(connection); XmlNodeList ksnodelist = file.SelectNodes("/CNXML_SV_QLKS_2_Cach_1/PHIEU_THUE"); for (int i = 0; i < ksnodelist.Count; i++) { XmlElement node = (XmlElement)ksnodelist[i]; ptp = new CPhieuThuePhong(); ptp._ID = int.Parse(node.GetAttribute("ID")); ptp._ID_Phong = int.Parse(node.GetAttribute("ID_PHONG")); ptp._Ngay_Bat_Dau = DateTime.Parse(node.GetAttribute("Ngay_Bat_dau")); ptp._Ngay_Du_Kien_Tra = DateTime.Parse(node.GetAttribute("Ngay_Du_kien_Tra")); ptp._Ngay_Ket_Thuc = DateTime.Parse(node.GetAttribute("Ngay_Ket_thuc")); ptp._Tien_Tra = double.Parse(node.GetAttribute("Tien_Tra")); list.Add(ptp); } return(list); }