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