public ActionResult Edit_Worker(int workerID)
{
if (Session["username"] == null)
{
return(RedirectToAction("Index", "Home"));
}
if (Session["uType"] == null)
{
return(RedirectToAction("Index", "Home"));
}
System.Diagnostics.Debug.WriteLine("-----Edit Worker-------------------------------");
System.Diagnostics.Debug.WriteLine(workerID);
System.Diagnostics.Debug.WriteLine("-----Edit Worker-------------------------------");
/*if (Request["workerID"] != null)
* Session["workerID"] = Request["workerID"];
*
* var id = Int32.Parse(Session["workerID"].ToString());*/
Session["workerID"] = workerID;
worker worker = dbContext.worker.Find(workerID);
if (worker == null)
{
return(HttpNotFound());
}
var typeList = getWorkerTypeList(worker.type);
ViewData["typeList"] = typeList;
return(View(worker));
}
public async Task <IActionResult> Putworker(long id, worker worker)
{
if (id != worker.Id)
{
return(BadRequest());
}
_context.Entry(worker).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!workerExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IEnumerator move_animation(worker obj, GameObject dest)
{
Vector3 workerPos = obj.gameObject.transform.position;
Debug.Log(dest.name);
Vector3 destination = dest.transform.position;
Debug.Log(workerPos.x + ", " + workerPos.z);
Debug.Log(destination.x + ", " + destination.z);
Vector3 direction = (destination - workerPos) / 10;
Debug.Log(direction.x + ", " + direction.z);
for (int i = 0; i < 10; i++)
{
if (obj != null)
{
obj.gameObject.transform.position = obj.gameObject.transform.position + new Vector3(direction.x, 0, direction.z);
}
yield return(new WaitForSeconds(0.05f));
}
if (obj != null)
{
obj.worker_obj.transform.position = new Vector3(destination.x, workerPos.y, destination.z);
}
yield return(new WaitForSeconds(0.05f));
}
public IActionResult AddDriver(AddWorker model, string depart)
{
worker worker = new worker()
{
age = model.age,
fullname = model.fullname,
namber = model.namber,
};
_context.workers.Add(worker);
_context.SaveChanges();
work_data work_Data = new work_data()
{
department = _context.departments.Where(e => e.Department_Key == Convert.ToInt32(depart)).FirstOrDefault(),
worker = _context.workers.Where(e => e.fullname == worker.fullname).FirstOrDefault(),
profession = _context.professions.Where(e => e.Profession_Key == 1).FirstOrDefault(),
date_start = model.date_start,
date_end = model.date_end
};
work_Data.Department_Key = work_Data.department.Department_Key;
work_Data.Worker_Key = work_Data.worker.Worker_Key;
work_Data.Profession_Key = work_Data.profession.Profession_Key;
_context.work_data.Add(work_Data);
_context.SaveChanges();
return(RedirectToAction("AddDriverToAvto", "AddSome", new { id = model.Avto_Key }));
}
public void dump_waste(worker obj)
{
if (obj.location.name.Substring(4) == "Dome_tile")
{
TurnManager turn_manager = GameObject.Find("TurnManager").GetComponent <TurnManager>();
PlayerStats player;
if (obj.location.name.Substring(0, 1) == "0")
{
player = turn_manager.player1.GetComponent <PlayerStats>();
}
else
{
player = turn_manager.player2.GetComponent <PlayerStats>();
}
player.resources.w += (float)obj.waste_on_worker;
obj.waste_on_worker = 0;
return;
}
Building BuildingOnTile = obj.location.GetComponent <TileClass>().GetComponentInChildren <Building>();
if (BuildingOnTile != null)
{
if (BuildingOnTile.name == "Landfill(Clone)")
{
BuildingOnTile.nowWaste += (float)obj.waste_on_worker;
obj.waste_on_worker = 0;
}
return;
}
obj.location.GetComponent <TileClass>().resources.w += (float)obj.waste_on_worker;
obj.waste_on_worker = 0;
}
public async Task <ActionResult <worker> > Postworker(worker worker)
{
_context.workerContexts.Add(worker);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getworker", new { id = worker.Id }, worker));
}
public IActionResult EditWorker(AddWorker model, string depart, string professionss)
{
worker worker = new worker()
{
Worker_Key = model.Avto_Key,
age = model.age,
fullname = model.fullname,
namber = model.namber,
};
_context.workers.Update(worker);
_context.SaveChanges();
work_data work_Data = new work_data()
{
Work_data_Key = model.work_data_key,
department = _context.departments.Where(e => e.Department_Key == Convert.ToInt32(depart)).FirstOrDefault(),
worker = _context.workers.Where(e => e.fullname == worker.fullname).FirstOrDefault(),
profession = _context.professions.Where(e => e.Profession_Key == Convert.ToInt32(professionss)).FirstOrDefault(),
date_start = model.date_start,
date_end = model.date_end
};
work_Data.Department_Key = work_Data.department.Department_Key;
work_Data.Worker_Key = work_Data.worker.Worker_Key;
work_Data.Profession_Key = work_Data.profession.Profession_Key;
_context.work_data.Update(work_Data);
_context.SaveChanges();
return(RedirectToAction("ShowsWorker", "Shows"));
}
public ActionResult DeleteWorker()
{
if (Session["username"] == null)
{
return(RedirectToAction("Index", "Home"));
}
if (Session["uType"] == null)
{
return(RedirectToAction("Index", "Home"));
}
/*DBHelper db = DBHelper.getDB();
* string sql = "DELETE from worker where WorkerId = '" + Session["workerID"] + "' ";
* db.setData(sql);*/
int id = Int32.Parse(Session["workerID"].ToString());
worker worker = dbContext.worker.Find(id);
var img = worker.image;
img = @"E:\Mahin\3.2\New\Lab\ISD\MaidEasy\Content\Workers\" + img;
dbContext.worker.Remove(worker);
dbContext.SaveChanges();
System.IO.File.Delete(@img);
Session.Remove("workerID");
return(RedirectToAction("WorkerList", "AdminWorker"));
}
private static string getFIOWorker(int idWorker)
{
using (var db = new workshopEntities())
{
worker w = db.worker.Find(idWorker);
return(w.lastName + " " + w.firstName + " " + w.middleName);
}
}
public StatisticWindowViewModel(worker w, DateTime ft, DateTime st)
{
NameWorker = w.lastName + " " + w.firstName + " " + w.middleName;
Period = " з\t" + "\t по\n" + ft.Date.ToString().Split(' ')[0] + "\t" + st.Date.ToString().Split(' ')[0];
DateFirst = ft;
DateSecond = st.AddDays(1);
SelectedWorker = w;
}
/// <summary>
/// 공종별 현황
/// </summary>
/// <param name="listview"></param>
/// <param name="Job"></param>
public Detail(ListView listview, string Job)
{
int sumIn = 0, sumOut = 0;
int ii = 0;
listWorker.Clear();
InitializeComponent();
this.lv = listview;
dgvTotal.Visible = false;
lblDgvTotal.Visible = false;
dgvLoca.Visible = false;
lblDgvLoca.Visible = false;
dgvCompnay.Visible = false;
lblCompnay.Visible = false;
dgvJob.Visible = true;
foreach (ListViewItem item in lv.Items)
{
worker wk = new worker();
wk.time = item.SubItems[0].Text;
wk.status = item.SubItems[1].Text;
wk.name = item.SubItems[2].Text;
wk.tag = item.SubItems[3].Text;
wk.gate = item.SubItems[4].Text;
wk.job = item.SubItems[5].Text;
wk.loca = item.SubItems[6].Text;
wk.company = item.SubItems[7].Text;
listWorker.Add(wk);
}
for (int i = 0; i < formMain.listJob.Count; i++)
{
string zob = formMain.listJob[i];
int cntIn = 0, cntOut = 0;
foreach (worker wk in listWorker)
{
if (wk.job == zob && wk.status == "입")
{
cntIn++;
}
else if (wk.job == zob && wk.status == "출")
{
cntOut++;
}
}
string[] row = { zob, cntIn.ToString(), cntOut.ToString(), (cntIn - cntOut).ToString() };
dgvJob.Rows.Add(row);
ii++;
sumIn += cntIn;
sumOut += cntOut;
}
string[] row3 = { "총계", sumIn.ToString(), sumOut.ToString(), (sumIn - sumOut).ToString() };
dgvJob.Rows.Add(row3);
DataGridViewCellStyle style = new DataGridViewCellStyle();
style.Font = new Font(dgvJob.Font, FontStyle.Bold);
dgvJob.Rows[ii].DefaultCellStyle = style;
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
worker worker = await db.workers.FindAsync(id);
db.workers.Remove(worker);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void statisticWindowShow(worker w, DateTime first, DateTime second)
{
var sw = new StatisticWindow
{
DataContext = new StatisticWindowViewModel(w, first, second)
};
sw.ShowDialog();
}
public WorkerModel(worker m)
{
workerID = m.workerID;
FIO = m.FIO;
post = m.post;
age = m.age;
OrderedContracts = String.Join(",", m.contract.Select(i => i.contract_name).ToList());
OrderedContractsIds = m.contract.Select(i => i.contractID).ToList();
}
public void collect_waste(worker obj)
{
if (obj.location.name.Substring(4) == "Dome_tile")
{
TurnManager turn_manager = GameObject.Find("TurnManager").GetComponent <TurnManager>();
PlayerStats player;
if (obj.location.name.Substring(0, 1) == "0")
{
player = turn_manager.player1.GetComponent <PlayerStats>();
}
else
{
player = turn_manager.player2.GetComponent <PlayerStats>();
}
if (player.resources.w <= (obj.capacity - obj.waste_on_worker))
{
obj.waste_on_worker += (int)player.resources.w;
player.resources.w = (float)0;
}
else
{
obj.waste_on_worker = obj.capacity;
player.resources.w -= (float)(obj.capacity - obj.waste_on_worker);
}
return;
}
Building BuildingOnTile = obj.location.GetComponent <TileClass>().GetComponentInChildren <Building>();
if (BuildingOnTile != null)
{
if (BuildingOnTile.name == "Landfill(Clone)")
{
if (BuildingOnTile.nowWaste <= obj.capacity)
{
obj.waste_on_worker = (int)BuildingOnTile.nowWaste;
BuildingOnTile.nowWaste = (float)0;
}
else
{
obj.waste_on_worker = obj.capacity;
BuildingOnTile.nowWaste -= (float)obj.capacity;
}
return;
}
}
if (obj.location.GetComponent <TileClass>().resources.w <= obj.capacity)
{
obj.waste_on_worker = (int)obj.location.GetComponent <TileClass>().resources.w;
obj.location.GetComponent <TileClass>().resources.w = (float)0;
}
else
{
obj.waste_on_worker = obj.capacity;
obj.location.GetComponent <TileClass>().resources.w -= (float)obj.capacity;
}
}
protected void btAdd_Click(object sender, EventArgs e)
{
workDBDataContext db = new workDBDataContext();
worker workerQuery = new worker();
workerQuery.username = txtWorker.Text.Trim();
db.worker.InsertOnSubmit(workerQuery);
db.SubmitChanges();
Response.Redirect(HttpContext.Current.Request.RawUrl);
}
public void DeleteWorker(int id)
{
worker p = db.worker.Find(id);
if (p != null)
{
db.worker.Remove(p);
Save();
}
}
public void UpdateWorker(WorkerModel p)
{
worker ph = db.worker.Find(p.workerID);
ph.FIO = p.FIO;
ph.age = p.age;
ph.post = p.post;
// ph.ManufacturerId = p.ManufacturerId;
Save();
}
public void LoadAllWorkers()
{
fb_con.Open();
string sql = "SELECT * FROM WORKERS ORDER BY ID";
FbCommand cmd = new FbCommand(sql, fb_con);
worker oneworker;
DateTime dateTemp = new DateTime();
using (FbDataReader r = cmd.ExecuteReader())
{
int i;
while (r.Read())
{
i = 0;
oneworker = new worker();
oneworker.ID = r.GetInt32(i++);
oneworker.WORKERINTID = r.GetInt32(i++);
oneworker.DEPARTMENTID = r.GetInt32(i++);
oneworker.FIRSTNAME = r.GetString(i++);
oneworker.SURNAME = r.GetString(i++);
oneworker.MIDDLENAME = r.GetString(i++);
if (DateTime.TryParse(r.GetString(i++), out dateTemp))
{
oneworker.BIRTHDAY = dateTemp;
}
oneworker.PASSPORT = r.GetString(i++);
oneworker.LICENCE = r.GetString(i++);
if (DateTime.TryParse(r.GetString(i++), out dateTemp))
{
oneworker.DATEDUELICENCE = dateTemp;
}
oneworker.CATHEGORIES = r.GetString(i++);
oneworker.MEDICALCERTIFICATE = r.GetString(i++);
if (DateTime.TryParse(r.GetString(i++), out dateTemp))
{
oneworker.DATEDUEMEDICAL = dateTemp;
}
//BLOB READING
oneworker.PHOTO = new byte[(r.GetBytes(i++, 0, null, 0, int.MaxValue))];
if (oneworker.PHOTO.Length > 0)
{
r.GetBytes(0, 0, oneworker.PHOTO, 0, oneworker.PHOTO.Length);
}
/////////////////////
oneworker.NOTES = r.GetString(i++);
oneworker.CREATEWHO = r.GetString(i++);
oneworker.CREATEWHEN = r.GetString(i++);
oneworker.CHANGEWHO = r.GetString(i++);
oneworker.CHANGEWHEN = r.GetString(i++);
workers.Add(oneworker);
}
}
fb_con.Close();
}
private static Client LoadSystem()
{
Composite Tree = new Composite("Tree", "İt keeps All segments");
Composite Web = new Composite("WebSegment", "İt keeps web_Worker");
Composite Cyber = new Composite("CyberSegment", "İt keeps cyber_Worker");
Composite AI = new Composite("AiSegment", "İt keeps AI_Worker");
worker worker1 = new worker("Mustafa", "Clouder", 5000);
worker worker2 = new worker("Ali", "Clouder", 5000);
worker worker3 = new worker("Veli", "Clouder", 5000);
worker worker4 = new worker("Emre", "AIworker", 5000);
worker worker5 = new worker("Veli", "AIworker", 5000);
worker worker6 = new worker("Kazım", "AIworker", 5000);
worker worker7 = new worker("Ali", "AIworker", 5000);
worker worker8 = new worker("veli", "Manager", 5000);
worker worker9 = new worker("Zeynep", "Manager", 5000);
worker worker10 = new worker("ŞtandartKazım", "SoftwareEn", 5000);
worker worker11 = new worker("Memati", "SoftwareEn", 5000);
worker worker12 = new worker("Cahit", "SoftwareEn", 5000);
worker worker13 = new worker("Mehmet", "SoftwareEn", 5000);
worker worker14 = new worker("Zeynep", "SoftwareEn", 5000);
worker worker15 = new worker("Celil", "AIworker", 5000);
worker worker16 = new worker("Polat", "Clouder", 5000);
Composite AISub = new Composite("AISub", "SubAreaOfAI");
worker denemeai = new worker("AliSub", "Manager", 50);
AI.Add(AISub);
Tree.Add(Web);
Tree.Add(Cyber);
Tree.Add(AI);
AISub.Add(denemeai);
Web.Add(worker16);
Web.Add(worker15);
Web.Add(worker12);
Web.Add(worker10);
Cyber.Add(worker14);
Cyber.Add(worker13);
Cyber.Add(worker12);
Cyber.Add(worker10);
Cyber.Add(worker8);
Cyber.Add(worker5);
AI.Add(worker1);
AI.Add(worker2);
AI.Add(worker4);
AI.Add(worker5);
AI.Add(worker6);
AI.Add(worker11);
AI.Add(worker7);
AI.Add(worker9);
Cyber.Add(worker3);
Cyber.Add(worker4);
Client client = new Client(Tree);
return(client);
}
public worker(worker copy) : base()
{
this.sallary = copy.sallary;
this.dateIn = copy.dateIn;
this.role = copy.role;
this.fullName = copy.fullName;
this.unixBorn = copy.unixBorn;
this.sex = copy.sex;
this.nationality = copy.nationality;
this.city = copy.city;
}
public void UpdateWorker(worker worker)
{
try
{
db.Entry(worker).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
catch
{
throw;
}
}
private void GUIsubmit_Click(object sender, RoutedEventArgs e)
{
switch (get_action())
{
case "add":
switch (get_view())
{
case "worker":
Console.WriteLine(DB.add_worker(user_name.Text, user_first_name.Text, user_last_name.Text, (user_date_of_birth.SelectedDate.HasValue ? (DateTime)user_date_of_birth.SelectedDate : DateTime.Now), int.Parse(user_worker_access.Text), CURRENT_USER).ToString());
break;
case "client":
Console.WriteLine(DB.add_client(user_name.Text, user_first_name.Text, user_last_name.Text, (user_date_of_birth.SelectedDate.HasValue ? (DateTime)user_date_of_birth.SelectedDate : DateTime.Now), CURRENT_USER).ToString());
break;
case "book":
Console.WriteLine(DB.add_book(book_name.Text, book_author.Text, book_category.Text, int.Parse(book_rating.Text), CURRENT_USER).ToString());
break;
}
break;
case "remove":
switch (get_view())
{
case "worker":
worker tempw = DB.delete_worker(user_name.Text, user_first_name.Text, user_last_name.Text, (user_date_of_birth.SelectedDate.HasValue ? (DateTime)user_date_of_birth.SelectedDate : DateTime.Now), int.Parse(user_worker_access.Text), CURRENT_USER);
if (tempw != null)
{
Console.WriteLine(tempw.ToString());
}
break;
case "client":
client tempc = DB.delete_client(user_name.Text, user_first_name.Text, user_last_name.Text, (user_date_of_birth.SelectedDate.HasValue ? (DateTime)user_date_of_birth.SelectedDate : DateTime.Now), CURRENT_USER);
if (tempc != null)
{
Console.WriteLine(tempc.ToString());
}
break;
case "book":
book tempb = DB.delete_book(book_name.Text, book_author.Text, book_category.Text, int.Parse(book_rating.Text), CURRENT_USER);
if (tempb != null)
{
Console.WriteLine(tempb.ToString());
}
break;
}
break;
}
GUI_clear();
}
//calculate path from current to destination.
//called every turn by all moving workers
//if there is a obstacle blocks way, calls player
public IEnumerator move_action(worker obj)
{
GameObject next = Calc_Path(obj.location, obj.destination);
Debug.Log("move action " + next.name);
StartCoroutine(move_animation(obj, next));
obj.location.GetComponent <TileClass>().tile_worker.Remove(obj.gameObject);
obj.location = next;
obj.is_assigned = true;
next.GetComponent <TileClass>().tile_worker.Add(obj.gameObject);
yield return(null);
}
public void AddWorker(worker worker)
{
try
{
db.worker.Add(worker);
db.SaveChanges();
}
catch
{
throw;
}
}
public void DeleteWorker(ulong id)
{
try
{
worker worker = db.worker.Find(id);
db.worker.Remove(worker);
db.SaveChanges();
}
catch
{
throw;
}
}
public Worker(worker item)
{
this.WorkerId = item.worker_id;
this.CompanyId = item.company_id;
this.Identity_UserID = item.identity_user_id;
this.IdNumber = item.id_number;
this.FirstName = item.first_name;
this.LastName = item.last_name;
this.PhoneNumber = item.phone_number;
this.Email = item.email;
this.Registered = item.registered.GetValueOrDefault(false);
this.RegisterDate = item.register_date;
}
public async Task <ActionResult> Edit([Bind(Include = "worker_id,identity_user_id,company_id,worker_number,id_number,first_name,last_name,email,phone_number,active,last_update")] worker worker)
{
if (ModelState.IsValid)
{
db.Entry(worker).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.company_id = new SelectList(db.companies, "company_id", "name", worker.company_id);
ViewBag.identity_user_id = new SelectList(db.users, "Id", "Email", worker.identity_user_id);
return(View(worker));
}
public bool addWorker(int ID, int position, float health, Jobs job, Resources holdingResource)
{
worker temp = new worker(ID, position, health, job, holdingResource);
for (int i = 0; i < workers.Length; i++)
{
if (workers[i].isNull())
{
workers[i] = temp;
return(true);
}
}
return(false);
}
private void button1_Click(object sender, EventArgs e)
{
worker cli = new worker();
cli.FIO = t1;
cli.post = t2;
cli.age = t3;
dbcontext.worker.Add(cli);
dbcontext.SaveChanges();
MessageBox.Show("Новый объект добавлен");
}
static void Main(string[] args)
{
worker NewWorker_1 = new worker();
worker NewWorker_2 = new worker();
Console.ReadLine();
Console.WriteLine(worker.n);
//передаем параметр через лямбда функцию
/*Thread FirstThread = new Thread(() => PrintIncrement(1));
Thread SecondThread = new Thread(() => PrintIncrement(2));*/
//приложение может быть завершено даже если Background поток продолжает работать
/*FirstThread.IsBackground = true;
FirstThread.Start();
SecondThread.Start();*/
Console.ReadLine();
}
public void LoadAllWorkers()
{
fb_con.Open();
string sql = "SELECT * FROM WORKERS ORDER BY ID";
FbCommand cmd = new FbCommand(sql, fb_con);
worker oneworker;
DateTime dateTemp = new DateTime();
using (FbDataReader r = cmd.ExecuteReader())
{
int i;
while (r.Read())
{
i = 0;
oneworker = new worker();
oneworker.ID = r.GetInt32(i++);
oneworker.WORKERINTID = r.GetInt32(i++);
oneworker.DEPARTMENTID = r.GetInt32(i++);
oneworker.FIRSTNAME = r.GetString(i++);
oneworker.SURNAME = r.GetString(i++);
oneworker.MIDDLENAME = r.GetString(i++);
if (DateTime.TryParse(r.GetString(i++), out dateTemp))
oneworker.BIRTHDAY = dateTemp;
oneworker.PASSPORT = r.GetString(i++);
oneworker.LICENCE = r.GetString(i++);
if (DateTime.TryParse(r.GetString(i++), out dateTemp))
oneworker.DATEDUELICENCE = dateTemp;
oneworker.CATHEGORIES = r.GetString(i++);
oneworker.MEDICALCERTIFICATE = r.GetString(i++);
if (DateTime.TryParse(r.GetString(i++), out dateTemp))
oneworker.DATEDUEMEDICAL = dateTemp;
//BLOB READING
oneworker.PHOTO = new byte[(r.GetBytes(i++, 0, null, 0, int.MaxValue))];
if (oneworker.PHOTO.Length > 0)
r.GetBytes(0, 0, oneworker.PHOTO, 0, oneworker.PHOTO.Length);
/////////////////////
oneworker.NOTES = r.GetString(i++);
oneworker.CREATEWHO = r.GetString(i++);
oneworker.CREATEWHEN = r.GetString(i++);
oneworker.CHANGEWHO = r.GetString(i++);
oneworker.CHANGEWHEN = r.GetString(i++);
workers.Add(oneworker);
}
}
fb_con.Close();
}
