protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TripDAO tripDao = new TripDAO();
List <String> countryList = tripDao.getCountry();
ddlUpdateLocation.DataSource = countryList;
ddlUpdateLocation.DataBind();
ddlUpdateLocation.Items.Insert(0, new ListItem("--Select--", "-1"));
int tripId = Convert.ToInt32(Request.QueryString["tripId"]);
Trip tripObj = tripDao.getTripById(tripId);
if (tripObj == null)
{
Response.Redirect("Oops.aspx");
}
else if (Session["role"].ToString() != "Incharge")
{
Response.Redirect("Oops.aspx");
}
else
{
tbUpdateTitle.Text = tripObj.tripTitle.ToString();
ddlUpdateLocation.SelectedValue = tripObj.tripLocation.ToString();
tripImage.ImageUrl = tripObj.tripImg.ToString();
tbUpdateStart.Text = tripObj.tripStart.ToString("yyyy-MM-dd");
tbUpdateEnd.Text = tripObj.tripEnd.ToString("yyyy-MM-dd");
tbUpdateOpeningday.Text = tripObj.tripOpen.ToString("yyyy-MM-dd");
tbUpdateActivities.Text = tripObj.tripActivities;
tbUpdateCost.Text = tripObj.tripCost.ToString();
DdlUpdateType.SelectedValue = tripObj.tripType.ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int tripId = Convert.ToInt32(Request.QueryString["tripId"]);
Trip tripClass = new Trip();
TripDAO tripObj = new TripDAO();
if (Session["AdminNo"] == null)
{
Response.Redirect("loginStudent.aspx");
}
else
{
Choice choice = tripObj.checkOffer(Session["AdminNo"].ToString(), tripId);
if (choice == null || choice.choice == "Accepted" || choice.choice == "Rejected")
{
System.Diagnostics.Debug.WriteLine("its here");
Response.Redirect("Oops.aspx");
}
else if (choice.teacherChoice != "Approve")
{
System.Diagnostics.Debug.WriteLine("its here2");
Response.Redirect("Oops.aspx");
}
tripName = choice.tripName;
tripStart = choice.tripStart.ToString("dd/MM/yyyy");
tripEnd = choice.tripEnd.ToString("dd/MM/yyyy");
}
}
protected void UpdateTrip(object sender, EventArgs e)
{
TripDAO updTd = new TripDAO();
int tripId = Convert.ToInt32(Request.QueryString["tripId"]);
System.Diagnostics.Debug.WriteLine(tripId + "this is id");
string tripTitle = tbUpdateTitle.Text;
string tripLocation = ddlUpdateLocation.SelectedValue;
string tripImgName = SaveFile(tripUploadImg.PostedFile);
System.Diagnostics.Debug.WriteLine(tripTitle + "this is title");
DateTime tripStart = Convert.ToDateTime(tbUpdateStart.Text);
//LOOK AT THIS SHIT, TRIPSTART WORKS BUT END DOESNT
System.Diagnostics.Debug.WriteLine(tbUpdateStart.Text);
DateTime tripEnd = Convert.ToDateTime(tbUpdateEnd.Text);
System.Diagnostics.Debug.WriteLine(tripEnd);
DateTime tripOpeningDay = Convert.ToDateTime(tbUpdateOpeningday.Text);
string tripActivities = tbUpdateActivities.Text;
double tripCost = Convert.ToInt16(tbUpdateCost.Text);
System.Diagnostics.Debug.WriteLine(tbUpdateCost.Text + "This is cost");
string tripType = DdlUpdateType.SelectedValue;
int results = updTd.updateTrip(tripId, tripTitle, tripLocation, tripImgName, tripStart, tripEnd, tripOpeningDay, tripActivities, tripCost, tripType);
Response.Redirect("TripDetails.aspx");
}
private void AddTripImageButton_Click(object sender, RoutedEventArgs e)
{
var dialog = new OpenFileDialog();
dialog.Multiselect = true;
dialog.DefaultExt = ".png";
dialog.Filter = "All Images Files (*.png;*.jpeg;*.gif;*.jpg;*.bmp;*.tiff;*.tif)|*.png;*.jpeg;*.gif;*.jpg;*.bmp;*.tiff;*.tif"
+ "|PNG Portable Network Graphics (*.png)|*.png"
+ "|JPEG File Interchange Format (*.jpg *.jpeg *jfif)|*.jpg;*.jpeg;*.jfif"
+ "|BMP Windows Bitmap (*.bmp)|*.bmp"
+ "|TIF Tagged Imaged File Format (*.tif *.tiff)|*.tif;*.tiff"
+ "|GIF Graphics Interchange Format (*.gif)|*.gif";
if (true == dialog.ShowDialog())
{
foreach (string FileName in dialog.FileNames)
{
string imageName = System.IO.Path.GetFileName(FileName);
string imageRP = "Images/" + imageName;
string imagePath = AppDomain.CurrentDomain.BaseDirectory + imageRP;
var prefix = 0;
while (File.Exists(imagePath))
{
prefix += 1;
imageRP = "Images/i" + prefix + imageName;
imagePath = AppDomain.CurrentDomain.BaseDirectory + imageRP;
}
File.Copy(FileName, imagePath);
SelectedTrip.Images.Add(imageRP);
}
TripDAO.Update(SelectedTrip);
ImagesListView.Items.Refresh();
}
}
public List <Trip> GetTripsByUser(User user)
{
List <Trip> tripList = new List <Trip>();
User loggedUser = UserSession.GetInstance().GetLoggedUser();
bool isFriend = false;
if (loggedUser != null)
{
foreach (User friend in user.GetFriends())
{
if (friend.Equals(loggedUser))
{
isFriend = true;
break;
}
}
if (isFriend)
{
tripList = TripDAO.FindTripsByUser(user);
}
return(tripList);
}
else
{
throw new UserNotLoggedInException();
}
}
private void createButton_Click(object sender, RoutedEventArgs e)
{
string name = nameTextBox.Text;
var startDate = startDatePicker.SelectedDate;
var endDate = endDatePicker.SelectedDate;
if (name == "")
{
MessageBox.Show("Chưa điền đầy đủ thông tin", "Lỗi");
return;
}
var tripEntered = new Trip()
{
Id = Guid.NewGuid().ToString(),
Name = name,
Status = status,
StartDate = (startDate == null)? "Chưa rõ": ((DateTime)startDate).ToString("dd/MM/yyyy"),
EndDate = (endDate == null) ? "Chưa rõ" : ((DateTime)endDate).ToString("dd/MM/yyyy"),
MainImage = nameImage,
Type = typeChosen,
Transport = transportChosen.Id,
Members = members,
Expenses = expenses,
Places = places,
Images = images
};
var resultAdded = TripDAO.InsertTrip(tripEntered);
MessageBox.Show("Đã thêm thành công", "Thông báo");
}
private void AddExpenseButton_Click(object sender, RoutedEventArgs e)
{
if (MembersListView.SelectedIndex >= 0)
{
Debug.WriteLine(SelectedTrip.Members[MembersListView.SelectedIndex].ToString());
TripExpense expense = new TripExpense();
expense.Description = ExpenseDescriptionTextBox.Text;
string ct = ExpenseCostTextBox.Text.Replace(" ", string.Empty);
double cost = 0;
if (double.TryParse(ct, out cost) && cost > 0)
{
expense.Cost = cost;
SelectedTrip.Members[MembersListView.SelectedIndex].Expenses.Add(expense);
ExpenseDescriptionTextBox.Text = "";
ExpenseCostTextBox.Text = "";
TripDAO.Update(SelectedTrip);
ExpensesListView.Items.Refresh();
DrawChart();
}
else
{
ShowErrorDialog("Chi phí là một số lớn hơn không ");
}
}
}
protected void GridActionWaitingList(object sender, GridViewCommandEventArgs e)
{
int tripId = Convert.ToInt32(Request.QueryString["tripId"]);
GridViewRow row = GridViewRegistered.SelectedRow;
string RegisterID = e.CommandArgument.ToString();
int staffId = Convert.ToInt32(Session["StaffId"]);
if (e.CommandName == "Shortlist")
{
TripDAO TripDAO = new TripDAO();
Trip TripList = new Trip();
int TRIPPYLIST;
TRIPPYLIST = TripDAO.updateShortlisted(RegisterID, tripId);
InterviewDAO intDao = new InterviewDAO();
string adminNo = intDao.exchangeRegIdForAdminNo(RegisterID);
int updateStuds = intDao.selectForInterview(adminNo, staffId, tripId);
Response.Redirect(Request.RawUrl);
}
else if (e.CommandName == "Move to pending")
{
TripDAO TripDAO = new TripDAO();
Trip TripList = new Trip();
int TRIPPYLIST;
TRIPPYLIST = TripDAO.updateRegistered(RegisterID, tripId);
Response.Redirect(Request.RawUrl);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if ((Session["role"].ToString() == "Teacher") || (Session["role"].ToString() == "Incharge"))
{
if (!IsPostBack)
{
FeedbackFormDAO tdDAO = new FeedbackFormDAO();
List <FeedbackForm> tdList = new List <FeedbackForm>();
tdList = tdDAO.GetAllFeedBack();
GridView_GetFB.DataSource = tdList;
GridView_GetFB.DataBind();
TripDAO tripDao = new TripDAO();
List <String> countryList = tripDao.getCountry();
CountryFilterDropDown.DataSource = countryList;
CountryFilterDropDown.DataBind();
CountryFilterDropDown.Items.Insert(0, new ListItem("All", "All"));
}
}
else
{
Response.Redirect("./Oops.aspx");
}
}
catch (Exception)
{
Response.Redirect("./Oops.aspx");
}
}
public MainWindow()
{
InitializeComponent();
var list = TripDAO.GetAll();
list.ForEach(e => Debug.WriteLine(e));
ListViewMenu.SelectedIndex = 0;
}
protected void Unnamed2_Click(object sender, EventArgs e)
{
Trip tripClass = new Trip();
TripDAO tripObj = new TripDAO();
tripObj.chooseOffer("Rejected", Session["AdminNo"].ToString());
Response.Redirect("Tripdetails.aspx");
}
private void removePlaceBtn_MouseDown(object sender, MouseButtonEventArgs e)
{
var idPlace = ((TextBlock)sender).Uid;
TripDAO.RemovePlace(idTrip, idPlace);
DisplayDetail();
MessageBox.Show("Đã xóa điểm dừng thành công.", "Thông báo");
}
private void removeExpenseBtn_MouseDown(object sender, MouseButtonEventArgs e)
{
var idExpense = ((Image)sender).Uid;
TripDAO.RemoveExpense(idTrip, idExpense);
DisplayDetail();
DisplayCostChart();
MessageBox.Show("Đã xóa chi phí thành công.", "Thông báo");
}
private void deleteMemberButton_MouseDown(object sender, MouseButtonEventArgs e)
{
var idMember = ((Image)sender).Uid;
TripDAO.RemoveMember(idTrip, idMember);
DisplayDetail();
DisplayDonationChart();
MessageBox.Show("Đã xóa thành viên thành công.", "Thông báo");
}
public void CompleteTrip(int tripId)
{
Trip trip = TripDAO.getTripById(tripId);
Order completedOrder = OrderDAO.GetOrderById(trip.OrderId);
completedOrder.Status = TripStatusEnum.DONE;
OrderDAO.Update(completedOrder);
TripDAO.Delete(trip);
}
public static string assignStudent(string tripId)
{
System.Diagnostics.Debug.WriteLine(tripId + " this is tripId@@@ ");
System.Diagnostics.Debug.WriteLine(adminNo + " this is adminNo@@@ ");
TripDAO addStudDao = new TripDAO();
addStudDao.assignStudentToTrip(Convert.ToInt32(tripId), adminNo);
System.Diagnostics.Debug.WriteLine("its in");
return(tripId);
}
public Trip FindTripByOrderId(int orderId)
{
Order order = OrderDAO.GetOrderById(orderId);
Trip trip = TripDAO.Read().First(t => t.OrderId == orderId);
Car car = CarDAO.GetById(trip.CarId);
Account account = AccountDAO.GetAccountById(trip.AccountId);
trip.Order = order;
trip.Account = account;
trip.Car = car;
return(trip);
}
private void Insert(Trip trip)
{
if (TripDAO.Insert(trip))
{
Clear();
MessageBox.Show($"Đã thêm chuyến đi {trip.Name}", "Thêm Chuyến Đi", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Đã xảy ra lỗi không rõ!", "Thêm Chuyến Đi", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
private void AddStepButton_Click(object sender, RoutedEventArgs e)
{
string step = StepNameTextBox.Text;
if (!string.IsNullOrEmpty(step) && !SelectedTrip.Step.Exists(x => x.Equals(step)))
{
SelectedTrip.Step.Add(step);
TripDAO.Update(SelectedTrip);
StepNameTextBox.Text = "";
StepListView.Items.Refresh();
}
}
public HomeScreen()
{
InitializeComponent();
SearchComboBox.ItemsSource = Tags;
completedJourney.ItemsSource = completedJourneyObj;
currentJourney.ItemsSource = currentJourneyObj;
data = TripDAO.GetAll();
Debug.WriteLine(data);
ReloadData();
}
public List <Trip> FindTripsRelatedTo(string currentUser)
{
List <Trip> relatedTrips = new List <Trip>();
if (currentUser != null && currentUser != string.Empty)
{
relatedTrips = TripDAO.Read()
.Where(trip => trip.AccountId == Convert.ToInt32(currentUser) &&
TripStatusEnum.IN_PROCESS.Equals(OrderDAO.GetOrderById(trip.OrderId).Status))
.ToList();
}
return(relatedTrips);
}
private void addExpenseBtn_MouseDown(object sender, MouseButtonEventArgs e)
{
var addExpenseDialog = new AddExpenseDialog();
if (addExpenseDialog.ShowDialog() == true)
{
var newExpense = addExpenseDialog.NewExpense;
trip.Expenses.Add(newExpense);
TripDAO.InsertExpense(idTrip, newExpense);
DisplayDetail();
DisplayCostChart();
}
}
private void addMemberButton_Click(object sender, RoutedEventArgs e)
{
var addMemberDialog = new AddMemberDialog();
if (addMemberDialog.ShowDialog() == true)
{
var newMember = addMemberDialog.NewMember;
trip.Members.Add(newMember);
TripDAO.InsertMember(idTrip, newMember);
DisplayDetail();
DisplayDonationChart();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminNo"] == null)
{
Response.Redirect("loginStudent.aspx");
}
else
{
Lbl_Address.Visible = true;
TripDAO Trip1 = new TripDAO();
TripRepeater.DataSource = Trip1.getAllTrip();
TripRepeater.DataBind();
}
}
private void DisplayDetail()
{
trip = TripDAO.GetById(idTrip);
ImageTrip imageToShow;
if (trip.Images.Count == 0)
{
imageToShow = new ImageTrip()
{
NameImage = "default_no_image.gif"
};
index_max = 0;
}
else
{
imageToShow = trip.Images[index_showImage];
index_max = trip.Images.Count - 1;
}
totalTextBlock.Text = trip.Members.Count + " t.viên";
totalExpense = trip.Expenses.Sum(item => int.Parse(item.Cost));
totalDonation = trip.Members.Sum(item => int.Parse(item.Donation));
CultureInfo provider = CultureInfo.InvariantCulture;
this.DataContext = new
{
Trip = new
{
Name = trip.Name,
StartDate = trip.StartDate,
EndDate = trip.EndDate,
MainImage = trip.MainImage,
Transport = TransportDAO.GetById(trip.Transport),
Status = trip.Status == "finish" ? "False" : "True",
NameButtonStatus = trip.Status == "finish" ? "Đã kết thúc" : "Kết thúc",
TotalDate = "not dev"
},
PointLabel,
SeriesCollection,
ImageToShow = imageToShow,
};
membersListView.ItemsSource = trip.Members;
expensesListView.ItemsSource = trip.Expenses;
donationsListView.ItemsSource = trip.Members;
placesListView.ItemsSource = trip.Places;
}
private void AddMemberButton_Click(object sender, RoutedEventArgs e)
{
Member mem = new Member();
mem.Name = MemberNameTextBox.Text;
mem.Expenses = new List <TripExpense>();
if (!string.IsNullOrEmpty(mem.Name) && !SelectedTrip.Members.Exists(x => x.Name.Equals(mem.Name)))
{
SelectedTrip.Members.Add(mem);
TripDAO.Update(SelectedTrip);
MemberNameTextBox.Text = "";
MembersListView.Items.Refresh();
DrawChart();
}
}
private void Search()
{
string key = VNCharacterUtils.RemoveAccent(SearchTextBox.Text).ToLower();
Debug.WriteLine(key);
int sb = SearchComboBox.SelectedIndex;
Debug.WriteLine($"{sb} {key}");
SearchBy searchBy = (sb == 0) ? SearchAll
: (sb == 1) ? SearchByName
: (sb == 2) ? SearchByPlace : (SearchBy)SearchByMember;
var all = TripDAO.GetAll();
data = all.Where(e => searchBy(e, key)).ToList();
ReloadData();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Staffid"] == null)
{
Response.Redirect("loginStaff.aspx");
}
else
{
StudentDAO stuObj = new StudentDAO();
TripDAO Trip1 = new TripDAO();
StudentRepeater.DataSource = stuObj.getAllstudent();
StudentRepeater.DataBind();
TripRepeater.DataSource = Trip1.getAllTrip();
TripRepeater.DataBind();
}
}
public void CreateTrip(int orderId, int driverId)
{
Account driver = AccountDAO.GetAccountById(driverId);
Order order = OrderDAO.GetOrderById(orderId);
Car car = CarDAO.GetById((int)driver.CarId);
driver.Car = car;
Trip trip = new Trip();
trip.TripDate = DateTime.Now;
trip.OrderId = order.OrderId;
trip.TripName = order.OrderName;
trip.CarId = driver.Car.CarId;
trip.AccountId = driver.AccountId;
TripDAO.Create(trip);
order.Status = TripStatusEnum.IN_PROCESS;
OrderDAO.Update(order);
}
private void editMemberButton_MouseDown(object sender, MouseButtonEventArgs e)
{
var idMember = ((Image)sender).Uid;
var memberCurrent = TripDAO.GetMemberById(idTrip, idMember);
var addMemberDialog = new AddMemberDialog(memberCurrent);
if (addMemberDialog.ShowDialog() == true)
{
var newMember = addMemberDialog.NewMember;
TripDAO.RemoveMember(idTrip, idMember);
TripDAO.InsertMember(idTrip, newMember);
DisplayDetail();
DisplayDonationChart();
MessageBox.Show("Đã cập nhật thành công!");
}
}
