/// <summary> /// Получение Номера счета /// </summary> /// <param name="typeClient"></param> /// <returns></returns> public static int GetAccountNumber(string typeClient) { ClientsDBContext context = new ClientsDBContext(); int accountNumber = 1000; try { if ((typeClient == "AllNaturalClient") && (context.AllNaturalClients.Count() != 0)) { accountNumber = context.AllNaturalClients.OrderByDescending(accountNumber => accountNumber).FirstOrDefault().AccountNumber; } else if ((typeClient == "AllLegalClient") && (context.AllLegalClients.Count() != 0)) { accountNumber = context.AllLegalClients.OrderByDescending(accountNumber => accountNumber).FirstOrDefault().AccountNumber; } else if ((typeClient == "AllVipNaturalClient") && (context.AllVipNaturalClients.Count() != 0)) { accountNumber = context.AllVipNaturalClients.OrderByDescending(accountNumber => accountNumber).FirstOrDefault().AccountNumber; } else if ((typeClient == "AllVipLegalClients") && (context.AllVipLegalClients.Count() != 0)) { accountNumber = context.AllVipLegalClients.OrderByDescending(accountNumber => accountNumber).FirstOrDefault().AccountNumber; } } catch (NullReferenceException) { accountNumber = 1000; } return(accountNumber + 1); }
/// <summary> /// Получение Id /// </summary> /// <param name="typeClient"></param> /// <returns></returns> public static int GetId(string typeClient) { ClientsDBContext context = new ClientsDBContext(); int iD = 0; try { if ((typeClient == "AllNaturalClient") && (context.AllNaturalClients.Count() != 0)) { iD = context.AllNaturalClients.OrderByDescending(id => id).FirstOrDefault().Id; } else if ((typeClient == "AllLegalClient") && (context.AllLegalClients.Count() != 0)) { iD = context.AllLegalClients.OrderByDescending(id => id).FirstOrDefault().Id; } else if ((typeClient == "AllVipNaturalClient") && (context.AllVipNaturalClients.Count() != 0)) { iD = context.AllVipNaturalClients.OrderByDescending(id => id).FirstOrDefault().Id; } else if ((typeClient == "AllVipLegalClients") && (context.AllVipLegalClients.Count() != 0)) { iD = context.AllVipLegalClients.OrderByDescending(id => id).FirstOrDefault().Id; } } catch (NullReferenceException ex) { iD = 0; } return(++iD); }