public UserLogin Login(string userName, string password /*, out UserLoginMessage msg*/) { try { using (var context = new CellularModelDB()) { UserLogin tmp; tmp = context.UserLoginsTable.SingleOrDefault((u) => u.UserName == userName && u.Password == password); if (tmp != null) { //msg = UserLoginMessage.userExist; return(tmp); } else { tmp = context.UserLoginsTable.SingleOrDefault((u) => u.UserName == userName); //if (tmp != null) // // msg = UserLoginMessage.worngPassword; //else // msg = UserLoginMessage.userNotExist; return(null); } } } catch (Exception e) { Logger.Log.WriteToLog("Failed connect to data base" + Environment.NewLine + DateTime.Now.ToString() + Environment.NewLine + "Exception details: " + e.ToString()); throw new Exception(); } }
private bool CheckLineNumber(string lineNumber) { try { using (var context = new CellularModelDB()) { Line tmp = context.LinesTable.FirstOrDefault((l) => l.LineNumber == lineNumber); return(tmp == null ? true : false); } } catch (Exception e) { Log(e); throw new DbFaildConnncetException("Failed connect to data base"); } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); GlobalConfiguration.Configure(WebApiConfig.Register); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); var json = GlobalConfiguration.Configuration.Formatters.JsonFormatter; json.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.PreserveReferencesHandling.All; //create db if model chenge using (var context = new CellularModelDB()) { List <Client> clients = context.ClientsTable.ToList(); } }
public ICollection <Call> IssuingInvoice(int clientId) { try { using (var context = new CellularModelDB()) { //get all client lines List <Line> liens = context.LinesTable.Where((l) => l.Client.ClientID == clientId).ToList(); List <Call> calls = new List <Call>(); return(calls); } } catch (Exception e) { Logger.Log.WriteToLog("Failed connect to data base" + Environment.NewLine + DateTime.Now.ToString() + Environment.NewLine + "Exception details: " + e.ToString()); } }
public Client DeleteClient(int id) { try { using (var contex = new CellularModelDB()) { Client tmp = contex.ClientsTable.FirstOrDefault((c) => c.ClientID == id); foreach (var line in tmp.Lines) { line.IsActive = false; } return(tmp); } } catch (Exception e) { Log(e); throw new DbFaildConnncetException("Failed connect to data base"); } }
public Line DeleteLine(string lineNumber) { try { using (var context = new CellularModelDB()) { Line tmp = context.LinesTable.FirstOrDefault((l) => l.LineNumber == lineNumber); if (tmp == null) { throw new EntityNotExistsException("Line number not exists"); } tmp.IsActive = false; context.SaveChanges(); return(tmp); } } catch (Exception e) { Log(e); throw new DbFaildConnncetException("Failed connect to data base"); } }