protected HomestayStudentBasic StudentRequest(int HomestayStudentId) { var cHomestayStudentBasic = new CHomestayStudentRequest(); HomestayStudentBasic Student = cHomestayStudentBasic.GetHomestayStudentRequest(HomestayStudentId); return(Student); }
protected void UpdateToolBar_ButtonClick(object sender, Telerik.Web.UI.RadToolBarEventArgs e) { if (HomestayStudentId > 0) { if (UpdateToolBar.TabIndex == 0) { HomestayStudentBasic Request = StudentRequest(HomestayStudentId); int StudentId = Convert.ToInt32(Request.StudentId); if (Grid_HostList.SelectedValue != null) { int HostId = Convert.ToInt32(Grid_HostList.SelectedValue); if (Grid_HostRoom.SelectedValue != null) { int RoomId = Convert.ToInt32(Grid_HostRoom.SelectedValue); if (Grid_HostBed.SelectedValue != null) { int BedId = Convert.ToInt32(Grid_HostBed.SelectedValue); //Homestay Placement int AddResult = 0; var cHomestayPlacement = new CHomestayPlacement(); HomestayPlacement Placement = new HomestayPlacement(); Placement.StudentBasicId = HomestayStudentId; Placement.StudentId = StudentId; Placement.HostId = HostId; Placement.RoomId = RoomId; Placement.BedId = BedId; Placement.HomestayAgencyId = 0; Placement.StartDate = Request.StartDate; Placement.EndDate = Request.EndDate; Placement.PlacementStatus = 1; // Placed=1, Canceled =0, Schedule Change=2 Placement.PlacementType = 1; // Placed by School=1, Place by Agency =2 Placement.CreatedDate = DateTime.Now; Placement.CreatedId = CurrentUserId; Placement.UpdatedDate = DateTime.Now; Placement.UpdatedId = CurrentUserId; AddResult = cHomestayPlacement.Add(Placement); if (AddResult > 0) { var cRequest = new CHomestayStudentRequest(); UpdateHomestayStudentStatus(HomestayStudentId, 2); //Placed By School RunClientScript("Close();"); ShowMessage("Homestay Placement Request has been placed successfully."); } else //Failed { ShowMessage("Failed to add Homestay Placement Request, Please try it again."); } } } } } } }
protected HomestayStudentBasic GetFormData(HomestayStudentBasic Student) { //Airpot Information Student.PickUp = Convert.ToInt32(ddl_pickup.SelectedValue.ToString()); Student.ArrivalDate = DatePickArrivalDate.SelectedDate; Student.ArriveTime = TimePickerArrivalTime.SelectedTime; Student.ArrivalAirLine = txtArrivalAirLine.Text.ToString().Trim(); Student.ArrivalFlightNo = txtArrivalFlilghtNo.Text.ToString().Trim(); Student.DepartingFrom = txtDepartingFrom.Text.ToString().Trim(); Student.DropOff = Convert.ToInt32(ddlDropoff.SelectedValue.ToString()); Student.DepartureDate = DatePicker_DepartureDate.SelectedDate; Student.DepartureTime = TimePickerDepartureTime.SelectedTime; Student.DepartureAirLine = txtDepartureAirline.Text.ToString().Trim(); Student.DepartureFlightNo = txtDepartureFlightNo.Text.ToString().Trim(); Student.LeavingFrom = txtLeavingFrom.Text.ToString().Trim(); //Preference Student.Smoking = Convert.ToInt32(ddlSmoking.SelectedValue.ToString()); Student.Internet = Convert.ToInt32(ddlInternet.SelectedValue.ToString()); Student.RoomType = Convert.ToInt32(ddlRoomType.SelectedValue.ToString()); Student.MealType = Convert.ToInt32(ddlMealType.SelectedValue.ToString()); Student.GuardianRequired = Convert.ToInt32(ddlGuardian.SelectedValue.ToString()); Student.Pet = Convert.ToInt32(ddlPet.SelectedValue.ToString()); Student.Children = Convert.ToInt32(ddlChildren.SelectedValue.ToString()); Student.Medication = txtMedication.Text.ToString().Trim(); Student.Diet = txtDiet.Text.ToString().Trim(); //General Information Student.StartDate = DatePickerStartDate.SelectedDate; Student.EndDate = DatePickerEndDate.SelectedDate; Student.ExtensionFlag = Convert.ToInt32(ddlExtention.SelectedValue.ToString()); int Weeks = 0; int ExtraDay = 0; if (TxtHomestayWeeks.Text.ToString().Trim().Length > 0) { Weeks = Convert.ToInt32(TxtHomestayWeeks.Text.ToString()); } if (TxtExtraDays.Text.ToString().Length > 0) { ExtraDay = Convert.ToInt32(TxtExtraDays.Text.ToString()); } Student.HomestayWeeks = Weeks; Student.ExtraDays = ExtraDay; Student.UrgentRequest = Convert.ToInt32(ddlUrgent.SelectedValue.ToString()); Student.AllergyType = Convert.ToInt32(ddlAllergy.SelectedValue.ToString()); Student.AllergyNote = txtAllergyType.Text.ToString(); Student.Comments = txtComments.Text; Student.PlacedUserId = 0; Student.StudentId = Convert.ToInt32(ddlStudent.SelectedValue); return(Student); }
protected void Grid_HostList_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { if (HomestayStudentId > 0) { HomestayStudentBasic Student = StudentRequest(HomestayStudentId); DateTime StartDate = Convert.ToDateTime(Student.StartDate); DateTime EndDate = Convert.ToDateTime(Student.EndDate); var cHomestayBasic = new CHomestayHostBasic(); Grid_HostList.DataSource = cHomestayBasic.HomestayHostListWithVacantBed(CurrentSiteLocationId, StartDate, EndDate); //cHomestayBasic.GetHomestayHostActiveList(CurrentSiteLocationId, StartDate,EndDate); } }
protected int GetStudentId(int HomestayStudentId) { int StudentId = 0; if (HomestayStudentId > 0) { var cHomestayStudent = new CHomestayStudentRequest(); HomestayStudentBasic StudentBasic = cHomestayStudent.GetHomestayStudentRequest(HomestayStudentId); StudentId = Convert.ToInt32(StudentBasic.StudentId); } return(StudentId); }
protected void Grid_HostBed_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { if (Grid_HostList.SelectedValue != null && Grid_HostRoom.SelectedValue != null) { var cHomestayHosBed = new CHomestayHostBasic(); int hostid = Convert.ToInt32(Grid_HostList.SelectedValue.ToString()); int roomid = Convert.ToInt32(Grid_HostRoom.SelectedValue.ToString()); HomestayStudentBasic Student = StudentRequest(HomestayStudentId); Grid_HostBed.DataSource = cHomestayHosBed.HomestayBedListWithVacantBed(hostid, roomid, Convert.ToDateTime(Student.StartDate), Convert.ToDateTime(Student.EndDate)); // cHomestayHostBed.HomestayHostBedByRoom(hostid, roomid); Grid_HostBed.Visible = true; } }
protected void Grid_HostRoom_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { if (Grid_HostList.SelectedValue != null) { int hostId = 0; hostId = Convert.ToInt32(Grid_HostList.SelectedValue.ToString()); List <HomestayHostRoom> HostRoom = new List <HomestayHostRoom>(); var cHomestayHostRoom = new CHomestayHostBasic(); HomestayStudentBasic Student = StudentRequest(HomestayStudentId); HostRoom = cHomestayHostRoom.HomestayRoomListWithVacantBed(hostId, Convert.ToDateTime(Student.StartDate), Convert.ToDateTime(Student.EndDate)); //cHomestayHostRoom.GetHostRoomList(hostId); Grid_HostRoom.DataSource = HostRoom; } }
protected void GridHistory_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { if (Grid_StudentList.SelectedValue != null) { int userid = CurrentUserId; int StudentId = 0; int HomestayStudentId = Convert.ToInt32(Grid_StudentList.SelectedValue); var cHomestayStudent = new CHomestayStudentRequest(); HomestayStudentBasic Student = cHomestayStudent.GetHomestayStudentRequest(HomestayStudentId); StudentId = Convert.ToInt32(Student.StudentId); if (StudentId > 0) { GridHistory.DataSource = cHomestayStudent.GetHomestayStudentHistoryList(CurrentSiteLocationId, StudentId, HomestayStudentId); } } }
public bool UpdateHomestayStudentStatus(int HomestayStudentId, int Status) { //Requested=1, Placed by School=2, Placed by Agency =3, Canceled =6,Schedule Changed=5,Rejected 7 bool updateStatus = false; var cHomestayStudent = new CHomestayStudentRequest(); HomestayStudentBasic HS = cHomestayStudent.GetHomestayStudentRequest(HomestayStudentId); HS.HomestayStudentStatus = Status; HS.UpdateUserId = CurrentUserId; HS.UpdatedDate = DateTime.Now; if (Status == 2 || Status == 3) { HS.PlacedUserId = CurrentUserId; HS.PlacedDate = DateTime.Now; } updateStatus = cHomestayStudent.Update(HS); return(updateStatus); }
protected void ShowPlacementRequestDetail(int HomestayStudentId) { var cHomestayStudentBasic = new CHomestayStudentRequest(); HomestayStudentBasic Student = cHomestayStudentBasic.GetHomestayStudentRequest(HomestayStudentId); //Airpot Information ddl_pickup.SelectedValue = Student.PickUp.ToString(); DatePickArrivalDate.SelectedDate = Student.ArrivalDate; TimePickerArrivalTime.SelectedTime = Student.ArriveTime; txtArrivalAirLine.Text = Student.ArrivalAirLine; txtArrivalFlilghtNo.Text = Student.ArrivalFlightNo; txtDepartingFrom.Text = Student.DepartingFrom; ddlDropoff.SelectedValue = Student.DropOff.ToString(); DatePicker_DepartureDate.SelectedDate = Student.DepartureDate; TimePickerDepartureTime.SelectedTime = Student.DepartureTime; txtDepartureAirline.Text = Student.DepartureAirLine; txtDepartureFlightNo.Text = Student.DepartureFlightNo; txtLeavingFrom.Text = Student.LeavingFrom; //Preference ddlSmoking.SelectedValue = Student.Smoking.ToString(); ddlInternet.SelectedValue = Student.Internet.ToString(); ddlRoomType.SelectedValue = Student.RoomType.ToString(); ddlMealType.SelectedValue = Student.MealType.ToString(); ddlGuardian.SelectedValue = Student.GuardianRequired.ToString(); ddlPet.SelectedValue = Student.Pet.ToString(); ddlChildren.SelectedValue = Student.Children.ToString(); txtMedication.Text = Student.Medication; txtDiet.Text = Student.Diet; //General Information DatePickerStartDate.SelectedDate = Student.StartDate; DatePickerEndDate.SelectedDate = Student.EndDate; ddlExtention.SelectedValue = Student.ExtensionFlag.ToString(); int Weeks = Convert.ToInt32(Student.HomestayWeeks); int ExtraDay = Convert.ToInt32(Student.ExtraDays); if (Weeks == 0) { TxtHomestayWeeks.Text = ""; } else { TxtHomestayWeeks.Text = Weeks.ToString(); } if (ExtraDay == 0) { TxtExtraDays.Text = ""; } else { TxtExtraDays.Text = ExtraDay.ToString(); } if (ExtraDay == 7) { Weeks = Weeks + 1; TxtHomestayWeeks.Text = Weeks.ToString(); TxtExtraDays.Text = "0"; } ddlUrgent.SelectedValue = Student.UrgentRequest.ToString(); ddlAllergy.SelectedValue = Student.AllergyType.ToString(); txtAllergyType.Text = Student.AllergyNote; txtComments.Text = Student.Comments; //File Upload file_upload.GetFileDownload(Convert.ToInt32(HomestayStudentId)); Dropdown_StudentlList(Convert.ToInt32(Student.StudentId)); // Load Student List }
protected void UpdateToolBar_ButtonClick(object sender, Telerik.Web.UI.RadToolBarEventArgs e) { if (HomestayStudentId > 0) { int Status = 0; switch (e.Item.Text) { case "Accepted": Status = 1; //Accepted break; case "Cancelled:": Status = 0; //Cancelled break; case "Rejected": Status = 3; //Rejected break; default: Status = 0; break; } if (e.Item.Text != "Close Window") { HomestayStudentBasic Request = StudentRequest(HomestayStudentId); int StudentId = Convert.ToInt32(Request.StudentId); int AddResult = 0; var cHomestayPlacement = new CHomestayPlacement(); HomestayPlacement Placement = new HomestayPlacement(); Placement.StudentBasicId = HomestayStudentId; Placement.StudentId = StudentId; Placement.HostId = 0; Placement.RoomId = 0; Placement.BedId = 0; Placement.HomestayAgencyId = 0; Placement.StartDate = Request.StartDate; Placement.EndDate = Request.EndDate; Placement.PlacementStatus = Status; // Accepted=1, Canceled =0, Rejected:3, Schedule Change=2 Placement.PlacementComment = txt_Comment.Text; Placement.PlacementType = 2; // Placed by School=1, Place by Agency =2 Placement.CreatedDate = DateTime.Now; Placement.CreatedId = CurrentUserId; Placement.UpdatedDate = DateTime.Now; Placement.UpdatedId = CurrentUserId; Placement.HomestayAgencyId = CurrentUserId; file_upload.GetFileDownload(Convert.ToInt32(HomestayStudentId)); if (cHomestayPlacement.CountPlacementbyBasicId(HomestayStudentId) == 0) { AddResult = cHomestayPlacement.Add(Placement); } else { HomestayPlacement UpdatePlacement = cHomestayPlacement.GetByStudentBasicId(HomestayStudentId); UpdatePlacement.PlacementStatus = Status; UpdatePlacement.PlacementComment = txt_Comment.Text; UpdatePlacement.UpdatedDate = DateTime.Now; UpdatePlacement.UpdatedId = CurrentUserId; cHomestayPlacement.Update(UpdatePlacement); } file_upload.SaveFile(HomestayStudentId); // in HomestayBasic table int BasicStatus = 0; switch (Status) { case 0: BasicStatus = 6; // Cancelled by Agency break; case 1: BasicStatus = 3; //Placed By Agency break; case 3: BasicStatus = 7; //Rejected by Agency break; default: break; } UpdateHomestayStudentStatus(HomestayStudentId, BasicStatus); RunClientScript("Close();"); ShowMessage("Homestay Placement Request has been updated successfully."); } } }
protected void UpdateStudentRegistar() { if (Request["id"] != null) { int HomestayStudentId = Id; var cHomestayStudentRequest = new CHomestayStudentRequest(); if (ScheduleChange == 0) { if (HomestayStudentId == 0) //New Registrar { int AddResult = 0; HomestayStudentBasic Student = new HomestayStudentBasic(); //Retrive Data from Form Student = GetFormData(Student); //Homestay Status Student.HomestayStudentStatus = 0; //Pending=0, Requested=1, Placed by School=2, Placed by Agency =3, Canceled =4 Student.CreatedDate = DateTime.Now; Student.CreatedUserId = CurrentUserId; AddResult = cHomestayStudentRequest.Add(Student); if (AddResult > 0) { file_upload.SaveFile(AddResult); // GenerateInvoice(AddResult, (int)CConstValue.InvoiceType.Homestay); RunClientScript("Close();"); ShowMessage("Added a new homestay registar and Generated an invoice successfully."); } else //Failed { ShowMessage("Failed to add a new homestay registar, Please try it again."); } } else //Update Registrar { bool UpdateResult = false; HomestayStudentBasic UpdateStudent = cHomestayStudentRequest.GetHomestayStudentRequest(HomestayStudentId); // Retrive Data from From UpdateStudent = GetFormData(UpdateStudent); UpdateStudent.HomestayStudentStatus = 1; //Requested UpdateStudent.UpdateUserId = CurrentUserId; UpdateStudent.UpdatedDate = DateTime.Now; UpdateResult = cHomestayStudentRequest.Update(UpdateStudent); int InvoiceId = 0; var cInvoice = new CInvoice(); InvoiceId = cInvoice.GetInvoiceIdbyHomestayStudentId(HomestayStudentId); if (InvoiceId == 0) { GenerateInvoice(HomestayStudentId, (int)CConstValue.InvoiceType.Homestay); //Generate Invoice } file_upload.SaveFile(UpdateStudent.HomestayStudentId); if (UpdateResult) { RunClientScript("Close();"); ShowMessage("Requested Homestay Registar successfully."); } else //Failed { ShowMessage("Failed to update Homestay Registrar, please try it again."); } } } else //Schedule Change: New Homestay Replacement Request { //int SCResult = 0; //HomestayStudentBasic StudentBasic = new HomestayStudentBasic(); ////Retrive Data from Form //StudentBasic = GetFormData(StudentBasic); ////Homestay Status //StudentBasic.HomestayStudentStatus = 1; //Requested=1, Placed by School=2, Placed by Agency =3, Canceled =4, Schedule Change=5 //StudentBasic.CreatedDate = DateTime.Now; //StudentBasic.CreatedUserId = CurrentUserId; //SCResult = cHomestayStudentRequest.Add(StudentBasic); //if (SCResult > 0) //{ // file_upload.SaveFile(SCResult); // GenerateInvoice(SCResult, 16); // var cHomestayCancleSheduleChange = new CHomestayCancelSheduleChange(); // HomestayCancelScheduleChange Cancel = new HomestayCancelScheduleChange(); // Cancel.CancellationDate = DateTime.MaxValue; // Cancel.Comment = txtScheduleComment.Text; // Cancel.ChangeType = 2; // 1=Cancel, 2=Schedule Change // Cancel.OriginalStudentBasicId = Convert.ToInt32(Request["Id"]); // Cancel.NewStudentBasicId = SCResult; // Cancel.RequestStatus = 0; //0=Pending, 1=Rejected, 2=Approved // Cancel.CreatedDate = DateTime.Now; // Cancel.CreatedId = CurrentUserId; // Cancel.UpdatedDate = DateTime.Now; // Cancel.UpdatedId = CurrentUserId; // int result = 0; // result = cHomestayCancleSheduleChange.Add(Cancel); // Grid_ChangeList.Rebind(); // ShowMessage("Homestay Schedule Change are added and Generated an invoice successfully."); //} //else //Failed //{ // ShowMessage("Failed to Add Schedule Change, Please try it again."); //} //Wait for Jun's Schedule Change Invoice Function //Update Student Request Status: Schedule Change //Release Homestay Placement (Host Bed) } } }