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