public static bool RemoveComment(int projectId, DateTime time, string message, string userName)
{
AgrDataSet.ProjectsRow drProjects = Ds.Projects.FindById(projectId);
if (drProjects == null)
{
LogManager.LogError(unit, "RemoveComment. Ошибка. Проект не найден: " + projectId);
return(false);
}
AgrDataSet.UserRow drUser = Ds.User.FindByName(userName);
if (drUser == null)
{
LogManager.LogError(unit, "RemoveComment. Ошибка. Пользователь не найден: " + userName);
return(false);
}
drProjects.Date = DateTime.Now;
bool res = Storage.RemoveComment(projectId, time, message, userName);
if (res)
{
var drsComment = (AgrDataSet.CommentRow[])Ds.Comment.Select("ProjectId = " + projectId
+ " AND Time = '" + time
+ "' AND User = '******'");
foreach (AgrDataSet.CommentRow drComment in drsComment)
{
drComment.Delete();
}
return(true);
}
return(false);
}
public static bool SetComment(int projectId, DateTime time, string message, string userName)
{
AgrDataSet.ProjectsRow drProjects = Ds.Projects.FindById(projectId);
if (drProjects == null)
{
LogManager.LogError(unit, "SetComment. Ошибка. Проект не найден: " + projectId);
return(false);
}
AgrDataSet.UserRow drUser = Ds.User.FindByName(userName);
if (drUser == null)
{
LogManager.LogError(unit, "SetComment. Ошибка. Пользователь не найден: " + userName);
return(false);
}
drProjects.Date = DateTime.Now;
AgrDataSet.ProjectRow[] drsProject = drProjects.GetProjectRows();
if (drsProject.Length > 0)
{
bool res = Storage.AddComment(projectId, time, message, userName);
if (res)
{
Ds.Comment.AddCommentRow(drProjects, time, message, drUser);
return(true);
}
}
return(false);
}
private void UserListSelectedIndexChanged(object sender, EventArgs e)
{
splitContainer1.Panel2.Enabled = (user_list.SelectedItems.Count == 1);
if (user_list.SelectedItems.Count == 1)
{
name_text.Text = user_list.SelectedItems[0].Text;
AgrDataSet.UserRow drUser = Db.Ds.User.FindByName(user_list.SelectedItems[0].Text);
radioButton1.Checked = false;
radioButton2.Checked = false;
radioButton3.Checked = false;
radioButton4.Checked = false;
radioButton5.Checked = false;
radioButton6.Checked = false;
radioButton7.Checked = false;
login_text.Text = drUser.Login;
switch (drUser.Group)
{
case "Коммерческий отдел":
radioButton1.Checked = true;
break;
case "Иженерно техничский отдел":
radioButton2.Checked = true;
break;
case "Склад":
radioButton3.Checked = true;
break;
case "ОМТС":
radioButton4.Checked = true;
break;
case "Производство":
radioButton5.Checked = true;
break;
case "ОТК":
radioButton6.Checked = true;
break;
case "Администраторы":
radioButton7.Checked = true;
break;
}
//foreach (ListViewItem item in group_list.Items)
// item.Checked = ((ulong)(UserRight)Enum.Parse(typeof(UserRight), item.Name) & drUser.Groups) != 0;
apply_btn.Enabled = false;
}
else
{
name_text.Text = "";
//group_list.Text = "";
//foreach (ListViewItem item in group_list.Items)
// item.Checked = false;
}
}
public static bool Login(string name, string password)
{
AgrDataSet.UserRow drUser = Ds.User.FindByName(name);
if (drUser == null)
{
return(false);
}
return(drUser.Login == password);
}
//public static bool AddGroup(string name)
//{
// try
// {
// AgrDataSet.GroupRow drGroup = Ds.Group.AddGroupRow(name);
// return Storage.SaveUsers(Ds);
// }
// catch (Exception)
// {
// return false;
// }
//}
//public static bool EditGroup(string oldName, string newName)
//{
// try
// {
// AgrDataSet.GroupRow drGroup = Ds.Group.FindByName(oldName);
// drGroup.Name = newName;
// return Storage.SaveUsers(Ds);
// }
// catch (Exception)
// {
// return false;
// }
//}
public static bool AddUser(string user, string login, string group, uint right)
{
try
{
AgrDataSet.UserRow drUser = Ds.User.AddUserRow(user, login, group, right);
return(Storage.SaveUsers(Ds, false));
}
catch (Exception)
{
return(false);
}
}
public static bool EditUser(string oldName, string newName, string login, string group, uint right)
{
try
{
AgrDataSet.UserRow drUser = Ds.User.FindByName(oldName);
drUser.Name = newName;
drUser.Login = login;
drUser.Group = group;
drUser.Right = right;
return(Storage.SaveUsers(Ds, false));
}
catch (Exception)
{
return(false);
}
}
public static bool SetRequest(int projectId, DateTime time, string message, string userName)
{
AgrDataSet.ProjectsRow drProjects = Ds.Projects.FindById(projectId);
if (drProjects == null)
{
LogManager.LogError(unit, "SetRequest. Ошибка. Проект не найден: " + projectId);
return(false);
}
AgrDataSet.UserRow drUser = Ds.User.FindByName(userName);
if (drUser == null)
{
LogManager.LogError(unit, "SetRequest. Ошибка. Пользователь не найден: " + userName);
return(false);
}
drProjects.Date = DateTime.Now;
return(Storage.AddRequest(projectId, time, message, userName));
}
private void remove_user_btn_Click(object sender, EventArgs e)
{
if (user_list.SelectedItems.Count != 1)
{
return;
}
if (MessageBox.Show(this, "Удалить выделенного пользователя?", "Удаление пользователя", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
int idx = user_list.SelectedItems[0].Index;
foreach (ListViewItem item in user_list.SelectedItems)
{
AgrDataSet.UserRow dr = Db.Ds.User.FindByName(item.Name);
dr.Delete();
}
FillUser(idx, null);
}
