public ActionResult DeleteConfirmed(int id)
{
Sotrudnik sotrudnik = db.Sotrudniks.Find(id);
db.Sotrudniks.Remove(sotrudnik);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID_Sotrudnik,Fam,Im,Otch,Ser,Nom,Mail")] Sotrudnik sotrudnik)
{
if (ModelState.IsValid)
{
db.Entry(sotrudnik).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sotrudnik));
}
private void EditSotrudnikForm_Load(object sender, EventArgs e)
{
this.editedSotr = DataLayer.GetSotrudnikById(this.Id).ToList()[0];
txtCabNumber.Text = editedSotr.CabNumber;
txtEndWork.Text = editedSotr.WorkEnd.ToString("HH:mm");
txtFullName.Text = editedSotr.FullName;
txtSpec.Text = editedSotr.Specialization;
txtStartWork.Text = editedSotr.WorkStart.ToString("HH:mm");
}
public ActionResult Delete(int id)
{
Sotrudnik b = db.Sotrudniks.Find(id);
if (b == null)
{
return(HttpNotFound());
}
return(View(b));
}
public ActionResult Create([Bind(Include = "ID_Sotrudnik,Fam,Im,Otch,Ser,Nom,Mail")] Sotrudnik sotrudnik)
{
if (ModelState.IsValid)
{
db.Sotrudniks.Add(sotrudnik);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sotrudnik));
}
public ActionResult DeleteConfirmed(int id)
{
Sotrudnik b = db.Sotrudniks.Find(id);
if (b == null)
{
return(HttpNotFound());
}
db.Sotrudniks.Remove(b);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void btnAddSotrudnik_Click(object sender, EventArgs e)
{
Sotrudnik addSotrudnik = new Sotrudnik();
addSotrudnik.FullName = txtFullName.Text;
addSotrudnik.Specialization = txtSpec.Text;
addSotrudnik.WorkEnd = Convert.ToDateTime(txtEndWork.Text);
addSotrudnik.WorkStart = Convert.ToDateTime(txtStartWork.Text);
addSotrudnik.CabNumber = txtCabNumber.Text;
DataLayer.AddSotrudnik(addSotrudnik);
this.Close();
}
// GET: Sotrudniks/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Sotrudnik sotrudnik = db.Sotrudniks.Find(id);
if (sotrudnik == null)
{
return(HttpNotFound());
}
return(View(sotrudnik));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
Sotrudnik Sotrudnik = db.Sotrudniks.Find(id);
if (Sotrudnik != null)
{
SelectList doljnosts = new SelectList(db.Doljnosts, "dolj_ID", "doljnosts");
ViewBag.Doljnosts = doljnosts;
return(View(Sotrudnik));
}
return(HttpNotFound());
}
public void UpdateSotrudnik(Sotrudnik sotrudnik)
{
try
{
string sql = @"UPDATE sotrudniki SET FullName = @FullName,Specialization = @Specialization,CabNumber = @CabNumber,WorkStart=@WorkStart,WorkEnd=@WorkEnd WHERE Id = @Id ";
using (IDbConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
con.Open();
var result = con.Execute(sql, sotrudnik);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void AddSotrudnik(Sotrudnik sotrudnik)
{
try
{
string sql = @"INSERT INTO sotrudniki (FullName,Specialization,CabNumber,WorkStart,WorkEnd)
VALUES (@FullName,@Specialization,@CabNumber,@WorkStart,@WorkEnd)";
using (IDbConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
con.Open();
var result = con.Execute(sql, sotrudnik);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var ID = Request.QueryString["id"];
var myKadry = new OtdelKadrov();
//LoadOtdelKadrov();
FileStream filestream = new FileStream("file.xml", FileMode.Open, FileAccess.Read, FileShare.Read);//|DataDirectory|/
XmlSerializer xmls = new XmlSerializer(typeof(OtdelKadrov));
myKadry = (OtdelKadrov)xmls.Deserialize(filestream);
filestream.Close();
foreach (var Node in myKadry.sotrudniki)
{
if (Node.sotrudnikID == ID)
{
mySotrud = Node;
}
}
//12367
TextBox1.Text = mySotrud.name;
TextBox2.Text = mySotrud.lastname;
TextBox3.Text = mySotrud.middlename;
TextBox6.Text = mySotrud.phone;
TextBox7.Text = mySotrud.rukovoditelID;
foreach (var node in myKadry.dolzhnosti)
{
ListItem temp2 = new ListItem(node, node);
ListBox2.Items.Add(temp2);
}
foreach (var node in myKadry.otdely)
{
ListItem temp2 = new ListItem(node, node);
ListBox3.Items.Add(temp2);
}
}
protected void Page_Load(object sender, EventArgs e)
{
myKadry = new OtdelKadrov();
LoadOtdelKadrov();
foreach (var node in myKadry.sotrudniki)//руководители
{
ListItem temp2 = new ListItem(node.lastname + ' ' + node.name + ' ' + node.middlename, node.sotrudnikID);
ListBox1.Items.Add(temp2);
}
foreach (var node in myKadry.dolzhnosti)//должности
{
ListItem temp2 = new ListItem(node, node);
ListBox2.Items.Add(temp2);
}
foreach (var node in myKadry.otdely)//отделы
{
ListItem temp2 = new ListItem(node, node);
ListBox3.Items.Add(temp2);
}
ID = Request.QueryString["id"];
if (ID != null)
{
Label9.Text = "Изменить информацтю о сотруднике";
foreach (var Node in myKadry.sotrudniki)
{
if (Node.sotrudnikID == ID)
{
mySotrud = Node;
}
}
/*TextBox1.Text = mySotrud.name;
* TextBox2.Text = mySotrud.lastname;
* TextBox3.Text = mySotrud.middlename;
* TextBox6.Text = mySotrud.phone;*/
ListBox1.Visible = false; //руководит
TextBox9.Visible = true; //руководит
//TextBox9.Text = mySotrud.rukovoditelID;
Button4.Visible = true; //кнопка изменения
Button1.Visible = false; //кнпк создания
}
else
{
foreach (var node in myKadry.dolzhnosti) //должности
{
ListItem temp2 = new ListItem(node, node);
ListBox2.Items.Add(temp2);
}
foreach (var node in myKadry.otdely)//отделы
{
ListItem temp2 = new ListItem(node, node);
ListBox3.Items.Add(temp2);
}
//показать всё иерархию
Temp(ref Label8, "0");//начинаем с директора- ""
//ListBox1.DataSource = myKadry.sotrudniki.;
//ListBox1.DataBind();
// ListBox1.
/*IEnumerable<OtdelKadrov> myFiltrKadry =
* from student in app.students
* join ci in app.contactList on student.ID equals ci.ID
* select ci;
*/
/*myKadry.sotrudniki.Add(new Sotrudnik("ayaz","Zali","Aidar","developer","otdel1","89518954606","0","0"));
* myKadry.dolzhnosti.Add("developer");
* myKadry.dolzhnosti.Add("qa");
* myKadry.dolzhnosti.Add("project manager");
* myKadry.dolzhnosti.Add("business analyst");
* myKadry.dolzhnosti.Add("product owner");
*
* myKadry.otdely.Add("отдел1");
* myKadry.otdely.Add("отдел2");
* myKadry.otdely.Add("отдел3");
* myKadry.otdely.Add("отдел4");
*/
//Console.Write("Press any key to continue . . . И база сохраниться");
//SaveOtdelKadrov();
}
}
static void Main(string[] args)
{
/* Sotrudnik sotrudnik0 = null;
*
* Sotrudnik sotrudink1 = new Sotrudnik();
* sotrudink1.FIO = null;
* sotrudink1.ID = 0;
* sotrudink1.otdel = null;
* sotrudink1.inWork = null;
*
* Sotrudnik sotrudink2 = new Sotrudnik();
* sotrudink2.FIO = "Test";
* sotrudink2.ID = 0;
* sotrudink2.otdel = new Otdel();
* sotrudink2.inWork = new Position();
*
* TLog log = new TLog();
* TRPZ rpz = new TRPZ();
* TsqlDB sqlDB = new TsqlDB();
* TURV urv = new TURV();
*
* log.TWriteLine("test");
* log.TWriteLine(null);
*
* rpz.TGetDataNachisl(sotrudnik0);
* rpz.TGetDataNachisl(sotrudink1);
* rpz.TGetDataNachisl(sotrudink2);
*
* sqlDB.TcSQL_init(null);
* sqlDB.TcSQL_init("test");
* sqlDB.TcSQL_init("Provider = Microsoft.Ace.OLEDB.12.0; " + @"Data Source= ../../../worker_time.accdb; Persist Security Info=False;");
*
* sqlDB.TConnect();
*
* sqlDB.TQuery(null);
* sqlDB.TQuery("SELECT * FROM Worker");
*
* sqlDB.TDisconnect();
*
* urv.TCalcEdetg(sotrudnik0);
* urv.TCalcEdetg(sotrudink1);
* urv.TCalcEdetg(sotrudink2);
*
* urv.TgetDataRV(sotrudnik0);
* urv.TgetDataRV(sotrudink1);
* urv.TgetDataRV(sotrudink2);*/
sqlDB.cSQL_init("Provider = Microsoft.Ace.OLEDB.12.0; " + @"Data Source= ../../../worker_time.accdb; Persist Security Info=False;");
pos = new Position();
ipAddress = IPAddress.Parse("0.0.0.0");
listener = new TcpListener(ipAddress, PORT);
sqlDB.Connect();
try
{
Console.WriteLine($"Ip addres: {ipAddress.ToString()}");
listener.Start();
String msg;
String query;
while (true)
{
TcpClient client = listener.AcceptTcpClient();
NetworkStream stream = client.GetStream();
byte[] recBytes = new byte[1024];
stream.Read(recBytes, 0, 1024);
MessageBox.Show($"Recive bytes length: {recBytes.Length}");
switch (recBytes[0])
{
case codeNewUser:
msg = Convert.ToString(recBytes);
var msg_arr = msg.Split(',').ToArray();
MessageBox.Show("Информационное сообщение", "Добавлен новый пользователь!");
//TODO set name and firstname
String name = "Petr";
String firstName = "Ivanov";
query = $"INSERT INTO Worker(Name,Firstname) VALUES('{name}','{firstName}')";
ds = sqlDB.Query(query);
Console.WriteLine("Added new user");
break;
case codeChangePosition:
msg = Convert.ToString(recBytes);
MessageBox.Show(Encoding.ASCII.GetString(recBytes), "Изменилось положение для пользователя!");
//TODO set parametrs
int workerID = 1;
DateTime Date = DateTime.Now;
pos.inWork = true;
query = $"INSERT INTO WorkTime(WorkerID,Data,Position) VALUES({workerID},'{Date.ToString().Replace('.', '-')}',{pos.inWork})";
ds = sqlDB.Query(query);
Console.WriteLine("Chabge position from user");
break;
case codeGetStatistick:
//TODO: getStatisctic from db
byte[] data = Encoding.UTF8.GetBytes("Message");
NetworkStream writeStream = client.GetStream();
writeStream.Write(data, 0, data.Length);
writeStream.Flush();
Console.WriteLine("Send statistic to user");
break;
case codeRegisterUser:
String _name = "Petr";
String _firstName = "Ivanov";
Sotrudnik sotr = new Sotrudnik();
sotr.FIO = _name + _firstName;
sotr.ID = worker.Count - 1;
worker.Add(sotr);
Console.WriteLine("Register new user");
break;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка сервера");
Console.ReadKey();
}
}
public ActionResult Edit(Sotrudnik Proizvodstvo)
{
db.Entry(Proizvodstvo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
