public CLayer.B2BApprovers CheckBookingApproversExist(long userId, long BookingID)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pUserID", DataPlug.DataType._BigInt, userId));
param.Add(Connection.GetParameter("pBookingID", DataPlug.DataType._BigInt, BookingID));
DataTable dt = Connection.GetTable("CheckBookingApproversExists", param);
CLayer.B2BApprovers objResult = new CLayer.B2BApprovers();
if (dt != null && dt.Rows.Count > 0)
{
objResult.b2b_approver_id = Connection.ToLong(dt.Rows[0]["b2b_approver_id"]);
objResult.user_id = Connection.ToLong(dt.Rows[0]["userid"]);
objResult.approver_id = Connection.ToLong(dt.Rows[0]["b2b_approver_id"]);
objResult.approver_order = Connection.ToInteger(dt.Rows[0]["Approver_Order"]);
objResult.created_by = Connection.ToLong(dt.Rows[0]["b2b_approver_id"]);
// objResult.created_date = Connection.ToDate(dt.Rows[0]["created_date"]);
objResult.approver_email = Connection.ToString(dt.Rows[0]["approveremail"]);
objResult.approver_password = Connection.ToString(dt.Rows[0]["passwordhash"]);
objResult.username = Connection.ToString(dt.Rows[0]["UserName"]);
objResult.status = Connection.ToInteger(dt.Rows[0]["ApprovalStatus"]);
}
// return ids;
return(objResult);
}
public CLayer.B2BApprovers GetApproverUsers(long userId, long BookingID)
{
string sql = " SELECT b.userid,IFNULL(a.approver_id,0) AS b2b_approver_id,a.approver_order AS Approver_Order,IFNULL(ba.approval_status,0) AS ApprovalStatus,(SELECT CONCAT(Firstname,' ',lastname) FROM `user` WHERE userid=a.approver_id) AS UserName,(SELECT email FROM `user` WHERE userid=a.approver_id) AS approveremail,(SELECT passwordhash FROM `user` WHERE userid=a.approver_id) AS passwordhash " +
" FROM b2b_approvers a INNER JOIN USER b ON a.user_id=b.userid AND a.user_id=" + userId.ToString() + "" +
" LEFT JOIN booking_approvals ba ON ba.approver_id = a.approver_id AND ba.booking_id = " + BookingID.ToString() + " LIMIT 1";
//string sql = " SELECT b.userid,IFNULL(a.approver_id, 0) AS b2b_approver_id, a.approver_order AS Approver_Order,IFNULL(ba.approval_status, 0) AS ApprovalStatus,(SELECT CONCAT(Firstname, ' ', lastname) FROM `user` WHERE userid = a.approver_id) AS UserName,(SELECT email FROM `user` WHERE userid = a.approver_id) AS approveremail,(SELECT passwordhash FROM `user` WHERE userid = a.approver_id) AS passwordhash," +
// " b1.approvedstatus FROM b2b_approvers a" +
// " INNER JOIN USER b ON a.user_id = b.userid AND a.user_id = " + userId.ToString() + "" +
// " LEFT JOIN booking_approvals ba ON ba.approver_id = a.approver_id AND ba.booking_id = " + BookingID.ToString() + "" +
// " LEFT JOIN booking b1 ON ba.booking_id = b1.bookingid WHERE b1.approvedstatus != 2 LIMIT 1";
DataTable dt = Connection.GetSQLTable(sql);
CLayer.B2BApprovers objResult = new CLayer.B2BApprovers();
if (dt != null && dt.Rows.Count > 0)
{
objResult.b2b_approver_id = Connection.ToLong(dt.Rows[0]["b2b_approver_id"]);
objResult.user_id = Connection.ToLong(dt.Rows[0]["userid"]);
objResult.approver_id = Connection.ToLong(dt.Rows[0]["b2b_approver_id"]);
objResult.approver_order = Connection.ToInteger(dt.Rows[0]["Approver_Order"]);
objResult.created_by = Connection.ToLong(dt.Rows[0]["b2b_approver_id"]);
// objResult.created_date = Connection.ToDate(dt.Rows[0]["created_date"]);
objResult.approver_email = Connection.ToString(dt.Rows[0]["approveremail"]);
objResult.approver_password = Connection.ToString(dt.Rows[0]["passwordhash"]);
objResult.username = Connection.ToString(dt.Rows[0]["UserName"]);
objResult.status = Connection.ToInteger(dt.Rows[0]["ApprovalStatus"]);
}
return(objResult);
}
public ActionResult BookingConfirm(CLayer.B2BApprovers ApproverDetails)
{
string ApprovalRequest = "User " + ApproverDetails.username + " Requesting approval for travel to ________(city name) for ____ ";
ApprovalRequest += " Days and accommodation for nights";
ApprovalRequest += " @ Rs. per night.Total cost of stay – Rs..";
return(View());
}
public ActionResult BookingApprovalAlert(CLayer.B2BApprovers ApproverDetails)
{
try
{
string ApprovalRequest = "User " + ApproverDetails.username + " Requesting approval for travel to ________(city name) for ____ ";
ApprovalRequest += " Days and accommodation for nights";
ApprovalRequest += " @ Rs. per night.Total cost of stay – Rs..";
}
catch (Exception ex)
{
Common.LogHandler.AddLog(ex.Message);
}
return(View());
}
public ActionResult BookingApprovalMessage(CLayer.B2BApprovers ApproverDetails)
{
string ApprovalRequest = "This booking required approval from " + ApproverDetails.username + ".\r\nThanks for your patience in the mean time.";
return(View());
}
