public WindowAddTo(Canvas parent, AddTo addTo) { InitializeComponent(); IsClosed = false; parentCanvas = parent; windowAddTo = addTo; if (parent.Tag is int) { idMembership = Convert.ToInt32(parent.Tag); } if (idMembership == 0) { idApplication = parent.Name.Replace("ID_", ""); } timerAnimation = new DispatcherTimer(); timerAnimation.Interval = new TimeSpan(0, 0, 0, 0, 10); repeatIntervals = 0; Canvas activity = new Canvas() { Width = 150, Height = 200, }; ScrollViewer sv = ScrollViewerCreator.CreateScrollViewer(addToCanvas, 150, 200, 0, 0, activity); Dictionary <string, string> names = new Dictionary <string, string>(); if (addTo == AddTo.Activity) { names = NameActivity_db.GetNameActivityDictionary(); } else if (addTo == AddTo.Group) { names = Membership_db.GetNameGroupsDictionaryIfIsActive(); } int nextIndex = 0; foreach (KeyValuePair <string, string> name in names) { Label button = ButtonCreator.CreateButton(activity, name.Value, 150, 30, 12, 0, 29 * nextIndex, Color.FromArgb(255, 255, 255, 255), Color.FromArgb(200, 255, 255, 255), 1); activity.Height += 29; button.MouseEnter += button_MouseEnter; button.MouseLeave += button_MouseLeave; button.MouseLeftButtonDown += button_MouseLeftButtonDown; button.Name = "ID_" + name.Key; nextIndex++; } activity.Height = ((activity.Height - 200) < 200) ? 200 : activity.Height - 199; timerAnimation.Tick += new EventHandler(AnimationAddShow); timerAnimation.Start(); }
public virtual void CreateMap(string record) { var match = _extractRegex.Match(record); AddTo.Add(new OsRecord { Code = match.Groups["Code"].Value.Trim(), Name = match.Groups["Name"].Value.Trim(), Isbn = match.Groups["Isbn"].Value.Trim() }); }
public WindowAddTo(Canvas parent, bool revert, AddTo addTo) { IsClosed = false; bool ifAdd = false; parentCanvas = parent; windowAddTo = addTo; if (parent.Tag is int) { idMembership = Convert.ToInt32(parent.Tag); } if (idMembership == 0) { idApplication = parent.Name.Replace("ID_", ""); } timerAnimation = new DispatcherTimer(); timerAnimation.Interval = new TimeSpan(0, 0, 0, 0, 10); repeatIntervals = 0; if (windowAddTo == AddTo.Activity && idMembership == 0) { if (ActiveApplication_db.AddActivityToApplication(idApplication, "1")) { ifAdd = true; } } if (addTo == AddTo.Group) { if (ActiveApplication_db.AddGroupToApplication(idApplication, "NULL")) { ifAdd = true; } } if (windowAddTo == AddTo.Activity && idMembership > 0) { if (ActiveApplication_db.AddActivityToApplicationGroup(idMembership, "1")) { ifAdd = true; } } if (ifAdd) { ((Label)(parentCanvas.Children[7])).Content = "+"; Canvas.SetTop((Label)(parentCanvas.Children[7]), 28); timerAnimation.Tick += new EventHandler(AnimationButtonRestart); timerAnimation.Start(); } }
protected void Page_Load(object sender, EventArgs e) { CheckAccount(); if (!string.IsNullOrEmpty(Request["id"])) { _id = Int32.Parse(Request["id"]); phAddRecord.Visible = false; phEditRecord.Visible = true; } App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); _data = db.GetUsers(); List <string> roles = new List <string>() { "Administrator", "Manager", "Cadry" }; if (!db.CheckAccount(User.Identity.Name, roles)) { Select.SelectCommand = "select j.*, uf.Family+' '+uf.IO as FromFIO, ut.Family+' '+ut.IO as ToFIO, '~/Journal.aspx?id='+CAST(j.Id as nvarchar) as Url " + "from [Journal] j left join UserInfo uf on uf.UserId=j.[From] left join UserInfo ut on ut.UserId=j.[To] " + "join Users u1 on u1.UserId=j.[From] or j.[From] is null " + "join Users u2 on u2.UserId=j.[To] or j.[To] is null " + "where (j.[From] is not null and u1.UserName=N'" + User.Identity.Name + "') " + "or (j.[To] is not null and u2.UserName=N'" + User.Identity.Name + "') " + "order by j.[Begin] desc"; } if (!IsPostBack) { AddTo.DataSource = _data; AddTo.DataBind(); AddTo.SelectedIndex = 0; using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); /* * SqlCommand cmd = new SqlCommand("select * from [Journal] order by [Begin] desc", conn); * SqlDataReader dr = cmd.ExecuteReader(); * List<Data> data = new List<Data>(); * while (dr.Read()) * { * data.Add(new Data() * { * Id = dr["Id"].ToString(), * Url = "~/Journal.aspx?id=" + dr["Id"].ToString(), * Role = dr["Role"].ToString(), * Page = dr["Page"].ToString(), * Description = dr["Description"].ToString(), * Begin = ((DateTime)dr["Begin"]).Date.ToShortDateString(), * End = dr["End"] is DBNull ? "" : ((DateTime)dr["End"]).Date.ToShortDateString(), * Prim = dr["Prim"] is DBNull ? "" : dr["Prim"].ToString() * }); * } * dr.Close(); * Table.DataSource = data; * Table.DataBind(); */ if (_id > 0) { SqlCommand cmd = new SqlCommand("select j.*, uif.Family as FromF, uif.IO as FromIO, uit.Family as ToF, uit.IO as ToIO from [Journal] j " + "left join UserInfo uit on uit.UserId=j.[To] " + "left join UserInfo uif on uif.UserId=j.[From] where j.Id=@id", conn); cmd.Parameters.AddWithValue("id", _id); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); EditRole.Text = dt.Rows[0]["Role"].ToString(); EditPage.Text = dt.Rows[0]["Page"].ToString(); EditDescription.Text = dt.Rows[0]["Description"].ToString(); if (!(dt.Rows[0]["Prim"] is DBNull)) { EditPrim.Text = dt.Rows[0]["Prim"].ToString(); } if (!(dt.Rows[0]["FromF"] is DBNull)) { EditFrom.Text = dt.Rows[0]["FromF"].ToString() + " " + dt.Rows[0]["FromIO"].ToString(); } if (!(dt.Rows[0]["ToF"] is DBNull)) { EditTo.Text = dt.Rows[0]["ToF"].ToString() + " " + dt.Rows[0]["ToIO"].ToString(); } } } } }