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 async Task <List <User> > GetUsers()
{
using (var _userContext = new TestProjectEntities())
{
return(await _userContext.Users.ToListAsync());
}
}
public PartialViewResult DisplayMenu()
{
List <Menu> menulist = new List <Menu>();
using (TestProjectEntities db = new TestProjectEntities())
{
menulist = db.Menus.ToList();
}
return(PartialView(menulist));
}
// GET: Admin/Edit
public ActionResult Index()
{
List <Menu> menus = new List <Menu>();
using (TestProjectEntities db = new TestProjectEntities())
{
menus = db.Menus.OrderBy(m => m.Id).ToList();
}
return(View(menus));
}
// GET: Admin/User
public ActionResult Index()
{
List <User> users = new List <User>();
using (TestProjectEntities db = new TestProjectEntities())
{
users = db.Users.OrderBy(m => m.Id).ToList();
}
return(View(users));
}
//GET: Admin/Slide
public ActionResult Index()
{
List <AdPanel> adPanels = new List <AdPanel>();
using (TestProjectEntities db = new TestProjectEntities())
{
adPanels = db.AdPanels.OrderBy(a => a.Id).ToList();
}
return(View(adPanels));
}
public async Task <List <User> > GetUsers()
{
try
{
using (var _userContext = new TestProjectEntities())
{
return(await _userContext.Users.ToListAsync());
}
}
catch (Exception ex)
{
return(null);
}
}
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"));
}
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"));
}
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 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 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"));
}
// GET: Client/Home
public ActionResult Index()
{
using (TestProjectEntities db = new TestProjectEntities())
{
List <AdPanel> ads = db.AdPanels.ToList();
AdPanel ad = ads[ads.Count - 1];
AdText text = new AdText();
text.Text = ad.Text;
ViewBag.Text = text.Text;
}
//Weatherinfo weather = new Weatherinfo();
string link = string.Format("https://samples.openweathermap.org/data/2.5/weather");
var client = new RestClient(link);
var request = new RestRequest("?q=London&appid=439d4b804bc8187953eb36d2a8c26a02", Method.GET);
List <Weatherinfo> wheathers = client.Execute <List <Weatherinfo> >(request).Data;
return(View(wheathers));
}
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 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());
}
}//Cierre DecryptKey
public static string getDefaultSetting(string code)
{
TestProjectEntities db = new TestProjectEntities();
try
{
genConfigName config = db.genConfigName.Where(x => x.code.ToLower() == code.ToLower()).FirstOrDefault();
//tenant tenant = db.tenant.Find(user.tenantId);
//billingRefNumber = tenant.billingRefNumber;
if (config != null)
{
return(config.defaultValue);
}
}
catch (Exception e)
{
}
return(null);
}
public static string getSetting(string code)
{
TestProjectEntities db = new TestProjectEntities();
try
{
int currenttenant = getIdentity().tenatId;
genConfigName config = db.genConfigName.Where(x => x.code.ToLower() == code.ToLower()).FirstOrDefault();
genConfig configvalue = db.genConfig.Where(c => c.tenantId == currenttenant && c.genConfigNameId == config.genConfigNameId).FirstOrDefault();
//tenant tenant = db.tenant.Find(user.tenantId);
//billingRefNumber = tenant.billingRefNumber;
if (config != null)
{
return(configvalue.parameter);
}
}
catch (Exception e)
{
}
return(null);
}
