//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 })); }