// GET: Linked ClientSubUnit CreditCards
public ActionResult LinkedClientSubUnitCreditCards(int id)
{
//Get Group From Database
Meeting meeting = new Meeting();
meeting = meetingRepository.GetGroup(id);
//Check Exists
if (meeting == null)
{
ViewData["ActionMethod"] = "ClientSubUnitGet";
return(View("RecordDoesNotExistError"));
}
MeetingClientSubUnitCreditCardsVM meetingClientSubUnitCreditCardsVM = new MeetingClientSubUnitCreditCardsVM();
meetingClientSubUnitCreditCardsVM.MeetingId = id;
meetingClientSubUnitCreditCardsVM.MeetingName = meeting.MeetingName;
if (meeting.ClientTopUnitGuid != "")
{
ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository();
ClientTopUnit clientTopUnit = clientTopUnitRepository.GetClientTopUnit(meeting.ClientTopUnitGuid);
if (clientTopUnit != null)
{
meetingClientSubUnitCreditCardsVM.ClientTopUnitName = clientTopUnit.ClientTopUnitName;
}
}
List <MeetingLinkedCreditCardVM> creditCardsAvailable = new List <MeetingLinkedCreditCardVM>();
creditCardsAvailable = meetingRepository.GetLinkedCreditCards(id, false);
meetingClientSubUnitCreditCardsVM.CreditCardsAvailable = creditCardsAvailable;
List <MeetingLinkedCreditCardVM> creditCardsUnAvailable = new List <MeetingLinkedCreditCardVM>();
creditCardsUnAvailable = meetingRepository.GetLinkedCreditCards(id, true);
meetingClientSubUnitCreditCardsVM.CreditCardsUnAvailable = creditCardsUnAvailable;
//Set Access Rights
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
return(View(meetingClientSubUnitCreditCardsVM));
}
// GET: Linked ClientSubUnits
public ActionResult LinkedClientSubUnits(int id)
{
//Get Group From Database
Meeting group = new Meeting();
group = meetingRepository.GetGroup(id);
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "ClientSubUnitGet";
return(View("RecordDoesNotExistError"));
}
MeetingClientSubUnitCountriesVM MeetingClientSubUnits = new MeetingClientSubUnitCountriesVM();
MeetingClientSubUnits.MeetingId = id;
MeetingClientSubUnits.MeetingName = group.MeetingName;
if (group.ClientTopUnitGuid != "")
{
ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository();
ClientTopUnit clientTopUnit = clientTopUnitRepository.GetClientTopUnit(group.ClientTopUnitGuid);
if (clientTopUnit != null)
{
MeetingClientSubUnits.ClientTopUnitName = clientTopUnit.ClientTopUnitName;
}
}
List <ClientSubUnitCountryVM> clientSubUnitsAvailable = new List <ClientSubUnitCountryVM>();
clientSubUnitsAvailable = meetingRepository.GetLinkedClientSubUnits(id, false);
MeetingClientSubUnits.ClientSubUnitsAvailable = clientSubUnitsAvailable;
List <ClientSubUnitCountryVM> clientSubUnitsUnAvailable = new List <ClientSubUnitCountryVM>();
clientSubUnitsUnAvailable = meetingRepository.GetLinkedClientSubUnits(id, true);
MeetingClientSubUnits.ClientSubUnitsUnAvailable = clientSubUnitsUnAvailable;
//Set Access Rights
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
return(View(MeetingClientSubUnits));
}
public ActionResult ImportStep1(CDRImportStep1WithFileVM csvfile)
{
//used for return only
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csvfile.ClientSubUnitGuid);
ClientTopUnit clientTopUnit = new ClientTopUnit();
ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository();
clientTopUnit = clientTopUnitRepository.GetClientTopUnit(clientSubUnit.ClientTopUnitGuid);
clientSubUnit.ClientTopUnit = clientTopUnit;
csvfile.ClientSubUnit = clientSubUnit;
if (!ModelState.IsValid)
{
return(View(csvfile));
}
string fileExtension = Path.GetExtension(csvfile.File.FileName);
if (fileExtension != ".csv" && fileExtension != ".xls" && fileExtension != ".xlsx")
{
ModelState.AddModelError("file", csvfile.File.ContentType);
return(View(csvfile));
}
if (csvfile.File.ContentLength > 0)
{
CDRImportStep2VM preImportCheckResult = new CDRImportStep2VM();
List <string> returnMessages = new List <string>();
preImportCheckResult = clientSubUnitCDRRepository.PreImportCheck(csvfile.File, csvfile.ClientSubUnitGuid, csvfile.DisplayName, csvfile.RelatedToDisplayName);
CDRImportStep1VM preImportCheckResultVM = new CDRImportStep1VM();
preImportCheckResultVM.ClientSubUnit = clientSubUnit;
preImportCheckResultVM.CDRImportStep2VM = preImportCheckResult;
preImportCheckResultVM.DisplayName = csvfile.DisplayName;
preImportCheckResultVM.RelatedToDisplayName = csvfile.RelatedToDisplayName;
preImportCheckResultVM.ClientSubUnitGuid = csvfile.ClientSubUnitGuid;
TempData["PreImportCheckResultVM"] = preImportCheckResultVM;
return(RedirectToAction("ImportStep2"));
}
return(View());
}
public static string GetCurrentClientTopUnitGuid()
{
string clientTopUnitGuid = string.Empty;
string id = GetUrlParameter(HttpContext.Current.Request.Url.Query.ToString(), "id");
if (!string.IsNullOrEmpty(id))
{
ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository();
ClientTopUnit clientTopUnit = clientTopUnitRepository.GetClientTopUnit(id);
if (clientTopUnit != null)
{
clientTopUnitGuid = clientTopUnit.ClientTopUnitGuid;
}
}
return(clientTopUnitGuid);
}
// GET: /ListByClientAccount/
public ActionResult List(int?page, string can, string ssc, string csu, string sortField, int?sortOrder)
{
ClientAccount clientAccount = new ClientAccount();
clientAccount = clientAccountRepository.GetClientAccount(can, ssc);
//Check Exists
if (clientAccount == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
ViewData["Access"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToClientAccountCreditCards(can, ssc))
{
ViewData["Access"] = "WriteAccess";
}
//Sorting
if (sortField == null || sortField == "CreditCardTypeDescription")
{
sortField = "CreditCardTypeDescription";
}
ViewData["CurrentSortField"] = sortField;
//Ordering
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
sortOrder = 0;
}
ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository();
ClientTopUnit clientTopUnit = clientSubUnit.ClientTopUnit;
ClientAccountCreditCardsVM clientAccountCreditCardsVM = new ClientAccountCreditCardsVM();
clientAccountCreditCardsVM.CreditCards = creditCardClientAccountRepository.GetCreditCardsByClientAccount(can, ssc, page ?? 1, sortField, sortOrder ?? 0);
clientAccountCreditCardsVM.ClientAccount = clientAccount;
clientAccountCreditCardsVM.ClientTopUnit = clientTopUnit;
clientAccountCreditCardsVM.ClientSubUnit = clientSubUnit;
clientAccountCreditCardsVM.CreditCardBehavior = creditCardRepository.GetCreditCardBehavior();
return(View(clientAccountCreditCardsVM));
}
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 }));
}