public ActionResult Register(User user) { if (user.Name == null || user.Surname == null || user.Email == null || user.Password == null) { Session["Register"] = "This fields are required"; } using (TestProjectEntities db = new TestProjectEntities()) { User usr = db.Users.FirstOrDefault(u => u.Email == user.Email && u.Password == user.Password && u.Name == user.Name && u.Surname == user.Surname); if (usr != null) { return(Content("This user already exist")); } usr = new User { Name = user.Name, Surname = user.Surname, Email = user.Email, Password = Crypto.HashPassword(user.Password), IsAdmin = false, IsBlocked = false, RegistrateDate = DateTime.Now, LastLoginDate = DateTime.Now }; Session["Register"] = true; db.Users.Add(usr); db.SaveChanges(); return(RedirectToAction("login")); } }
public ActionResult Login(User usr) { if (usr.Email == null || usr.Password == null) { Session["LogError"] = "This field required"; } using (TestProjectEntities db = new TestProjectEntities()) { User user = db.Users.FirstOrDefault(u => u.Email == usr.Email); if (user != null) { if (user.IsBlocked == false) { if (Crypto.VerifyHashedPassword(user.Password, usr.Password)) { user.ErrosCount = 0; HttpContext.Session["Login"] = true; HttpContext.Session["User"] = user; user.LastLoginDate = DateTime.Now; if (user.IsAdmin == false) { return(RedirectToAction("index", "profile", new { Area = "Client" })); } return(RedirectToAction("index", "dashboard", new { Area = "Admin" })); } Session["LoginError"] = "The email or password is not valid"; user.ErrosCount++; db.SaveChanges(); if (user.ErrosCount == 3) { user.IsBlocked = true; user.ErrosCount = 0; db.SaveChanges(); return(Content("Your account is blocked, please contact adminstrator")); } return(View()); } ModelState.AddModelError(string.Empty, "This email is not exist"); return(RedirectToAction("register", "login")); } return(RedirectToAction("register", "login")); } }
public ActionResult chooseFields(List <FieldsVM> fieldList) { DataTable dt = (DataTable)Session["DataTableModel"]; List <importTable> lst = ModelDataTableBinder.dataTableToTypeList <importTable>(dt, fieldList); db.importTable.AddRange(lst); db.SaveChanges(); return(View("SaveData")); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (TestProjectEntities db = new TestProjectEntities()) { AdPanel AdPanel = db.AdPanels.Find(id); db.AdPanels.Remove(AdPanel); db.SaveChanges(); } return(RedirectToAction("index")); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (TestProjectEntities db = new TestProjectEntities()) { Menu menu = db.Menus.Find(id); db.Menus.Remove(menu); db.SaveChanges(); } return(RedirectToAction("index", "edit")); }
static void Main(string[] args) { var connectionString = "server=.;initial catalog=TestProject;Integrated Security=SSPI;"; using (var context = new TestProjectEntities(connectionString)) { var newCustomer = new Customer { FirstName = "John", LastName = "Doe" }; context.AddItem(newCustomer); context.SaveChanges(); } }
public ActionResult Edit(AdPanel adpanel) { if (adpanel == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (TestProjectEntities db = new TestProjectEntities()) { AdPanel edited = db.AdPanels.Find(adpanel.Id); edited.Id = adpanel.Id; edited.Name = adpanel.Name; edited.Text = adpanel.Text; db.SaveChanges(); } return(RedirectToAction("index")); }
public ActionResult Update(Menu menu) { if (menu == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (TestProjectEntities db = new TestProjectEntities()) { Menu edited = db.Menus.Find(menu.Id); edited.Id = menu.Id; edited.Name = menu.Name; edited.Link = menu.Link; db.SaveChanges(); } return(RedirectToAction("index")); }
public ActionResult Update([Bind(Include = "Id,Name,Surname,IsAdmin,Email,IsBlocked")] User user) { if (user == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (TestProjectEntities db = new TestProjectEntities()) { User usr = db.Users.Find(user.Id); usr.Name = user.Name; usr.Email = user.Email; usr.Surname = user.Surname; usr.IsAdmin = user.IsAdmin; usr.IsBlocked = user.IsBlocked; db.SaveChanges(); } return(RedirectToAction("index")); }
public ActionResult Create(AdPanel adpanel) { using (TestProjectEntities db = new TestProjectEntities()) { AdPanel adpanel1 = db.AdPanels.FirstOrDefault(a => a.Id == adpanel.Id && a.Name == adpanel.Name && a.Text == adpanel.Text); if (adpanel1 != null) { return(Content("This item already exist")); } adpanel1 = new AdPanel() { Id = adpanel.Id, Name = adpanel.Name, Text = adpanel.Text }; db.AdPanels.Add(adpanel1); db.SaveChanges(); } return(View()); }
public ActionResult Create(Menu menu) { using (TestProjectEntities db = new TestProjectEntities()) { Menu menu1 = db.Menus.FirstOrDefault(m => m.Id == menu.Id && m.Name == menu.Name && m.Link == menu.Link); if (menu1 != null) { ModelState.AddModelError("AddError", "This menu already exist"); return(View()); } menu1 = new Menu() { Name = menu.Name, Link = menu.Link }; db.Menus.Add(menu1); db.SaveChanges(); } return(RedirectToAction("index", "dashboard")); }
public ActionResult Subscribe(TestProject.Models.Subscribe subscribe, string confirmKey) { ChargifyConnect chargify = ChargifyTools.Chargify; string plan = subscribe.plan; bool isCredit = subscribe.hasCreditCard || subscribe.creditcard.requireCredit;//ChargifyTools.RequireCreditCard(subscribe.plan); try { if (ChargifyTools.IsChargifyProduct(subscribe.plan)) { ViewBag.confirmKey = confirmKey; ViewBag.plan = subscribe.plan; if (ValidatePassword(subscribe.password) == false) { //ViewBag.contactGenderId = new SelectList(db.contactGender.ToList(), "contactGenderId", "name"); ViewBag.Message = "Error password, you need a format that contains capital letters and numbers, example: Michael7."; ViewBag.plan = subscribe.plan; return(View(subscribe)); } userLogin user = new userLogin(); contact cont = new contact(); tenant tnt = new tenant(); //---------------------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------------------- tnt.tenantSubscriptionPlanId = (from pl in db.tenantSubscriptionPlan where pl.code.ToLower().Equals(plan.ToLower()) select pl.tenantSubscriptionPlanId).FirstOrDefault(); tnt.active = true; tnt.allocatedUsers = 1; //cantidad de usuarios asignados tnt.billingRefNumber = Guid.NewGuid().ToString(); tnt.companyName = subscribe.company; tnt.companyURL = "N/A"; tnt.database = "TestProject"; tnt.tenantStatusId = 2; tnt.tenantSourceId = 2; if (isCredit) { tnt.tenentBillingTypeId = 1; } else { tnt.tenentBillingTypeId = 2; } /****** Valores quemados de campos auditoria*****/ tnt.updatedById = 0; tnt.createdById = TntIdTestProject; // Id tenant TestProject tnt.modifyDateTime = new DateTime(1900, 1, 1, 0, 0, 0); tnt.insertDateTime = DateTime.Now; /****** Valores quemados de campos auditoria*****/ db.tenant.Add(tnt); db.SaveChanges(); var city = db.genCity .Include(x => x.genState.genContry) .SingleOrDefault(x => x.genCityId == Convert.ToInt32(subscribe.genCityId)); if (isCredit) { contactPhone phone = new contactPhone { active = true, number = subscribe.phoneNumber, contactId = cont.contactId, contactPhoneTypeId = 1, tenantId = tnt.tenantId, updatedById = 0, createdById = TntIdTestProject, // Id tenant TestProject modifyDateTime = new DateTime(1900, 1, 1, 0, 0, 0), insertDateTime = DateTime.Now }; db.contactPhone.Add(phone); db.SaveChanges(); cont.preferredBillAddressId = address.contactAddressId; cont.preferredPhoneId = phone.contactPhoneId; db.Entry(cont).State = EntityState.Modified; db.SaveChanges(); } /*** cosas de chargify!!!*/ CustomerAttributes customerInformation = new CustomerAttributes(); customerInformation.FirstName = subscribe.firstName; customerInformation.LastName = subscribe.lastName; customerInformation.Organization = subscribe.company; customerInformation.Email = subscribe.email; // Create a new guid, this would be the Membership UserID if we were creating a new user simultaneously customerInformation.SystemID = tnt.billingRefNumber; ISubscription newSubscription = null; string productHandle = plan; if (isCredit) { CreditCardAttributes creditCardInfo = new CreditCardAttributes(); creditCardInfo.FullNumber = subscribe.creditcard.creditCardNumber; creditCardInfo.CVV = subscribe.creditcard.cvv; creditCardInfo.ExpirationMonth = subscribe.creditcard.ExpireMonth; creditCardInfo.ExpirationYear = subscribe.creditcard.ExpireYear; creditCardInfo.BillingAddress = subscribe.street; creditCardInfo.BillingCity = city.City;//subscribe.city; creditCardInfo.BillingState = city.genState.State; creditCardInfo.BillingZip = subscribe.postalCode; creditCardInfo.BillingCountry = city.genState.genContry.contry; newSubscription = chargify.CreateSubscription(productHandle, customerInformation, creditCardInfo); } else { newSubscription = chargify.CreateSubscription(productHandle, customerInformation); } } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { System.Diagnostics.Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } catch (Exception e) { return(View(subscribe)); } return(View(subscribe)); }