public ActionResult Register(User mUser) { try { if (ModelState.IsValid) { var users = new Users { ID = mUser.Id, FName = mUser.FName, LName = mUser.LName, E_Mail = mUser.EMail, Username = mUser.Username, Password = mUser.Password }; ModelsContainer db = new ModelsContainer(); db.Users.Add(users); db.SaveChanges(); User u = new User(); return RedirectToAction("OperationResult"); } } catch (Exception ex) { return RedirectToAction("OperationResult"); } return View(); }
static void Main(string[] args) { InitApplicationData(); using (var container = new ModelsContainer()) { var records = container.Set <Record>().ToList(); LbsOperator oper = new LbsOperator(); foreach (var record in records) { try { oper.CreatePoin(record); } catch (Exception ex) { string msg = ex.OutputMessage(); Console.WriteLine(msg); } } } //Task task = Task.Factory.StartNew(() => // { // string path = ConfigurationManager.AppSettings["file_path"]; // FileOperator fo = new FileOperator(path); // fo.LoadExcelData(); // DbOperator.InsertData(fo.DataSet); // }); //task.Wait(); //Console.WriteLine("----Finish Read Excel Data----"); //GetHttpContent(); //Console.WriteLine("{0}", "----All Finish----"); //LbsOperator.CreateDatabox("TestBox"); //LbsOperator.CreatePoin(); Console.ReadKey(); }
public JsonResult CeateAdmin(string id, string password) { ModelsContainer db = new ModelsContainer(); MembershipCreateStatus createStatus; var user = Membership.CreateUser(id, password, null, null, null, true, null, out createStatus); if (createStatus == MembershipCreateStatus.Success) { Roles.AddUserToRole(id, "Admin"); UserInformation userInformation = new UserInformation(); userInformation.phone = ""; userInformation.telephone = ""; userInformation.trueName = "管理员"; userInformation.UserID = new Guid(Convert.ToString(user.ProviderUserKey)); userInformation.UserType = 3; db.UserInformation.AddObject(userInformation); db.SaveChanges(); return(new JsonResult { Data = id }); } else { return(new JsonResult { Data = "failed" }); } }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { ModelsContainer db = new ModelsContainer(); // Attempt to register the user MembershipCreateStatus createStatus; var user = Membership.CreateUser(model.UserName, model.Password, model.Email, null, null, true, null, out createStatus); if (createStatus == MembershipCreateStatus.Success) { FormsAuthentication.SetAuthCookie(model.UserName, false /* createPersistentCookie */); UserInformation userInformation = new UserInformation(); userInformation.phone = model.Phone; userInformation.telephone = model.TelePhone; userInformation.trueName = model.TrueName; userInformation.UserID = new Guid(Convert.ToString(user.ProviderUserKey)); userInformation.UserType = model.UserType; db.UserInformation.AddObject(userInformation); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } ModelState.AddModelError("", ErrorCodeToString(createStatus)); } // If we got this far, something failed, redisplay form return(View(model)); }
static async void GetHttpContent() { //Task task = Task.Factory.StartNew(() => // { try { AddressTrans at = new AddressTrans(); using (var container = new ModelsContainer()) { var records = container.Set <Record>().ToList(); int cursor = 0; foreach (var record in records) { if (record.Lat == null || record.Lnt == null) { Thread.Sleep(20); if (!string.IsNullOrEmpty(record.Address)) { try { string url = at.BuildeUrl(record.Address.Trim().Replace(" ", "")); await at.TransLocation(record, url); Console.WriteLine("Lat = {0}, Lnt = {1}, cursor = {2}", record.Lat, record.Lnt, cursor); } catch (Exception ex) { string msg = ex.OutputMessage(); Console.WriteLine("trans address exception {0}", msg); } cursor++; if (cursor == 100) { cursor = 0; container.SaveChanges(); } } } } container.SaveChanges(); } } catch (Exception ex) { string msg = ex.OutputMessage(); Console.WriteLine("exception message:{0}", msg); } //}); //task.Wait(); Console.WriteLine("----Finish Trans Location----"); }
public PartialViewResult Information() { ModelsContainer db = new ModelsContainer(); if (User.Identity.IsAuthenticated) { var uid = new Guid(Convert.ToString(Membership.GetUser().ProviderUserKey)); UserInformation model = (from userInformation in Db.UserInformation where userInformation.UserID == uid select userInformation).FirstOrDefault(); //Return the fully populated ViewModel return(this.PartialView(model)); } //return the model with IsAuthenticated only set since none of the //other properties are needed return(this.PartialView()); }
/// <summary> /// ID生成函数 /// </summary> /// <returns></returns> public static string generate() { string year = DateTime.Now.Year.ToString(); string month = (DateTime.Now.Month < 10) ? "0" + (DateTime.Now.Month) : "" + DateTime.Now.Month; string day = (DateTime.Now.Day < 10) ? "0" + DateTime.Now.Day : "" + DateTime.Now.Day; string date = year + month + day; ModelsContainer db = new ModelsContainer(); var userinstances = db.UserInstance.Where(u => u.ID.StartsWith(date)).ToList(); if (userinstances.Count == 0){ return date + "0001"; } else { userinstances.Sort((x,y)=>y.ID.CompareTo(x.ID)); return (Int64.Parse(userinstances[0].ID) + 1).ToString(); } }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddDbContext <NavyBattleContext>(options => options.UseSqlServer(Configuration.GetConnectionString("sqlConnection"), x => x.MigrationsAssembly("NavyBattle.Dal"))); services.AddControllers(); DalContainer.RegisterRepositories(services); ModelsContainer.RegisterModels(services); ServicesContainer.RegisterServices(services); services.AddSwaggerGen(options => { options.SwaggerDoc("v1", new OpenApiInfo { Title = "NavyBattle", Version = "v1" }); }); services.AddAutoMapper(typeof(Startup)); }
/// <summary> /// ID生成函数 /// </summary> /// <returns></returns> public static string generate() { string year = DateTime.Now.Year.ToString(); string month = (DateTime.Now.Month < 10) ? "0" + (DateTime.Now.Month) : "" + DateTime.Now.Month; string day = (DateTime.Now.Day < 10) ? "0" + DateTime.Now.Day : "" + DateTime.Now.Day; string date = year + month + day; ModelsContainer db = new ModelsContainer(); var userinstances = db.UserInstance.Where(u => u.ID.StartsWith(date)).ToList(); if (userinstances.Count == 0) { return(date + "0001"); } else { userinstances.Sort((x, y) => y.ID.CompareTo(x.ID)); return((Int64.Parse(userinstances[0].ID) + 1).ToString()); } }
public JsonResult CeateAdmin(string id, string password) { ModelsContainer db = new ModelsContainer(); MembershipCreateStatus createStatus; var user = Membership.CreateUser(id, password, null, null, null, true, null, out createStatus); if (createStatus == MembershipCreateStatus.Success) { Roles.AddUserToRole(id, "Admin"); UserInformation userInformation = new UserInformation(); userInformation.phone = ""; userInformation.telephone = ""; userInformation.trueName = "管理员"; userInformation.UserID = new Guid(Convert.ToString(user.ProviderUserKey)); userInformation.UserType = 3; db.UserInformation.AddObject(userInformation); db.SaveChanges(); return new JsonResult { Data = id }; } else { return new JsonResult { Data = "failed" }; } }
public Repository(ModelsContainer container) { this._container = container; }
public static void InsertData(DataSet dataSet) { if (dataSet == null) { throw new ArgumentNullException("DataSet param is null"); } try { //ConcurrentDictionary<string, object> cache = new ConcurrentDictionary<string, object>(); ICacheManager cache = new MemoryCacheManager(); var exceptions = new ConcurrentQueue <Exception>(); List <Task> tasks = new List <Task>(); Stopwatch stopwatch = new Stopwatch(); stopwatch.Start(); using (var container = new ModelsContainer()) { foreach (DataTable dt in dataSet.Tables) { //Task task = Task.Factory.StartNew(() => //{ try { Console.WriteLine("----------Table name is : {0}---------", dt.TableName); int cursor = 0; foreach (DataRow dr in dt.Rows) { Record record = new Record(); string brandsName = dr[0].ToString(); var brands = cache.Get <Brands>(brandsName, () => { return(new Brands() { Name = brandsName }); }); record.Brands = brands; string modelsName = dr[1].ToString(); var models = cache.Get <Models>(modelsName, () => { return(new Models() { Name = modelsName }); }); record.Models = models; record.City = dr[2].ToString(); string dv = dr[3].ToString().Replace(".", ""); string d = string.Format("{0}-{1}-01", dv.Substring(0, 4), dv.Substring(4, 2)).Trim(); var buyYear = cache.Get <BuyYear>(d, () => { return(new BuyYear() { Time = Convert.ToDateTime(d) }); }); record.BuyYear = buyYear; d = string.Format("{0}-01-01", dr[4].ToString()); record.Both = DateTime.Parse(d); bool g = dr[5].ToString().Equals("男") ? true : false; record.Gender = Convert.ToBoolean(g); record.Address = dr[6].ToString(); record.Zip = dr[7].ToString(); container.Set <Record>().Add(record); Console.WriteLine("address {0}, cursor = {1}, threadId = {2}", record.Address, cursor, Thread.CurrentThread.ManagedThreadId); cursor++; if (cursor == 100) { cursor = 0; container.SaveChanges(); } } } catch (Exception ex) { exceptions.Enqueue(ex); } //}); //tasks.Add(task); container.SaveChanges(); } } //Task.WaitAll(tasks.ToArray()); stopwatch.Stop(); TimeSpan ts = stopwatch.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); Console.WriteLine("RunTime " + elapsedTime); if (exceptions.Any()) { Console.WriteLine("Parallel have exceptions, count = {0}", exceptions.Count()); } } catch (Exception ex) { string msg = ex.OutputMessage(); Console.WriteLine("{0}", msg); } }
public PartialViewResult Information() { ModelsContainer db = new ModelsContainer(); if (User.Identity.IsAuthenticated) { var uid = new Guid(Convert.ToString(Membership.GetUser().ProviderUserKey)); UserInformation model = (from userInformation in Db.UserInformation where userInformation.UserID == uid select userInformation).FirstOrDefault(); //Return the fully populated ViewModel return this.PartialView(model); } //return the model with IsAuthenticated only set since none of the //other properties are needed return this.PartialView(); }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { ModelsContainer db = new ModelsContainer(); // Attempt to register the user MembershipCreateStatus createStatus; var user = Membership.CreateUser(model.UserName, model.Password, model.Email, null, null, true, null, out createStatus); if (createStatus == MembershipCreateStatus.Success) { FormsAuthentication.SetAuthCookie(model.UserName, false /* createPersistentCookie */); UserInformation userInformation = new UserInformation(); userInformation.phone = model.Phone; userInformation.telephone = model.TelePhone; userInformation.trueName = model.TrueName; userInformation.UserID = new Guid(Convert.ToString(user.ProviderUserKey)); userInformation.UserType = model.UserType; db.UserInformation.AddObject(userInformation); db.SaveChanges(); return RedirectToAction("Index", "Home"); } ModelState.AddModelError("", ErrorCodeToString(createStatus)); } // If we got this far, something failed, redisplay form return View(model); }