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