public static IList <string> GetPrefixList(CrmContext orgCtx)
{
var defaultPublisherRef =
orgCtx.SolutionSet
.Where(r => r.UniqueName == "Default")
.Select(r => r.PublisherId)
.FirstOrDefault();
var publishers =
orgCtx.PublisherSet.Select(
r => new Publisher
{
PublisherId = r.PublisherId,
CustomizationPrefix = r.CustomizationPrefix
}).ToList();
var defaultPrefix = defaultPublisherRef == null
? null
: publishers.FirstOrDefault(r => r.PublisherId == defaultPublisherRef.Id)?.CustomizationPrefix;
defaultPrefix = defaultPrefix == null ? null : defaultPrefix + "_";
var prefixes = publishers.Select(r => r.CustomizationPrefix + "_").ToList();
if (defaultPrefix == null)
{
return(prefixes);
}
var result = new List <string>();
result.Add(defaultPrefix);
result.AddRange(prefixes.Where(r => !r.Equals(defaultPrefix, StringComparison.InvariantCultureIgnoreCase)));
return(result);
}
public ClientsController(
CrmContext context,
ISavedDocumentHandler savedDocumentHandler)
{
_context = context;
_savedDocumentHandler = savedDocumentHandler;
}
public static IList <ActionDto> GetActionList(CrmContext orgCtx)
{
const int WorkflowTypeCode = 1;
const int WorkflowCategoryCode = 3;
const string PrimaryEntity = "none";
const int ActiveStatusCode = 2;
var actions = (from w in orgCtx.WorkflowSet
join ms in orgCtx.SdkMessageSet on w.SdkMessageId.Id equals ms.SdkMessageId.Value
where (
w.StateCode == WorkflowState.Activated &&
w.StatusCode != null && w.StatusCode.Value == ActiveStatusCode &&
w.IsCustomizable != null && w.IsCustomizable.Value &&
w.SdkMessageId != null &&
w.Type != null && w.Type.Value == WorkflowTypeCode &&
w.Category != null && w.Category.Value == WorkflowCategoryCode &&
w.PrimaryEntity == PrimaryEntity &&
w.UniqueName != "ItemSetConfigurationGetEntities" &&
w.UniqueName != "GetItemSet" &&
w.UniqueName != "ItemSetConfigurationAddControlOnForm" &&
w.UniqueName != "ItemSetConfigurationGetAddControlWizardData" &&
w.UniqueName != "ItemSetConfigurationExport" &&
w.UniqueName != "ItemSetConfigurationImport" &&
w.UniqueName != "DemoInstallDemoData"
)
select new ActionDto {
UniqueName = ms.Name, Name = w.Name
})
.ToList();
return(actions.OrderBy(r => r.UniqueName).ToList());
}
public EventRepository(CrmContext context, IEventContactRepository eventContactRepo, IEventOrganizationRepository eventOrgaRepo, IContactRepository contactRepo, IOrganizationRepository orgaRepo) : base(context)
{
this.contactRepo = contactRepo;
this.eventOrgaRepo = eventOrgaRepo;
this.orgaRepo = orgaRepo;
this.eventContactRepo = eventContactRepo;
}
public void CommandsRealization(/*AdminCommandscommon command*/)
{
Console.WriteLine("введите права доступа создаваемого пользователя(true=admin false=sales)");
bool root = Convert.ToBoolean(Console.ReadLine());
Console.WriteLine("Введите имя создаваемого пользователя");
string name = Console.ReadLine();
Console.WriteLine("введите логин нового пользователя");
string login = Console.ReadLine();
Console.WriteLine("введите пароль нового пользователя");
string password = Console.ReadLine();
CrmContext CrmCreateUserContext = new CrmContext();
User usr = new User(root, name, login, password);
CrmCreateUserContext.Users.Add(usr);
CrmCreateUserContext.SaveChanges();
//foreach (User newusr in quarry)
//{ //для изменений текущей записи
// newusr.Root = root;
// newusr.Name = name;
// newusr.Login = login;
// newusr.Password = password;
//}
//CrmCreateUserContext.SaveChanges();
}
public ReportQuery(CrmContext context) : base(context)
{
accounts = Context.Accounts.ToList();
invoices = Context.Invoices.ToList();
workDoneItems = Context.WorkDoneItems.ToList();
allocations = Context.Allocations.ToList();
}
// POST api/values
public object Post(CustomerViewModel value)
{
//Validate something about your input
if (value == null)
{
throw new ArgumentException();
}
using (var crmContext = new CrmContext())
{
//Find the record in the DB
Customer customer = crmContext.Customers.Find(value.CustomerId);
if (customer != null)
{
//Update the record
value.ApplyToCustomer(customer);
//Save the crmContext back
crmContext.SaveChanges();
return(new
{
Success = true,
ViewModel = new CustomerViewModel(customer)
});
}
}
return(new
{
Success = false
});
}
public SystemTaskDataProvider(CrmContext context, IGraphApiSystemTaskService graphApiSystemTask,
ILogger <SystemTaskDataProvider> logger)
{
_context = context;
_graphApiSystemTask = graphApiSystemTask;
_logger = logger;
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req,
ExecutionContext context,
ILogger log)
{
log.LogInformation("LobFunction triggered!");
var configuration = new ConfigurationBuilder()
.SetBasePath(context.FunctionAppDirectory)
.AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables()
.Build();
var connectionString = configuration.GetConnectionString("CrmContext");
var options = new DbContextOptionsBuilder <CrmContext>();
options.UseSqlServer(connectionString);
var db = new CrmContext(options.Options);
await db.Database.EnsureCreatedAsync();
var customers = await db.Customers.ToListAsync();
return(new OkObjectResult(customers));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public MensajeRetorno <Solicitante> Get(string id)
{
if (id == null)
{
return new MensajeRetorno <Solicitante> {
Data = null, Message = "Debe de suministrar los parametros", State = "FAIL"
}
}
;
CrmContext db = new CrmContext();
Guid _id = new Guid();
var result = new Solicitante();
if (Guid.TryParse(id, out _id))
{
result = db.Solicitantes.Consultar(_id);
}
else
{
result = db.Solicitantes.Consultar(id);
}
if (result == null)
{
return new MensajeRetorno <Solicitante> {
Data = null, Message = "Esta cedula no existe.", State = "FAIL"
}
}
;
result.Clave = "";
return(new MensajeRetorno <Solicitante> {
Data = result, Message = "", State = "SUCCESS"
});
}
public void CommandsRealization(/*SalesCommandscommon command*/)
{
CrmContext creatingcustomer = new CrmContext();
Console.WriteLine("введите имя");
string name = Console.ReadLine();
Console.WriteLine("введите адрес эмейл");
string email = Console.ReadLine();
Console.WriteLine("введите номер телефона ");
Int32 phone = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("введите адрес расположения");
string address = Console.ReadLine();
Console.WriteLine("введите marketorganization");
string marketorganization = Console.ReadLine();
Customer cust = new Customer(name, email, phone, address, marketorganization);
creatingcustomer.Customers.Add(cust);
creatingcustomer.SaveChanges();
}
/// <summary>
/// Updates the First or Last Name of the contact to match the given case
/// </summary>
/// <param name="service">The service.</param>
/// <param name="name">The name.</param>
public static void MakeNameMatchCase(IOrganizationService service, string name)
{
using (var context = new CrmContext(service))
{
var contacts = (from c in context.ContactSet
where c.FirstName == name || c.LastName == name
select new Contact {
Id = c.Id, FirstName = c.FirstName, LastName = c.LastName
}).ToList();
foreach (var contact in contacts.Where(c => StringsAreEqualButCaseIsNot(c.FirstName, name)))
{
contact.FirstName = name;
context.UpdateObject(contact);
}
foreach (var contact in contacts.Where(c => StringsAreEqualButCaseIsNot(c.LastName, name)))
{
contact.LastName = name;
context.UpdateObject(contact);
}
context.SaveChanges();
}
}
public MensajeRetorno <Solicitante> GetNoAuth(string id)
{
if (id == null)
{
return new MensajeRetorno <Solicitante> {
Data = null, Message = "Debe de suministrar los parametros", State = "FAIL"
}
}
;
CrmContext db = new CrmContext();
var result = db.Solicitantes.ConsultarNoRegistrado(id);
if (result == null)
{
return new MensajeRetorno <Solicitante> {
Data = null, Message = "Esta cedula no existe.", State = "FAIL"
}
}
;
return(new MensajeRetorno <Solicitante> {
Data = result, Message = "", State = "SUCCESS"
});
}
}
}
public MensajeRetorno <Solicitante> crear(Solicitante solicitante)
{
CrmContext db = new CrmContext();
if (solicitante == null)
{
return new MensajeRetorno <Solicitante> {
Data = null, Message = "Debe de suministrar los parametros", State = "FAIL"
}
}
;
var result = db.Solicitantes.Crear(solicitante);
if (result == null)
{
return new MensajeRetorno <Solicitante> {
Data = null, Message = "El usuario ya esta creado.", State = "FAIL"
}
}
;
if (result.CorreoElectronico == "")
{
return new MensajeRetorno <Solicitante> {
Data = null, Message = "Este correo esta siendo usado por otro usuario.", State = "FAIL"
}
}
;
result.Clave = "";
return(new MensajeRetorno <Solicitante> {
Data = result, Message = "", State = "SUCESS"
});
}
public MainForm()
{
InitializeComponent();
rnd = new Random(DateTime.Now.Millisecond);
dbContext = new CrmContext();
cusrtomerCart = new Cart(customer);
}
public MensajeRetorno <Estado> Get(string id)
{
CrmContext db = new CrmContext();
Guid guid = new Guid();
if (!Guid.TryParse(id, out guid))
{
return new MensajeRetorno <Estado> {
Data = null, Message = "No existe ningún estado con este id.", State = "FAIL"
}
}
;
var result = db.Estados.Consultar(guid);
if (result == null)
{
return new MensajeRetorno <Estado> {
Data = null, Message = "No existe ningún estado con este id.", State = "FAIL"
}
}
;
return(new MensajeRetorno <Estado> {
Data = result, Message = "", State = "SUCCESS"
});
}
}
}
public MensajeRetorno <IEnumerable <Estado> > collection(string id)
{
CrmContext db = new CrmContext();
Guid guid = new Guid();
if (!Guid.TryParse(id, out guid))
{
return new MensajeRetorno <IEnumerable <Estado> > {
Data = null, Message = "Este id no es valido", State = "FAIL"
}
}
;
var result = db.Estados.ConsultarTodo(guid);
if (result == null)
{
return new MensajeRetorno <IEnumerable <Estado> > {
Data = null, Message = "Este servicio no tiene estados.", State = "FAIL"
}
}
;
return(new MensajeRetorno <IEnumerable <Estado> > {
Data = result, Message = "", State = "SUCCESS"
});
}
public void CrmContext_ObjectTest()
{
var settings = new S2SAppSettings(S2SProp.testClientId, S2SProp.testClientSecret, S2SProp.testResource, S2SProp.testTenantId);
var context = new CrmContext(settings);
WhoAmITest(context);
}
public Main()
{
InitializeComponent();
db = new CrmContext();
cart = new Cart(customer);
}
public DepositDataProvider(ISequenceDataProvider sequenceDataProvider, CrmContext context, IMapper mapper, ILogger <DepositDataProvider> logger)
{
_sequenceDataProvider = sequenceDataProvider;
_context = context;
_mapper = mapper;
_logger = logger;
}
public void CrmContext_DefaultMultipleContextNoClear_Test()
{
ConfigurationManager.AppSettings["dyn:ClientId"] = S2SProp.testClientId;
ConfigurationManager.AppSettings["dyn:ClientSecret"] = S2SProp.testClientSecret;
ConfigurationManager.AppSettings["dyn:Resource"] = S2SProp.testResource;
ConfigurationManager.AppSettings["dyn:tenantId"] = S2SProp.testTenantId;
var context = new CrmContext();
var context2 = new CrmContext();
var context3 = new CrmContext();
try
{
WhoAmITest(context, false);
WhoAmITest(context2, false);
WhoAmITest(context3, false);
}
finally
{
context.Dispose();
context.ResetAll();
context2.Dispose();
context2.ResetAll();
context3.Dispose();
context3.ResetAll();
}
}
public PlanoveForm(DbSet <T> set, CrmContext db)
{
InitializeComponent();
this.db = db;
this.set = set;
//set.Load(); // загружаем все данные
}
// GET: api/Solicitudes/Details/5
public MensajeRetorno <Solicitudes> Details(string id)
{
CrmContext db = new CrmContext();
Guid guid = new Guid();
if (!Guid.TryParse(id, out guid))
{
return new MensajeRetorno <Solicitudes> {
Data = null, Message = "Este id no es valido", State = "FAIL"
}
}
;
var result = db.SolicitudesEnLinea.Consultar(guid);
if (result == null)
{
return new MensajeRetorno <Solicitudes> {
Data = null, Message = "La solicitud no se pudo crear", State = "SUCCESS"
}
}
;
return(new MensajeRetorno <Solicitudes> {
Data = result, Message = "", State = "SUCCESS"
});
}
// GET: api/Solicitudes/Collection/1
public MensajeRetorno <IEnumerable <Solicitudes> > Collection(string id)
{
CrmContext db = new CrmContext();
Guid guid = new Guid();
if (!Guid.TryParse(id, out guid))
{
return new MensajeRetorno <IEnumerable <Solicitudes> > {
Data = null, Message = "Este id no es valido", State = "FAIL"
}
}
;
var result = db.SolicitudesEnLinea.ConsultarTodo(guid);
if (result == null)
{
return new MensajeRetorno <IEnumerable <Solicitudes> > {
Data = null, Message = "Este usuario no tiene solicitudes", State = "SUCCESS"
}
}
;
return(new MensajeRetorno <IEnumerable <Solicitudes> > {
Data = result, Message = "La solicitud no se pudo crear", State = "SUCCESS"
});
}
public VykComission(DbSet <T> set, CrmContext db)
{
InitializeComponent();
this.db = db;
this.set = set;
List <Teacher> teachers = db.Teachers.ToList();
List <Groups> groups = db.Groups.ToList(); //принимаем данные с таблицы групп
List <Subjects> subjects = db.Subjects.ToList(); //принимаем данные с таблицы предметов
comboBox1.DataSource = teachers;
comboBox1.ValueMember = "IdTeacher";
comboBox1.DisplayMember = "Surname";
//подключаем данные и выводим список групп в comboBox1
comboBox3.DataSource = groups;
comboBox3.ValueMember = "GroupId";
comboBox3.DisplayMember = "GroupName";
//подключаем данные и выводим список предметов в comboBox2
comboBox4.DataSource = subjects;
comboBox4.ValueMember = "SubjId";
comboBox4.DisplayMember = "ShortName";
}
public InvoiceDataProvider(IDepositInvoiceDataProvider depositInvoiceDataProvider,
ISequenceDataProvider sequenceDataProvider, IVatRateDataProvider vatRateDataProvider,
CrmContext context, IMapper mapper, ILogger <InvoiceDataProvider> logger)
: base(sequenceDataProvider, vatRateDataProvider, context, mapper, logger)
{
_depositInvoiceDataProvider = depositInvoiceDataProvider;
}
public static CrmContext GetContext()
{
var db = new CrmContext();
//db.Customers.Load();
//Console.WriteLine(db.Customers.Local.FirstOrDefault().FirstName); //тест чтения из бд
return(db);
}
public CustomerRecordDataProvider(CrmContext context, IMapper mapper, ISequenceDataProvider sequenceDataProvider,
ILogger <CustomerRecordDataProvider> logger)
{
_context = context;
_mapper = mapper;
_sequenceDataProvider = sequenceDataProvider;
_logger = logger;
}
public Catalog(DbSet <T> set, CrmContext db)
{
InitializeComponent();
this.db = db;
this.set = set;
set.Load();
dataGridView.DataSource = set.Local.ToBindingList();
}
DbSet <T> set; // контекст для работы и подключение к бд
///
public Catalog(DbSet <T> set, CrmContext db) // в качестве параметра указываем подключение к дазе данных
{
InitializeComponent();
this.db = db; // в теущую переменую присваиваем входящую экземпляр db работа с БДЫ
this.set = set; // контекст..кэш данных
set.Load(); // закрузка данных из бд. Ленивая подгузка
dataGridView.DataSource = set.Local.ToBindingList(); // Соединение с БД и получам закешированые данные из БД
}
private IUnitOfWork GetUnitOfWork()
{
var orm = new CrmContext();
return new UnitOfWork(orm);
}
