private static IOEMDevice Return(NpgsqlDataReader lect) { IOEMDevice bean = new IOEMDevice(); try { bean.id = Convert.ToInt32(lect["id"].ToString()); bean.iMachineNumber = Convert.ToInt32(lect["machine"].ToString()); bean.idwSEnrollNumber = Convert.ToInt32(lect["employe"].ToString()); bean.idwVerifyMode = Convert.ToInt32(lect["verify_mode"].ToString()); bean.idwInOutMode = Convert.ToInt32(lect["in_out_mode"].ToString()); bean.idwWorkCode = Convert.ToInt32(lect["work_code"].ToString()); bean.idwReserved = Convert.ToInt32(lect["reserved"].ToString()); bean.pointeuse = new Pointeuse(Convert.ToInt32(lect["pointeuse"].ToString())); bean.date_action = (DateTime)((lect["date_action"] != null) ? (!lect["date_action"].ToString().Trim().Equals("") ? lect["date_action"] : DateTime.Now) : DateTime.Now); bean.time_action = (DateTime)((lect["time_action"] != null) ? (!lect["time_action"].ToString().Trim().Equals("") ? lect["time_action"] : DateTime.Now) : DateTime.Now); bean.date_time_action = (DateTime)((lect["date_time_action"] != null) ? (!lect["date_time_action"].ToString().Trim().Equals("") ? lect["date_time_action"] : DateTime.Now) : DateTime.Now); bean.idwYear = Convert.ToInt32(bean.date_action.ToString("yyyy")); bean.idwMonth = Convert.ToInt32(bean.date_action.ToString("MM")); bean.idwDay = Convert.ToInt32(bean.date_action.ToString("dd")); bean.idwHour = Convert.ToInt32(bean.time_action.ToString("HH")); bean.idwMinute = Convert.ToInt32(bean.time_action.ToString("mm")); bean.idwSecond = Convert.ToInt32(bean.time_action.ToString("ss")); } catch (Exception ex) { Messages.Exception("IOEMDeviceDAO (Return)", ex); } return(bean); }
public static void SaveCsv(string fileName, IOEMDevice iO) { try { // Write sample data to CSV file using (CsvFileWriter writer = new CsvFileWriter(fileName, true, Encoding.UTF8)) { List <string> row = new List <string>(); row.Add(iO.iMachineNumber.ToString()); row.Add(iO.idwSEnrollNumber.ToString()); row.Add(iO.idwVerifyMode.ToString()); row.Add(iO.idwInOutMode.ToString()); row.Add(iO.idwWorkCode.ToString()); row.Add(iO.idwReserved.ToString()); row.Add(iO.date_action.ToString("dd-MM-yyyy")); row.Add(iO.time_action.ToString("HH:mm:ss")); row.Add(iO.date_time_action.ToString("dd-MM-yyyy HH:mm:ss")); row.Add(iO.pointeuse.Id.ToString()); writer.WriteRow(row); } } catch (Exception ex) { Utils.Exception(ex); } }
public static IOEMDevice getOne(Pointeuse pointeuse, Employe employe, DateTime date, string adresse) { IOEMDevice result = new IOEMDevice(); NpgsqlConnection connect = new Connexion().Connection(adresse); try { string query = "SELECT * FROM yvs_grh_ioem_device WHERE date_time_action = '" + date + "' AND employe =" + employe.Id + " AND pointeuse =" + pointeuse.Id; NpgsqlCommand Lcmd = new NpgsqlCommand(query, connect); NpgsqlDataReader lect = Lcmd.ExecuteReader(); if (lect.HasRows) { while (lect.Read()) { result = Return(lect); break; } } } catch (Exception ex) { Messages.Exception("IOEMDeviceDAO (getOne)", ex); return(result); } finally { Connexion.Close(connect); } return(result); }
public Dial_View_No_Insert(Employe employe, IOEMDevice current) { InitializeComponent(); Configuration.Load(this); object_presence = new ObjectThread(dgv_presence); object_pointage = new ObjectThread(dgv_pointage); this.employe = employe; this.current = current; }
public static void WriteCsv(string fileName, IOEMDevice iO) { if (!File.Exists(fileName)) { SaveCsv(fileName, iO); } else { UpdateCsv(fileName, iO); } }
public static bool Insert(IOEMDevice bean, string adresse) { try { return(IOEMDeviceDAO.getInsert(bean, adresse)); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void Dial_Insert_Pointage_Load(object sender, EventArgs e) { if (parent != null) { string adresse = Constantes.SOCIETE.AdresseIp; IOEMDevice current = parent.currentPointage; employe = EmployeBLL.OneById(current.idwSEnrollNumber); txt_id.Text = employe.Id.ToString(); txt_matricule.Text = employe.Matricule; txt_noms.Text = employe.NomPrenom; txt_poste.Text = employe.Poste.Poste.Intitule; try { current_time = new DateTime(current.idwYear, current.idwMonth, current.idwDay, current.idwHour, current.idwMinute, current.idwSecond); dtp_decalage.Value = current_time; time_decalage = current_time; Presence presence = Fonctions.GetPresence(employe, current_time, true, adresse); if (presence != null ? presence.Id > 0 : false) { dtp_date_debut.Value = presence.DateDebut; dtp_date_fin.Value = presence.DateFinPrevu; dtp_heure_debut.Value = presence.HeureDebut; dtp_heure_fin.Value = presence.HeureFinPrevu; box_fich_exit.Image = global::ZK_Lymytz.Properties.Resources.vu; } else { Planning planning = Fonctions.GetPlanning(employe, new DateTime(current_time.Year, current_time.Month, current_time.Day, 0, 0, 0), adresse); dtp_date_debut.Value = planning.DateDebut; dtp_date_fin.Value = planning.DateFin; dtp_heure_debut.Value = planning.HeureDebut; dtp_heure_fin.Value = planning.HeureFin; } } catch (Exception ex) { } this.Text += " [" + current_time.ToShortTimeString() + "]"; } else { this.Dispose(); } }
public static bool getInsert(IOEMDevice bean, string adresse) { NpgsqlConnection connect = new Connexion().Connection(adresse); try { string query = "INSERT INTO yvs_grh_ioem_device(machine, employe, verify_mode, in_out_mode, work_code, reserved, date_action, time_action, date_time_action, pointeuse, author) " + " VALUES (" + bean.iMachineNumber + "," + bean.idwSEnrollNumber + ", " + bean.idwVerifyMode + ", " + bean.idwInOutMode + ", " + bean.idwWorkCode + ", " + bean.idwReserved + ", '" + bean.date_action + "', '" + bean.time_action.ToString("HH:mm:ss") + "', '" + bean.date_time_action + "', " + bean.pointeuse.Id + ", " + (Constantes.USERS.Author > 0 ? Constantes.USERS.Author.ToString() : "null") + ")"; NpgsqlCommand cmd = new NpgsqlCommand(query, connect); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { Messages.Exception("IOEMDeviceDAO (getInsert)", ex); return(false); } finally { Connexion.Close(connect); } }
public static void UpdateCsv(string fileName, IOEMDevice iO) { try { // Write sample data to CSV file FileInfo file = new FileInfo(fileName); if (file.Length == 8192) { string destination = file.DirectoryName + Constantes.FILE_SEPARATOR + file.Name.Replace(file.Extension, "") + "_" + DateTime.Now.ToShortDateString().Replace("/", "-") + file.Extension; file.MoveTo(destination); SaveCsv(fileName, iO); } else { using (CsvFileWriter writer = new CsvFileWriter(fileName, true, Encoding.UTF8)) { List <string> row = new List <string>(); row.Add(iO.iMachineNumber.ToString()); row.Add(iO.idwSEnrollNumber.ToString()); row.Add(iO.idwVerifyMode.ToString()); row.Add(iO.idwInOutMode.ToString()); row.Add(iO.idwWorkCode.ToString()); row.Add(iO.idwReserved.ToString()); row.Add(iO.date_action.ToString("dd-MM-yyyy")); row.Add(iO.time_action.ToString("HH:mm:ss")); row.Add(iO.date_time_action.ToString("dd-MM-yyyy HH:mm:ss")); row.Add(iO.pointeuse.Id.ToString()); writer.WriteRow(row); } } } catch (Exception ex) { Utils.Exception(ex); } }
public Dial_Update_Action(IOEMDevice current) : this() { this.current = current; }
public static void WriteCsv(IOEMDevice iO) { string fileName = TOOLS.Chemins.CheminDatabase() + "LogRecord.csv"; WriteCsv(fileName, iO); }
public static List <IOEMDevice> ReadCsv(string fileName) { try { if (!File.Exists(fileName)) { return(new List <IOEMDevice>()); } List <IOEMDevice> l = new List <IOEMDevice>(); // Read sample data from CSV file using (CsvFileReader reader = new CsvFileReader(fileName)) { List <string> row = new List <string>(); while (reader.ReadRow(row)) { int i = 0; IOEMDevice e = new IOEMDevice(Convert.ToInt32(row.Count > 0 ? row[i++] : "0")); if (row.Count == 10)//Chargement de la version 2 du fichier { e.idwSEnrollNumber = Convert.ToInt32(row.Count > 1 ? row[i++] : "0"); e.idwVerifyMode = Convert.ToInt32(row.Count > 2 ? row[i++] : "0"); e.idwInOutMode = Convert.ToInt32(row.Count > 3 ? row[i++] : "0"); e.idwWorkCode = Convert.ToInt32(row.Count > 4 ? row[i++] : "0"); e.idwReserved = Convert.ToInt32(row.Count > 5 ? row[i++] : "0"); e.date_action = row.Count > 6 ? Convert.ToDateTime(row[i++]) : DateTime.Now; e.time_action = row.Count > 7 ? Convert.ToDateTime(row[i++]) : DateTime.Now;; e.date_time_action = row.Count > 8 ? Convert.ToDateTime(row[i++]) : DateTime.Now;; e.pointeuse = new Pointeuse(Convert.ToInt32(row.Count > 9 ? row[i++] : "0")); e.idwYear = Convert.ToInt32(e.date_action.ToString("yyyy")); e.idwMonth = Convert.ToInt32(e.date_action.ToString("MM")); e.idwDay = Convert.ToInt32(e.date_action.ToString("dd")); e.idwHour = Convert.ToInt32(e.time_action.ToString("HH")); e.idwMinute = Convert.ToInt32(e.time_action.ToString("mm")); e.idwSecond = Convert.ToInt32(e.time_action.ToString("ss")); } else//Chargement de la version 1 du fichier { e.idwTMachineNumber = Convert.ToInt32(row.Count > 1 ? row[i++] : "0"); e.idwSEnrollNumber = Convert.ToInt32(row.Count > 2 ? row[i++] : "0"); e.iParams4 = Convert.ToInt32(row.Count > 3 ? row[i++] : "0"); e.iParams1 = Convert.ToInt32(row.Count > 4 ? row[i++] : "0"); e.iParams2 = Convert.ToInt32(row.Count > 5 ? row[i++] : "0"); e.idwManipulation = Convert.ToInt32(row.Count > 6 ? row[i++] : "0"); e.iParams3 = Convert.ToInt32(row.Count > 7 ? row[i++] : "0"); e.idwYear = Convert.ToInt32(row.Count > 8 ? row[i++] : "0"); e.idwMonth = Convert.ToInt32(row.Count > 9 ? row[i++] : "0"); e.idwDay = Convert.ToInt32(row.Count > 10 ? row[i++] : "0"); e.idwHour = Convert.ToInt32(row.Count > 11 ? row[i++] : "0"); e.idwMinute = Convert.ToInt32(row.Count > 12 ? row[i++] : "0"); e.idwSecond = Convert.ToInt32(row.Count > 13 ? row[i++] : "0"); e.date_action = new DateTime(e.idwYear, e.idwMonth, e.idwDay, 0, 0, 0); e.time_action = new DateTime(e.idwYear, e.idwMonth, e.idwDay, e.idwHour, e.idwMinute, 0); e.date_time_action = new DateTime(e.idwYear, e.idwMonth, e.idwDay, e.idwHour, e.idwMinute, 0); } l.Add(e); Constantes.LoadPatience(false); } } return(l); } catch (Exception ex) { Utils.Exception(ex); } return(new List <IOEMDevice>()); }