public IQueryable getDataCity() { UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); var q = from c in db.CityTables select new { c.CityName, c.Id }; return(q); }
public IQueryable getDataLogin() { UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); var q = from c in db.UserTables join d in db.CityTables on c.City equals d.Id select new { c.Id, c.Name, c.Family, c.User, c.Password, c.Permission, c.AdminVersion, c.Messages, d.CityName }; return(q); }
public IQueryable <CityTable> queryCities() { try { UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); var q = from c in db.CityTables select c; return(q); } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } }
public string getCityName(long cityID) { UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); var q = from c in db.CityTables select new { c.CityName, c.Id }; foreach (var a in q) { if (a.Id == cityID) { return(a.CityName); } } return("not found"); }
public Boolean addCity(CityTable newCity) { try { UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); db.CityTables.InsertOnSubmit(newCity); db.SubmitChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public bool sendUpdateNotify(int newVersion) { try { var logindata = getDataLogin(); UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); var data = from a in db.UserTables select a; foreach (var d in data) { d.Version = newVersion; } db.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
public Boolean removeCity(CityTable newCity) { try { UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); var q = from a in db.CityTables where a.Id == newCity.Id select a; foreach (var a in q) { db.CityTables.DeleteOnSubmit(a); } db.SubmitChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
public List <string> addUser(UserTable newLogin) { try { UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); db.UserTables.InsertOnSubmit(newLogin); db.SubmitChanges(); List <string> report = new List <string>(); report.Add(newLogin.User + "" + " با موفقیت اضافه گردید"); return(report); } catch (System.Data.SqlClient.SqlException) { // DaftarModelDataContext db = new DaftarModelDataContext(cn); List <string> report = new List <string>(); report.Add(newLogin.User + "" + " نام کاربری تکراری است"); return(report); } }
public bool sendMessages(string messages) { try { // var logindata = getDataLogin(); UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); var data = from a in db.UserTables select a; foreach (var d in data) { d.Messages = messages; d.Update = true; } db.SubmitChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public bool MessagesSeenStatus(bool status, LoginInfo login) { try { var logindata = getDataLogin(); UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); var data = from a in db.UserTables select a; foreach (var d in data) { if (d.Id == login.Id) { d.Update = status; } } db.SubmitChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
private void loginButton_Click(object sender, EventArgs e) { try { var cn = Properties.Settings.Default.MainConnectionString; if (IsServerConnected(cn)) { UserManagerDataClassesDataContext db = new UserManagerDataClassesDataContext(cn); foreach (var q in db.UserTables) { if (q.User == this.UserNametextBox.Text && q.Password == this.PasswordTextBox.Text) { this.Hide(); LoginInfo login = new LoginInfo(); login.cityID = q.City; login.Name = q.Name; login.Id = q.Id; login.family = q.Family; login.permission = q.Permission.Value; login.user = q.User; login.update = q.Update.Value; login.messages = q.Messages; login.version = q.Version ?? default(int); login.adminVersion = q.AdminVersion ?? default(bool); if (login.version > currentVersion && !login.adminVersion) { MessageBox.Show("نسخه شما بروز نیست . آخرین نسخه بروز شده را نصب کنید ", "پیغام", MessageBoxButtons.OK, MessageBoxIcon.Stop); this.Close(); return; } SqlManipulator sql = new SqlManipulator(); if (!login.adminVersion) { if (login.update) { MessageBox.Show(login.messages, "پیغام ", MessageBoxButtons.OK, MessageBoxIcon.Information); try { sql.MessagesSeenStatus(false, login); } catch (Exception) { MessageBox.Show("خطا در پیغام"); } } } string cityName = sql.getCityName(login.cityID); login.cityName = cityName; form.setLoginData(login); Properties.Settings.Default.LastUser = this.UserNametextBox.Text; tmr = new Timer(); //set time interval 3 sec tmr.Interval = 3500; //starts the timer formwait = new SplashScreenForm(); formwait.Show(); tmr.Start(); tmr.Tick += tmr_Tick; permission = q.Permission.Value; Properties.Settings.Default.Save(); return; } } MessageBox.Show("نام کاربری و گذر واژه فاقد اعتبار است", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { MessageBox.Show("ارتباط با سرور قطع است ، تنظیمات سرور را بررسی کنید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }