private async void btn_biometry_Click(object sender, RoutedEventArgs e) { System.Drawing.Image SelectedFingerPrint = null; OpenFileDialog dlg = new OpenFileDialog { InitialDirectory = "c:\\Pictures", Filter = "Image files (*.jpg, *.jpeg, *.jpe, *.jfif, *.png) | *.jpg; *.jpeg; *.jpe; *.jfif; *.png", RestoreDirectory = true }; if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string selectedFileName = dlg.FileName; SelectedFingerPrint = System.Drawing.Image.FromFile(selectedFileName); FingerPrintData fingerDataBase = new FingerPrintData(); var resultComparison = await new ImageController().CompareDatabase(SelectedFingerPrint); if (resultComparison != 0) { var user = await new DataController().GetUserInfo(resultComparison); MainSystem newSystem = new MainSystem(user.User); newSystem.Show(); this.Close(); } else { System.Windows.MessageBox.Show("Não foi possivel realizar o login"); } } else { System.Windows.MessageBox.Show("Não foi possivel realizar o login"); } }
public HttpResponseMessage Getall([FromBody] filter filter) { if (filter.startdate == null || filter.enddate == null) { return(null); } List <KTX0050> list = new List <KTX0050>(); DataTable dt = new DataTable(); string iptemp = ""; filter.ip.ToList().ForEach(fff => { iptemp += "'" + fff.ip + "'" + ","; FingerPrintData.Getdata(new FingerPrintData.filter() { commkey = fff.commkey, enddate = DateTime.Parse(filter.enddate.ToString()).ToString("yyyy-MM-dd HH:mm:ss"), ip = fff.ip, port = fff.port, startdate = DateTime.Parse(filter.startdate.ToString()).ToString("yyyy-MM-dd HH:mm:ss") }, ref dt, list ); }); using (DB db = new DB()) { do { string startdate = DateTime.Parse(filter.startdate.ToString()).ToString("yyyy-MM-dd HH:mm:ss"); string enddate = DateTime.Parse(filter.enddate.ToString()).ToString("yyyy-MM-dd HH:mm:ss"); var temp = db.Database.SqlQuery <count>("select count( User_ID ) as counts from KTX0050 where Verify_Date>='" + startdate + "' and Verify_Date<='" + enddate + "' and ip in (" + iptemp.TrimEnd(',') + ")"); object data = null; if (filter.style == 2) { data = db.Database.SqlQuery <getdataOnDB>(@"DECLARE @ip ListIP; INSERT INTO @ip ( ip ) VALUES (" + iptemp.TrimEnd(',').Replace(",", "),(") + @") EXECUTE Getravaocong2 @List=@ip,@startdate='" + startdate + "',@enddate='" + enddate + "'").ToList(); } else if (filter.style == 1) { data = db.Database.SqlQuery <getdataOnDB2>(@"DECLARE @ip ListIP; INSERT INTO @ip ( ip ) VALUES (" + iptemp.TrimEnd(',').Replace(",", "),(") + @") EXECUTE getxuatan @List=@ip,@startdate='" + startdate + "',@enddate='" + enddate + "'").AsEnumerable().Select(p => new { p.buasang, p.buatoi, p.buatrua, p.User_ID, p.thanhtienbuasang, p.thanhtienbuatoi, p.thanhtienbuatrua, ngayvao = db.Database.SqlQuery <Nullable <DateTime> >("execute getngayvao @id='" + p.User_ID + "'").FirstOrDefault(), phong = db.Database.SqlQuery <string>("execute Getphong @id='" + p.User_ID + "'").FirstOrDefault() }).ToList(); } int kkkk = temp.FirstOrDefault().counts; if (list.Count > kkkk) { FingerPrintData.Syncdata(new FingerPrintData.datasync() { KTX0050 = list.ToArray(), type = 1 }); } else { return(REST.GetHttpResponseMessFromObject(data)); } }while (true); } }