//Delete From DB public void Delete(ClientSubUnitClientDefinedReference csuCDR) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeleteClientSubUnitClientDefinedReference_v1( csuCDR.ClientSubUnitClientDefinedReferenceId, adminUserGuid, csuCDR.VersionNumber ); }
public ActionResult List(int id, string csu, string filter, int?page, string sortField, int?sortOrder) { ClientSubUnitCDRItemsVM clientSubUnitCDRItemsVM = new ClientSubUnitCDRItemsVM(); ClientSubUnitClientDefinedReference clientSubUnitClientDefinedReference = new ClientSubUnitClientDefinedReference(); clientSubUnitClientDefinedReference = clientSubUnitCDRRepository.GetClientSubUnitCDR(id); //ClientSubUnitClientDefinedReference if (clientSubUnitClientDefinedReference == null) { ViewData["ActionMethod"] = "List"; return(View("RecordDoesNotExistError")); } clientSubUnitCDRItemsVM.ClientSubUnitClientDefinedReference = clientSubUnitClientDefinedReference; //SortField if (string.IsNullOrEmpty(sortField)) { sortField = "RelatedToValue"; } ViewData["CurrentSortField"] = sortField; //SortOrder if (sortOrder == 1) { ViewData["NewSortOrder"] = 0; ViewData["CurrentSortOrder"] = 1; } else { ViewData["NewSortOrder"] = 1; ViewData["CurrentSortOrder"] = 0; } //ClientSubUnit ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu); if (clientSubUnit == null) { ViewData["ActionMethod"] = "List"; return(View("RecordDoesNotExistError")); } clientSubUnitCDRItemsVM.ClientSubUnit = clientSubUnit; clientSubUnitCDRItemsVM.HasWriteAccess = rolesRepository.HasWriteAccessToClientSubUnit(csu); //Return items clientSubUnitCDRItemsVM.ClientSubUnitCDRItems = clientSubUnitCDRItemRepository.PageClientSubUnitCDRItems(id, page ?? 1, filter ?? "", sortField, sortOrder ?? 0); return(View(clientSubUnitCDRItemsVM)); }
//Update DB public void Edit(ClientSubUnitClientDefinedReference clientSubUnitCDR) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_UpdateClientSubUnitClientDefinedReference_v1( clientSubUnitCDR.ClientSubUnitClientDefinedReferenceId, clientSubUnitCDR.Value, clientSubUnitCDR.SourceSystemCode, clientSubUnitCDR.ClientAccountNumber, clientSubUnitCDR.CreditCardId, adminUserGuid, clientSubUnitCDR.VersionNumber ); }
//Add to DB public void Add(ClientSubUnitClientDefinedReference csuCDR) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertClientSubUnitClientDefinedReference_v1( csuCDR.ClientSubUnitGuid, csuCDR.DisplayName, csuCDR.Value, csuCDR.SourceSystemCode, csuCDR.ClientAccountNumber, csuCDR.CreditCardId, adminUserGuid ); }
public ClientSubUnitCDRVM( string clientAccountNumber, //int creditCardId, IEnumerable <SelectListItem> creditCardSelectList, IEnumerable <SelectListItem> clientAccountSelectList, DateTime creditCardValidTo, ClientSubUnitClientDefinedReference clientSubUnitClientDefinedReference, ClientSubUnit clientSubUnit, string clientDefinedReferenceItemId, string displayName) { ClientSubUnit = clientSubUnit; //CreditCardId = creditCardId; CreditCardValidTo = creditCardValidTo; ClientSubUnitClientDefinedReference = clientSubUnitClientDefinedReference; ClientDefinedReferenceItemId = clientDefinedReferenceItemId; CreditCardSelectList = creditCardSelectList; ClientAccountSelectList = clientAccountSelectList; ClientAccountNumber = clientAccountNumber; DisplayName = displayName; }
public ActionResult View(int id) { //Get ClientSubUnitTelephony ClientSubUnitClientDefinedReference clientSubUnitClientDefinedReference = new ClientSubUnitClientDefinedReference(); clientSubUnitClientDefinedReference = clientSubUnitCDRRepository.GetClientSubUnitCDR(id); //Check Exists if (clientSubUnitClientDefinedReference == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } if (clientSubUnitClientDefinedReference.ClientAccountNumber == null) { ClientAccount clientAccount = new ClientAccount(); clientSubUnitClientDefinedReference.ClientAccount = clientAccount; } if (clientSubUnitClientDefinedReference.CreditCardId == null) { CreditCard creditCard = new CreditCard(); clientSubUnitClientDefinedReference.CreditCard = creditCard; } ClientSubUnitCDRVM clientSubUnitCDRVM = new ClientSubUnitCDRVM(); clientSubUnitCDRVM.ClientSubUnitClientDefinedReference = clientSubUnitClientDefinedReference; ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnitCDRVM.ClientSubUnit = clientSubUnitRepository.GetClientSubUnit(clientSubUnitClientDefinedReference.ClientSubUnitGuid); //Show Create Form return(View(clientSubUnitCDRVM)); }
public ActionResult Delete(ClientSubUnitCDRVM clientSubUnitCDRVM) { int id = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.ClientSubUnitClientDefinedReferenceId; ClientSubUnitClientDefinedReference clientSubUnitClientDefinedReference = new ClientSubUnitClientDefinedReference(); clientSubUnitClientDefinedReference = clientSubUnitCDRRepository.GetClientSubUnitCDR(id); //Check Exists (at least one if (clientSubUnitClientDefinedReference == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToClientSubUnit(clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } try { clientSubUnitCDRRepository.Delete(clientSubUnitClientDefinedReference); } catch (SqlException ex) { 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 = clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid })); }
public ActionResult Edit(ClientSubUnitCDRVM clientSubUnitCDRVM) { if (!ModelState.IsValid) { string clientSubUnitGuid = clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid; //Get ClientSubUnit ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnit = clientSubUnitRepository.GetClientSubUnit(clientSubUnitGuid); ClientTopUnit clientTopUnit = new ClientTopUnit(); ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository(); clientTopUnit = clientTopUnitRepository.GetClientTopUnit(clientSubUnit.ClientTopUnitGuid); clientSubUnit.ClientTopUnit = clientTopUnit; clientSubUnitCDRVM.ClientSubUnit = clientSubUnit; clientSubUnitCDRVM.ClientSubUnit = clientSubUnit; CreditCardClientSubUnitRepository creditCardClientSubUnitRepository = new CreditCardClientSubUnitRepository(); clientSubUnitCDRVM.CreditCardSelectList = new SelectList(creditCardClientSubUnitRepository.GetAllCreditCardsBySubUnit(clientSubUnitGuid).ToList(), "CreditCardId", "MaskedCreditCardNumber"); ClientSubUnitClientAccountRepository clientSubUnitClientAccountRepository = new ClientSubUnitClientAccountRepository(); clientSubUnitCDRVM.ClientAccountSelectList = clientSubUnitClientAccountRepository.GetClientAccountsBySubUnit(clientSubUnitGuid, ""); //ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository(); //clientSubUnitCDRVM.ClientSubUnit.ClientTopUnit = clientTopUnitRepository.GetClientTopUnit(clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid); return(View(clientSubUnitCDRVM)); } CreditCard creditCard = new CreditCard(); int? creditCardId = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.CreditCardId; if (creditCardId != null) { creditCard = creditCardRepository.GetCreditCard((int)creditCardId, false); } ClientAccount clientAccount = new ClientAccount(); string clientAccountNumber = null; string sourceSystemCode = null; if (!String.IsNullOrEmpty(clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.ClientAccountNumberSourceSystemCode)) { clientAccountNumber = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.ClientAccountNumberSourceSystemCode.Split(new[] { '|' })[0]; sourceSystemCode = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.ClientAccountNumberSourceSystemCode.Split(new[] { '|' })[1]; clientAccount = clientAccountRepository.GetClientAccount(clientAccountNumber, sourceSystemCode); } //Check Exists (at least one if (creditCard == null && clientAccount == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToClientSubUnit(clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } ClientSubUnitClientDefinedReference clientSubUnitClientDefinedReference = new ClientSubUnitClientDefinedReference(); clientSubUnitClientDefinedReference.ClientSubUnitGuid = clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid; clientSubUnitClientDefinedReference.Value = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.Value; clientSubUnitClientDefinedReference.VersionNumber = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.VersionNumber; clientSubUnitClientDefinedReference.ClientAccountNumber = clientAccountNumber; clientSubUnitClientDefinedReference.SourceSystemCode = sourceSystemCode; if (creditCardId != null) { clientSubUnitClientDefinedReference.CreditCardId = creditCard.CreditCardId; } clientSubUnitClientDefinedReference.ClientSubUnitClientDefinedReferenceId = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.ClientSubUnitClientDefinedReferenceId; clientSubUnitClientDefinedReference.VersionNumber = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.VersionNumber; try { clientSubUnitCDRRepository.Edit(clientSubUnitClientDefinedReference); } catch (SqlException ex) { 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 = clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid })); }
public ActionResult Edit(int id) { //Get ClientSubUnitTelephony ClientSubUnitClientDefinedReference clientSubUnitClientDefinedReference = new ClientSubUnitClientDefinedReference(); clientSubUnitClientDefinedReference = clientSubUnitCDRRepository.GetClientSubUnitCDR(id); //Check Exists if (clientSubUnitClientDefinedReference == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToClientSubUnit(clientSubUnitClientDefinedReference.ClientSubUnitGuid)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } ClientSubUnitCDRVM clientSubUnitCDRVM = new ClientSubUnitCDRVM(); CreditCard creditCard = new CreditCard(); CreditCardRepository creditCardRepository = new CreditCardRepository(); if (clientSubUnitClientDefinedReference.CreditCardId == null) { clientSubUnitClientDefinedReference.CreditCard = creditCard; } else { creditCard = creditCardRepository.GetCreditCard((int)clientSubUnitClientDefinedReference.CreditCardId, false); clientSubUnitCDRVM.CreditCardValidTo = creditCard.CreditCardValidTo; } ClientSubUnit clientSubUnit = new ClientSubUnit(); clientSubUnitCDRVM.ClientSubUnit = clientSubUnitRepository.GetClientSubUnit(clientSubUnitClientDefinedReference.ClientSubUnitGuid); //Add MaskedCreditCardNumber and CreditCardHolderName into Select List CreditCardClientSubUnitRepository creditCardClientSubUnitRepository = new CreditCardClientSubUnitRepository(); List <CreditCard> creditCards = creditCardClientSubUnitRepository.GetAllCreditCardsBySubUnit(clientSubUnitClientDefinedReference.ClientSubUnitGuid).ToList(); List <SelectListItem> creditCardList = new List <SelectListItem>(); foreach (CreditCard creditCardItem in creditCards) { creditCardList.Add(new SelectListItem { Value = creditCardItem.CreditCardId.ToString(), Text = string.Format("{0}\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0{1}", creditCardItem.MaskedCreditCardNumber, creditCardItem.CreditCardHolderName) //Space out items }); } clientSubUnitCDRVM.CreditCardSelectList = new SelectList(creditCardList, "Value", "Text"); ClientSubUnitClientAccountRepository clientSubUnitClientAccountRepository = new ClientSubUnitClientAccountRepository(); string modifiedClientAccountNumber = clientSubUnitClientDefinedReference.ClientAccountNumber + "|" + clientSubUnitClientDefinedReference.SourceSystemCode; clientSubUnitCDRVM.ClientAccountSelectList = clientSubUnitClientAccountRepository.GetClientAccountsBySubUnit(clientSubUnitClientDefinedReference.ClientSubUnitGuid, modifiedClientAccountNumber.ToString()); clientSubUnitClientDefinedReference.ClientAccountNumberSourceSystemCode = modifiedClientAccountNumber; clientSubUnitCDRVM.ClientSubUnitClientDefinedReference = clientSubUnitClientDefinedReference; //Show Create Form return(View(clientSubUnitCDRVM)); }