public static bool RejectTransfer(DesktopSession cds, TransferVO transfer, out string errorCode, out string errorText)
{
if (transfer == null)
{
throw new ArgumentNullException("transfer");
}
//Initialize output vars
errorCode = string.Empty;
errorText = string.Empty;
OracleDataAccessor dA = GlobalDataAccessor.Instance.OracleDA;
//Create parameter list
List <OracleProcParam> oParams = new List <OracleProcParam>();
oParams.Add(new OracleProcParam("p_transfer_ticket_number", transfer.TransferTicketNumber));
oParams.Add(new OracleProcParam("p_store_number", cds.CurrentSiteId.StoreNumber));
oParams.Add(new OracleProcParam("p_user_id", cds.FullUserName));
oParams.Add(new OracleProcParam("p_origination_store_number", transfer.OriginalStoreNumber));
oParams.Add(new OracleProcParam("p_reject_reason", transfer.RejectReason));
oParams.Add(new OracleProcParam("p_status_date", ShopDateTime.Instance.ShopDate.FormatDate()));
oParams.Add(new OracleProcParam("p_status_time", ShopDateTime.Instance.ShopTransactionTime.ToString()));
oParams.Add(new OracleProcParam("p_carrier", transfer.Carrier));
oParams.Add(new OracleProcParam("p_ticket_type", transfer.TransferSource.ToString()));
//Make stored proc call
bool retVal;
DataSet outputDataSet;
try
{
retVal = GlobalDataAccessor.Instance.OracleDA.issueSqlStoredProcCommand("ccsowner",
"transfers", "reject_transfer", oParams, null, "o_return_code",
"o_return_text", out outputDataSet);
errorCode = dA.ErrorCode;
errorText = dA.ErrorDescription;
}
catch (OracleException oEx)
{
BasicExceptionHandler.Instance.AddException("Execute RejectTransfer Failed", oEx);
errorCode = "ExecuteRejectTransferFailed";
errorText = "OracleException thrown: " + oEx.Message;
return(false);
}
if (retVal == false)
{
BasicExceptionHandler.Instance.AddException("Execute RejectTransfer Failed: return value is false", new ApplicationException());
errorCode = dA.ErrorCode + " --- ExecuteRejectTransfer";
errorText = dA.ErrorDescription + " -- Return value is false";
return(false);
}
return(true);
}
private void PrintDetailRow(TransferVO vo, PdfPTable table, int row)
{
PdfPCell cell;
Font fontToUSE = _reportFont;
if (isBoldRow(vo.StatusDate))
{
fontToUSE = _reportFontBold;
}
cell = new PdfPCell(new Paragraph(row.ToString(), fontToUSE));
//cell.Border = Rectangle.NO_BORDER;
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
cell = new PdfPCell(new Paragraph(vo.StoreNickName, fontToUSE));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
cell = new PdfPCell(new Paragraph(vo.GetTransferTypeDescription(), fontToUSE));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
cell = new PdfPCell(new Paragraph(vo.GetTransferInStatusDescription(), fontToUSE));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
//For Rejected Transfers will be avail later
cell = new PdfPCell(new Paragraph("", fontToUSE));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
cell = new PdfPCell(new Paragraph(vo.TransferTicketNumber.ToString(), fontToUSE));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
cell = new PdfPCell(new Paragraph(vo.StatusDate.ToString("MM/dd/yyyy"), fontToUSE));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
cell = new PdfPCell(new Paragraph(vo.NumberOfItems.ToString(), fontToUSE));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
cell = new PdfPCell(new Paragraph(String.Format("{0:C}", vo.Amount), fontToUSE));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.VerticalAlignment = Element.ALIGN_TOP;
table.AddCell(cell);
}
public static bool GetTransferInItems(DesktopSession cds, TransferVO transfer, out string errorCode, out string errorText)
{
if (transfer == null)
{
throw new ArgumentNullException("transfer");
}
//Initialize output vars
errorCode = string.Empty;
errorText = string.Empty;
OracleDataAccessor dA = GlobalDataAccessor.Instance.OracleDA;
//Create parameter list
List <OracleProcParam> oParams = new List <OracleProcParam>();
oParams.Add(new OracleProcParam("p_ticket_number", transfer.TransferTicketNumber));
oParams.Add(new OracleProcParam("p_store_number", cds.CurrentSiteId.StoreNumber));
oParams.Add(new OracleProcParam("p_user_id", cds.FullUserName));
oParams.Add(new OracleProcParam("p_transfer_type", (transfer.TransferSource == TransferSource.TOPSTICKET && transfer.TempStatus == TransferTempStatus.REJCT) ? TransferSource.CLXTICKET.ToString() : transfer.TransferSource.ToString()));
oParams.Add(new OracleProcParam("p_origination_store_number", transfer.OriginalStoreNumber));
//Setup ref cursor array
List <PairType <string, string> > refCursors = new List <PairType <string, string> >();
//Add general ref cursors
refCursors.Add(new PairType <string, string>("o_ti_mdse", "ti_mdse_ref_cursor"));
//Make stored proc call
bool retVal;
DataSet outputDataSet;
try
{
retVal = GlobalDataAccessor.Instance.OracleDA.issueSqlStoredProcCommand("ccsowner",
"transfers", "retrieve_TI_ticket_mdse", oParams, refCursors, "o_return_code",
"o_return_text", out outputDataSet);
errorCode = dA.ErrorCode;
errorText = dA.ErrorDescription;
}
catch (OracleException oEx)
{
BasicExceptionHandler.Instance.AddException("ExecuteGetTransferInTickets Failed", oEx);
errorCode = "ExecuteGetTransferInTicketsFailed";
errorText = "OracleException thrown: " + oEx.Message;
return(false);
}
if (retVal == false)
{
BasicExceptionHandler.Instance.AddException("ExecuteGetTransferInTickets Failed: return value is false", new ApplicationException());
errorCode = dA.ErrorCode + " --- ExecuteGetTransferInTickets";
errorText = dA.ErrorDescription + " -- Return value is false";
return(false);
}
if (outputDataSet != null && outputDataSet.Tables.Count == 1)
{
foreach (DataRow dr in outputDataSet.Tables[0].Rows)
{
TransferItemVO item = new TransferItemVO();
item.ICN = Utilities.GetStringValue(dr["icn"]);
item.TransferType = Utilities.ParseEnum <TransferTypes>(Utilities.GetStringValue(dr["trantype"], string.Empty), TransferTypes.STORETOSTORE);
item.MdseRecordDesc = Utilities.GetStringValue(dr["md_desc"]);
item.PfiAmount = Utilities.GetDecimalValue(dr["pfi_amount"], 0);
item.RefurbNumber = Utilities.GetIntegerValue(dr["rfb_no"], 0);
item.ICNQty = Utilities.GetStringValue(dr["quantity"]);
item.Transfer = transfer;
transfer.Items.Add(item);
}
}
return(true);
}
public static bool ProcessTransferIn(DesktopSession cds, TransferVO transfer, out int ticketNumber, out string errorCode, out string errorText)
{
if (transfer == null)
{
throw new ArgumentNullException("transfer");
}
ticketNumber = 0;
//Initialize output vars
errorCode = string.Empty;
errorText = string.Empty;
OracleDataAccessor dA = GlobalDataAccessor.Instance.OracleDA;
//Create parameter list
List <OracleProcParam> oParams = new List <OracleProcParam>();
oParams.Add(new OracleProcParam("p_transfer_ticket_number", transfer.TransferTicketNumber));
oParams.Add(new OracleProcParam("p_store_number", cds.CurrentSiteId.StoreNumber));
oParams.Add(new OracleProcParam("p_user_id", cds.FullUserName));
oParams.Add(new OracleProcParam("p_transfer_type", transfer.GetTransferTypeDatabaseValue()));
oParams.Add(new OracleProcParam("p_carrier", transfer.Carrier));
oParams.Add(new OracleProcParam("p_status_date", ShopDateTime.Instance.ShopDate.FormatDate()));
oParams.Add(new OracleProcParam("p_status_time", ShopDateTime.Instance.ShopTransactionTime.ToString()));
oParams.Add(new OracleProcParam("p_origination_store_number", transfer.OriginalStoreNumber));
oParams.Add(new OracleProcParam("p_ticket_type", transfer.TransferSource.ToString()));
oParams.Add(new OracleProcParam("o_ti_ticket", OracleDbType.Int32, DBNull.Value, ParameterDirection.Output, 1));
//Make stored proc call
bool retVal;
DataSet outputDataSet;
try
{
retVal = GlobalDataAccessor.Instance.OracleDA.issueSqlStoredProcCommand("ccsowner",
"transfers", "process_ti", oParams, null, "o_return_code",
"o_return_text", out outputDataSet);
errorCode = dA.ErrorCode;
errorText = dA.ErrorDescription;
}
catch (OracleException oEx)
{
BasicExceptionHandler.Instance.AddException("ExecuteProcessTransferIn Failed", oEx);
errorCode = "ExecuteProcessTransferInFailed";
errorText = "OracleException thrown: " + oEx.Message;
return(false);
}
if (retVal == false)
{
BasicExceptionHandler.Instance.AddException("ExecuteProcessTransferInTickets Failed: return value is false", new ApplicationException());
errorCode = dA.ErrorCode + " --- ExecuteProcessTransferIn";
errorText = dA.ErrorDescription + " -- Return value is false";
return(false);
}
DataTable outputDt = outputDataSet.Tables["OUTPUT"];
if (outputDt != null && outputDt.IsInitialized &&
outputDt.Rows != null && outputDt.Rows.Count > 0)
{
DataRow dr = outputDt.Rows[0];
if (dr != null && dr.ItemArray.Length > 0)
{
object ticketNumberObj = dr.ItemArray.GetValue(1);
if (ticketNumberObj != null)
{
ticketNumber = Utilities.GetIntegerValue(dr.ItemArray.GetValue(1));
errorCode = "0";
errorText = "Success";
SaveTransferInReceipts(cds, ticketNumber, transfer.Amount);
return(true);
}
}
}
errorCode = "Error";
errorText = "NoSuccess";
return(false);
}
public static bool GetTransferInTickets(DesktopSession cds, List <TransferVO> transfers, out string errorCode, out string errorText)
{
if (transfers == null)
{
throw new ArgumentNullException("transfers");
}
//Initialize output vars
errorCode = string.Empty;
errorText = string.Empty;
OracleDataAccessor dA = GlobalDataAccessor.Instance.OracleDA;
//Create parameter list
List <OracleProcParam> oParams = new List <OracleProcParam>();
oParams.Add(new OracleProcParam("p_store_number", cds.CurrentSiteId.StoreNumber));
oParams.Add(new OracleProcParam("p_user_id", cds.FullUserName));
//Setup ref cursor array
List <PairType <string, string> > refCursors = new List <PairType <string, string> >();
//Add general ref cursors
refCursors.Add(new PairType <string, string>("o_ti_tickets", "ti_tickets_ref_cursor"));
//Make stored proc call
bool retVal;
DataSet outputDataSet;
try
{
retVal = GlobalDataAccessor.Instance.OracleDA.issueSqlStoredProcCommand("ccsowner",
"transfers", "retrieve_TI_tickets", oParams, refCursors, "o_return_code",
"o_return_text", out outputDataSet);
errorCode = dA.ErrorCode;
errorText = dA.ErrorDescription;
}
catch (OracleException oEx)
{
BasicExceptionHandler.Instance.AddException("ExecuteGetTransferInTickets Failed", oEx);
errorCode = "ExecuteGetTransferInTicketsFailed";
errorText = "OracleException thrown: " + oEx.Message;
return(false);
}
if (retVal == false)
{
BasicExceptionHandler.Instance.AddException("ExecuteGetTransferInTickets Failed: return value is false", new ApplicationException());
errorCode = dA.ErrorCode + " --- ExecuteGetTransferInTickets";
errorText = dA.ErrorDescription + " -- Return value is false";
return(false);
}
if (outputDataSet != null && outputDataSet.Tables.Count == 1)
{
if (outputDataSet.Tables[0].TableName == "ti_tickets_ref_cursor")
{
foreach (DataRow dr in outputDataSet.Tables[0].Rows)
{
TransferVO transfer = new TransferVO();
transfer.Amount = Utilities.GetDecimalValue(dr["amount"], 0);
transfer.Carrier = Utilities.GetStringValue(dr["carrier"]);
transfer.NumberOfItems = Utilities.GetIntegerValue(dr["LastLine"], 0);
transfer.Status = Utilities.ParseEnum <TransferStatus>(Utilities.GetStringValue(dr["status"], string.Empty), TransferStatus.TI);
transfer.StatusDate = Utilities.GetDateTimeValue(dr["statusdate"]);
transfer.StoreNickName = Utilities.GetStringValue(dr["storenickname"]);
transfer.OriginalStoreNumber = Utilities.GetStringValue(dr["storenumber"]);
transfer.TempStatus = Utilities.ParseEnum <TransferTempStatus>(Utilities.GetStringValue(dr["tempstatus"], string.Empty), TransferTempStatus.NONE);
transfer.TransferTicketNumber = Utilities.GetIntegerValue(dr["transticketnum"], 0);
transfer.TransferType = Utilities.ParseEnum <TransferTypes>(Utilities.GetStringValue(dr["trantype"], string.Empty), TransferTypes.STORETOSTORE);
transfer.TransferSource = Utilities.ParseEnum <TransferSource>(Utilities.GetStringValue(dr["ticket_type"], string.Empty), TransferSource.NONE);
transfer.RejectReason = Utilities.GetStringValue(dr["reject_reason"], string.Empty);
transfer.DestinationStoreNumber = Utilities.GetStringValue(dr["entitynumber"], string.Empty);
if (transfer.TransferSource == TransferSource.NONE)
{
continue;
}
transfers.Add(transfer);
}
}
errorCode = "0";
errorText = "Success";
return(true);
}
return(false);
}