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