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