// GET api/default1 public IEnumerable<User> Get() { IEnumerable<User> users = new List<User>(); try { //List<UserMapper> usersMapper = new List<UserMapper>(); using (SmarteezDatabaseEntities db = new SmarteezDatabaseEntities()) { users = db.Users.ToList(); } //foreach (var item in users) //{ // UserMapper obj = new UserMapper(); // obj.UserName = item.UserId; // usersMapper.Add(obj); //} //UserMapper usersMapper = from users i return users; } catch (Exception ex) { logger.Error(ex.Message,ex); throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(ex.Message), ReasonPhrase = "Critical Exception" }); } }
public HttpResponseMessage Get(string LoginId, string Passowrd, string Role) { List<User> users = new List<User>(); using (SmarteezDatabaseEntities db = new SmarteezDatabaseEntities()) { users = db.Users.Where(user=>user.UserId == LoginId && user.Passowrd == Passowrd && user.IsActive=="A" && user.Role == Role).ToList(); if (users==null) { return new HttpResponseMessage(HttpStatusCode.NotFound); } } return Request.CreateResponse(HttpStatusCode.OK, users); }
private static void insertUserName(String name, string email, String contact, string query) { CustomerQuery customerQuery = new CustomerQuery() { CustomerName = name, Email = email, IsQueryResponded = "N", Message = query, MobileNumber = contact, QueryResponse = string.Empty, QueryResponseDate = null, ReceiveDate = DateTime.Now }; using (var dbContext = new SmarteezDatabaseEntities()) { dbContext.CustomerQueries.Add(customerQuery); dbContext.SaveChanges(); } }
void Session_Start(object sender, EventArgs e) { //Code that runs when a new session is started Application.Lock(); using (var dbContext = new SmarteezDatabaseEntities()) { WebSiteUser websiteUser = new WebSiteUser() { ClientBrowser = HttpContext.Current.Request.Browser.Browser, MachineIP = string.IsNullOrEmpty(HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"]) ? HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"] : HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"], VisitDate = DateTime.Now }; int i = dbContext.Users.Count(); dbContext.WebSiteUsers.Add(websiteUser); dbContext.SaveChanges(); int userCount = dbContext.WebSiteUsers.Count<WebSiteUser>() + 1000; Application.Add("UserCount", userCount); } Application.UnLock(); }