//Delete Item
public void Delete(CreditCard creditCard, CreditCardClientSubUnit creditCardClientSubUnit)
{
LogRepository logRepository = new LogRepository();
string computerName = logRepository.GetComputerName();
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
using (TransactionScope ts = TransactionUtils.CreateTransactionScope())
{
using (ccdbDC creditCardDatabase = new ccdbDC(ConfigurationManager.ConnectionStrings["CreditCardDatabase"].ConnectionString))
{
creditCardDatabase.spDesktopDataAdmin_DeleteCreditCard_v1(creditCard.CreditCardToken);
}
using (HierarchyDC desktopDatabase = new HierarchyDC(Settings.getConnectionString()))
{
desktopDatabase.spDesktopDataAdmin_DeleteClientSubUnitCreditCard_v1(
creditCardClientSubUnit.CreditCardId,
adminUserGuid,
creditCardClientSubUnit.VersionNumber,
Settings.ApplicationName(),
Settings.ApplicationVersion(),
null,
computerName,
null,
null,
13,
null,
null
);
}
ts.Complete();
}
}
public ActionResult View(int id)
{
CreditCard creditCard = new CreditCard();
creditCard = creditCardRepository.GetCreditCard(id, false);
//Check Exists
if (creditCard == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists
CreditCardClientSubUnit creditCardClientSubUnit = new CreditCardClientSubUnit();
creditCardClientSubUnit = creditCardClientSubUnitRepository.GetCreditCardClientSubUnit(id);
if (creditCardClientSubUnit == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//Log View Of Credit Card
LogRepository logRepository = new LogRepository();
logRepository.LogApplicationUsage(8, creditCardClientSubUnit.ClientSubUnitGuid, "", "", creditCard.CreditCardToken, creditCard.CreditCardTypeId, true);
creditCardRepository.EditForDisplay(creditCard);
return(View(creditCard));
}
public ActionResult Delete(int id)
{
//Check if changes are allowed to Cards for this Database
CreditCardBehavior creditCardBehavior = new CreditCardBehavior();
creditCardBehavior = creditCardRepository.GetCreditCardBehavior();
if (!creditCardBehavior.CanChangeCreditCardsFlag)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("Error"));
}
CreditCard creditCard = new CreditCard();
creditCard = creditCardRepository.GetCreditCard(id, false);
//Check Exists
if (creditCard == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists
CreditCardClientSubUnit creditCardClientSubUnit = new CreditCardClientSubUnit();
creditCardClientSubUnit = creditCardClientSubUnitRepository.GetCreditCardClientSubUnit(id);
if (creditCardClientSubUnit == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Log View Of Credit Card
LogRepository logRepository = new LogRepository();
logRepository.LogApplicationUsage(8, creditCardClientSubUnit.ClientSubUnitGuid, "", "", creditCard.CreditCardToken, creditCard.CreditCardTypeId, true);
creditCardRepository.EditForDisplay(creditCard);
return(View(creditCard));
}
//Add Data From Linked Tables for Display
//type is optional to letus know if it is a TopUnit card, which has no links to other tables
public void EditForDisplay(CreditCardEditable creditCard)
{
ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository();
ClientTopUnit clientTopUnit = new ClientTopUnit();
clientTopUnit = clientTopUnitRepository.GetClientTopUnit(creditCard.ClientTopUnitGuid);
if (clientTopUnit != null)
{
creditCard.ClientTopUnitName = clientTopUnit.ClientTopUnitName;
}
CreditCardVendorRepository creditCardVendorRepository = new CreditCardVendorRepository();
CreditCardVendor creditCardVendor = new CreditCardVendor();
creditCardVendor = creditCardVendorRepository.GetCreditCardVendor(creditCard.CreditCardVendorCode);
if (creditCardVendor != null)
{
creditCard.CreditCardVendorName = creditCardVendor.CreditCardVendorName;
}
if (creditCard.CreditCardTypeId != null)
{
int creditCardTypeId = (int)creditCard.CreditCardTypeId;
CreditCardTypeRepository creditCardTypeRepository = new CreditCardTypeRepository();
CreditCardType creditCardType = new CreditCardType();
creditCardType = creditCardTypeRepository.GetCreditCardType(creditCardTypeId);
if (creditCardType != null)
{
creditCard.CreditCardTypeDescription = creditCardType.CreditCardTypeDescription;
}
}
//If Linked to ClientSubUnit
CreditCardClientSubUnit creditCardClientSubUnit = new CreditCardClientSubUnit();
CreditCardClientSubUnitRepository creditCardClientSubUnitRepository = new CreditCardClientSubUnitRepository();
creditCardClientSubUnit = creditCardClientSubUnitRepository.GetCreditCardClientSubUnit(creditCard.CreditCardId);
if (creditCardClientSubUnit != null)
{
ClientSubUnitRepository clientSubUnitRepository = new ClientSubUnitRepository();
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(creditCardClientSubUnit.ClientSubUnitGuid);
if (clientSubUnit != null)
{
creditCard.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid;
creditCard.ClientSubUnitName = clientSubUnit.ClientSubUnitName;
creditCard.ClientTopUnitGuid = clientSubUnit.ClientTopUnit.ClientTopUnitGuid;
creditCard.ClientTopUnitName = clientSubUnit.ClientTopUnit.ClientTopUnitName;
}
}
//If Linked to ClientAccount
CreditCardClientAccount creditCardClientAccount = new CreditCardClientAccount();
CreditCardClientAccountRepository creditCardClientAccountRepository = new CreditCardClientAccountRepository();
creditCardClientAccount = creditCardClientAccountRepository.GetCreditCardClientAccount(creditCard.CreditCardId);
if (creditCardClientAccount != null)
{
ClientAccountRepository clientAccountRepository = new ClientAccountRepository();
ClientAccount clientAccount = new ClientAccount();
clientAccount = clientAccountRepository.GetClientAccount(creditCardClientAccount.ClientAccountNumber, creditCardClientAccount.SourceSystemCode);
if (clientAccount != null)
{
creditCard.ClientAccountNumber = clientAccount.ClientAccountNumber;
creditCard.ClientAccountName = clientAccount.ClientAccountName;
creditCard.SourceSystemCode = clientAccount.SourceSystemCode;
}
}
HierarchyRepository hierarchyRepository = new HierarchyRepository();
fnDesktopDataAdmin_SelectCreditCardHierarchy_v1Result hierarchy = new fnDesktopDataAdmin_SelectCreditCardHierarchy_v1Result();
hierarchy = GetGroupHierarchy(creditCard.CreditCardId);
if (hierarchy == null)
{
}
else
{
creditCard.HierarchyType = hierarchy.HierarchyType;
creditCard.HierarchyCode = hierarchy.HierarchyCode.ToString();
creditCard.HierarchyItem = hierarchy.HierarchyName.Trim();
if (hierarchy.HierarchyType == "ClientSubUnitTravelerType")
{
creditCard.ClientSubUnitGuid = hierarchy.HierarchyCode.ToString();
creditCard.ClientSubUnitName = hierarchy.HierarchyName.Trim();
creditCard.TravelerTypeGuid = hierarchy.TravelerTypeGuid;
creditCard.TravelerTypeName = hierarchy.TravelerTypeName.Trim();
}
}
}
public ActionResult Edit(int id, FormCollection collection)
{
//Check if changes are allowed to Cards for this Database
CreditCardBehavior creditCardBehavior = new CreditCardBehavior();
creditCardBehavior = creditCardRepository.GetCreditCardBehavior();
if (!creditCardBehavior.CanChangeCreditCardsFlag)
{
ViewData["ActionMethod"] = "EditPost";
return(View("Error"));
}
//Check Exists
CreditCardClientSubUnit creditCardClientSubUnit = new CreditCardClientSubUnit();
creditCardClientSubUnit = creditCardClientSubUnitRepository.GetCreditCardClientSubUnit(id);
if (creditCardClientSubUnit == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Get Item From Database
CreditCardEditable creditCard = new CreditCardEditable();
creditCard = creditCardRepository.GetCreditCardEditable(id, false);
//Check Exists
if (creditCard == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToClientSubUnitCreditCards(creditCardClientSubUnit.ClientSubUnitGuid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model From Form + Validate against DB
try
{
UpdateModel(creditCard);
}
catch
{
string n = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
n += error.ErrorMessage;
}
}
ViewData["Message"] = "ValidationError : " + n;
return(View("Error"));
}
//Database Update
try
{
creditCard.VersionNumber = Int32.Parse(collection["VersionNumber"]);
creditCardRepository.Edit(creditCard);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/CreditCardClientSubUnit.mvc/Edit?id=" + id;
return(View("VersionError"));
}
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
return(RedirectToAction("List", new { id = creditCardClientSubUnit.ClientSubUnitGuid }));
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Check if changes are allowed to Cards for this Database
CreditCardBehavior creditCardBehavior = new CreditCardBehavior();
creditCardBehavior = creditCardRepository.GetCreditCardBehavior();
if (!creditCardBehavior.CanChangeCreditCardsFlag)
{
ViewData["ActionMethod"] = "EditGet";
return(View("Error"));
}
CreditCard creditCard = new CreditCard();
creditCard = creditCardRepository.GetCreditCard(id, true);
//Check Exists
if (creditCard == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists
CreditCardClientSubUnit creditCardClientSubUnit = new CreditCardClientSubUnit();
creditCardClientSubUnit = creditCardClientSubUnitRepository.GetCreditCardClientSubUnit(id);
if (creditCardClientSubUnit == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToClientSubUnitCreditCards(creditCardClientSubUnit.ClientSubUnitGuid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
CreditCardVendorRepository creditCardVendorRepository = new CreditCardVendorRepository();
SelectList creditCardVendorsList = new SelectList(creditCardVendorRepository.GetAllCreditCardVendors().ToList(), "CreditCardVendorCode", "CreditCardVendorName", creditCard.CreditCardVendorCode);
ViewData["CreditCardVendorsList"] = creditCardVendorsList;
CreditCardTypeRepository creditCardTypeRepository = new CreditCardTypeRepository();
ViewData["CreditCardTypeList"] = new SelectList(creditCardTypeRepository.GetAllCreditCardTypes().ToList(), "CreditCardTypeId", "CreditCardTypeDescription", creditCard.CreditCardTypeId);;
//Populate List of Products
ProductRepository productRepository = new ProductRepository();
SelectList products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName", creditCard.ProductId);
ViewData["ProductList"] = products;
//Log View Of Credit Card
LogRepository logRepository = new LogRepository();
logRepository.LogApplicationUsage(8, creditCardClientSubUnit.ClientSubUnitGuid, "", "", creditCard.CreditCardToken, creditCard.CreditCardTypeId, true);
//Show Create Form
creditCardRepository.EditForDisplay(creditCard);
return(View(creditCard));
}
public ActionResult Delete(int id, FormCollection collection)
{
//Check if changes are allowed to Cards for this Database
CreditCardBehavior creditCardBehavior = new CreditCardBehavior();
creditCardBehavior = creditCardRepository.GetCreditCardBehavior();
if (!creditCardBehavior.CanChangeCreditCardsFlag)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("Error"));
}
//Check Exists
CreditCardClientSubUnit creditCardClientSubUnit = new CreditCardClientSubUnit();
creditCardClientSubUnit = creditCardClientSubUnitRepository.GetCreditCardClientSubUnit(id);
if (creditCardClientSubUnit == null)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToClientSubUnitCreditCards(creditCardClientSubUnit.ClientSubUnitGuid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
CreditCard creditCard = new CreditCard();
creditCard = creditCardRepository.GetCreditCard(id, false);
//Delete Item
try
{
creditCardClientSubUnit.VersionNumber = Int32.Parse(collection["VersionNumber"]);
creditCardClientSubUnitRepository.Delete(creditCard, creditCardClientSubUnit);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/CreditCardClientSubUnit.mvc/Delete?id=" + id.ToString();
return(View("VersionError"));
}
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
//Generic Error
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
//Return
return(RedirectToAction("List", new { id = creditCardClientSubUnit.ClientSubUnitGuid }));
}
