public async Task <IActionResult> Edit(int id, [Bind("idLog,Log")] logs logs)
{
if (id != logs.idLog)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(logs);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!logsExists(logs.idLog))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(logs));
}
private void MBut_addFreeWork_Click(object sender, EventArgs e)
{
using (DataBase db = new DataBase())
{
try
{
if (idOreder == 0)
{
freeWork fs = new freeWork();
fs.nameFreeWork = mTextB_addFreeWork.Text.Trim();
logs lg = new logs();
lg.idUser = this.idUser;
lg.typeSql = "Insert";
lg.nameTable = "FreeWork";
lg.fielTable = "id, nameFreeWork";
lg.newValue = mTextB_addFreeWork.Text.Trim();
lg.dateCrt = DateTime.Now;
db.logs.Add(lg);
db.freeWork.Add(fs);
db.SaveChanges();
funDGV();
MessageBox.Show("Запись добавлена");
mTextB_addFreeWork.Clear();
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
}
public ActionResult Index(user userr)
{
try
{
//kontrol
if (userr.username.Length < 4 || userr.username.Length > 12)
{
ViewBag.error = "Username length must be in 4 and 12";
return(View(userr));
}
if (userr.password.Length < 5 || userr.password.Length > 16)
{
ViewBag.error = "Username length must be in 5 and 16";
return(View(userr));
}
var checkusername = (from a in ent.user where a.username == userr.username select a).FirstOrDefault();
if (checkusername != null)
{
ViewBag.error = "Error. This username already in use.";
return(View(userr));
}
var checkemail = (from a in ent.user where a.email == userr.email select a).FirstOrDefault();
if (checkemail != null)
{
ViewBag.error = "Error. This email already in use.";
return(View(userr));
}
//end kontrol
user usr = new user();
usr.username = userr.username;
usr.email = userr.email;
usr.password = userr.password;
usr.aktif = true;
usr.age = userr.age;
usr.user_group_id = 2;
usr.registerdate = DateTime.Now;
ent.user.Add(usr);
ent.SaveChanges();
logs log = new logs();
log.createdDate = DateTime.Now;
log.info = EvrenselKodlarController.GetIPAddress();
log.log_type_id = 3;
ent.logs.Add(log);
ent.SaveChanges();
ViewBag.success = "Register successful.";
return(View(userr));
}
catch
{
ViewBag.error = "Something happaned wrong. Contact with mods.";
return(View(userr));
}
}
private void MBut_addFreeWork_Click_1(object sender, EventArgs e)
{
using (DataBase db = new DataBase())
{
try
{
if (idOreder == 0)
{
usersRole ur = new usersRole();
ur.users.fio = mTextB_adduserFIO.Text.Trim();
ur.role.name = mComB_addRole.Text.Trim();
logs lg = new logs();
lg.idUser = this.idUser;
lg.typeSql = "Insert";
lg.nameTable = "FreeWork";
lg.fielTable = "id, nameFreeWork";
lg.newValue = mTextB_adduserFIO.Text.Trim() + " " + mComB_addRole.Text.Trim();
lg.dateCrt = DateTime.Now;
db.logs.Add(lg);
db.usersRole.Add(ur);
db.SaveChanges();
funDGV();
MessageBox.Show("Запись добавлена");
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
}
private void MBut_editFreeWork_Click_1(object sender, EventArgs e)
{
using (DataBase db = new DataBase())
{
try
{
if (idOreder != 0)
{
usersRole fs = db.usersRole.FirstOrDefault(p => p.id == idOreder);
logs lg = new logs();
lg.oldValue = idOreder + " " + mTextB_edituserFIO.Text.Trim();
fs.users.fio = mTextB_edituserFIO.Text.Trim();
lg.idUser = this.idUser;
lg.typeSql = "Update";
lg.nameTable = "FreeWork";
lg.fielTable = "id, nameFreeWork";
lg.newValue = mTextB_edituserFIO.Text.Trim();
lg.dateCrt = DateTime.Now;
db.logs.Add(lg);
db.SaveChanges();
funDGV();
MessageBox.Show("Данные изменены");
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
}
//int id = 0;
private void MBut_delPersYear_Click(object sender, EventArgs e)
{
using (DataBase db = new DataBase())
{
var Result = MessageBox.Show("Вы уверены что хотите удалить всех студентов в данном году?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
var ser = db.persons.Where(obj => mTextB_yearIssue.Text.Contains(obj.yeatIssue.Value.ToString())).ToList();
try
{
if (Result == DialogResult.Yes)
{
logs lg = new logs();
lg.idUser = this.idUser;
lg.typeSql = "Delete";
lg.nameTable = "perstToWork, persons";
lg.fielTable = "all";
lg.oldValue = "Удаление всех студентов " + mTextB_yearIssue.Text + " года";
lg.dateCrt = DateTime.Now;
db.logs.Add(lg);
db.persons.RemoveRange(ser);
db.SaveChanges();
MessageBox.Show("Запись удалена");
}
}
catch { MessageBox.Show("В этом году не было выпускников или в БД нет записей за этот год"); }
}
}
public static void AddUserLog(string message, string object_ID, string userID_str, string username, string IP_client = "")
{
// Logger variables
System.Diagnostics.StackTrace stackTrace = new System.Diagnostics.StackTrace(true);
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
string className = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name;
string methodName = stackFrame.GetMethod().Name;
using (ChevacaDB context = new ChevacaDB())
{
logs _logs = new logs();
_logs.Fecha_creado = GlobalVariables.GetCurrentTime();
_logs.Usuario = username;
_logs.Descripcion = message;
_logs.Dato_afectado = object_ID;
_logs.IP_client = IP_client;
int userID = 0;
if (!string.IsNullOrWhiteSpace(userID_str))
{
if (!int.TryParse(userID_str, out userID))
{
userID = 0;
AddErrorLog("Excepcion. Convirtiendo int. ERROR:", className, methodName, userID_str);
}
}
_logs.Usuario_ID = userID;
context.logs.Add(_logs);
context.SaveChanges();
}
}
public void MBut_editFreeWork_Click(object sender, EventArgs e)
{
using (DataBase db = new DataBase())
{
try
{
if (idOreder != 0)
{
freeWork fs = db.freeWork.FirstOrDefault(p => p.id == idOreder);
logs lg = new logs();
lg.oldValue = idOreder + " " + mTextB_editFreeWork.Text.Trim();
fs.nameFreeWork = mTextB_editFreeWork.Text.Trim();
lg.idUser = this.idUser;
lg.typeSql = "Update";
lg.nameTable = "FreeWork";
lg.fielTable = "id, nameFreeWork";
lg.newValue = mTextB_editFreeWork.Text.Trim();
lg.dateCrt = DateTime.Now;
db.logs.Add(lg);
db.SaveChanges();
funDGV();
MessageBox.Show("Данные изменены");
mTextB_editFreeWork.Clear();
}
}
catch { MessageBox.Show("Данного приказа уже нет"); }
}
}
public async Task <IActionResult> AssinarChamado(int id)
{
//recupera usuario logado e busca no banco de dados
var userName = User.Identity.Name;
var user = await _context.Users.FirstOrDefaultAsync(x => x.UserName == userName);
var usuario = await _context.Funcionario.FirstOrDefaultAsync(x => x.PessoaId == user.Id);
var chamado = await _context.Chamados.FirstOrDefaultAsync(x => x.idChamado == id);
chamado.status = "Andamento";
chamado.FuncionarioId = usuario.IdFuncionario;
_context.Chamados.Update(chamado);
_context.SaveChanges();
//registra log da alteração
logsController logs = new logsController(_context);
var log = new logs();
log.IdUsuario = usuario.IdFuncionario;
log.Tipo = TipoLogEnum.AssinarChamado;
log.chamdosId = chamado.idChamado;
logs.SalvarLog(log);
return(RedirectToAction(nameof(Index)));
}
public void deleteLogs(logs log)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
context.logs.Remove(log);
context.SaveChanges();
}
}
public async Task <IActionResult> Create([Bind("idChamado,DH_Abertura,DH_Fechamento,descricao,categoriasId,comentariosId,logsId,gruposId,prioridadesId,Arquivo")] chamados chamados)
{
if (ModelState.IsValid)
{
//Se o chamdo for aberto pelo proprio usuario pega o id pelo usuario logado
if (chamados.UsuarioId == 0)
{
//recupera usuario logado e busca no banco de dados
var userName = User.Identity.Name;
var user = await _context.Users.FirstOrDefaultAsync(x => x.UserName == userName);
var usuario = await _context.Usuario.FirstOrDefaultAsync(x => x.PessoaId == user.Id);
chamados.UsuarioId = usuario.IdUsuario;
}
chamados.status = "Aberto";
chamados.DH_Abertura = DateTime.Now;
_context.Add(chamados);
await _context.SaveChangesAsync();
if (chamados.Arquivo != null)
{
var retorno = Upload(chamados.Arquivo);
var arquivo = new Arquivos();
arquivo.Arquivo = string.Format(@"{0}\{1}{2}", retorno.CaminhoDBArquivo, retorno.NomeArquivo, retorno.ExtensaoArquivo);
arquivo.NomeArquivo = chamados.Arquivo.FileName;
arquivo.DH_Cadastro = DateTime.Now;
arquivo.chamdosId = chamados.idChamado;
//salva
_context.Arquivos.Add(arquivo);
await _context.SaveChangesAsync();
}
//registra log da alteração
logsController logs = new logsController(_context);
var log = new logs();
log.IdUsuario = chamados.UsuarioId;
log.Tipo = TipoLogEnum.Criacao;
log.chamdosId = chamados.idChamado;
logs.SalvarLog(log);
return(RedirectToAction(nameof(Index)));
}
// ViewBag.categoriasId = new SelectList(_context.Categoria.ToList(), "idCategoria", "categoria", chamados.categoriasId);
//ViewData["categoriasId"] = new SelectList(_context.Categoria, "idCategoria", "idCategoria", chamados.categoriasId);
//ViewData["comentariosId"] = new SelectList(_context.Comentarios, "idComentario", "idComentario", chamados.comentariosId);
//ViewBag.gruposId = new SelectList(_context.grupos.ToList(), "idGrupo", "grupo", chamados.gruposId);
//ViewData["gruposId"] = new SelectList(_context.grupos, "idGrupo", "idGrupo", chamados.gruposId);
//ViewData["logsId"] = new SelectList(_context.Logs, "idLog", "idLog", chamados.logsId);
//ViewData["prioridadesId"] = new SelectList(_context.Prioridades, "idPrioridade", "idPrioridade", chamados.prioridadesId);
return(await Index());
}
public logs Add(logs item)
{
if (item == null)
{
throw new ArgumentNullException("item");
}
Banco.InserirLog(item);
return(item);
}
public HttpResponseMessage PostLogs(logs item)
{
item = repositorio.Add(item);
var response = Request.CreateResponse <logs>(HttpStatusCode.Created, item);
string uri = Url.Link("DefaultApi", new { id = item.idLogs });
response.Headers.Location = new Uri(uri);
return(response);
}
public logs GetLogs(int id)
{
logs item = repositorio.Get(id);
if (item == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
return(item);
}
public static void writelog(string txt)
{
UserService userService = new UserService();
logs loger = new logs();
loger.entry = txt;
loger.nid = userService.getNid() != ""? userService.getNid():"";
loger.ip = userService.getUserIp();
loger.date = DateTime.Now;
loger.Save();
}
public LogMaintainer(
logs log,
ILogRepository repository,
ITimeService timeService,
INpgsqlConnectionFactory connectionFactory)
{
_repository = repository;
_timeService = timeService;
_connectionFactory = connectionFactory;
_timeToStore = log.time_to_store.HasValue ? new TimeSpan(log.time_to_store.Value) as TimeSpan? : null;
}
public void SalvarLog(logs log)
{
var email = ControllerHelper.RecuperarNomePessoa(log.IdUsuario);
//monta log
var logText = string.Format("{0} : {1} em {2}", email, log.Tipo, DateTime.Now);
log.Log = logText;
_context.Add(log);
_context.SaveChanges();
}
public logs GetLog(int id)
{
var res = new logs();
try
{
res = GetLogs().FirstOrDefault(x => x.id == id);
}
catch (Exception ex)
{
}
return(res);
}
protected void Button1_Click(object sender, EventArgs e)
{
string TxtPath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\TestPage\\TextToSql\\TextFile\\1.txt";
StreamReader sr = new StreamReader(TxtPath, Encoding.UTF8);
string nextLine;
logs l = new logs();
while ((nextLine = sr.ReadLine()) != null)
{
if (nextLine.Contains("IP"))
{
try
{
string[] TimeAndIp = Regex.Split(nextLine, "IP:", RegexOptions.IgnoreCase);
l.strIp = TimeAndIp[1].ToString();
string time1 = TimeAndIp[0];
l.dtCreatTime = time1.Trim();
}
catch
{
l.strIp = "无ip";
l.dtCreatTime = "无时间";
}
}
if (nextLine.Contains("接口名称"))
{
l.strName = nextLine;
}
if (nextLine.Contains("执行用时"))
{
string[] strTimes = nextLine.Split(':');
string strTime1 = strTimes[1].ToString();
strTime1 = strTime1.Substring(0, strTime1.Length - 2);
l.nTimes = Convert.ToInt32(strTime1);
}
if (nextLine.Contains("接口参数"))
{
l.strData = nextLine;
}
if (nextLine == "---------------------------------------------------------------------")
{
Addlogs(l);
}
}
sr.Close();
}
public bool Addlogs(logs model)
{
string strSql = "insert into [Tab_System_TxtLog] (dtCreatTime,strName,nTimes,strData,strIp) values (@dtCreatTime,@strName,@nTimes,@strData,@strIp)";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("dtCreatTime", model.dtCreatTime),
new SqlParameter("strName", model.strName),
new SqlParameter("nTimes", model.nTimes),
new SqlParameter("strData", model.strData),
new SqlParameter("strIp", model.strIp)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters) > 0);
}
public ILogMaintainer Create(string connectionString, logs log, ITimeService timeService)
{
var npgsqlConnectionFactory = new NpgsqlConnectionFactory(connectionString);
var logRepository = new LogRepository(log.id);
using (var connection = npgsqlConnectionFactory.Create())
{
logRepository.EnsureTable(connection);
}
return(new LogMaintainer(
log,
logRepository,
timeService,
npgsqlConnectionFactory));
}
public static void writelog(string txt, users user, string controller, string action, int obj_id)
{
UserService userService = new UserService();
logs loger = new logs();
loger.entry = txt;
loger.nid = user == null?userService.getNid() : user.nid;
loger.ip = userService.getUserIp();
loger.date = DateTime.Now;
loger.controller = controller;
loger.action = action;
loger.obj_id = obj_id;
ActiveRecordMediator <logs> .Save(loger);
}
public async Task <IActionResult> Create(logs logs)
{
if (ModelState.IsValid)
{
var email = ControllerHelper.RecuperarNomePessoa(logs.IdUsuario);
//monta log
var log = string.Format("{0} : {1} em {2}", email, logs.Tipo, DateTime.Now);
logs.Log = log;
_context.Add(logs);
_context.SaveChanges();
}
return(View(logs));
}
public static void AddErrorLog(string message, string className, string methodName, string obj, [CallerLineNumber] int numberNumber = 0)
{
try
{
string Path_Data = @"Logs\";
if (ConfigurationManager.AppSettings != null)
{
Path_Data = ConfigurationManager.AppSettings["Path_Log"].ToString();
}
string File_ErrorLog = "error_log.txt";
if (ConfigurationManager.AppSettings != null)
{
File_ErrorLog = ConfigurationManager.AppSettings["File_ErrorLog"].ToString();
}
string path_complete = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, Path_Data);
if (!Directory.Exists(Path.GetDirectoryName(path_complete)))
{
Directory.CreateDirectory(Path.GetDirectoryName(path_complete));
}
using (StreamWriter writer = new StreamWriter(path_complete + "/" + File_ErrorLog, true))
{
string text = DateTime.Now.ToString() + ": [ln:" + numberNumber + "] " + className + ": " + methodName + "() - " + message + " " + obj + ".";
writer.WriteLine(text);
}
using (ChevacaDB context = new ChevacaDB())
{
logs _logs = new logs();
_logs.Usuario_ID = 0;
_logs.Fecha_creado = GlobalVariables.GetCurrentTime();
_logs.Usuario = "Externo";
_logs.IP_client = "N/D";
_logs.Descripcion = message + "|" + obj;
_logs.Dato_afectado = "N/D";
context.logs.Add(_logs);
context.SaveChanges();
}
}
catch (Exception) { }
}
public logs AddLog(games game, int turn, int position, string player, string mark)
{
var res = new logs();
try
{
if (game == null || game.id == 0)
{
return(res);
}
if (!_players.Contains(player))
{
return(res);
}
if (!_marks.Contains(mark))
{
return(res);
}
if (turn < 1 || 9 < turn)
{
return(res);
}
if (position < 0 || 8 < position)
{
return(res);
}
res = new logs
{
id = 0,
gameID = game.id,
player = player,
mark = mark.ToString(),
turn = turn,
position = position
};
db.SaveLog(res);
}
catch (Exception ex)
{
}
return(res);
}
/// <summary>
/// realiza log en la base de datos
/// </summary>
/// <param name="dato_nuevo"></param>
/// <param name="dato_anterior"></param>
/// <param name="usuario"></param>
/// <param name="tabla"></param>
/// <param name="accion"></param>
/// <param name="obs"></param>
/// <param name="db"></param>
public static void logApp(string dato_nuevo, string dato_anterior, int usuario, string tabla, string accion, string obs, gambling_dbEntities db)
{
try
{
logs dato = new logs();
dato.dato_anterior = dato_anterior;
dato.dato_nuevo = dato_nuevo;
dato.usuario = usuario;
dato.observacion = obs; //+ " " + GamblingHelper.datosPC();
dato.tabla = tabla;
dato.accion = accion;
dato.fecha_accion = DateTime.Now;
db.logs.Add(dato);
db.SaveChanges();
}
catch (Exception ex)
{
}
}
/// <summary> </summary>
public static void writelog(string txt, appuser user, string controller, string action, int obj_id)
{
if (Controllers.installController.is_installed())
{
logs loger = new logs();
loger.entry = txt;
loger.nid = user == null?userService.getNid() : user.nid;
loger.ip = userService.getUserIp();
loger.date = DateTime.Now;
loger.controller = controller;
loger.action = action;
loger.obj_id = obj_id;
ActiveRecordMediator <logs> .Save(loger);
}
else
{
//DateTime time = DateTime.Now;
//string format = "MMM ddd d HH:mm yyyy";
//file_handler.write_to_file("logs/install.log", time.ToString(format)+" "+ txt, true);
}
}
private void ToolStripMenuItem_Click(object sender, EventArgs e)
{
// ToolStripItem clickedItem = sender as ToolStripItem;
using (DataBase db = new DataBase())
{
var Result = MessageBox.Show("Вы уверены что хотите удалить данную запись?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
persToWork persW = db.persToWork.FirstOrDefault(obj => obj.id == id);
try
{
if (Result == DialogResult.Yes)
{
logs lg = new logs();
lg.idUser = this.idUser;
lg.typeSql = "Delete";
lg.nameTable = "perstToWork, persons";
lg.fielTable = "all";
lg.oldValue = persW.id + " " + persW.persons.surname + " " + persW.persons.name + " " + persW.persons.patronymic + " " + persW.persons.birthday + " " + persW.persons.gender + " " +
//persW.persons.addressCountry + " " + persW.persons.addressRegion + " " + persW.persons.addressArea + " " + persW.persons.addressCity + " " + persW.persons.addressStreet + " " + persW.persons.addressHome + " " + persW.persons.addressFlat + " " +
persW.persons.addressCity + " " + persW.persons.addressStreet + " " + persW.persons.addressHome +
persW.persons.typeQualification.nameQualification + " " + persW.persons.trainingDirection + " " + persW.persons.profile + " " + persW.persons.yeatIssue + " " +
persW.nameStateOrg + " " + persW.nameOrg + " " + persW.post + " " + persW.freeWork.nameFreeWork + " " + persW.numCertificate + " " + persW.numReference + " " + persW.verificationArrival + " " + persW.commentary;
lg.dateCrt = DateTime.Now;
db.logs.Add(lg);
int id = persW.idPers.Value;
persons pe = db.persons.FirstOrDefault(obj => obj.id == id);
db.persons.Remove(pe);
//db.persToWork.Remove(persW);
db.SaveChanges();
MessageBox.Show("Запись удалена");
}
}
catch { MessageBox.Show("Данной перосны уже нет обновит таблицу нажав на кнопку поиск"); }
}
}
private void MBut_savePersCard_Click_1(object sender, EventArgs e)
{
using (DataBase db = new DataBase())
{
try
{
if (idPers == 0 && idUser != 0)
{
#region INSERT новая персона
int qid = mComboB_qualificationLevel.Text == "бакалавр" ? 1 : 2;
typeQualification TQ = new typeQualification();
TQ.nameQualification = qid.ToString();
persons ps = new persons();
ps.idTypeQualification = qid;
ps.surname = mTextB_surname.Text.Trim();
ps.name = mTextB_name.Text.Trim();
ps.patronymic = mTextB_patronymic.Text.Trim();
ps.birthday = dateTime_birthday.Value;
ps.gender = mComboB_gender.Text.Trim();
ps.addressCountry = mTextB_addressCountry.Text.Trim();
// ps.addressRegion = mTextB_addressRegion.Text.Trim();
// ps.addressArea = mTextB_addressArea.Text.Trim();
ps.addressCity = mTextB_addressCity.Text.Trim();
ps.addressStreet = mTextB_addressStreet.Text.Trim();
ps.addressHome = mTextB_addressHome.Text.Trim();
// ps.addressFlat = mTextB_addressFlat.Text.Trim();
ps.trainingDirection = mTextB_trainingDirection.Text.Trim();
ps.profile = mTextB_profile.Text.Trim();
ps.yeatIssue = mTextB_yearIssue.Text == "" ? ps.yeatIssue = 1970 : Convert.ToInt16(mTextB_yearIssue.Text.Trim());
db.persons.Add(ps);
idPers = ps.id;
int IDFW = db.freeWork.FirstOrDefault(p => p.nameFreeWork == mComboB_freeWork.Text.Trim()).id;
freeWork fW = new freeWork();
fW.nameFreeWork = IDFW.ToString();
persToWork pTW = new persToWork();
pTW.idPers = idPers;
pTW.idFreeWork = IDFW;
pTW.nameStateOrg = mTextB_nameStateOrg.Text.Trim();
pTW.educational = mTextB_educational.Text.Trim();
pTW.nameOrg = mTextB_nameOrg.Text.Trim();
pTW.cityOrg = mTextB_cityOrg.Text.Trim();
pTW.post = mTextB_post.Text.Trim();
pTW.numCertificate = mTextB_numCertificate.Text.Trim();
pTW.numReference = mTextB_numReference.Text.Trim();
pTW.verificationArrival = mComboB_verificationArrival.Text == "в наличии" ? "T" : "F";
pTW.commentary = mTextB_commentary.Text.Trim();
pTW.dateCrt = DateTime.Now;
db.persToWork.Add(pTW);
logs lg = new logs();
lg.idUser = this.idUser;
lg.typeSql = "Insert";
lg.nameTable = "typeQualification, persons, freeWork, persToWork";
lg.newValue = idPers + " " + mTextB_surname.Text.Trim() + " " + mTextB_name.Text.Trim() + " " + mTextB_patronymic.Text.Trim() + " " + dateTime_birthday.Value + " " + mComboB_gender.Text.Trim() +
" " + mTextB_addressCountry.Text + " " + mTextB_addressCity.Text.Trim() + " " + mTextB_addressStreet.Text.Trim() + " " + mTextB_addressHome.Text.Trim() +
//+" "+mTextB_addressRegion.Text+" "+mTextB_addressArea.Text+" "+mTextB_addressArea.Text+" "+mTextB_addressCity.Text+" " +mTextB_addressStreet.Text+ " "+mTextB_addressHome.Text+" "+mTextB_addressFlat.Text +
" " + mComboB_qualificationLevel.Text.Trim() + " " + mTextB_trainingDirection.Text.Trim() + " " + mTextB_profile.Text.Trim() + " " + mTextB_yearIssue.Text.Trim() + " " + mComboB_freeWork.Text.Trim() +
" " + mTextB_nameStateOrg.Text.Trim() + " " + mTextB_educational.Text.Trim() + "" + mTextB_nameOrg.Text.Trim() + " " + mTextB_cityOrg.Text.Trim() + " " + mTextB_post.Text.Trim() + " " + mTextB_numCertificate.Text.Trim() + " " + mTextB_numReference.Text.Trim() + " " + mComboB_verificationArrival.Text.Trim() + " " + mTextB_commentary.Text.Trim();
lg.dateCrt = DateTime.Now;
db.logs.Add(lg);
MessageBox.Show("Запись добавлена");
#endregion
}
else
{
#region UPDATE Изменение информации о персоне
persToWork pTW = db.persToWork.FirstOrDefault(p => p.id == idPers);
logs lg = new logs();
lg.idUser = this.idUser;
lg.typeSql = "Update";
//lg.fielTable = pTW;
// lg.nametable = "typeQualification, persons, freeWork, persToWork";
lg.oldValue = pTW.id + " " + pTW.persons.surname + " " + pTW.persons.name + " " + pTW.persons.patronymic + " " + pTW.persons.birthday + " " + pTW.persons.gender +
//" " + pTW.persons.addressRegion + " " + pTW.persons.addressArea + " " + pTW.persons.addressCity + " " + pTW.persons.addressStreet + " " + pTW.persons.addressHome + " " + pTW.persons.addressFlat +
" " + pTW.persons.addressCountry + " " + pTW.persons.addressCity + " " + pTW.persons.addressStreet + " " + pTW.persons.addressHome + " " +
" " + pTW.persons.typeQualification.nameQualification + " " + pTW.persons.trainingDirection + " " + pTW.persons.profile + " " + pTW.persons.yeatIssue +
" " + pTW.nameStateOrg + " " + pTW.educational + " " + pTW.nameOrg + " " + pTW.cityOrg + " " + pTW.post + " " + pTW.freeWork.nameFreeWork + " " + pTW.numCertificate + " " + pTW.numReference + " " + pTW.verificationArrival + " " + pTW.commentary;
lg.dateCrt = DateTime.Now;
pTW.persons.surname = mTextB_surname.Text.Trim();
pTW.persons.name = mTextB_name.Text.Trim();
pTW.persons.patronymic = mTextB_patronymic.Text.Trim();
pTW.persons.birthday = dateTime_birthday.Value;
pTW.persons.gender = mComboB_gender.Text.Trim();
pTW.persons.addressCountry = mTextB_addressCountry.Text;
// pTW.persons.addressRegion = mTextB_addressRegion.Text;
// pTW.persons.addressArea = mTextB_addressArea.Text;
pTW.persons.addressCity = mTextB_addressCity.Text.Trim();
pTW.persons.addressStreet = mTextB_addressStreet.Text.Trim();
pTW.persons.addressHome = mTextB_addressHome.Text.Trim();
// pTW.persons.addressFlat = mTextB_addressFlat.Text;
pTW.persons.typeQualification.nameQualification = mComboB_qualificationLevel.Text.Trim();
pTW.persons.trainingDirection = mTextB_trainingDirection.Text.Trim();
pTW.persons.profile = mTextB_profile.Text.Trim();
//pTW.persons.yeatIssue = Convert.ToInt16(mTextB_yearIssue.Text.Trim());
pTW.persons.yeatIssue = mTextB_yearIssue.Text == "" ? pTW.persons.yeatIssue = 1970 : Convert.ToInt16(mTextB_yearIssue.Text.Trim());
pTW.nameStateOrg = mTextB_nameStateOrg.Text.Trim();
pTW.educational = mTextB_educational.Text.Trim();
pTW.nameOrg = mTextB_nameOrg.Text.Trim();
pTW.cityOrg = mTextB_cityOrg.Text.Trim();
pTW.post = mTextB_post.Text.Trim();
//pTW.freeWork.nameFreeWork = mComboB_freeWork.Text.Trim();
string fw2 = mComboB_freeWork.SelectedItem.ToString().Trim();
pTW.idFreeWork = db.freeWork.FirstOrDefault(pp => pp.nameFreeWork == fw2).id;
pTW.numCertificate = mTextB_numCertificate.Text.Trim();
pTW.numReference = mTextB_numReference.Text.Trim();
pTW.verificationArrival = mComboB_verificationArrival.Text == "в наличии" ? "T" : "F";
pTW.commentary = mTextB_commentary.Text.Trim();
pTW.dateCrt = DateTime.Now;
lg.newValue = idPers + " " + mTextB_surname.Text.Trim() + " " + mTextB_name.Text.Trim() + " " + mTextB_patronymic.Text.Trim() + " " + dateTime_birthday.Value + " " + mComboB_gender.Text.Trim() +
// " " + mTextB_addressRegion.Text + " " + mTextB_addressArea.Text + " " + mTextB_addressArea.Text + " " + mTextB_addressCity.Text + " " + mTextB_addressStreet.Text + " " + mTextB_addressHome.Text + " " + mTextB_addressFlat.Text +
" " + mTextB_addressCountry.Text + " " + mTextB_addressCity.Text.Trim() + " " + mTextB_addressStreet.Text.Trim() + " " + mTextB_addressHome.Text.Trim() + " " +
" " + mComboB_qualificationLevel.Text.Trim() + " " + mTextB_trainingDirection.Text.Trim() + " " + mTextB_profile.Text.Trim() + " " + mTextB_yearIssue.Text.Trim() + " " + mComboB_freeWork.Text.Trim() +
" " + mTextB_nameStateOrg.Text.Trim() + " " + mTextB_educational.Text.Trim() + " " + mTextB_nameOrg.Text.Trim() + " " + mTextB_cityOrg.Text.Trim() + " " + mTextB_post.Text.Trim() + " " + mTextB_numCertificate.Text.Trim() + " " + mTextB_numReference.Text.Trim() + " " + mComboB_verificationArrival.Text.Trim() + " " + mTextB_commentary.Text.Trim();
db.logs.Add(lg);
MessageBox.Show("Данные изменены");
#endregion
}
db.SaveChanges();
Close();
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
}
public bool Update(logs item)
{
throw new NotImplementedException();
}
