public static void Replicate()
        {
            try
            {
                var contextCreator = new TransactionContextCreator(@"Data Source = C:\Users\PetarPetrov\Desktop\server.sqlite; Version = 3;");

                var clientData = new ClientData();
                clientData.Add(new Dictionary <string, FeatureContextRow>
                {
                    { @"Agenda", new FeatureContextRow(1, @"Agenda") }
                });
                clientData.Add(new[] { new FeatureExceptionRow(1, @"new exception : stack trace => ..."), });
                clientData.Add(new Dictionary <long, List <FeatureRow> >()
                {
                    { 1, new List <FeatureRow>()
                      {
                          new FeatureRow(1, @"Add Activity", 1),
                          new FeatureRow(2, @"Close Activity", 1),
                          new FeatureRow(3, @"Cancel Activity", 1),
                      } },
                });
                clientData.Add(new[]
                {
                    new FeatureEntryRow(2, "N/A", DateTime.Now),
                    new FeatureEntryRow(3, "Sick", DateTime.Now)
                });
                clientData.Add(new[]
                {
                    new FeatureExceptionEntryRow(1, DateTime.Today.AddDays(-1), 1),
                });

                //ResetSchema(contextCreator);

                var s = Stopwatch.StartNew();
                using (var ctx = contextCreator.Create())
                {
                    //FeatureServerManager.CreateSchema(ctx);

                    for (var i = 0; i < 1; i++)
                    {
                        FeatureManager.Replicate(ctx, @"BG900343", @"1.0.0.0", clientData.GetBytes());
                    }

                    ctx.Complete();
                }
                s.Stop();
                Console.WriteLine(s.ElapsedMilliseconds);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
            }
        }
Exemple #2
0
        public byte[] GetClientDataBytes()
        {
            using (var dbContext = this.ContextCreator())
            {
                this.Load(dbContext);

                var data = new ClientData();

                data.Add(this.Contexts);
                data.Add(FeatureAdapter.GetExceptions(dbContext));
                data.Add(this.Features);
                data.Add(FeatureAdapter.GetFeatureEntries(dbContext));
                data.Add(FeatureAdapter.GetExceptionEntries(dbContext));

                dbContext.Complete();

                return(data.GetBytes());
            }
        }
        public ActionResult Create([Bind(Include =
                                             "ClientName"
                                             + "," + "Address1"
                                             + "," + "Address2"
                                             + "," + "City"
                                             + "," + "District"
                                             + "," + "State"
                                             + "," + "PinCode"
                                             + "," + "ContactNo"
                                             + "," + "EMail"
                                             + "," + "GSTIN"
                                             + "," + "CompanyID"
                                             + "," + "AddUserID"
                                             + "," + "AddDate"
                                             + "," + "ArchiveUserID"
                                             + "," + "ArchiveDate"
                                         )] Client Client)
        {
            if (ModelState.IsValid)
            {
                bool bSucess = false;
                bSucess = ClientData.Add(Client);
                if (bSucess == true)
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    ModelState.AddModelError("", "Can Not Insert");
                }
            }
            // ComboBox
            ViewData["CompanyID"] = new SelectList(Client_CompanyData.List(), "CompanyID", "CompanyName", Client.CompanyID);

            return(View(Client));
        }