Esempio n. 1
0
        private void metroButton1_Click(object sender, EventArgs e)
        {
            String me = LoginUI.userlogged;

            var query =
                from ssd in db.users
                where ssd.UNAME == me
                select ssd;

            foreach (user ssd in query)
            {
                if (ssd.Vacancy == 0)
                {
                    MessageBox.Show("YOU ARE NOT VACANT");
                    goto NOPE;
                }
            }


            var dealercontacts = from t1 in db.users
                                 join t2 in db.PROs on t1.UNAME equals t2.puser
                                 select new { t2.pid };



            //DateTime dt = new DateTime();
            String time    = DateTime.Now.ToString("h-mm");
            String date    = DateTime.Today.ToString("dd-MM-yy");
            String user    = LoginUI.userlogged;
            int    intIdt  = db.RECORDs.Max(u => u.RecordID) + 1;
            String CurDir  = Directory.GetCurrentDirectory();
            String path    = "d:\\\\" + intIdt.ToString() + "_" + user + "_" + time + "_" + date + ".wav";
            String Command = "save " + "recsound " + path;

            MessageBox.Show("Done");
            timer1.Stop();
            timer1.Enabled = false;
            record(Command, "", 0, 0);
            record("close recsound", "", 0, 0);
            metroLabel1.Text = "0";

            RECORD NEW = new RECORD
            {
                RecordID = intIdt,
                User     = user,
                PATH     = path,
                Duration = i / 60
            };

            db.RECORDs.InsertOnSubmit(NEW);
            try {
                db.SubmitChanges();
            }

            catch (Exception er) {
                MessageBox.Show("DATABASE ERROR");
            }

NOPE:
            i = 0;
        }
 private void detach_RECORDs(RECORD entity)
 {
     this.SendPropertyChanging();
     entity.user1 = null;
 }
 private void attach_RECORDs(RECORD entity)
 {
     this.SendPropertyChanging();
     entity.user1 = this;
 }
 partial void DeleteRECORD(RECORD instance);
 partial void UpdateRECORD(RECORD instance);
 partial void InsertRECORD(RECORD instance);