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(); }