public frmEditUser(UserInfo contact, IDXMenuManager menuManager)
{
InitializeComponent();
this.contact = contact;
this.bindingContact = contact.Clone();
InitEditors();
InitMenuManager(menuManager);
peUserPhoto.Image = bindingContact.Photo;
teUserID.DataBindings.Add("Text", bindingContact, "Id"); // Id
tePassword.DataBindings.Add("Text", bindingContact, "Password");
teConfirmPassword.DataBindings.Add("Text", bindingContact, "ConfirmPassword");
icbUserLevel.DataBindings.Add("EditValue", bindingContact, "Level"); // Level
teUserName.DataBindings.Add("Text", bindingContact, "Name"); // Name
teUserPhone.DataBindings.Add("Text", bindingContact, "Phone"); // Phone
meNotes.DataBindings.Add("Text", bindingContact, "Note");
UpdateCaption();
InitValidationProvider();
}
protected internal override void ButtonClick(string tag) {
switch(tag) {
case TagResources.ContactList:
UpdateMainView(gridView1);
ClearSortingAndGrouping();
break;
case TagResources.ContactAlphabetical:
UpdateMainView(gridView1);
ClearSortingAndGrouping();
colUserID.Group();
break;
//case TagResources.ContactByState:
// UpdateMainView(gridView1);
// ClearSortingAndGrouping();
// colUserName.Group();
// colCity.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
// break;
case TagResources.ContactCard:
UpdateMainView(layoutView1);
break;
case TagResources.FlipLayout:
layoutControl1.Root.FlipLayout();
break;
case TagResources.ContactDelete:
if(CurrentContact == null) return;
int index = gridView1.FocusedRowHandle;
gidControlUserManage.MainView.BeginDataUpdate();
try
{
DeleteUserInfo(CurrentContact);
DataHelper.UserInfos.Remove(CurrentContact);
}
finally
{
gidControlUserManage.MainView.EndDataUpdate();
}
if(index > gridView1.DataRowCount - 1) index--;
gridView1.FocusedRowHandle = index;
ShowInfo(gridView1);
break;
case TagResources.ContactNew:
UserInfo contact = new UserInfo();
if(EditUser(contact) == DialogResult.OK) {
gidControlUserManage.MainView.BeginDataUpdate();
try
{
DataHelper.UserInfos.Add(contact);
InsertUserInfo(contact);
}
finally
{
gidControlUserManage.MainView.EndDataUpdate();
}
ColumnView view = gidControlUserManage.MainView as ColumnView;
if(view != null) {
GridHelper.GridViewFocusObject(view, contact);
ShowInfo(view);
}
}
break;
case TagResources.ContactEdit:
if (EditUser(CurrentContact) == DialogResult.OK)
{
UpdateUserInfo(CurrentContact);
}
break;
}
UpdateCurrentContact();
UpdateInfo();
}
protected override void InitMDBData(string connectionString)
{
MariaDbConnection = new MySqlConnection(connectionString);
MariaDbConnection.Open();
MySqlManage sql = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString);
DataSet ds = new DataSet();
ds = sql.SelectMariaDBTable(MariaDbConnection, "SELECT * FROM AMR_MST06");
foreach( DataRow row in ds.Tables[0].Rows)
{
UserInfo contact = new UserInfo();
contact.Id = row["MST06AID"].ToString();
if (row["MST06LEV"].ToString() == "1")
{
contact.Level = UserLevel.Level1;
}
else if (row["MST06LEV"].ToString() == "2")
{
contact.Level = UserLevel.Level2;
}
else if (row["MST06LEV"].ToString() == "3")
{
contact.Level = UserLevel.Level3;
}
contact.Name = row["MST06NAM"].ToString();
contact.Phone = row["MST06PHN"].ToString();
contact.Password = row["MST06PWD"].ToString();
contact.ConfirmPassword = row["MST06PWD"].ToString();
DataHelper.UserInfos.Add(contact);
}
gidControlUserManage.DataSource = DataHelper.UserInfos;
}
DialogResult EditUser(UserInfo contact)
{
if(contact == null) return DialogResult.Ignore;
DialogResult ret = DialogResult.Cancel;
Cursor.Current = Cursors.WaitCursor;
using (frmEditUser frm = new frmEditUser(contact, OwnerForm.Ribbon))
{
ret = frm.ShowDialog(OwnerForm);
}
UpdateCurrentContact();
Cursor.Current = Cursors.Default;
return ret;
}
void DeleteUserInfo(UserInfo contact)
{
MySqlDataReader Reader;
MySqlCommand command = MariaDbConnection.CreateCommand();
string sql = string.Format("delete from AMR_MST06 where MST06AID = '{0}'", contact.Id);
command.CommandText = sql;
Reader = command.ExecuteReader();
Reader.Close();
}
void UpdateUserInfo(UserInfo contact)
{
MySqlDataReader Reader;
MySqlCommand command = MariaDbConnection.CreateCommand();
int level = 0;
if (contact.Level == UserLevel.Level1)
level = 1;
else if (contact.Level == UserLevel.Level2)
level = 2;
else if (contact.Level == UserLevel.Level3)
level = 3;
string sql = string.Format("update AMR_MST06 set MST06AID = '{0}', MST06LEV = '{1}', MST06NAM = '{2}', MST06PHN = '{3}', MST06PWD = '{4}' where MST06AID = '{5}'",
contact.Id, level, contact.Name, contact.Phone, contact.Password, contact.Id);
command.CommandText = sql;
Reader = command.ExecuteReader();
Reader.Close();
}
void InsertUserInfo(UserInfo contact)
{
MySqlDataReader Reader;
MySqlCommand command = MariaDbConnection.CreateCommand();
int level = 0;
if (contact.Level == UserLevel.Level1)
level = 1;
else if (contact.Level == UserLevel.Level2)
level = 2;
else if (contact.Level == UserLevel.Level3)
level = 3;
string sql = string.Format("insert into AMR_MST06 values('{0}', '{1}', '{2}', '{3}', '{4}')", contact.Id, contact.Password, contact.Name, level, contact.Phone);
command.CommandText = sql;
Reader = command.ExecuteReader();
Reader.Close();
}
public void Assign(UserInfo userinfo)
{
this.id = userinfo.id;
this.password = userinfo.password;
this.confirmPassword = userinfo.confirmPassword;
this.level = userinfo.level;
this.name = userinfo.name;
this.phone = userinfo.Phone;
this.note = userinfo.Note;
}
public UserInfo(UserInfo userinfo)
{
this.Assign(userinfo);
}
//object GetTasksData(Contact contact) {
// IEnumerable ret = from task in DataHelper.Tasks
// where task.AssignTo == contact
// select task;
// return ret.Cast<Task>().ToList();
//}
object GetTasksData(UserInfo contact)
{
IEnumerable ret = from task in DataHelper.Tasks
where task.AssignTo2 == contact
select task;
return ret.Cast<Task>().ToList();
}
//public NavBarData(object data, Contact contact) {
// this.contact = contact;
// this.data = data;
//}
public NavBarData(object data, UserInfo contact)
{
this.contact = contact;
this.data = data;
}
//NavBarItemLink AddNavBarItem(NavBarGroup group, string caption, Image image, object data, Contact contact) {
// NavBarItem item = new NavBarItem(caption);
// item.SmallImage = image;
// item.Tag = new NavBarData(data, contact);
// tasks.Add(item.Tag, data);
// NavBarItemLink link = group.ItemLinks.Add(item);
// item.LinkClicked += new NavBarLinkEventHandler(item_LinkClicked);
// return link;
//}
NavBarItemLink AddNavBarItem(NavBarGroup group, string caption, Image image, object data, UserInfo contact)
{
NavBarItem item = new NavBarItem(caption);
item.SmallImage = image;
item.Tag = new NavBarData(data, contact);
tasks.Add(item.Tag, data);
NavBarItemLink link = group.ItemLinks.Add(item);
item.LinkClicked += new NavBarLinkEventHandler(item_LinkClicked);
return link;
}