public string HowIsYourDatabase()
{
try
{
var logs = new DcDataContext().LogSet_Select().Take(1).FirstOrDefault().Id;
return("Its healthy :)");
}
catch
{
return("Its DOWN");
}
}
public LoginResult Login(string Username, string Password)
{
try
{
var loginResult = new DcDataContext().User_Login(Username, Password).FirstOrDefault();
return(new LoginResult {
Username = Username, Success = Convert.ToBoolean(loginResult.Success), Fullname = loginResult.Fullname, IsAdmin = Convert.ToBoolean(loginResult.IsAdmin)
});
}
catch
{
return(new LoginResult {
Success = false, Fullname = null, Username = Username, IsAdmin = false
});
}
}
public ActionResult In(string Username, string Password)
{
DcDataContext dc = new DcDataContext();
if (dc.Admin_Login(Username, Password).Count() > 0)
{
Session["Username"] = Username;
Session["Password"] = Password;
}
else
{
ViewBag.Message = "Invalid username or password";
return(View());
}
return(RedirectToAction("Index", "Admin"));
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
bool CanAccess = true;
try
{
DcDataContext dc = new DcDataContext();
if (dc.Admin_Login(filterContext.HttpContext.Session["Username"].ToString(), filterContext.HttpContext.Session["Password"].ToString()).Count() > 0)
{
CanAccess = true;
}
}
catch
{
CanAccess = false;
}
if (!CanAccess)
{
filterContext.Result = new HttpStatusCodeResult(404);
}
}
public List <MenuItem> Select()
{
List <MenuItem> Output = new List <MenuItem>();
v_Group[] Data = new DcDataContext().v_Groups.OrderBy(x => x.Serial).ToArray();
int TotalItems = Data.Length;
v_Group[] PrimaryTable = new v_Group[TotalItems];
v_Group[] SecondaryTable = new v_Group[TotalItems];
int Index = 0;
while (Index < TotalItems)
{
int a = 0;
while (a < Data.Length - Index)
{
PrimaryTable[a] = Data[Index + a];
a++;
}
int b = Index + 0;
while (b < TotalItems)
{
Data[b] = null;
b++;
}
v_Group CurrentItem = PrimaryTable[0];
int c = 0;
foreach (var item in PrimaryTable)
{
if (item != null)
{
if (item.ParentId == CurrentItem.Id || item.Id == CurrentItem.Id)
{
}
else
{
SecondaryTable[c] = item;
PrimaryTable[c] = null;
}
c++;
}
}
int d = Index + 0;
int e = 0;
foreach (var item in PrimaryTable)
{
if (item != null)
{
Data[d] = PrimaryTable[e];
d++;
PrimaryTable[e] = null;
}
e++;
}
int f = 0;
foreach (var item in SecondaryTable)
{
if (item != null)
{
Data[d] = SecondaryTable[f];
d++;
SecondaryTable[f] = null;
}
f++;
}
a = b = c = d = e = f = 0;
Index++;
}
int z = 0;
foreach (var v in Data)
{
bool IsCounting = true;
v_Group currentCountingItem = v;
int depth = 0;
while (IsCounting)
{
if (currentCountingItem.ParentId != null)
{
currentCountingItem = Data.Where(k => k.Id == currentCountingItem.ParentId).First();
depth++;
}
else
{
IsCounting = false;
}
}
Output.Add(new MenuItem {
Index = z, Depth = depth, OtherProps = v
});
z++;
}
return(Output);
}
