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)
}
}
}
