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