public static void Load() { // Load Accounts; foreach (Database.Account account in Database.ActiveRecord.Load <Database.Account>()) { Accounts.Add(account.id, account); } // Load Characters; foreach (Database.Character character in Database.ActiveRecord.Load <Database.Character>()) { Characters.Add(character.id, character); } // Load Npcs; foreach (Database.Npc npc in Database.ActiveRecord.Load <Database.Npc>()) { Npcs.Add(npc.id, npc); } // Load Npcs In World; foreach (NpcSpawn npcSpawn in Database.ActiveRecord.Load <NpcSpawn>()) { NpcSpawns.Add(npcSpawn.id, npcSpawn); } // Load Scenery In World; foreach (ScenerySpawnPoint scenery in ActiveRecord.Load <ScenerySpawnPoint>()) { scenery.Instantiate(); } }
private bool deleteDatabaseUser(string userId) { ActiveRecord record = new ActiveRecord(); string datosConexion = this.cadenaConexion; try { using (SqlConnection con = new SqlConnection(datosConexion)) { //Paso 2 - Abrir la conexión con.Open(); string textoCmd = "DELETE * FROM CuentaGastosUsuarios WHERE Usuario = '" + userId + "'"; SqlCommand cmd = new SqlCommand(textoCmd, con); SqlDataReader reader = cmd.ExecuteReader(); if (reader.RecordsAffected > 0) { return(true); } else { return(false); } } } catch (Exception e) { return(false); } }
public void Acc_Products_NullCrud() { //add a new product Product product = new Product(); product.CategoryID = 1; product.Discontinued = false; product.ProductName = "Unit Test Product"; product.QuantityPerUnit = null; product.ReorderLevel = null; product.SupplierID = null; product.UnitPrice = null; product.UnitsInStock = null; product.UnitsOnOrder = null; product.Save(""); //get the new id int newID = product.ProductID; product = new Product(newID); product.ReorderLevel = 100; product.Save("unit test"); //pull it out to confirm product = new Product(newID); Assert.IsTrue(product.ReorderLevel == 100, "Bad Save"); Assert.IsTrue(product.SupplierID == null, "Bad Save, Null not inserted"); //delete it ActiveRecord <Product> .Delete(newID); }
public void Show() { try { var connection = ActiveRecord.Open(); using (connection) { connection.Open(); var sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandText = "SELECT * FROM Prescriptions"; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { Console.WriteLine(); Console.WriteLine("ID: " + sqlDataReader["ID"]); Console.WriteLine("Nazwa Klienta: " + sqlDataReader["CustomerName"]); Console.WriteLine("Pesel: " + sqlDataReader["PESEL"]); Console.WriteLine("Numer recepty: " + sqlDataReader["PrescriptionNumber"]); Console.WriteLine(); } Console.ReadLine(); } } catch (Exception e) { Console.WriteLine(e); } }
public ActionResult MapLocationEditPanel(ActiveRecord record, string latitudeFieldName, string longitudeFieldName, string addressFieldNamesPipeSeparated) { return(View(new MapLocationViewData() { DataRecord = record, LatitudeFieldName = latitudeFieldName, LongitudeFieldName = longitudeFieldName, AddressFieldName = addressFieldNamesPipeSeparated })); }
public void AddRow(DynamicTableEntity result) { Dictionary <string, object> values = new Dictionary <string, object>(); foreach (var column in _dbTableSchema.Columns) { values.Add(column.ColumnName, null); } foreach (var property in result.Properties) { try { values[property.Key] = property.Value.PropertyAsObject; } catch (Exception e) { Console.WriteLine("Schema broken."); } } var row = ActiveRecord.Create(_dbTableSchema, values); Rows.Add(row); }
/// <summary> /// If a file was uploaded, this is where it is saved to the disk in the attachments folder. /// </summary> public override void PrepareForSave(ActiveRecord record) { this.wasPosted = false; // set to false, but back to true if file supplied if (toDelete || (fileData != null && this.OriginalValue.IsNotBlank())) { PrepareForDelete(true); this.wasPosted = true; } if (fileData != null && this.FileName != null && !this.savedAlready) { //save the file if just been uploaded using (var stream = fileData.InputStream) { if (stream != null && (stream.Position == 0 || (stream.Length > 0 && stream.Position != stream.Length))) //JN only save if not already saved (eg my picture control) //if (true) // do we need the line above? { // correct filename MakeUniqueFilename(); //this.FileName = FileSystem.GetUniqueFilename(Web.Attachments, this.FileName, this.MaxLength); string fullPath = Web.MapPath(Web.Attachments + this.FileName); stream.SaveStreamToFile(fullPath); this.wasPosted = true; stream.Close(); stream.Dispose(); this.savedAlready = true; } } } base.PrepareForSave(record); }
public static void AssertFieldsExist(ActiveRecord person) { // check person record is OK if (!person.FieldExists("Email") || !person.FieldExists("PersonID") || !person.FieldExists("DoubleOptInEmailSentDate") || !person.FieldExists("SubscribeDate") || !person.FieldExists("UnsubscribeDate") || !person.FieldExists("HasValidatedEmail")) { throw new Exception("NewsletterDoubleOptIn - fields missing from person record. The following fields must exists: Email, PersonID, DoubleOptInEmailSentDate, SubscribeDate, UnsubscribeDate, HasValidatedEmail"); } }
public ActionResult ModificationHistoryPanel(ActiveRecord record, bool showHeader) { CheckForNoShowHeader(record, ref showHeader); return(View(new ModificationHistoryViewData() { DataRecord = record, ShowHeader = showHeader })); }
private static void CheckForNoShowHeader(ActiveRecord record, ref bool showHeader) { if (record.Advanced.ExpiryDateField == null && record.Advanced.PublishDateField == null && record.Advanced.IsActiveFields.Count == 0) { showHeader = false; } }
public virtual string RowClass(ActiveRecord record) { if (record == null) { return("row-" + Html.OddEven); } return("row-" + Html.OddEven + (record.GetIsActive() ? "" : " inactive")); }
public void delete(ActiveRecord item) { DeleteQuery query = new DeleteQuery(item.GetType()); query.addWhere("id", item.id.ToString()); Console.WriteLine(query.build()); query.exec(); }
public ActionResult GetChildNav(int id) { string sql = @"select ID, Title, ParentID, ActiveFlag, OrderID, LevelID, ShowAssets, ViewType, Created from PPSNav where ParentID = '" + id + "' and ActiveFlag = '1'"; var page = ActiveRecord.GetAllWithSQL <PPSNav>(sql); return(Json(JsonConvert.SerializeObject(page), JsonRequestBehavior.AllowGet)); }
public static bool RemoveFromCach(ActiveRecord record) { if (cache.ContainsKey(GetCacheKey(record))) { cache.Remove(GetCacheKey(record)); return true; } return false; }
public ActionResult PublishSettingsEditPanel(ActiveRecord record, bool showHeader, string cssTablerowClass) { CheckForNoShowHeader(record, ref showHeader); return(View(new PublishSettingsViewData() { DataRecord = record, ShowHeader = showHeader, CssTablerowClass = cssTablerowClass })); }
/// <summary> /// Deletes a User by their id /// </summary> /// <param name="id">user id</param> /// <returns>true if successfull</returns> public override void Delete(int id) { _userController.Delete(id); _profileController.Delete(id); ActiveRecord <ManagerAssignment> .Delete(ManagerAssignment.Columns.UserID, id); ActiveRecord <ProjectAssignment> .Delete(ProjectAssignment.Columns.UserID, id); }
public string GetValue(ActiveRecord record, string fieldName) { string result = ""; try { result = record[fieldName] + ""; } catch (Exception) { } return(result); }
private void Editar(DTOFrete frete) { var freteModel = FreteModel.Transform(frete); var sql = ActiveRecord.Update(freteModel); using (var contexto = new Contexto()) { contexto.ExecutaComando(sql); } }
public void logicalDelete(ActiveRecord item) { UpdateQuery query = new UpdateQuery(item.GetType()); query.addKeyValue("estado", "0"); query.addWhere("id", item.id.ToString()); Console.WriteLine(query.build()); query.exec(); }
private void Editar(DTORota rota) { var transporteModel = RotaModel.Transform(rota); var sql = ActiveRecord.Update(transporteModel); using (var contexto = new Contexto()) { contexto.ExecutaComando(sql); } }
public void RemoteTwitchLogin(Security s, string username, ref string pCode) { if (username.ToLower().EndsWith("@beweb.co.nz")) { var remoteLogin = "******"; var isRemoteLoginOnline = false; try { var twitchKey = Util.GetSetting("TwitchKey", "dsigbsd9uFSdsg897gasiu%%$#*gas79%*gakisfaf"); remoteLogin = Http.Get("http://twitch.beweb.co.nz/Security/RemoteLogin?EncEmail=" + Crypto.Encrypt(username, twitchKey) + "&EncPassword="******"&EncRemembered=" + Crypto.Encrypt(Crypto.Decrypt(pCode), twitchKey)); isRemoteLoginOnline = true; } catch { } var localPerson = new ActiveRecord(Security.PersonTableName, Security.PersonTableName + "ID"); var personExists = localPerson.LoadData(new Sql("where Email = ", username.SqlizeText())); // If twitch is online and rejects the user login, then setup to fail the login if (isRemoteLoginOnline && remoteLogin == "Failed") { pCode = "invalid user " + Crypto.Random(); s.ResultMessage = "Invalid Twitch login"; if (personExists) { localPerson["IsActive"].ValueObject = false; localPerson.Save(); } } if (remoteLogin != "Failed") { if (!personExists) { localPerson["FirstName"].ValueObject = remoteLogin.Split("|")[0]; localPerson["LastName"].ValueObject = remoteLogin.Split("|")[1] + "*"; localPerson["Email"].ValueObject = username; localPerson["Role"].ValueObject = "administrators,superadmins,developers"; localPerson["Password"].ValueObject = Security.CreateSecuredPassword(RandomPassword.Generate(5, 7)); localPerson["IsActive"].ValueObject = true; localPerson.Save(); s.ResultMessage = "Logged in via Twitch"; } else { // log user in with existing account localPerson["IsActive"].ValueObject = true; localPerson.Save(); s.ResultMessage = "Logged in via Twitch, using local person"; } pCode = Security.DecryptPassword(localPerson["Password"].ToString()); } } }
public int insert(ActiveRecord item) { item.preInsert(); InsertQuery query = new InsertQuery(item.GetType()); foreach (KeyValuePair <string, string> properties in getProperties(item)) { query.addKeyValue(properties.Key, properties.Value); } return(query.exec()); }
/// <summary> /// The Subscribe page must call this function if Request["optin"]!=null to provide the completion of double opt in. /// </summary> /// <example>if (Request["optin"]!=null) { Models.TextBlock myTextBlock = VerificationLinkClicked(Request["optin"]) }</example> /// <param name="optInCode">You need to pass in Request["optin"]</param> /// <returns>Returns a Models.TextBlock containing the title and body text to be displayed to the user</returns> public static Models.TextBlock VerificationLinkClicked(string optInCode) { Models.TextBlock textBlock; //Web.Write("optinCode: "+Crypto.DecryptID(optInCode)); //Web.End(); //var person = Person.LoadID(Crypto.DecryptID(optInCode)); var person = new ActiveRecord <int>("Person", "PersonID"); AssertFieldsExist(person); bool exists = person.LoadID(Crypto.DecryptID(optInCode)); if (!exists) { // not on database, show error // get text to display on screen textBlock = Models.TextBlock.LoadBySectionCode("Double_OptIn_Error"); // create if not found if (textBlock == null) { textBlock = new Models.TextBlock { SectionCode = "Double_OptIn_Error", Title = "Problem with confirmation link", IsTitleAvailable = true, IsBodyPlainText = false, BodyTextHtml = "Sorry, the link you clicked did not work. Your record was not found in our database.<br><br>If you would like to subscribe to our email newsletter, please use the subscribe panel on the right and try the process again." }; textBlock.Save(); } } else { // opt in person["SubscribeDate"].ValueObject = DateTime.Now; person["HasValidatedEmail"].ValueObject = true; person.Save(); // get text to display on screen textBlock = Models.TextBlock.LoadBySectionCode("Double_OptIn_Confirmed"); // create if not found if (textBlock == null) { textBlock = new Models.TextBlock { SectionCode = "Double_OptIn_Confirmed", IsBodyPlainText = false, IsTitleAvailable = true, Title = "Subscribe Confirmed", BodyTextHtml = "Thanks very much for confirming your subscription.<br><br>You are now subscribed to our email newsletter." }; textBlock.Save(); } } return(textBlock); }
/// <summary> /// prepare each field for save /// </summary> /// <param name="record"></param> public virtual void PrepareForSave(ActiveRecord record) { if (IsDateField && Name == "DateModified") { ValueObject = DateTime.Now; } else if (IsDateField && Name == "DateAdded" && record.IsNewRecord) { ValueObject = DateTime.Now; } }
public void Excluir(int id) { var freteModel = new FreteModel { Id = id.ToString() }; var sql = ActiveRecord.Delete(freteModel); using (var contexto = new Contexto()) { contexto.ExecutaComando(sql); } }
protected void CheckLock(ActiveRecord record) { if (record == null) { return; } lockobj.InitLocking(Security.LoggedInUserID); if (!lockobj.LockTable(record.GetTableName(), (record[record.GetPrimaryKeyName()] + "").ToIntOrDie(), record.GetName())) { Web.ErrorMessage = lockobj.LockMessage; } }
public int update(ActiveRecord item) { UpdateQuery query = new UpdateQuery(item.GetType()); foreach (KeyValuePair <string, string> properties in getProperties(item)) { query.addKeyValue(properties.Key, properties.Value); } query.addWhere("id", item.id.ToString()); Console.WriteLine(query.build()); return(query.exec()); }
public static Dictionary<string, object> GetData(ActiveRecord inst) { var t = inst.GetType(); if (!rowCreators.ContainsKey(t)) throw new Exception("No creator has been added for Type [" + t.FullName + "]"); var rc = rowCreators[t]; if( rc.GetDataFunction == null ) throw new Exception( "No {GetData} Delegate has been added for Type [" + t.FullName + "]" ); return rowCreators[t].GetDataFunction(inst); }
public static void InitialzeAR() { XmlConfigurator.Configure(); if (!ActiveRecordStarter.IsInitialized) { var activeRecord = new ActiveRecord(); activeRecord.Assemblies = activeRecord.Assemblies.Concat(new[] { "Test.Support" }).ToArray(); activeRecord.Initialize(ActiveRecordSectionHandler.Instance); var admin = new Seed().Run(); SecurityContext.GetAdministrator = () => admin; Administrator.GetHost = () => "localhost"; } }
public static void AddPhrase(ActiveRecord record, string phrase = null, bool splitPhrase = false, string delimiter = ",") { if (phrase == null) { phrase = record.GetName(); } if (record.GetIsActive()) { AddPhrase(record.GetTableName(), record.ID_Field.ToInt(), phrase, splitPhrase, delimiter); } else { DeletePhrase(record); } }
public void save(ActiveRecord item) { item.preSave(); if (item.id != 0) { this.update(item); } else { item.id = this.insert(item); } item.afterSave(); }
/// <summary> /// Аутентификация пользователя /// </summary> private void LoginClick(object obj) { RowMapper <User> rowMapper = RowMapper; ActiveRecord <User> dao = new ActiveRecord <User>("User", rowMapper); User us = dao.Select(Login); if (us != null) { User.SharedUser = us; MenuWindow menu = new MenuWindow(); MenuViewModel viewModel = new MenuViewModel(menu); menu.DataContext = viewModel; menu.Show(); } }
public static bool InCache(ActiveRecord record) { return cache.ContainsKey(GetCacheKey(record)); }
private static string GetCacheKey(ActiveRecord record) { return record.GetType().Name + " " + record.Id; }
public static List<Person> GetContacts(ActiveRecord obj) { return ActiveRecord.Find<Person>("AssociatedKey", obj.GetType().Name + " " + obj.Id); }
public bool SetAssociatedKey(ActiveRecord obj) { return obj != null ? (AssociatedKey = obj.GetType().Name + " " + obj.Id) != null : false; }
public void SetUDT(ActiveRecord rec) { this._target = rec; this.FillData(); }
public Sync() { this.snackthatClient = new SnackthatServiceClient.SnackthatServiceSoapClient(); this.aR = new ActiveRecord(); }
public void receiveData(int idSeller) { try { Clients.addMessage(0); this.snackthatClient = new SnackthatServiceClient.SnackthatServiceSoapClient(); this.aR = new ActiveRecord(); Clients.addMessage(5); DataTable dtUsers = this.snackthatClient.getSellers(); if (dtUsers != null) { this.aR.callProcedure("deleteUsers"); for (int i = 0; i < dtUsers.Rows.Count; i++) { ArrayList parametersUser = new ArrayList(); parametersUser.Add(dtUsers.Rows[i].ItemArray[0].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[1].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[2].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[3].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[4].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[5].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[6].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[7].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[8].ToString()); parametersUser.Add(dtUsers.Rows[i].ItemArray[9].ToString()); this.aR.callProcedure("setUser", parametersUser); } } Clients.addMessage(15); DataTable dtProducts = this.snackthatClient.getProductsBySeller(idSeller); Clients.addMessage(25); if (dtProducts != null) { this.aR.callProcedure("deleteProductsContent"); Clients.addMessage(30); for (int i = 0; i < dtProducts.Rows.Count; i++) { ArrayList parametersProduct = new ArrayList(); parametersProduct.Add(dtProducts.Rows[i].ItemArray[0].ToString()); //ID parametersProduct.Add(dtProducts.Rows[i].ItemArray[2].ToString()); //Presentation parametersProduct.Add(dtProducts.Rows[i].ItemArray[1].ToString()); //Name parametersProduct.Add(dtProducts.Rows[i].ItemArray[5].ToString()); //Amount parametersProduct.Add(dtProducts.Rows[i].ItemArray[3].ToString()); //Price parametersProduct.Add(HttpUtility.HtmlDecode(dtProducts.Rows[i].ItemArray[4].ToString())); //Description this.aR.callProcedure("setProduct", parametersProduct); } } Clients.addMessage(50); DataTable dtRoute = this.snackthatClient.getRouteBySeller(idSeller); //id ArrayList parametersRoute = new ArrayList(); Clients.addMessage(65); if (dtRoute != null) { parametersRoute.Add(dtRoute.Rows[0].ItemArray[0].ToString()); //ID parametersRoute.Add(dtRoute.Rows[0].ItemArray[1].ToString()); //Name this.aR.callProcedure("setRoute", parametersRoute); } Clients.addMessage(75); DataTable dtCustomers = this.snackthatClient.getCustomersByRoute(int.Parse(parametersRoute[0].ToString())); //id Clients.addMessage(80); if (dtCustomers != null) { for (int i = 0; i < dtCustomers.Rows.Count; i++) { ArrayList parametersCustomer = new ArrayList(); parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[0].ToString()); //IdCustomer parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[1].ToString()); //Name parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[2].ToString()); //LastName parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[3].ToString()); //eMail parametersCustomer.Add(dtCustomers.Rows[i].ItemArray[4].ToString()); //RFC //Parametros de la tabla addressescustomer ArrayList parametersCustomerAddresses = new ArrayList(); parametersCustomerAddresses.Add(dtCustomers.Rows[i].ItemArray[5].ToString()); //IdAddressCustomer parametersCustomerAddresses.Add(dtCustomers.Rows[i].ItemArray[6].ToString()); //IdCustomer parametersCustomerAddresses.Add(dtCustomers.Rows[i].ItemArray[7].ToString()); //Address parametersCustomerAddresses.Add(dtCustomers.Rows[i].ItemArray[8].ToString()); //Phone //Parametros de la tabla customersroutes ArrayList parametersRouteCustomers = new ArrayList(); parametersRouteCustomers.Add(dtCustomers.Rows[i].ItemArray[9].ToString()); //IdCustomerRoute parametersRouteCustomers.Add(dtCustomers.Rows[i].ItemArray[10].ToString()); //IdRoute parametersRouteCustomers.Add(dtCustomers.Rows[i].ItemArray[11].ToString()); //IdAddressCustomer parametersRouteCustomers.Add(dtCustomers.Rows[i].ItemArray[12].ToString()); //EstimatedTime try { parametersRouteCustomers[parametersRouteCustomers.Count - 1] = Convert.ToDateTime(parametersRouteCustomers[parametersRouteCustomers.Count - 1].ToString()); } catch (Exception ex) { parametersRouteCustomers[parametersRouteCustomers.Count - 1] = null; } //Se llenan las tablas de customer, addressescustomers y customersroutes this.aR.callProcedure("setCustomer", parametersCustomer); this.aR.callProcedure("setAddressesCustomer", parametersCustomerAddresses); this.aR.callProcedure("setCustomersRoutes", parametersRouteCustomers); } Clients.addMessage(100); } } catch (System.ServiceModel.EndpointNotFoundException ex) { Clients.addMessage(1000); } catch (Exception ex) { Clients.addMessage(3000); } }
// Generates content of documentSettingsPart1. private void GenerateDocumentSettingsPart1Content(DocumentSettingsPart documentSettingsPart1) { Settings settings1 = new Settings() {MCAttributes = new MarkupCompatibilityAttributes() {Ignorable = "w14"}}; settings1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); settings1.AddNamespaceDeclaration("o", "urn:schemas-microsoft-com:office:office"); settings1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); settings1.AddNamespaceDeclaration("m", "http://schemas.openxmlformats.org/officeDocument/2006/math"); settings1.AddNamespaceDeclaration("v", "urn:schemas-microsoft-com:vml"); settings1.AddNamespaceDeclaration("w10", "urn:schemas-microsoft-com:office:word"); settings1.AddNamespaceDeclaration("w", "http://schemas.openxmlformats.org/wordprocessingml/2006/main"); settings1.AddNamespaceDeclaration("w14", "http://schemas.microsoft.com/office/word/2010/wordml"); settings1.AddNamespaceDeclaration("sl", "http://schemas.openxmlformats.org/schemaLibrary/2006/main"); Zoom zoom1 = new Zoom() {Percent = "100"}; ProofState proofState1 = new ProofState() {Spelling = ProofingStateValues.Clean, Grammar = ProofingStateValues.Clean}; MailMerge mailMerge1 = new MailMerge(); MainDocumentType mainDocumentType1 = new MainDocumentType() {Val = MailMergeDocumentValues.FormLetter}; DataType dataType1 = new DataType() {Val = MailMergeDataValues.TextFile}; ActiveRecord activeRecord1 = new ActiveRecord() {Val = -1}; mailMerge1.Append(mainDocumentType1); mailMerge1.Append(dataType1); mailMerge1.Append(activeRecord1); DefaultTabStop defaultTabStop1 = new DefaultTabStop() {Val = 720}; CharacterSpacingControl characterSpacingControl1 = new CharacterSpacingControl() {Val = CharacterSpacingValues.DoNotCompress}; HeaderShapeDefaults headerShapeDefaults1 = new HeaderShapeDefaults(); Ovml.ShapeDefaults shapeDefaults1 = new Ovml.ShapeDefaults() {Extension = V.ExtensionHandlingBehaviorValues.Edit, MaxShapeId = 6145}; headerShapeDefaults1.Append(shapeDefaults1); FootnoteDocumentWideProperties footnoteDocumentWideProperties1 = new FootnoteDocumentWideProperties(); FootnoteSpecialReference footnoteSpecialReference1 = new FootnoteSpecialReference() {Id = -1}; FootnoteSpecialReference footnoteSpecialReference2 = new FootnoteSpecialReference() {Id = 0}; footnoteDocumentWideProperties1.Append(footnoteSpecialReference1); footnoteDocumentWideProperties1.Append(footnoteSpecialReference2); EndnoteDocumentWideProperties endnoteDocumentWideProperties1 = new EndnoteDocumentWideProperties(); EndnoteSpecialReference endnoteSpecialReference1 = new EndnoteSpecialReference() {Id = -1}; EndnoteSpecialReference endnoteSpecialReference2 = new EndnoteSpecialReference() {Id = 0}; endnoteDocumentWideProperties1.Append(endnoteSpecialReference1); endnoteDocumentWideProperties1.Append(endnoteSpecialReference2); Compatibility compatibility1 = new Compatibility(); CompatibilitySetting compatibilitySetting1 = new CompatibilitySetting() { Name = CompatSettingNameValues.CompatibilityMode, Uri = "http://schemas.microsoft.com/office/word", Val = "14" }; CompatibilitySetting compatibilitySetting2 = new CompatibilitySetting() { Name = CompatSettingNameValues.OverrideTableStyleFontSizeAndJustification, Uri = "http://schemas.microsoft.com/office/word", Val = "1" }; CompatibilitySetting compatibilitySetting3 = new CompatibilitySetting() { Name = CompatSettingNameValues.EnableOpenTypeFeatures, Uri = "http://schemas.microsoft.com/office/word", Val = "1" }; CompatibilitySetting compatibilitySetting4 = new CompatibilitySetting() { Name = CompatSettingNameValues.DoNotFlipMirrorIndents, Uri = "http://schemas.microsoft.com/office/word", Val = "1" }; compatibility1.Append(compatibilitySetting1); compatibility1.Append(compatibilitySetting2); compatibility1.Append(compatibilitySetting3); compatibility1.Append(compatibilitySetting4); Rsids rsids1 = new Rsids(); RsidRoot rsidRoot1 = new RsidRoot() {Val = "002307CA"}; Rsid rsid25 = new Rsid() {Val = "00021925"}; Rsid rsid26 = new Rsid() {Val = "0005059E"}; Rsid rsid27 = new Rsid() {Val = "002307CA"}; Rsid rsid28 = new Rsid() {Val = "00267818"}; Rsid rsid29 = new Rsid() {Val = "002E2CE3"}; Rsid rsid30 = new Rsid() {Val = "00367B71"}; Rsid rsid31 = new Rsid() {Val = "003C716F"}; Rsid rsid32 = new Rsid() {Val = "00442AD3"}; Rsid rsid33 = new Rsid() {Val = "00485B24"}; Rsid rsid34 = new Rsid() {Val = "004B0395"}; Rsid rsid35 = new Rsid() {Val = "005A7CCB"}; Rsid rsid36 = new Rsid() {Val = "00664E23"}; Rsid rsid37 = new Rsid() {Val = "006D0F9D"}; Rsid rsid38 = new Rsid() {Val = "006F12E1"}; Rsid rsid39 = new Rsid() {Val = "00731A43"}; Rsid rsid40 = new Rsid() {Val = "00736D14"}; Rsid rsid41 = new Rsid() {Val = "007977E5"}; Rsid rsid42 = new Rsid() {Val = "007B10F8"}; Rsid rsid43 = new Rsid() {Val = "007C67E7"}; Rsid rsid44 = new Rsid() {Val = "00960953"}; Rsid rsid45 = new Rsid() {Val = "009F02C7"}; Rsid rsid46 = new Rsid() {Val = "00A056C7"}; Rsid rsid47 = new Rsid() {Val = "00B32099"}; Rsid rsid48 = new Rsid() {Val = "00B92CF0"}; Rsid rsid49 = new Rsid() {Val = "00BC57A3"}; Rsid rsid50 = new Rsid() {Val = "00BE6B68"}; Rsid rsid51 = new Rsid() {Val = "00BF235B"}; Rsid rsid52 = new Rsid() {Val = "00BF5126"}; Rsid rsid53 = new Rsid() {Val = "00C91302"}; Rsid rsid54 = new Rsid() {Val = "00CA68EB"}; Rsid rsid55 = new Rsid() {Val = "00E33AA1"}; Rsid rsid56 = new Rsid() {Val = "00E40D36"}; Rsid rsid57 = new Rsid() {Val = "00E7460D"}; Rsid rsid58 = new Rsid() {Val = "00E95156"}; Rsid rsid59 = new Rsid() {Val = "00F06304"}; Rsid rsid60 = new Rsid() {Val = "00FA5EBC"}; Rsid rsid61 = new Rsid() {Val = "00FB1F22"}; rsids1.Append(rsidRoot1); rsids1.Append(rsid25); rsids1.Append(rsid26); rsids1.Append(rsid27); rsids1.Append(rsid28); rsids1.Append(rsid29); rsids1.Append(rsid30); rsids1.Append(rsid31); rsids1.Append(rsid32); rsids1.Append(rsid33); rsids1.Append(rsid34); rsids1.Append(rsid35); rsids1.Append(rsid36); rsids1.Append(rsid37); rsids1.Append(rsid38); rsids1.Append(rsid39); rsids1.Append(rsid40); rsids1.Append(rsid41); rsids1.Append(rsid42); rsids1.Append(rsid43); rsids1.Append(rsid44); rsids1.Append(rsid45); rsids1.Append(rsid46); rsids1.Append(rsid47); rsids1.Append(rsid48); rsids1.Append(rsid49); rsids1.Append(rsid50); rsids1.Append(rsid51); rsids1.Append(rsid52); rsids1.Append(rsid53); rsids1.Append(rsid54); rsids1.Append(rsid55); rsids1.Append(rsid56); rsids1.Append(rsid57); rsids1.Append(rsid58); rsids1.Append(rsid59); rsids1.Append(rsid60); rsids1.Append(rsid61); M.MathProperties mathProperties1 = new M.MathProperties(); M.MathFont mathFont1 = new M.MathFont() {Val = "Cambria Math"}; M.BreakBinary breakBinary1 = new M.BreakBinary() {Val = M.BreakBinaryOperatorValues.Before}; M.BreakBinarySubtraction breakBinarySubtraction1 = new M.BreakBinarySubtraction() {Val = M.BreakBinarySubtractionValues.MinusMinus}; M.SmallFraction smallFraction1 = new M.SmallFraction() {Val = M.BooleanValues.Zero}; M.DisplayDefaults displayDefaults1 = new M.DisplayDefaults(); M.LeftMargin leftMargin1 = new M.LeftMargin() {Val = (UInt32Value) 0U}; M.RightMargin rightMargin1 = new M.RightMargin() {Val = (UInt32Value) 0U}; M.DefaultJustification defaultJustification1 = new M.DefaultJustification() {Val = M.JustificationValues.CenterGroup}; M.WrapIndent wrapIndent1 = new M.WrapIndent() {Val = (UInt32Value) 1440U}; M.IntegralLimitLocation integralLimitLocation1 = new M.IntegralLimitLocation() {Val = M.LimitLocationValues.SubscriptSuperscript}; M.NaryLimitLocation naryLimitLocation1 = new M.NaryLimitLocation() {Val = M.LimitLocationValues.UnderOver}; mathProperties1.Append(mathFont1); mathProperties1.Append(breakBinary1); mathProperties1.Append(breakBinarySubtraction1); mathProperties1.Append(smallFraction1); mathProperties1.Append(displayDefaults1); mathProperties1.Append(leftMargin1); mathProperties1.Append(rightMargin1); mathProperties1.Append(defaultJustification1); mathProperties1.Append(wrapIndent1); mathProperties1.Append(integralLimitLocation1); mathProperties1.Append(naryLimitLocation1); ThemeFontLanguages themeFontLanguages1 = new ThemeFontLanguages() {Val = "en-US"}; ColorSchemeMapping colorSchemeMapping1 = new ColorSchemeMapping() { Background1 = ColorSchemeIndexValues.Light1, Text1 = ColorSchemeIndexValues.Dark1, Background2 = ColorSchemeIndexValues.Light2, Text2 = ColorSchemeIndexValues.Dark2, Accent1 = ColorSchemeIndexValues.Accent1, Accent2 = ColorSchemeIndexValues.Accent2, Accent3 = ColorSchemeIndexValues.Accent3, Accent4 = ColorSchemeIndexValues.Accent4, Accent5 = ColorSchemeIndexValues.Accent5, Accent6 = ColorSchemeIndexValues.Accent6, Hyperlink = ColorSchemeIndexValues.Hyperlink, FollowedHyperlink = ColorSchemeIndexValues.FollowedHyperlink }; ShapeDefaults shapeDefaults2 = new ShapeDefaults(); Ovml.ShapeDefaults shapeDefaults3 = new Ovml.ShapeDefaults() {Extension = V.ExtensionHandlingBehaviorValues.Edit, MaxShapeId = 6145}; Ovml.ShapeLayout shapeLayout1 = new Ovml.ShapeLayout() {Extension = V.ExtensionHandlingBehaviorValues.Edit}; Ovml.ShapeIdMap shapeIdMap1 = new Ovml.ShapeIdMap() {Extension = V.ExtensionHandlingBehaviorValues.Edit, Data = "1"}; shapeLayout1.Append(shapeIdMap1); shapeDefaults2.Append(shapeDefaults3); shapeDefaults2.Append(shapeLayout1); DecimalSymbol decimalSymbol1 = new DecimalSymbol() {Val = "."}; ListSeparator listSeparator1 = new ListSeparator() {Val = ","}; settings1.Append(zoom1); settings1.Append(proofState1); settings1.Append(mailMerge1); settings1.Append(defaultTabStop1); settings1.Append(characterSpacingControl1); settings1.Append(headerShapeDefaults1); settings1.Append(footnoteDocumentWideProperties1); settings1.Append(endnoteDocumentWideProperties1); settings1.Append(compatibility1); settings1.Append(rsids1); settings1.Append(mathProperties1); settings1.Append(themeFontLanguages1); settings1.Append(colorSchemeMapping1); settings1.Append(shapeDefaults2); settings1.Append(decimalSymbol1); settings1.Append(listSeparator1); documentSettingsPart1.Settings = settings1; }
public static void AddToCache(ActiveRecord record) { cache[GetCacheKey(record)] = record; }
/// <summary> /// Constructor of the class, initialize the instance of the ActiveRecord Object /// </summary> public Data() { this.aR = new ActiveRecord(); }
public void sendData() { try { Clients.addMessage(0); this.snackthatClient = new SnackthatServiceClient.SnackthatServiceSoapClient(); this.aR = new ActiveRecord(); Clients.addMessage(25); DataTable dt = new Customers().getAllCustomers(1); DataTable route = new Routes().getAllRoutes(); Clients.addMessage(50); dt.TableName = "ClientesChofer"; this.snackthatClient.setCustomers(dt, Convert.ToInt16(route.Rows[0].ItemArray[0].ToString())); DataTable dtProducts = new Products().getAllProducts(), dtSells = this.aR.callProcedure("getAllSells"), dtProductsSells = this.aR.callProcedure("getAllProductsSell"); Clients.addMessage(75); dtProducts.TableName = "Productos"; dtSells.TableName = "RegistroVentas"; dtProductsSells.TableName = "ProductsSells"; this.snackthatClient.setSells(dtProducts, dtSells, dtProductsSells, Convert.ToInt16(route.Rows[0].ItemArray[0].ToString())); Clients.addMessage(90); this.aR.callProcedure("cleanAll"); Clients.addMessage(100); } catch (System.ServiceModel.EndpointNotFoundException ex) { Clients.addMessage(1000); } catch (Exception ex) { Clients.addMessage(2000); } }