public Options()
{
InitializeComponent();
this.FormClosing += new FormClosingEventHandler(this.Options_FormClosing);
this.UserComboBox.DropDown += new System.EventHandler(this.UserComboBox_DropDown);
using (DbOption db = new DbOption())
{
var Options = db.UserOptions.Select(x => new { UserName = x.UserName, Id = x.Id });
UserComboBox.DataSource = Options.ToList();
UserComboBox.DisplayMember = "UserName";
UserComboBox.ValueMember = "Id";
this.UserComboBox.SelectedIndexChanged += new System.EventHandler(this.UserComboBox_SelectedIndexChanged);
if (UserComboBox.Text != "")
{
int a = Convert.ToInt32(UserComboBox.SelectedValue.ToString());
var NewOption = db.UserOptions.Where(x => x.Id == a).FirstOrDefault();
if (NewOption != null)
{
LoginTextBox.Text = NewOption.Login;
PasswordTextBox.Text = NewOption.Password;
ProxyTextBox.Text = NewOption.Proxy;
PortTextBox.Text = NewOption.Port.ToString();
DirectoryTextBox.Text = NewOption.Directory;
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
List <Units> SaveUnit = new List <Units>();
List <Units> RemoveUnit = new List <Units>();
for (int i = CheckedUnits.Items.Count - 1; i >= 0; i--)
{
if (!CheckedUnits.GetItemChecked(i))
{
SaveUnit.Add((Units)CheckedUnits.Items[i]);
}
else
{
RemoveUnit.Add((Units)CheckedUnits.Items[i]);
}
}
SaveUnit.Reverse();
CheckedUnits.DataSource = SaveUnit;
CheckedUnits.DisplayMember = "Name";
CheckedUnits.ValueMember = "UnitId";
using (DbOption db = new DbOption())
{
foreach (Units a in RemoveUnit)
{
var unit = db.Units.Where(u => u.Name == a.Name & u.UnitId == a.UnitId & u.GroupId == a.GroupId).First();
db.Units.Remove(unit);
db.SaveChanges();
}
}
}
private void button3_Click(object sender, EventArgs e)
{
using (DbOption db = new DbOption())
{
var NewOption = db.UserOptions.Where(x => x.UserName == UserComboBox.Text).FirstOrDefault();
if (LoginTextBox.Text != "" & PasswordTextBox.Text != "" & ProxyTextBox.Text != "" & PortTextBox.Text != "" & UserComboBox.Text != "" & DirectoryTextBox.Text != "")
{
if (NewOption == null)
{
db.UserOptions.Add(new UserOptions {
Login = LoginTextBox.Text, Password = PasswordTextBox.Text, Port = Convert.ToInt32(PortTextBox.Text), Proxy = ProxyTextBox.Text, UserName = UserComboBox.Text, Directory = DirectoryTextBox.Text
});
db.SaveChanges();
}
else
{
db.UserOptions.Remove(NewOption);
db.UserOptions.Add(new UserOptions {
Login = LoginTextBox.Text, Password = PasswordTextBox.Text, Port = Convert.ToInt32(PortTextBox.Text), Proxy = ProxyTextBox.Text, UserName = UserComboBox.Text, Directory = DirectoryTextBox.Text
});
db.SaveChanges();
}
}
else
{
MessageBox.Show("Заполните все поля, чтобы отредактировать данные, или добавить нового пользователя");
}
}
}
private void ComboBoxGroup_DropDown(object sender, EventArgs e)
{
using (DbOption db = new DbOption())
{
var Groups = db.Groups.Select(x => new { GroupId = x.GroupId, Name = x.Name });
ComboBoxGroup.DataSource = Groups.ToList();
ComboBoxGroup.DisplayMember = "Name";
ComboBoxGroup.ValueMember = "GroupId";
}
}
private void UserComboBox_DropDown(object sender, EventArgs e)
{
using (DbOption db = new DbOption())
{
var Options = db.UserOptions.Select(x => new { UserName = x.UserName, Id = x.Id });
UserComboBox.DataSource = Options.ToList();
UserComboBox.DisplayMember = "UserName";
UserComboBox.ValueMember = "Id";
}
}
private void button1_Click(object sender, EventArgs e)
{
List <Units> NewUnits = new List <Units>();
foreach (Units a in CheckedUnits.Items)
{
NewUnits.Add(a);
}
if (ComboBoxGroup.SelectedValue != null & ComboBoxGroup.SelectedValue.ToString() != "")
{
foreach (Units Check in UnitsWialon.CheckedItems)
{
bool flag = false;
foreach (Units i in CheckedUnits.Items)
{
if (Check.Name == i.Name)
{
flag = true; break;
}
}
if (!flag)
{
NewUnits.Add(new Units()
{
Name = Check.Name, UnitId = Check.UnitId, GroupId = Convert.ToInt32(ComboBoxGroup.SelectedValue.ToString())
});
}
}
CheckedUnits.DataSource = NewUnits;
CheckedUnits.DisplayMember = "Name";
CheckedUnits.ValueMember = "UnitId";
using (DbOption db = new DbOption())
{
if (NewUnits.Count != 0)
{
foreach (Units a in NewUnits)
{
try
{
db.Units.Add(new Units {
Name = a.Name, UnitId = a.UnitId, GroupId = (int)ComboBoxGroup.SelectedValue
});
db.SaveChanges();
}
catch { MessageBox.Show("Не удалось добавить технику " + a.Name); }
}
}
else
{
MessageBox.Show("Вы не выбрали технику");
}
}
}
}
public AddForm()
{
InitializeComponent();
this.FormClosing += new FormClosingEventHandler(this.Add_FormClosing);
using (DbOption db = new DbOption())
{
this.ComboGroup.DataSource = db.Groups.ToList();
this.ComboGroup.DisplayMember = "Name";
this.ComboGroup.ValueMember = "GroupId";
}
}
private void UserDeleteBtn_Click(object sender, EventArgs e)
{
using (DbOption db = new DbOption())
{
int a = Convert.ToInt32(UserComboBox.SelectedValue.ToString());
var NewOption = db.UserOptions.Where(x => x.Id == a).FirstOrDefault();
db.UserOptions.Remove(NewOption);
db.SaveChanges();
UserComboBox.DataSource = db.UserOptions;
UserComboBox.DisplayMember = "UserName";
UserComboBox.ValueMember = "Id";
}
}
void ComboBoxGroup_SelectedIndexChanged(object sender, EventArgs e)
{
int ComboGroupS = (int)ComboBoxGroup.SelectedValue;
using (DbOption db = new DbOption())
{
if (ComboGroupS != 0)
{
CheckedUnits.DataSource = db.Units.ToList().Where(x => x.GroupId == ComboGroupS).ToList();
CheckedUnits.DisplayMember = "Name";
CheckedUnits.ValueMember = "UnitId";
}
}
}
private void AddOk_Click(object sender, EventArgs e)
{
using (DbOption db = new DbOption())
{
if (ComboGroup.Text != null)
{
db.Groups.Add(new Groups {
Name = ComboGroup.Text
});
try { db.SaveChanges(); }
catch { System.Windows.Forms.MessageBox.Show("Введите другое название группы. Это не соответсвует формату данных"); }
this.ComboGroup.DataSource = db.Groups.ToList();
this.ComboGroup.DisplayMember = "Name";
this.ComboGroup.ValueMember = "GroupId";
}
}
}
private void RemoveBtn_Click(object sender, EventArgs e)
{
using (DbOption db = new DbOption())
{
if (ComboGroup.Text != null)
{
int a = Convert.ToInt32(ComboGroup.SelectedValue.ToString());
var group = db.Groups.OrderByDescending(u => u.Name == ComboGroup.Text & u.GroupId == a).First();
db.Groups.Remove(group);
var units = db.Units.Where(x => x.GroupId == a);
db.Units.RemoveRange(units);
db.SaveChanges();
this.ComboGroup.DataSource = db.Groups.ToList();
this.ComboGroup.DisplayMember = "Name";
this.ComboGroup.ValueMember = "GroupId";
}
}
}
private void UserComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
if (UserComboBox.Text != "")
{
using (DbOption db = new DbOption())
{
int a = Convert.ToInt32(UserComboBox.SelectedValue.ToString());
var NewOption = db.UserOptions.Where(x => x.Id == a).FirstOrDefault();
if (NewOption != null)
{
LoginTextBox.Text = NewOption.Login;
PasswordTextBox.Text = NewOption.Password;
ProxyTextBox.Text = NewOption.Proxy;
PortTextBox.Text = NewOption.Port.ToString();
DirectoryTextBox.Text = NewOption.Directory;
}
}
}
}
public WialonForm()
{
TimeZone localZone = TimeZone.CurrentTimeZone;
DateTime currentDate = DateTime.Now;
int currentYear = currentDate.Year;
DateTime currentUTC = localZone.ToUniversalTime(currentDate);
TimeSpan currentOffset = localZone.GetUtcOffset(currentDate);
AddForm1 = new AddForm();
Option = new Options();
InitializeComponent();
using (DbOption db = new DbOption())
{
ComboBoxGroup.DataSource = db.Groups.ToList();
ComboBoxGroup.DisplayMember = "Name";
ComboBoxGroup.ValueMember = "GroupId";
}
Wialon = new WialonConnection();
Units = new WialonCollection();
Reports = new WialonCollection();
WialonUnit Unit = new WialonUnit();
WialonReport Report = new WialonReport();
long CountOfUnits;
if (Wialon == null)
{
MessageBox.Show("No object");
return;
}
if (Option.ProxyTextBox.Text.Trim() != "" & Option.PortTextBox.Text.Trim() != "" & Option.LoginTextBox.Text.Trim() != "" & Option.PasswordTextBox.Text.Trim() != "" & Option.DirectoryTextBox.Text.Trim() != "")
{
Wialon.SetProxyMode(Option.ProxyTextBox.Text.Trim(), (ushort)Convert.ToInt32(Option.PortTextBox.Text.Trim()), Option.LoginTextBox.Text.Trim() + ":" + Option.PasswordTextBox.Text.Trim());
Units = Wialon.Login(Option.ProxyTextBox.Text.Trim(), (ushort)Convert.ToInt32(Option.PortTextBox.Text.Trim()), Option.LoginTextBox.Text.Trim(), Option.PasswordTextBox.Text.Trim());
}
else
{
Wialon.SetProxyMode("activex-wln.sucden.ru", 80, "UserForApp:UserForApp");
Units = Wialon.Login("activex-wln.sucden.ru", 80, "UserForApp", "UserForApp");
}
Reports = Wialon.GetReportsList();
WialonReport NewRep = new WialonReport();
List <ReportL> RepList = new List <ReportL>();
foreach (WialonReport a in Reports)
{
if (a == null)
{
MessageBox.Show(Wialon.GetLastError().ToString());
return;
}
else
{
RepList.Add(new ReportL()
{
Name = a.Name, ReportID = a.ReportID, ResourceID = a.ResourceID
});
}
}
RepList.Sort((a, b) => a.Name.CompareTo(b.Name));
ReportList.DataSource = RepList;
ReportList.DisplayMember = "Name";
ReportList.ValueMember = "ReportID";
CountOfUnits = Units.Count;
List <Units> UnitsCl = new List <Units>();
for (int i = 1; i < CountOfUnits; i++)
{
Unit = (WialonUnit)Units[i];
if (Unit == null)
{
MessageBox.Show("Not unit");
return;
}
else
{
UnitsCl.Add(new Units()
{
Name = Unit.Name, UnitId = (int)Unit.ID
});
}
}
UnitsCl.Sort((a, b) => a.Name.CompareTo(b.Name));
UnitsWialon.DataSource = UnitsCl;
UnitsWialon.DisplayMember = "Name";
UnitsWialon.ValueMember = "UnitId";
// string some = Wialon.GetReportByID(1482094800, 1482181199, UId, (int)GetTimeZoneForWialon(), "ru", ResId, RepId);
System.Runtime.InteropServices.Marshal.ReleaseComObject(Unit);
Unit = null;
// StreamWriter SW = new StreamWriter(new FileStream(@"C:\Rapport\MyXml.txt", FileMode.Create, FileAccess.Write));
// SW.Write(some);
// SW.Close();
// StreamWriter SW2 = new StreamWriter(new FileStream(@"C:\Rapport\MyXml2.txt", FileMode.Create, FileAccess.Write));
// if (some != null)
// {
// SW2.Write(some);
// SW2.Close();
// }
System.Runtime.InteropServices.Marshal.ReleaseComObject(Units);
Units = null;
Wialon = null;
ComboBoxGroup.SelectedIndexChanged += ComboBoxGroup_SelectedIndexChanged;
}