}//setSubItems() public int saveCheckList() { String SQL = ""; String UserID = Session["UserID"] == null ? "1" : Session["UserID"].ToString(); //Save the header of checklist SQL = "INSERT INTO [DroneCheckList](\n" + " [DroneCheckListID],\n" + " [DroneID],\n" + " [FlightID],\n" + " [CreatedBy],\n" + " [CreatedOn]\n" + ") VALUES(\n" + " " + CheckListID.ToString() + ",\n" + " 0,\n" + " " + FlightID.ToString() + ",\n" + " '" + UserID + "',\n" + " GETDATE()\n" + ")"; var DroneCheckListID = Util.InsertSQL(SQL); foreach (var item in HeaderCheckItems) { item.saveCheckListItem(DroneCheckListID); } foreach (var item in CheckItems) { item.saveCheckListItem(DroneCheckListID); } return DroneCheckListID; }