public List <ChiTietDichVu> GetDataByMa(int MaDV)
{
try
{
List <ChiTietDichVu> dsDichVu = new List <ChiTietDichVu>();
DataTable dt = dataProvider.ExecuteQuery("Proc_ChiTietDichVu_GetData", new object[] { MaDV }, new List <string>()
{
"MaDV"
});
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
ChiTietDichVu chitietdichvu = new ChiTietDichVu();
chitietdichvu.MaCTDV = String.IsNullOrEmpty(row["MaCTDV"].ToString()) ? 0 : int.Parse(row["MaCTDV"].ToString());
chitietdichvu.MaDV = String.IsNullOrEmpty(row["MaDV"].ToString()) ? 0 : int.Parse(row["MaDV"].ToString());
chitietdichvu.Buoc = String.IsNullOrEmpty(row["Buoc"].ToString()) ? "" : row["Buoc"].ToString();
dsDichVu.Add(chitietdichvu);
}
return(dsDichVu);
}
return(new List <ChiTietDichVu>());
}
catch (Exception ex)
{
return(new List <ChiTietDichVu>());
}
}
public ActionResult ThemMoi(ChiTietDichVu ctdv)
{
if (ModelState.IsValid)
{
ctdv.ThanhTien = ctdv.SoLuong * ctdv.DonGia;
ctdv.TongTien = ctdv.GiaPhong + ctdv.ThanhTien;
db.ChiTietDichVus.Add(ctdv);
db.SaveChanges();
}
return(RedirectToAction("ThongKe"));
}
//[ValidateInput(false)]
public ActionResult Sua(ChiTietDichVu ctdv)
{
if (ModelState.IsValid)
{
//Thực hiện cập nhật trong model
ctdv.ThanhTien = ctdv.SoLuong * ctdv.DonGia;
ctdv.TongTien = ctdv.GiaPhong + ctdv.ThanhTien;
db.Entry(ctdv).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("ThongKe"));
}
public JsonResult ThemChiTietDichVu(string MaDV, string Buoc)
{
ChiTietDichVu chiTietDichVu = new ChiTietDichVu();
chiTietDichVu.MaDV = Convert.ToInt32(MaDV);
chiTietDichVu.Buoc = Buoc;
ChiTietDichVuModel chiTietDichVuModel = new ChiTietDichVuModel();
chiTietDichVuModel.ThemChiTietDichVu(chiTietDichVu);
return(Json(new { Message = "", JsonRequestBehavior.AllowGet }));
}
public HttpResponseMessage Delete(int ma_dulieu, [FromBody] ChiTietDichVu value)
{
if (Test() == false)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound));
}
ChiTiet_DichVu = new ChiTietDichVuDAO();
bool ret = ChiTiet_DichVu.delete_ChiTiet_DichVu(value);
var response = Request.CreateResponse <bool>(HttpStatusCode.Created, ret);
return(response);
}
public HttpResponseMessage Post([FromBody] ChiTietDichVu value)
{
//if (Test() == false)
//{
// throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound));
//}
ChiTiet_DichVu = new ChiTietDichVuDAO();
bool ret = ChiTiet_DichVu.insert_ChiTiet_DichVu(value);
var response = Request.CreateResponse <bool>(HttpStatusCode.Created, ret);
return(response);
}
public bool maThue_maDV_CoTonTai(string maThue, string maDV)
{
ChiTietDichVu ctdv = db.ChiTietDichVus.Where(x => x.maThue.Equals(maThue) && x.maDV.Equals(maDV)).SingleOrDefault();
if (ctdv == null)
{
return(true);
}
else
{
return(false);
}
}
public int insertCTDV(eChiTetDichVu ctdvnew)
{
ChiTietDichVu temp = new ChiTietDichVu();
temp.maThue = ctdvnew.MaThue;
temp.maPhong = ctdvnew.MaPhong;
temp.maKhach = ctdvnew.MaKhach;
temp.maDV = ctdvnew.MaDV;
temp.soLuong = ctdvnew.SoLuong;
db.ChiTietDichVus.InsertOnSubmit(temp);
db.SubmitChanges();
return(1);
}
public ActionResult Xoa(int MaPhong)
{
//lấy ra đối tượng khách hàng theo mã
ChiTietDichVu ctdv = db.ChiTietDichVus.FirstOrDefault(n => n.MaPhong == MaPhong);
if (ctdv == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(ctdv));
}
public ActionResult XacnhanXoa(int MaPhong)
{
ChiTietDichVu ctdv = db.ChiTietDichVus.FirstOrDefault(n => n.MaPhong == MaPhong);
if (ctdv == null)
{
Response.StatusCode = 404;
return(null);
}
db.ChiTietDichVus.Remove(ctdv);
db.SaveChanges();
return(RedirectToAction("ThongKe"));
}
public IEnumerable <ChiTietDichVu> Get_DanhSach_DichVu(int ma_dulieu)
{
//if (Test() == false)
//{
// throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound));
//}
ChiTiet_DichVu = new ChiTietDichVuDAO();
ChiTietDichVu[] chitiet = new ChiTietDichVu[ChiTiet_DichVu.get_ChiTiet_DichVu(ma_dulieu).Count];
chitiet = ChiTiet_DichVu.get_ChiTiet_DichVu(ma_dulieu).ToArray();
if (chitiet.Length == 0)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
return(chitiet);
}
private void btnLuuDV_Click(object sender, EventArgs e)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
if (trangThai2 == "them")
{
ChiTietDichVu ctdv = new ChiTietDichVu();
string maTour = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString();
ctdv.MaSoTour = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString());
ctdv.MaDichVu = int.Parse(cboDichVu.EditValue.ToString());
string duocHuong = cboDuocHuong.EditValue.ToString();
if (duocHuong == "Có")
{
ctdv.DuocHuong = 1;
}
else
{
ctdv.DuocHuong = 0;
}
data.ChiTietDichVus.InsertOnSubmit(ctdv);
data.SubmitChanges();
loadDgvDichVuTheoMa(int.Parse(maTour));
ClearAllDichVu();
MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (trangThai2 == "sua")
{
string maTour = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString();
string maDV = gridView2.GetRowCellValue(gridView2.FocusedRowHandle, "MaDichVu").ToString();
ChiTietDichVu ctdv = data.ChiTietDichVus.Where(t => t.MaSoTour == int.Parse(maTour) && t.MaDichVu == int.Parse(maDV)).FirstOrDefault();
string duocHuong = cboDuocHuong.EditValue.ToString();
if (duocHuong == "Có")
{
ctdv.DuocHuong = 1;
}
else
{
ctdv.DuocHuong = 0;
}
data.SubmitChanges();
loadDgvDichVuTheoMa(int.Parse(maTour));
ClearAllDichVu();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
private void btnXoaDichVu_Click(object sender, EventArgs e)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
string maTour = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString();
string maDV = gridView2.GetRowCellValue(gridView2.FocusedRowHandle, "MaDichVu").ToString();
ChiTietDichVu ctdv = data.ChiTietDichVus.Where(t => t.MaSoTour == int.Parse(maTour) && t.MaDichVu == int.Parse(maDV)).FirstOrDefault();
DialogResult r;
r = MessageBox.Show("Bạn có muốn xóa dịch vụ này", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (r == DialogResult.Yes)
{
data.ChiTietDichVus.DeleteOnSubmit(ctdv);
data.SubmitChanges();
loadDgvDichVuTheoMa(int.Parse(maTour));
}
}
}
public string CapNhatChiTietDichVu(ChiTietDichVu chiTietDichVu)
{
try
{
int kq = dataProvider.ExecuteNonQuery("Proc_ChiTietDichVu_Update", new object[] { chiTietDichVu.MaCTDV, chiTietDichVu.MaDV, chiTietDichVu.Buoc },
new List <string>()
{
"@MaCTDV",
"@MaDV",
"@Buoc"
});
return(kq.ToString());
}
catch (Exception ex)
{
return("");
}
}
public string ThemChiTietDichVu(ChiTietDichVu chiTietDichVu)
{
try
{
string rs = "";
rs = dataProvider.ExecuteScalar("Proc_ChiTietDichVu_Insert", new object[] { chiTietDichVu.MaDV, chiTietDichVu.Buoc },
new List <string>()
{
"@MaDV",
"@Buoc"
});
return(rs);
}
catch (Exception ex)
{
return("");
}
}
