public RequestRemarks CancelRequest(PostRequest cancelRequest)
{
var objReturn = new RequestRemarks();
if (IsRandomCodeValid(cancelRequest.trip_id, cancelRequest.random))
{
var eecEmployee = new EECEmployee();
var employeeInfo = eecEmployee.SearchOnDirectory(cancelRequest.emp_id);
var info = employeeInfo.Count != 0 ? employeeInfo[0] : null;
using (var con = new MySqlConnection(ConnectionHelper.ServicesConnection()))
{
con.Open();
var cmd = new MySqlCommand("DELETE FROM seat WHERE random=@random AND trip_id=@trip_id", con);
cmd.Parameters.AddWithValue("@trip_id", cancelRequest.trip_id);
cmd.Parameters.AddWithValue("@random", cancelRequest.random);
if (cmd.ExecuteNonQuery() > 0)
{
objReturn = new RequestRemarks
{
remarks = "You have cancelled your reserved seat!",
subject = "Cancelled"
};
AppendLog(info.e_Mail.Split('@')[0], " cancelled ", cancelRequest.trip_id + " reservation");
}
}
}
else
{
objReturn = new RequestRemarks
{
remarks = "Trip not found.",
subject = "Notice"
};
}
return(objReturn);
}
public RequestRemarks CreateUpdateRequest(PostRequest newRequest)
{
var objReturn = new RequestRemarks();
var eecEmployee = new EECEmployee();
var employeeInfo = eecEmployee.SearchOnDirectory(newRequest.emp_id);
var info = employeeInfo.Count != 0 ? employeeInfo[0] : null;
if (info != null)
{
if (IsTripValid(newRequest.trip_id))
{
if (newRequest.seat_no >= 0 && newRequest.seat_no <= 6)
{
if (!IsSeatAvailable(newRequest.trip_id, newRequest.seat_no))
{
objReturn = new RequestRemarks
{
remarks = "Seat selected is no longer available!",
subject = "Already Taken"
};
}
else
{
if (IsUpdateSeat(info.emp_ID, newRequest.trip_id, newRequest.seat_no))
{
if (IsRandomCodeValid(newRequest.trip_id, newRequest.random))
{
using (var con = new MySqlConnection(ConnectionHelper.ServicesConnection()))
{
con.Open();
var cmd = new MySqlCommand("UPDATE seat SET seat=@seat,date_submit=@date_submit WHERE pax_id=@pax_id AND trip_id=@trip_id", con);
cmd.Parameters.AddWithValue("@seat", newRequest.seat_no);
cmd.Parameters.AddWithValue("@date_submit", DateTime.Now);
cmd.Parameters.AddWithValue("@trip_id", newRequest.trip_id);
cmd.Parameters.AddWithValue("@pax_id", info.emp_ID);
if (cmd.ExecuteNonQuery() > 0)
{
objReturn = new RequestRemarks
{
remarks = "You have updated your reserved seat!",
subject = "Updated"
};
AppendLog(info.e_Mail.Split('@')[0], " updated to " + newRequest.seat_no + " on ", newRequest.trip_id);
}
}
}
else
{
objReturn = new RequestRemarks
{
remarks = "Trip not found.",
subject = "Notice"
};
}
}
else
{
var tripDetails = new TripDetails();
var details = tripDetails.GetTripDetails(newRequest.trip_id);
using (var con = new MySqlConnection(ConnectionHelper.ServicesConnection()))
{
con.Open();
var cmd = new MySqlCommand("INSERT INTO seat ( trip_id, trip, pax_name, gender, pax_email, pax_id, seat, cost_center, ip, date_submit, code, random) VALUES(@trip_id,@trip,@pax_name,@gender,@pax_email,@pax_id,@seat,@cost_center,@ip,@date_submit,@code,@random)", con);
cmd.Parameters.AddWithValue("@trip_id", newRequest.trip_id);
cmd.Parameters.AddWithValue("@trip", details.trip_date);
cmd.Parameters.AddWithValue("@pax_name", info.employee_Name_English);
cmd.Parameters.AddWithValue("@gender", info.gender);
cmd.Parameters.AddWithValue("@pax_email", info.e_Mail);
cmd.Parameters.AddWithValue("@pax_id", info.emp_ID);
cmd.Parameters.AddWithValue("@seat", newRequest.seat_no);
cmd.Parameters.AddWithValue("@cost_center", info.cost_Center);
cmd.Parameters.AddWithValue("@ip", "EEC Mobility");
cmd.Parameters.AddWithValue("@date_submit", DateTime.Now);
cmd.Parameters.AddWithValue("@code", 1);
cmd.Parameters.AddWithValue("@random", RandomizeHelper.GenerateRandomString());
if (cmd.ExecuteNonQuery() > 0)
{
objReturn = new RequestRemarks
{
remarks = "You have reserved a seat!",
subject = "Reserved"
};
AppendLog(info.e_Mail.Split('@')[0], " reserved " + newRequest.seat_no + " on ", newRequest.trip_id);
}
}
}
}
}
else
{
objReturn = new RequestRemarks
{
remarks = "Seat not found.",
subject = "Notice"
};
}
}
else
{
objReturn = new RequestRemarks
{
remarks = "Trip not found.",
subject = "Notice"
};
}
}
else
{
objReturn = new RequestRemarks
{
remarks = "Request should be initiated by an EEC Employee.",
subject = "Notice"
};
}
return(objReturn);
}