public BlogController(BlogEntryRepository blogEntryRepository, BlogResponseRepository blogResponseRepository, databaseContext context, ILogger <HomeController> logger)
{
_blogEntryRepository = blogEntryRepository;
_blogResponseRepository = blogResponseRepository;
_context = context;
_logger = logger;
}
public JsonResult getResult(int[] arr)
{
databaseContext dbCont = new databaseContext();
List <variables> Variables = dbCont.Variables.ToList();
var result = new List <result>();
result resl = new result();
foreach (var item in Variables)
{
resl.variableName = item.variable_name;
resl.variableValue = ((arr[0] * item.quest_1_effect) / 100 + (arr[1] * item.quest_2_effect) / 100 +
(arr[2] * item.quest_3_effect) / 100 + (arr[3] * item.quest_4_effect) / 100 +
(arr[4] * item.quest_5_effect) / 100 +
(arr[5] * item.quest_6_effect) / 100 + (arr[6] * item.quest_7_effect) / 100 +
(arr[7] * item.quest_8_effect) / 100 + (arr[8] * item.quest_9_effect) / 100 +
(arr[9] * item.quest_10_effect) / 100);
//result.Add(resl);
//result.Insert(inc,resl);
result.Add(new result()
{
variableName = resl.variableName, variableValue = resl.variableValue
});
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//Bir sonraki soruyu getirme kısmı
public JsonResult getNextQuestion(int id)
{
databaseContext dbCont = new databaseContext();
List <questions> Questions = dbCont.Questions.ToList();
List <questions> nextQuestion = (from q in dbCont.Questions where q.Id == id select q).ToList();
return(Json(nextQuestion, JsonRequestBehavior.AllowGet));
}
public static string GetLinkedin()
{
string ATALinkedin;
using (databaseContext db = new databaseContext {
})
{
ATALinkedin = db.Global.FirstOrDefault().LinkedinLink;
}
return(ATALinkedin);
}
public static string GetPinterest()
{
string ATAPinterest;
using (databaseContext db = new databaseContext {
})
{
ATAPinterest = db.Global.FirstOrDefault().PinterestLink;
}
return(ATAPinterest);
}
public static string GetGooglePlus()
{
string ATAGooglePlus;
using (databaseContext db = new databaseContext {
})
{
ATAGooglePlus = db.Global.FirstOrDefault().GooglePlusLink;
}
return(ATAGooglePlus);
}
public static string GetInstagram()
{
string ATAInstagram;
using (databaseContext db = new databaseContext {
})
{
ATAInstagram = db.Global.FirstOrDefault().InstagramLink;
}
return(ATAInstagram);
}
public static string GetTwitter()
{
string ATATwitter;
using (databaseContext db = new databaseContext {
})
{
ATATwitter = db.Global.FirstOrDefault().TwitterLink;
}
return(ATATwitter);
}
public static string GetYoutube()
{
string ATAYoutube;
using (databaseContext db = new databaseContext {
})
{
ATAYoutube = db.Global.FirstOrDefault().YoutubeLink;
}
return(ATAYoutube);
}
public static string GetFacebook()
{
string ATAEmail;
using (databaseContext db = new databaseContext {
})
{
ATAEmail = db.Global.FirstOrDefault().FacebookLink;
}
return(ATAEmail);
}
// GET: Question
//Index sayfası
public ActionResult Index()
{
databaseContext dbCont = new databaseContext();
List <questions> Questions = dbCont.Questions.ToList();
int id = 1;
List <questions> firstQuestion = (from q in dbCont.Questions where q.Id == id select q).ToList();
return(View(firstQuestion));
}
public IEnumerable <Users> Get()
{
using (var db = new databaseContext())
{
try
{
return(db.Users.ToList());
} catch (Exception) {
return(null);
}
}
}
public Users Get(int id)
{
using (var db = new databaseContext())
{
try
{
return(db.Users.First((user => user.Id == id)));
} catch (Exception) {
return(null);
}
}
}
public override void OnActionExecuted(System.Web.Http.Filters.HttpActionExecutedContext actionExecutedContext) {
var principal = actionExecutedContext.ActionContext.RequestContext.Principal;
if(principal != null) {
using (var db = new databaseContext()) {
var dbUser = (from b in db.AspNetUsers
where b.UserName == principal.Identity.Name
select b).First();
dbUser.LastActivity = DateTime.Now;
db.SaveChanges();
}
}
}
public static User GetUserIfAny()
{
if (HttpContext.Current.Session[_LoggedInUser] != null)
{
int userID = (int)HttpContext.Current.Session[_LoggedInUser];
using (databaseContext db = new databaseContext {
})
{
return(db.User.SingleOrDefault(u => u.Id == userID));
}
}
return(null);
}
public ActionResult GetCustomers()
{
using (databaseContext db = new databaseContext())
{
var List = db.Customers.Select(x => new CustomerViewModel {
Id = x.Id,
CName = x.CName,
Address = x.Address
}).ToList();
return(Json(List, JsonRequestBehavior.AllowGet));
};
}
public ActionResult GetProducts()
{
using (databaseContext db = new databaseContext())
{
var List = db.Products.Select(x => new ProductViewModel
{
Id = x.Id,
PName = x.PName,
Price = x.Price
}).ToList();
return(Json(List, JsonRequestBehavior.AllowGet));
};
}
public ActionResult GetAllSales()
{
using (databaseContext db = new databaseContext())
{
List <SalesViewModel> List = db.ProductSolds.Select(x => new SalesViewModel
{
Id = x.Id,
CustomerId = x.CustomerId,
ProductId = x.ProductId,
StoreId = x.StoreId,
CName = x.Customer.CName,
PName = x.Product.PName,
SName = x.Store.SName,
DateSold = x.DateSold
}).ToList();
return(Json(List, JsonRequestBehavior.AllowGet));
};
}
public static User GetLoggedInUser()
{
User currentUser = GetUserIfAny();
if (currentUser != null)
{
return(currentUser);
}
HttpCookie cookie = HttpContext.Current.Request.Cookies.Get(_Cookie);
if (cookie != null)
{
long userID = 0;
bool found = long.TryParse(cookie.Value, out userID);
if (found)
{
User userToLogin = null;
try
{
using (databaseContext db = new databaseContext {
})
{
userToLogin = db.User
.AsNoTracking()
.SingleOrDefault(e => e.Id == userID);
StartSession(user: userToLogin, rememberMe: true);
}
return(userToLogin);
}
catch
{
return(null);
}
}
}
return(null);
}
public CartController(databaseContext db, IHttpContextAccessor httpContextAccessor)
{
_db = db;
_httpContextAccessor = httpContextAccessor;
}
public AccountController(databaseContext dbc, IWebHostEnvironment webHostEnvironment, ILogger <HomeController> logger)
{
_dbc = dbc;
_webHostEnvironment = webHostEnvironment;
_logger = logger;
}
public ShopController(IWebHostEnvironment webHostEnvironment, databaseContext db, ILogger <HomeController> logger)
{
_webHostEnvironment = webHostEnvironment;
_db = db;
_logger = logger;
}
public ErrorPageController(databaseContext db)
{
_db = db;
}
public AdRepository(databaseContext context)
{
_context = context;
}
public HomeController(databaseContext dbc, ILogger <HomeController> logger)
{
_logger = logger;
_dbc = dbc;
}
public BlogResponseRepository(databaseContext context)
{
_context = context;
}
public AdminController(databaseContext db)
{
_db = db;
}
public InsecureController(databaseContext context)
{
_context = context;
}
public HomeController(databaseContext context)
{
_context = context;
}
public CartController(databaseContext db, IHttpContextAccessor httpContextAccessor, ILogger <HomeController> logger)
{
_db = db;
_httpContextAccessor = httpContextAccessor;
_logger = logger;
}
