public BaseController()
{
_userappservice = new UserAppService();
_roleappservice = new RoleAppService();
_settingdataservice = new SettingDataService();
_generalsettingservice = new GeneralSettingService();
_carihesapyetkiliORM = new CariHesapYetkiliORM();
_iliskiORM = new iliskierORM();
_iliskilerViewORM = new iliskilerViewORM();
_carihesapYetkiliORM = new CariHesapYetkiliORM();
_carihesapadresleriORM = new CariHesapAdresORM();
_carihesaplarORM = new CariHesaplarORM();
_hizmethesaplarORM = new HizmetHesapORM();
_stoklarORM = new StoklarORM();
_carihesaplarORM = new CariHesaplarORM();
_siparisORM = new SiparisORM();
_stoksatisFiyatORM = new StokSatisFiyatlariORM();
_evrakAciklamaORM = new EvrakAciklamaORM();
_viewproformaSiparisORM = new viewProformaSiparisORM();
_proformaSiparisORM = new ProformaSiparisORM();
_caripersonelTanimORM = new CariPersonelTanimlariORM();
_viewCustomerReportORM = new viewCustomerReportORM();
_myeTextDataOrm = new myeTextDataOrm();
_cleanderservice = new CleanderService();
_customersearchORM = new CustomerSearchORM();
_customerreportORM = new CustomerReportORM();
_bankahesaplarORM = new BankaHesaplarOrm();
_viewBankReportORM = new viewBankReportORM();
}
public static bool GetConnection(this HtmlHelper h)
{
var email = HttpContext.Current.User.Identity.Name;
UserAppService _userservice = new UserAppService();
SettingDataService _settingdataservice = new SettingDataService();
var user = _userservice.Get(x => x.Email.Trim() == email);
var data = _settingdataservice.Get(x => x.UserId == user.Id);
string sqlcon = "server=" + data.Server + ";DataBase=" + data.DataBase + ";User="******";Password="******"";
SqlConnection con = new SqlConnection(sqlcon);
try
{
con.Open();
if (con.State == ConnectionState.Open)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
finally
{
if (con.State == ConnectionState.Closed)
{
con.Close();
}
}
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
if (!HttpContext.Current.User.Identity.IsAuthenticated)
{
//if (!HttpContext.Current.Response.IsRequestBeingRedirected)
// filterContext.HttpContext.Response.Redirect("/Login/Index");
}
else
{
var database = (SettingData)filterContext.HttpContext.Session["UserDataBase"];
if (database == null)
{
var email = HttpContext.Current.User.Identity.Name;
UserAppService _userservice = new UserAppService();
SettingDataService _settingdataservice = new SettingDataService();
var user = _userservice.Get(x => x.Email.Trim() == email);
var data = _settingdataservice.Get(x => x.UserId == user.Id);
filterContext.HttpContext.Session["UserDataBase"] = data;
filterContext.HttpContext.Session["UserAccount"] = user;
_userservice.Dispose();
_settingdataservice.Dispose();
}
}
}
public LoginController()
{
_userservice = new UserAppService();
_settingDataBase = new SettingDataService();
}
