public bool Delete(int id)
{
PrintTour currObject = db.PrintTours.FirstOrDefault(x => x.ID == id);
if (currObject != null)
{
db.PrintTours.DeleteOnSubmit(currObject);
db.SubmitChanges();
return(true);
}
return(false);
}
public bool Update(PrintTour obj)
{
PrintTour currObject = db.PrintTours.FirstOrDefault(x => x.ID == obj.ID);
if (currObject != null)
{
currObject.OrganizationID = obj.OrganizationID;
currObject.TourID = obj.TourID;
currObject.DateStart = obj.DateStart;
currObject.Guide1 = obj.Guide1;
currObject.Guide2 = obj.Guide2;
currObject.Driver1 = obj.Driver1;
currObject.Driver2 = obj.Driver2;
currObject.CarCode = obj.CarCode;
currObject.DatePrint = obj.DatePrint;
currObject.TotalPax = obj.TotalPax;
db.SubmitChanges();
}
return(true);
}
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 int Insert(PrintTour obj)
{
db.PrintTours.InsertOnSubmit(obj);
db.SubmitChanges();
return(obj.ID);
}
public PrintTour GetByID(int id)
{
PrintTour data = db.PrintTours.FirstOrDefault(x => x.ID == id);
return(data);
}
