public HttpResponseMessage SubmitTravelRequest(SubmitTravelRequestData submitTravelRequestData)
{
HttpResponseMessage response = null;
try
{
var result = approvalService.SubmitTravelRequest(submitTravelRequestData);
response = Request.CreateResponse(HttpStatusCode.OK, result);
}
catch (Exception ex)
{
LogMessage.Log("SubmitTravelRequest :" + ex.Message);
response = Request.CreateResponse(HttpStatusCode.InternalServerError, "Travel request was not successfully submited. Please try again.");
}
return(response);
}
public bool SubmitTravelRequest(SubmitTravelRequestData submitTravelRequestData)
{
List <BadgeInfo> approvalOrderList = new List <BadgeInfo>();
approvalOrderList.Add(new BadgeInfo()
{
BadgeId = submitTravelRequestData.DepartmentHeadBadgeNumber, Name = submitTravelRequestData.DepartmentHeadName
});
approvalOrderList.Add(new BadgeInfo()
{
BadgeId = submitTravelRequestData.ExecutiveOfficerBadgeNumber, Name = submitTravelRequestData.ExecutiveOfficerName
});
approvalOrderList.Add(new BadgeInfo()
{
BadgeId = submitTravelRequestData.CEOForAPTABadgeNumber, Name = submitTravelRequestData.CEOForAPTAName
});
approvalOrderList.Add(new BadgeInfo()
{
BadgeId = submitTravelRequestData.CEOForInternationalBadgeNumber, Name = submitTravelRequestData.CEOForInternationalName
});
approvalOrderList.Add(new BadgeInfo()
{
BadgeId = submitTravelRequestData.TravelCoordinatorBadgeNumber, Name = submitTravelRequestData.TravelCoordinatorName
});
try
{
dbConn = ConnectionFactory.GetOpenDefaultConnection();
int count = 1;
foreach (var item in approvalOrderList)
{
if (!string.IsNullOrEmpty(item.BadgeId))
{
// submit to approval
OracleCommand cmd = new OracleCommand();
cmd.Connection = (OracleConnection)dbConn;
cmd.CommandText = @"INSERT INTO TRAVELREQUEST_APPROVAL (
TRAVELREQUESTID,
BADGENUMBER,
APPROVERNAME,
APPROVALSTATUS,
APPROVALORDER
)
VALUES
(:p1,:p2,:p3,:p4,:p5)";
cmd.Parameters.Add(new OracleParameter("p1", submitTravelRequestData.TravelRequestId));
cmd.Parameters.Add(new OracleParameter("p2", item.BadgeId));
cmd.Parameters.Add(new OracleParameter("p3", item.Name));
cmd.Parameters.Add(new OracleParameter("p4", Common.ApprovalStatus.Pending.ToString()));
cmd.Parameters.Add(new OracleParameter("p5", count));
var rowsUpdated = cmd.ExecuteNonQuery();
cmd.Dispose();
count++;
}
}
OracleCommand cmd1 = new OracleCommand();
cmd1.Connection = (OracleConnection)dbConn;
cmd1.CommandText = string.Format(@"UPDATE TRAVELREQUEST SET
SUBMITTEDBYUSERNAME = :p1 ,
SUBMITTEDDATETIME = :p2,
STATUS = :p3,
AGREE = :p4
WHERE TRAVELREQUESTID = {0}", submitTravelRequestData.TravelRequestId);
cmd1.Parameters.Add(new OracleParameter("p1", submitTravelRequestData.SubmittedByUserName));
cmd1.Parameters.Add(new OracleParameter("p2", DateTime.Now));
cmd1.Parameters.Add(new OracleParameter("p3", Common.ApprovalStatus.Pending.ToString()));
cmd1.Parameters.Add(new OracleParameter("p4", (submitTravelRequestData.AgreedToTermsAndConditions) ? "Y" : "N"));
var rowsUpdated1 = cmd1.ExecuteNonQuery();
cmd1.Dispose();
dbConn.Close();
dbConn.Dispose();
string link = string.Format("<a href=\"http://*****:*****@"Travel Request Approval for Id - {0} ", submitTravelRequestData.TravelRequestId);
string body = string.Format(@"Please visit Travel application website " + link + " to Approve/Reject for travel request Id : {0} btnApprove ", submitTravelRequestData.TravelRequestId);
/* Requesttype -
* Form1 (TravelRequest)
* Form2 (Reimbursement) */
var dateTime = System.DateTime.Now.Ticks;
//Generate Crystal report
travelRequestReportService.RunReport("Travel_Request.rpt", "TravelRequest_" + submitTravelRequestData.TravelRequestId + "_" + dateTime, submitTravelRequestData.TravelRequestId.ToString());
// email with attachment
sendEmail(Convert.ToInt32(submitTravelRequestData.DepartmentHeadBadgeNumber), subject, submitTravelRequestData.TravelRequestId.ToString(), "Form1", "TravelRequest_" + submitTravelRequestData.TravelRequestId + "_" + dateTime);
return(true);
}
catch (Exception ex)
{
LogMessage.Log("Repository : SubmitTravelRequest : " + ex.Message);
throw new Exception(ex.Message);
}
}
public bool SubmitTravelRequest(SubmitTravelRequestData submitTravelRequestData)
{
var result = approvalRepository.SubmitTravelRequest(submitTravelRequestData);
return(result);
}
