public bool Delete(int id) { DetailPrintTour currObject = db.DetailPrintTours.FirstOrDefault(x => x.ID == id); if (currObject != null) { db.DetailPrintTours.DeleteOnSubmit(currObject); db.SubmitChanges(); return(true); } return(false); }
private void insertPrintDetails() { var hdvName = txtHdvName.Text; var txName = txtTXName.Text; var hdvID = cbbHDV.SelectedValue == null ? "0" : cbbHDV.SelectedValue.ToString(); var txID = cbbTaiXe.SelectedValue == null ? "0" : cbbTaiXe.SelectedValue.ToString(); if (hdvName != "") { hdvID = "0"; } if (txName != "") { txID = "0"; } var currentDate = DateTime.Now; PrintTour printTour = new PrintTour(); //printTour.OrganizationID = 0; printTour.TourID = _tourID; printTour.DateStart = _startDate; printTour.Guide1 = int.Parse(hdvID); printTour.Guide2 = hdvName; printTour.Driver1 = int.Parse(txID); printTour.Driver2 = txName; printTour.CarCode = txtBKS.Text; printTour.DatePrint = currentDate; printTour.TotalPax = countPax(); var printID = printService.Insert(printTour); for (int i = 0; i < gridViewData.RowCount; i++) { int bookID = int.Parse(gridViewData.GetRowCellValue(i, "ID").ToString()); DetailPrintTour detail = new DetailPrintTour(); detail.PrintID = printID; detail.BookID = bookID; detail.Date = currentDate; printDetailService.Insert(detail); } }
public bool Insert(DetailPrintTour obj) { db.DetailPrintTours.InsertOnSubmit(obj); db.SubmitChanges(); return(true); }
public DetailPrintTour GetByID(int id) { DetailPrintTour data = db.DetailPrintTours.FirstOrDefault(x => x.ID == id); return(data); }