// REQ002; PARTNER
// new CardOrderEngine("cn_db_requests_partner");
public ActionResult ExportDeliveryList(long id, uint packageId)
{
try
{
cardOrderEngine = new CardOrderEngine();
cardOrderEngine.initWebConfigFileMembers();
List <string> pomlist = new List <string>()
{
"CardOrderRequests", "CardOrderAnswers"
};
cardOrderEngine.setDbTableInitialization("cardnetDB", pomlist);
// get card order XML
var pomXelement = cardOrderEngine.getCardnetDAL().getXMLByOrderId(id);
// get card order partner name
var partnerName = cardOrderEngine.getCardnetDAL().getPartnerNameByOrderId(id);
// get delivery list
var pomDeliveryListType = cardOrderEngine.getCardnetDAL().getCardOrderRequests().Where(co => co.ID == id).Select(co => co.DeliveryListId).First();
var pomDlTemplateName = cardOrderEngine.getCardnetDAL().getCardnetDB().C___EXPORT_MAP.Where(e => e.CONSTANT_NAME == "delivery_list" && e.CONSTANT_VALUE == pomDeliveryListType).First().TEMPLATE_FILE_NAME.ToString();
var dlTuple = new Tuple <string, string>(pomDeliveryListType, pomDlTemplateName);
DeliveryListGenerationApp.AppEngine appEngine = new DeliveryListGenerationApp.AppEngine(pomXelement, packageId, partnerName, id, cardOrderEngine.getSambaPath(), cardOrderEngine.getEnvironment(), dlTuple);
FlashMessage.Confirmation("Operation succeeded. Delivery List was exported to " + appEngine.getExportManager().getDestinationPath());
return(RedirectToAction("OpenOrder", new { id = id }));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Shows cards from Rewardo in specified package
/// </summary>
/// <param name="id"></param>
/// <param name="packageId"></param>
/// REQ002; PARTNER;
public ActionResult ShowCardsInPackage(long id, uint packageId)
{
cardOrderEngine = new CardOrderEngine();
List <string> tablesToInit = new List <string>()
{
"CardOrderRequests", "CardOrderAnswers", "partners"
};
cardOrderEngine.setDbTableInitialization("all", tablesToInit);
// get card order partner name
var partnerName = cardOrderEngine.getCardnetDAL().getPartnerNameByOrderId(id);
// get organization ID from REWARDO.ORGANIZATION table according to @param partnerName == ORGANIZATION.NAME == ___PARTNER.ORGANIZATION_NAME
var organizationID = cardOrderEngine.getRewardoEngine().getOrganizationId(partnerName);
// get card order XML
var pomXelement = cardOrderEngine.getCardnetDAL().getXMLByOrderId(id);
var partnerCardIdsFromRW = cardOrderEngine.getRewardoEngine().getPartnerCardIdsFromRW(partnerName); // from RW
var partnerCardsFromCNXML = cardOrderEngine.getCardnetDAL().getCardsFromXMLByPartnerAndPackageIdFromCN(id, packageId); // from CN
var cardsNotInRW = new List <long>();
var pomRewardoCardListViewModel = cardOrderEngine.getRewardoEngine().getRewardoCardListViewModel();
var pom1 = new RewardoCardListViewModel();
cardOrderEngine.getRewardoEngine().createRewardoCardListViewModel(partnerCardsFromCNXML, pom1, pomRewardoCardListViewModel, organizationID);
pom1.orderId = id;
pom1.packageId = packageId;
pom1.rclvm.OrderBy(rcl => rcl.OrderInPackage);
int pomocnaPremenna = 0;
// better to use DO-WHILE
foreach (var i in pom1.rclvm)
{
if (i.Cardno == "")
{
pomocnaPremenna += 1;
}
}
if (pomocnaPremenna != 0)
{
pom1.infoColor = "red";
pom1.info = "Uncompleted order in Rewardo. Some (or all) cards are not still in Rewardo.";
return(View("ShowCardsInPackage", pom1));
}
else
{
pom1.infoColor = "green";
pom1.info = "Cards are succesfully created in Rewardo.";
return(View("ShowCardsInPackage", pom1));
}
}
private void contextInit()
{
// -------------------------------------------------------------------
// DB INIT
// -------------------------------------------------------------------
cardOrderEngine = new CardOrderEngine();
List <string> tablesToInit = new List <string>();
tablesToInit.Add("partners");
tablesToInit.Add("CardOrderRequests");
tablesToInit.Add("CardOrderAnswers");
tablesToInit.Add("partners");
tablesToInit.Add("constantUniversals");
tablesToInit.Add("constantPartners");
cardOrderEngine.setDbTableInitialization("all", tablesToInit);
// -------------------------------------------------------------------
}
