protected void ShowPlacementRequestDetail(int DormitoryRegistrationId) { var cHomestayStudentBasic = new CDormitoryRegistrations(); DormitoryRegistration Student = cHomestayStudentBasic.GetDormitoryStudentRequest(DormitoryRegistrationId); //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; //General Information DatePickerStartDate.SelectedDate = Student.StartDate; DatePickerEndDate.SelectedDate = Student.EndDate; ddlExtention.SelectedValue = Student.ExtensionFlag.ToString(); int Weeks = Convert.ToInt32(Student.DormitoryWeeks); 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(); txtComments.Text = Student.Comments; //File Upload file_upload.GetFileDownload(Convert.ToInt32(DormitoryRegistrationId)); Dropdown_StudentlList(Convert.ToInt32(Student.StudentId)); // Load Student List }
protected DormitoryRegistration StudentRequest(int DormitoryRegistrationId) { var cDormitoryStudentRequest = new CDormitoryRegistrations(); DormitoryRegistration Student = cDormitoryStudentRequest.GetDormitoryStudentRequest(DormitoryRegistrationId); return(Student); }
protected void UpdateToolBar_ButtonClick(object sender, Telerik.Web.UI.RadToolBarEventArgs e) { if (DormitoryRegistrationId > 0) { if (UpdateToolBar.TabIndex == 0) { DormitoryRegistration Request = StudentRequest(DormitoryRegistrationId); 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); //Dormitory Placement int AddResult = 0; var cDormitoryPlacement = new CDormitoryPlacement(); DormitoryPlacement Placement = new DormitoryPlacement(); Placement.StudentBasicId = DormitoryRegistrationId; Placement.StudentId = StudentId; Placement.HostId = HostId; Placement.RoomId = RoomId; Placement.BedId = BedId; Placement.DormitoryAgencyId = 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 = cDormitoryPlacement.Add(Placement); if (AddResult > 0) { var cRequest = new CDormitoryRegistrations(); UpdateDormitoryStudentStatus(DormitoryRegistrationId, 2); //Placed By School RunClientScript("Close();"); ShowMessage("Dormitory Placement Request has been placed successfully."); } else //Failed { ShowMessage("Failed to add Dormitory Placement Request, Please try it again."); } } } } } } }
protected int GetStudentId(int DormitoryRegistrationId) { int StudentId = 0; if (DormitoryRegistrationId > 0) { var cDormitoryStudent = new CDormitoryRegistrations(); DormitoryRegistration StudentBasic = cDormitoryStudent.GetDormitoryStudentRequest(DormitoryRegistrationId); StudentId = Convert.ToInt32(StudentBasic.StudentId); } return(StudentId); }
protected void FillFormData(int DormitoryRegistrationId) { int type = Convert.ToInt32(Request["StudentId"].ToString()); // 0: New, 1000000:Schedule Change var cDormitoryStudentBasic = new CDormitoryRegistrations(); DormitoryRegistration Student = cDormitoryStudentBasic.GetDormitoryStudentRequest(DormitoryRegistrationId); //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; //General Information DatePickerStartDate.SelectedDate = Student.StartDate; DatePickerEndDate.SelectedDate = Student.EndDate; ddlExtention.SelectedValue = Student.ExtensionFlag.ToString(); int Weeks = Convert.ToInt32(Student.DormitoryWeeks); int ExtraDay = Convert.ToInt32(Student.ExtraDays); if (Weeks == 0) { TxtDormitoryWeeks.Text = ""; } else { TxtDormitoryWeeks.Text = Weeks.ToString(); } if (ExtraDay == 0) { TxtExtraDays.Text = ""; } else { TxtExtraDays.Text = ExtraDay.ToString(); } ddlUrgent.SelectedValue = Student.UrgentRequest.ToString(); txtComments.Text = Student.Comments; //File Upload file_upload.GetFileDownload(Convert.ToInt32(DormitoryRegistrationId)); ddlStudent.Enabled = false; }
protected void Grid_HostList_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { if (DormitoryRegistrationId > 0) { DormitoryRegistration Student = StudentRequest(DormitoryRegistrationId); DateTime StartDate = Convert.ToDateTime(Student.StartDate); DateTime EndDate = Convert.ToDateTime(Student.EndDate); var cDormitoryBasic = new CDormitoryRegistrations(); Grid_HostList.DataSource = cDormitoryBasic.DormitoryHostListWithVacantBed(CurrentSiteLocationId, StartDate, EndDate); //cDormitoryBasic.GetDormitoryHostActiveList(CurrentSiteLocationId, StartDate,EndDate); } }
protected void Grid_HostBed_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { if (Grid_HostList.SelectedValue != null && Grid_HostRoom.SelectedValue != null) { var cDormitoryHostBed = new CDormitoryRegistrations(); int hostid = Convert.ToInt32(Grid_HostList.SelectedValue.ToString()); int roomid = Convert.ToInt32(Grid_HostRoom.SelectedValue.ToString()); DormitoryRegistration Student = StudentRequest(DormitoryRegistrationId); Grid_HostBed.DataSource = cDormitoryHostBed.DormitoryBedListWithVacantBed(hostid, roomid, Convert.ToDateTime(Student.StartDate), Convert.ToDateTime(Student.EndDate)); 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 <DormitoryHostRoom> HostRoom = new List <DormitoryHostRoom>(); var cDormitoryHostRoom = new CDormitoryRegistrations(); DormitoryRegistration Student = StudentRequest(DormitoryRegistrationId); HostRoom = cDormitoryHostRoom.DormitoryRoomListWithVacantBed(hostId, Convert.ToDateTime(Student.StartDate), Convert.ToDateTime(Student.EndDate)); Grid_HostRoom.DataSource = HostRoom; } }
protected void GridHistory_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { if (Grid_StudentList.SelectedValue != null) { int userid = CurrentUserId; int StudentId = 0; int DormitoryRegistrationId = Convert.ToInt32(Grid_StudentList.SelectedValue); var cDormitoryStudent = new CDormitoryRegistrations(); DormitoryRegistration Student = cDormitoryStudent.GetDormitoryStudentRequest(DormitoryRegistrationId); StudentId = Convert.ToInt32(Student.StudentId); if (StudentId > 0) { GridHistory.DataSource = cDormitoryStudent.GetDormitoryStudentHistoryList(CurrentSiteLocationId, StudentId, DormitoryRegistrationId); } } }
protected DormitoryRegistration GetFormData(DormitoryRegistration 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(); //General Information Student.StartDate = DatePickerStartDate.SelectedDate; Student.EndDate = DatePickerEndDate.SelectedDate; Student.ExtensionFlag = Convert.ToInt32(ddlExtention.SelectedValue.ToString()); int Weeks = 0; int ExtraDay = 0; if (TxtDormitoryWeeks.Text.ToString().Trim().Length > 0) { Weeks = Convert.ToInt32(TxtDormitoryWeeks.Text.ToString()); } if (TxtExtraDays.Text.ToString().Length > 0) { ExtraDay = Convert.ToInt32(TxtExtraDays.Text.ToString()); } Student.DormitoryWeeks = Weeks; Student.ExtraDays = ExtraDay; Student.UrgentRequest = Convert.ToInt32(ddlUrgent.SelectedValue.ToString()); Student.Comments = txtComments.Text; Student.PlacedUserId = 0; Student.StudentId = Convert.ToInt32(ddlStudent.SelectedValue); return(Student); }
public bool UpdateDormitoryStudentStatus(int DormitoryRegistrationId, int Status) { //Requested=1, Placed by School=2, Placed by Agency =3, Canceled =4,Schedule Changed=5 bool updateStatus = false; var cDormitoryStudent = new CDormitoryRegistrations(); DormitoryRegistration HS = cDormitoryStudent.GetDormitoryStudentRequest(DormitoryRegistrationId); HS.DormitoryStudentStatus = Status; HS.UpdatedId = CurrentUserId; HS.UpdatedDate = DateTime.Now; if (Status == 2 || Status == 3) { HS.PlacedUserId = CurrentUserId; HS.PlacedDate = DateTime.Now; } updateStatus = cDormitoryStudent.Update(HS); return(updateStatus); }
protected void UpdateStudentRegistar() { if (Request["id"] != null) { int DormitoryRegistrationId = Id; var cDormitoryStudentRequest = new CDormitoryRegistrations(); if (ScheduleChange == 0) { if (DormitoryRegistrationId == 0) //New Registrar { int AddResult = 0; DormitoryRegistration Student = new DormitoryRegistration(); //Retrive Data from Form Student = GetFormData(Student); //Dormitory Status Student.DormitoryStudentStatus = 1; //Requested=1, Placed by School=2, Placed by Agency =3, Canceled =4 Student.CreatedDate = DateTime.Now; Student.CreatedId = CurrentUserId; AddResult = cDormitoryStudentRequest.Add(Student); if (AddResult > 0) { file_upload.SaveFile(AddResult); GenerateInvoice(AddResult, (int)CConstValue.InvoiceType.Dormitory); RunClientScript("Close();"); } else //Failed { ShowMessage("Failed to add a new dormitory registar, Please try it again."); } } else //Update Registrar { bool UpdateResult = false; DormitoryRegistration UpdateStudent = cDormitoryStudentRequest.GetDormitoryStudentRequest(DormitoryRegistrationId); // Retrive Data from From UpdateStudent = GetFormData(UpdateStudent); UpdateStudent.UpdatedId = CurrentUserId; UpdateStudent.UpdatedDate = DateTime.Now; UpdateResult = cDormitoryStudentRequest.Update(UpdateStudent); file_upload.SaveFile(UpdateStudent.DormitoryRegistrationId); if (UpdateResult) { RunClientScript("Close();"); ShowMessage("Updated Dormitory Registration successfully."); } else //Failed { ShowMessage("Failed to update Dormitory Registration, please try it again."); } } } else //Schedule Change: New Dormitory Replacement Request { int SCResult = 0; DormitoryRegistration StudentBasic = new DormitoryRegistration(); //Retrive Data from Form StudentBasic = GetFormData(StudentBasic); //Homestay Status StudentBasic.DormitoryStudentStatus = 1; //Requested=1, Placed by School=2, Placed by Agency =3, Canceled =4, Schedule Change=5 StudentBasic.CreatedDate = DateTime.Now; StudentBasic.CreatedId = CurrentUserId; SCResult = cDormitoryStudentRequest.Add(StudentBasic); if (SCResult > 0) { file_upload.SaveFile(SCResult); GenerateInvoice(SCResult, 14);// ScheduleChange Grid_ChangeList.Rebind(); RunClientScript("Close();"); ShowMessage("Dormitory 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 Dormitory Placement (Host Bed) } } }