/// <summary>
/// Create new travel request
/// </summary>
/// <param name="request">Object containing all necessary values to create travel request</param>
/// <returns></returns>
public int ADD_TravelRequest(TRV_Request request, int Vessel_ID, int ReqID = 0, string Change_Remark = "")
{
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["smsconn"].ConnectionString);
try
{
SqlParameter pramaout = new SqlParameter("@ReqID", ReqID);
pramaout.Direction = ParameterDirection.InputOutput;
SqlParameter[] pList = { new SqlParameter("@Staff_ID", request.StaffID),
new SqlParameter("@Travel_Origin", request.Travel_Origin),
new SqlParameter("@Travel_Destination", request.Travel_Destination),
new SqlParameter("@Departure_Date", request.Departure_Date),
new SqlParameter("@Return_Date", request.Return_Date),
new SqlParameter("@Preferred_Departure_Time", request.Preferred_Departure_Time),
new SqlParameter("@Preferred_Airline", request.Preferred_Airline),
new SqlParameter("@Travel_Class", request.Travel_Class),
new SqlParameter("@Travel_Type", request.Travel_Type),
new SqlParameter("@Is_Seaman_Ticket", request.Is_Seaman_Ticket),
new SqlParameter("@isPersonal_Ticket", request.isPersonal_Ticket),
new SqlParameter("@Remarks", request.Remarks),
new SqlParameter("@userid", request.Created_By),
new SqlParameter("@Vessel_ID", Vessel_ID),
new SqlParameter("@PrefDepHrs", request.PrefDepHrs),
new SqlParameter("@PrefDepMin", request.PrefDepMin),
new SqlParameter("@Change_Remark", Change_Remark),
pramaout };
SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "CRW_TRV_SP_ADD_TravelRequest", pList);
return(Convert.ToInt32(pramaout.Value));
}
catch { throw; }
finally { conn.Close(); }
}
/// <summary>
/// Create a new travel request
/// </summary>
/// <param name="newRequest">object as new request with all properties set</param>
/// <returns>New created request id</returns>
public int CreateTravelRequest(TRV_Request newRequest, int Vessel_ID = 0, int ReqID = 0, string Change_Remark = "")
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.ADD_TravelRequest(newRequest, Vessel_ID, ReqID, Change_Remark)); }
catch { throw; }
}
/// <summary>
/// Add Flights to the existing request
/// </summary>
/// <param name="RequestID">Existing request id</param>
/// <param name="FlightDetail">object wrapped in trv_request class</param>
/// <returns>true on success, false otherwise</returns>
public Boolean AddFlightToTravelRequest(int RequestID, TRV_Request FlightDetail)
{
DAL_TRV_Request TRequest = new DAL_TRV_Request();
try { return(TRequest.ADD_FLIGHT_TO_TravelRequest(RequestID, FlightDetail)); }
catch { throw; }
}
/// <summary>
/// Add Flight in Request
/// </summary>
/// <param name="RequestID">Request ID</param>
/// <param name="request">Request object, which contains the flight details in it</param>
/// <returns></returns>
public Boolean ADD_FLIGHT_TO_TravelRequest(int RequestID, TRV_Request request)
{
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["smsconn"].ConnectionString);
try
{
SqlParameter[] pList = { new SqlParameter("@RequestID", RequestID),
new SqlParameter("@Travel_Origin", request.Travel_Origin),
new SqlParameter("@Travel_Destination", request.Travel_Destination),
new SqlParameter("@Departure_Date", request.Departure_Date),
new SqlParameter("@Return_Date", request.Return_Date),
new SqlParameter("@Preferred_Departure_Time", request.Preferred_Departure_Time),
new SqlParameter("@Preferred_Airline", request.Preferred_Airline),
new SqlParameter("@Travel_Class", request.Travel_Class),
new SqlParameter("@isPersonal_Ticket", request.isPersonal_Ticket),
new SqlParameter("@userid", request.Created_By),
new SqlParameter("@PrefDephours", request.PrefDepHrs),
new SqlParameter("@PrefDepmins", request.PrefDepMin) };
SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "CRW_TRV_SP_ADD_FlightInTravelRequest", pList);
return(true);
}
catch { throw; }
}
protected void cmdSaveRequest_Click(object sender, EventArgs e)
{
if (UDFLib.ConvertToInteger(Vessel_List.SelectedValue) > 0)
{
if (!string.IsNullOrEmpty(Request.QueryString["Request_ID"]))
{
CheckForChangesInRequest();
}
string isReturn;
int CreatedBy, isSeaman;
int VoyageID = UDFLib.ConvertToInteger(Request.QueryString["VoyageID"]);
int EventID = UDFLib.ConvertToInteger(Request.QueryString["EventID"]);
if (chkSeaman.Checked)
{
isSeaman = 1;
}
else
{
isSeaman = 0;
}
if (chkReturn.Checked)
{
isReturn = "RETURN";
}
else
{
isReturn = "ONEWAY";
}
DataTable dtPax = (DataTable)ViewState["DataTable"];
if (dtPax.Rows.Count > 0)
{
BLL_TRV_TravelRequest TReq = new BLL_TRV_TravelRequest();
TRV_Request ReqProperties = new TRV_Request();
try
{
int i, requestid = 0; Boolean Issavingpax = true;
CreatedBy = Convert.ToInt32(Session["USERID"].ToString());
foreach (GridViewRow gr in GrdFlight.Rows)
{
UserControl_ctlAirPortList txtFrom1 = (gr.FindControl("txtFrom1") as UserControl_ctlAirPortList);
UserControl_ctlAirPortList txtTo1 = (gr.FindControl("txtTo1") as UserControl_ctlAirPortList);
TextBox txtDepDate1 = (gr.FindControl("txtDepDate1") as TextBox);
DropDownList cmbDepHours1 = (gr.FindControl("cmbDepHours1") as DropDownList);
DropDownList cmbDepMins1 = (gr.FindControl("cmbDepMins1") as DropDownList);
if (string.IsNullOrEmpty(txtFrom1.Text))
{
string js = "alert('Please select from !');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "txtFrom1", js, true);
return;
}
if (string.IsNullOrEmpty(txtTo1.Text))
{
string js = "alert('Please select To !');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "txtTo1", js, true);
return;
}
if (txtFrom1.Text.Trim() != "" && txtTo1.Text.Trim() != "" && Issavingpax) // save pax and first segment
{
Issavingpax = false;
for (i = 0; i < dtPax.Rows.Count; i++)
{
//to add all pax to the request after the default one, i.e. first / lead pax
if (i == 0)
{
StringBuilder sbMainChanges_Remark = new StringBuilder("");
if (Changes_Remark.ToString() != "")
{
sbMainChanges_Remark.Append("<div style='font-size:11px;font-family:Tahoma'>");
sbMainChanges_Remark.Append(Changes_Remark.ToString());
sbMainChanges_Remark.Append("</div>");
}
ReqProperties.StaffID = Convert.ToInt32(dtPax.Rows[i]["id"].ToString());
ReqProperties.Travel_Class = cmbTravelClass.SelectedValue;
ReqProperties.Is_Seaman_Ticket = isSeaman;
ReqProperties.Travel_Type = isReturn;
ReqProperties.isPersonal_Ticket = 0;
ReqProperties.Travel_Origin = txtFrom1.Text;
ReqProperties.Departure_Date = txtDepDate1.Text;
ReqProperties.Travel_Destination = txtTo1.Text;
//ReqProperties.Return_Date = txtArrDate1.Text;
//ReqProperties.Preferred_Airline = txtPrefAirline1.Text;
//ReqProperties.Preferred_Departure_Time = txtPrefTime1.Text;
ReqProperties.Created_By = CreatedBy;
ReqProperties.Remarks = txtRequestRemarks.Text;
ReqProperties.PrefDepMin = cmbDepMins1.SelectedItem.Text;
ReqProperties.PrefDepHrs = cmbDepHours1.SelectedItem.Text;
requestid = TReq.CreateTravelRequest(ReqProperties, UDFLib.ConvertToInteger(Vessel_List.SelectedValue), UDFLib.ConvertToInteger(Request.QueryString["Request_ID"])
, sbMainChanges_Remark.ToString());
}
else
{
TReq.AddPaxToTravelRequest(requestid, Convert.ToInt32(dtPax.Rows[i]["id"].ToString()), CreatedBy, VoyageID, EventID);
}
}
}
else if (txtFrom1.Text.Trim() != "" && txtTo1.Text.Trim() != "") //ADDING from SECOND segment DETAIL IF VALID
{
ReqProperties.Travel_Class = cmbTravelClass.SelectedValue;
ReqProperties.Is_Seaman_Ticket = isSeaman;
ReqProperties.Travel_Type = isReturn;
ReqProperties.isPersonal_Ticket = 0;
ReqProperties.Travel_Origin = txtFrom1.Text;
ReqProperties.Departure_Date = txtDepDate1.Text;
ReqProperties.Travel_Destination = txtTo1.Text;
//ReqProperties.Return_Date = txtArrDate2.Text;
//ReqProperties.Preferred_Airline = txtPrefAirline2.Text;
//ReqProperties.Preferred_Departure_Time = txtPrefTime2.Text;
ReqProperties.Created_By = CreatedBy;
ReqProperties.Remarks = txtRequestRemarks.Text;
ReqProperties.PrefDepMin = cmbDepMins1.SelectedItem.Text;
ReqProperties.PrefDepHrs = cmbDepHours1.SelectedItem.Text;
//ONLY LEADPAX DETAIL HAS TO BE SAVED
ReqProperties.StaffID = Convert.ToInt32(dtPax.Rows[0]["id"].ToString());
TReq.AddFlightToTravelRequest(requestid, ReqProperties);
}
}
if (!string.IsNullOrEmpty(Request.QueryString["Request_ID"]))
{
string js = "window.opener.location.href='RequestList.aspx';window.open('','_self');window.close();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg2", js, true);
}
else
{
Response.Redirect("RequestList.aspx");
}
}
catch { throw; }
finally { TReq = null; ReqProperties = null; }
}
else
{
string msgPax = "alert('Add at least 1 Pax !');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "msgPax", msgPax, true);
}
}
else
{
string js = "alert('Please select vessel !');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "msgvsl", js, true);
}
}
