/// <summary> /// Default constructor (new) /// </summary> public frmEmailEdit() { // Required for Windows Form Designer support InitializeComponent(); m_UpdateAction = false; CurrentID = new DBGuid(Guid.NewGuid()); m_IsNewsMail = true; pHeader.Text2 = "Új hírlevél létrehozása"; m_currentMail = new Email(CurrentID); }
public List <RegionData> RunCommand(MySqlCommand cmd) { List <RegionData> retList = new List <RegionData>(); using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) { dbcon.Open(); cmd.Connection = dbcon; using (IDataReader result = cmd.ExecuteReader()) { while (result.Read()) { RegionData ret = new RegionData(); ret.Data = new Dictionary <string, object>(); ret.RegionID = DBGuid.FromDB(result["uuid"]); ret.ScopeID = DBGuid.FromDB(result["ScopeID"]); ret.RegionName = result["regionName"].ToString(); ret.posX = Convert.ToInt32(result["locX"]); ret.posY = Convert.ToInt32(result["locY"]); ret.sizeX = Convert.ToInt32(result["sizeX"]); ret.sizeY = Convert.ToInt32(result["sizeY"]); if (m_ColumnNames == null) { m_ColumnNames = new List <string>(); DataTable schemaTable = result.GetSchemaTable(); foreach (DataRow row in schemaTable.Rows) { if (row["ColumnName"] != null) { m_ColumnNames.Add(row["ColumnName"].ToString()); } } } foreach (string s in m_ColumnNames) { if (s == "uuid") { continue; } if (s == "ScopeID") { continue; } if (s == "regionName") { continue; } if (s == "locX") { continue; } if (s == "locY") { continue; } ret.Data[s] = result[s].ToString(); } retList.Add(ret); } } } return(retList); }
/// <summary> /// Remove a NewsPicture from the list. /// </summary> private void RemoveFile() { DBGuid ID = new DBGuid(); ID.Value = dtgFiles.GetSelectedRowCell("ID"); if (ID.IsNull) { MessageBox.Show("Válasszon eltávolítani kívánt fájlt a listában!", "NDI HelpDesk Adminisztrátor", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } try { // Logical undelete source item EmailAttachment selected = (EmailAttachment) m_currentMail.EmailAttachments[ID.ToString()]; m_currentMail.EmailAttachments.Delete(selected); // Refresh grid FillDatagrid(DBGuid.Null); } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Nem várt hiba lépett fel a fájl eltávolítása során.", ex); } }
// ------------------------------------------------------------------------------------- /// <summary> /// Fill datagrid with data, get relations for keyword /// </summary> // ------------------------------------------------------------------------------------- private void FillDatagrid(DBGuid ID) { try { if (tabPageAttachment == null) { return; } string sortColumn = "Name"; int selectedRow = -1; // Storing the previous sort order if (dtgFiles.DataSource != null) { sortColumn = ((DataTable) dtgFiles.DataSource).DefaultView.Sort; } if (m_currentMail.EmailAttachments != null) { DataTable dt = m_currentMail.EmailAttachments.CurrentAsDatatable; dt.DefaultView.Sort = sortColumn; dtgFiles.DataSource = dt; // locates the row specified by ID param if (! ID.IsNull && dtgFiles.BindingContext != null) { BindingManagerBase bm = dtgFiles.BindingContext[dtgFiles.DataSource, dtgFiles.DataMember]; DataRow dr; int nPositionStart = bm.Position; for (int i = 0; i < bm.Count; i++) { dr = ((DataRowView) bm.Current).Row; if (ID.Value.Equals(dr["ID"])) { selectedRow = i; break; } bm.Position += 1; } bm.Position = nPositionStart; } // makes the row selected if (selectedRow <= ((DataTable) dtgFiles.DataSource).DefaultView.Count && selectedRow > -1) { dtgFiles.Select(selectedRow); dtgFiles.CurrentRowIndex = selectedRow; } } } catch (Exception ex) { // --- Log exception ExceptionManager.Publish(ex); // --- Display Exception ErrorHandler.DisplayError("Nem várt hiba a lista frissítése során.", ex); } }
/// <summary> /// Edit constructor /// </summary> public frmEmailEdit(DBGuid ID) { // Required for Windows Form Designer support InitializeComponent(); m_UpdateAction = true; CurrentID = ID; pHeader.Text2 = "Hírlevél szerkesztése"; }
protected T[] DoQuery(MySqlCommand cmd) { List <T> result = new List <T>(); using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) { dbcon.Open(); cmd.Connection = dbcon; using (IDataReader reader = cmd.ExecuteReader()) { if (reader == null) { return(new T[0]); } CheckColumnNames(reader); while (reader.Read()) { T row = new T(); foreach (string name in m_Fields.Keys) { if (reader[name] is DBNull) { continue; } if (m_Fields[name].FieldType == typeof(bool)) { int v = Convert.ToInt32(reader[name]); m_Fields[name].SetValue(row, v != 0 ? true : false); } else if (m_Fields[name].FieldType == typeof(UUID)) { m_Fields[name].SetValue(row, DBGuid.FromDB(reader[name])); } else if (m_Fields[name].FieldType == typeof(int)) { int v = Convert.ToInt32(reader[name]); m_Fields[name].SetValue(row, v); } else { m_Fields[name].SetValue(row, reader[name]); } } if (m_DataField != null) { Dictionary <string, string> data = new Dictionary <string, string>(); foreach (string col in m_ColumnNames) { data[col] = reader[col].ToString(); if (data[col] == null) { data[col] = String.Empty; } } m_DataField.SetValue(row, data); } result.Add(row); } } } return(result.ToArray()); }
public bool GetAvatarProperties(ref UserProfileProperties props, ref string result) { string query = string.Empty; query += "SELECT * FROM userprofile WHERE "; query += "useruuid = :Id"; try { using (NpgsqlConnection dbcon = new NpgsqlConnection(ConnectionString)) { dbcon.Open(); using (NpgsqlCommand cmd = new NpgsqlCommand(query, dbcon)) { cmd.Parameters.Add(m_database.CreateParameter("Id", props.UserId)); using (NpgsqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow)) { if (reader.HasRows) { // m_log.DebugFormat("[PROFILES_DATA]" + // ": Getting data for {0}.", props.UserId); reader.Read(); props.WebUrl = (string)reader["profileURL"].ToString(); props.ImageId = DBGuid.FromDB(reader["profileImage"]); props.AboutText = (string)reader["profileAboutText"]; props.FirstLifeImageId = DBGuid.FromDB(reader["profileFirstImage"]); props.FirstLifeText = (string)reader["profileFirstText"]; props.PartnerId = DBGuid.FromDB(reader["profilePartner"]); props.WantToMask = (int)reader["profileWantToMask"]; props.WantToText = (string)reader["profileWantToText"]; props.SkillsMask = (int)reader["profileSkillsMask"]; props.SkillsText = (string)reader["profileSkillsText"]; props.Language = (string)reader["profileLanguages"]; } else { //m_log.DebugFormat("[PROFILES_DATA]" + // ": No data for {0}", props.UserId); props.WebUrl = string.Empty; props.ImageId = UUID.Zero; props.AboutText = string.Empty; props.FirstLifeImageId = UUID.Zero; props.FirstLifeText = string.Empty; props.PartnerId = UUID.Zero; props.WantToMask = 0; props.WantToText = string.Empty; props.SkillsMask = 0; props.SkillsText = string.Empty; props.Language = string.Empty; props.PublishProfile = false; props.PublishMature = false; query = "INSERT INTO userprofile ("; query += "useruuid, "; query += "\"profilePartner\", "; query += "\"profileAllowPublish\", "; query += "\"profileMaturePublish\", "; query += "\"profileURL\", "; query += "\"profileWantToMask\", "; query += "\"profileWantToText\", "; query += "\"profileSkillsMask\", "; query += "\"profileSkillsText\", "; query += "\"profileLanguages\", "; query += "\"profileImage\", "; query += "\"profileAboutText\", "; query += "\"profileFirstImage\", "; query += "\"profileFirstText\") VALUES ("; query += ":userId, "; query += ":profilePartner, "; query += ":profileAllowPublish, "; query += ":profileMaturePublish, "; query += ":profileURL, "; query += ":profileWantToMask, "; query += ":profileWantToText, "; query += ":profileSkillsMask, "; query += ":profileSkillsText, "; query += ":profileLanguages, "; query += ":profileImage, "; query += ":profileAboutText, "; query += ":profileFirstImage, "; query += ":profileFirstText)"; dbcon.Close(); dbcon.Open(); using (NpgsqlCommand put = new NpgsqlCommand(query, dbcon)) { //m_log.DebugFormat("[PROFILES_DATA]" + // ": Adding new data for {0}", props.UserId); put.Parameters.Add(m_database.CreateParameter("userId", props.UserId)); put.Parameters.Add(m_database.CreateParameter("profilePartner", props.PartnerId)); put.Parameters.Add(m_database.CreateParameter("profileAllowPublish", props.PublishProfile)); put.Parameters.Add(m_database.CreateParameter("profileMaturePublish", props.PublishMature)); put.Parameters.Add(m_database.CreateParameter("profileURL", props.WebUrl)); put.Parameters.Add(m_database.CreateParameter("profileWantToMask", props.WantToMask)); put.Parameters.Add(m_database.CreateParameter("profileWantToText", props.WantToText)); put.Parameters.Add(m_database.CreateParameter("profileSkillsMask", props.SkillsMask)); put.Parameters.Add(m_database.CreateParameter("profileSkillsText", props.SkillsText)); put.Parameters.Add(m_database.CreateParameter("profileLanguages", props.Language)); put.Parameters.Add(m_database.CreateParameter("profileImage", props.ImageId)); put.Parameters.Add(m_database.CreateParameter("profileAboutText", props.AboutText)); put.Parameters.Add(m_database.CreateParameter("profileFirstImage", props.FirstLifeImageId)); put.Parameters.Add(m_database.CreateParameter("profileFirstText", props.FirstLifeText)); put.ExecuteNonQuery(); } } } } } } catch (Exception e) { m_log.Error("[PROFILES_DATA]: GetAvatarProperties exception ", e); result = e.Message; return(false); } return(true); }
private EstateSettings DoLoad(MySqlCommand cmd, UUID regionID, bool create) { EstateSettings es = new EstateSettings(); es.OnSave += StoreEstateSettings; using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) { dbcon.Open(); cmd.Connection = dbcon; bool found = false; using (IDataReader r = cmd.ExecuteReader()) { if (r.Read()) { found = true; foreach (string name in FieldList) { if (m_FieldMap[name].FieldType == typeof(bool)) { m_FieldMap[name].SetValue(es, Convert.ToInt32(r[name]) != 0); } else if (m_FieldMap[name].FieldType == typeof(UUID)) { m_FieldMap[name].SetValue(es, DBGuid.FromDB(r[name])); } else { m_FieldMap[name].SetValue(es, r[name]); } } } } if (!found && create) { // Migration case List <string> names = new List <string>(FieldList); names.Remove("EstateID"); string sql = "insert into estate_settings (" + String.Join(",", names.ToArray()) + ") values ( ?" + String.Join(", ?", names.ToArray()) + ")"; using (MySqlCommand cmd2 = dbcon.CreateCommand()) { cmd2.CommandText = sql; cmd2.Parameters.Clear(); foreach (string name in FieldList) { if (m_FieldMap[name].GetValue(es) is bool) { if ((bool)m_FieldMap[name].GetValue(es)) { cmd2.Parameters.AddWithValue("?" + name, "1"); } else { cmd2.Parameters.AddWithValue("?" + name, "0"); } } else { cmd2.Parameters.AddWithValue("?" + name, m_FieldMap[name].GetValue(es).ToString()); } } cmd2.ExecuteNonQuery(); cmd2.CommandText = "select LAST_INSERT_ID() as id"; cmd2.Parameters.Clear(); using (IDataReader r = cmd2.ExecuteReader()) { r.Read(); es.EstateID = Convert.ToUInt32(r["id"]); } cmd2.CommandText = "insert into estate_map values (?RegionID, ?EstateID)"; cmd2.Parameters.AddWithValue("?RegionID", regionID.ToString()); cmd2.Parameters.AddWithValue("?EstateID", es.EstateID.ToString()); // This will throw on dupe key try { cmd2.ExecuteNonQuery(); } catch (Exception) { } es.Save(); } } } LoadBanList(es); es.EstateManagers = LoadUUIDList(es.EstateID, "estate_managers"); es.EstateAccess = LoadUUIDList(es.EstateID, "estate_users"); es.EstateGroups = LoadUUIDList(es.EstateID, "estate_groups"); return(es); }
public List <RegionData> RunCommand(MySqlCommand cmd) { List <RegionData> retList = new List <RegionData>(); using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) { dbcon.Open(); cmd.Connection = dbcon; using (IDataReader result = cmd.ExecuteReader()) { while (result.Read()) { RegionData ret = new RegionData(); ret.Data = new Dictionary <string, object>(); ret.RegionID = DBGuid.FromDB(result["uuid"]); ret.ScopeID = DBGuid.FromDB(result["ScopeID"]); ret.RegionName = result["regionName"].ToString(); ret.posX = Convert.ToInt32(result["locX"]); ret.posY = Convert.ToInt32(result["locY"]); ret.sizeX = Convert.ToInt32(result["sizeX"]); ret.sizeY = Convert.ToInt32(result["sizeY"]); CheckColumnNames(result); foreach (string s in m_ColumnNames) { if (s == "uuid") { continue; } if (s == "ScopeID") { continue; } if (s == "regionName") { continue; } if (s == "locX") { continue; } if (s == "locY") { continue; } object value = result[s]; if (value is DBNull) { ret.Data[s] = null; } else { ret.Data[s] = result[s].ToString(); } } retList.Add(ret); } } } return(retList); }