public ActionResult DownloadFile(string Id)
{
DBDataContext db = new DBDataContext();
int IdCur = Convert.ToInt32(Id);
EducationSearching.Files fFile = db.Files.FirstOrDefault(u => u.Id == IdCur);
FileContentResult tr = new FileContentResult(fFile.FileData.ToArray(), fFile.MimeType);
tr.FileDownloadName = fFile.Name;
return tr;
}
//
// GET: /Admin/
public ActionResult Index()
{
DBDataContext db = new DBDataContext();
UserProfile user = db.UserProfile.FirstOrDefault(u => u.UserName.ToLower() == User.Identity.Name.ToLower());
ViewBag.UserFIO = user.FIOShort;
if (user == null)
{
ViewBag.UserRole = "Anonymous";
return View();
}
webpages_UsersInRoles userInRoles = db.webpages_UsersInRoles.FirstOrDefault(u => u.UserId == user.UserId);
if (userInRoles == null)
{
ViewBag.UserRole = "Anonymous";
return View();
}
webpages_Roles roles = db.webpages_Roles.FirstOrDefault(u => u.RoleId == userInRoles.RoleId);
if (roles == null)
{
ViewBag.UserRole = "Anonymous";
return View();
}
if (!string.Equals(roles.RoleName, "Administrator"))
{
return RedirectToAction("Index", "Main");
}
return View();
}
public void OnNewsChanged(object sender, EventArgs e)
{
using (DBDataContext db = new DBDataContext())
{
int mId = 0;
int.TryParse(ddlNews.SelectedValue, out mId);
var p = (from N in db.News
where N.id == mId
select N).FirstOrDefault();
if (p != null)
{
txtHeader.Text = p.Header;
txtPageTitle.Text = p.PageHeader;
fckEditor.Value = p.Content;
btnSave.Text = "Обновить новость";
btnDelete.Enabled = true;
}
else
{
btnSave.Text = "Добавить новость";
btnDelete.Enabled = false;
}
}
}
public void OnAdd(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (ddlNews.SelectedValue == "-1")
{
using (DBDataContext db = new DBDataContext())
{
var news = new News()
{
Header = txtHeader.Text.Trim(),
PageHeader = txtPageTitle.Text.Trim(),
Content = fckEditor.Value
};
db.News.InsertOnSubmit(news);
db.SubmitChanges();
lblMessage.Text = string.Format("Добавлена новая новость '{0}'", txtHeader.Text.Trim());
}
}
else
{
Update();
}
InitLists();
}
}
public void OnAdd(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (DBDataContext db = new DBDataContext())
{
int catID = int.Parse(ddlCategories.SelectedValue);
var qa = new QA()
{
Quester = txtName.Text.Trim(),
Question = txtQuestion.Text.Trim(),
Header = txtQuestion.Text.Trim(),
Phone = string.IsNullOrEmpty(txtPhone.Text.Trim()) ? null : txtPhone.Text.Trim(),
Date = DateTime.Now,
CategoryId = catID
};
db.QA.InsertOnSubmit(qa);
db.SubmitChanges();
mvQA.SetActiveView(vQuestion);
txtName.Text = "";
txtQuestion.Text = "";
txtPhone.Text = "";
lblMessage.Text = "Спасибо за Ваш вопрос. В ближайшее время мы постараемся дать Вам ответ.";
}
}
}
protected void lvCities_ItemUpdating(object sender, ListViewUpdateEventArgs e)
{
using (DBDataContext db = new DBDataContext())
{
string name = "";
int ID = 0, DeliveryPrice = 0, FreeDelivery = 0;
foreach (string key in e.NewValues.Keys)
{
switch(key)
{
case "Name":
name = e.NewValues[key].ToString();
break;
case "DeliveryPrice":
int.TryParse(e.NewValues[key].ToString(), out DeliveryPrice);
break;
case "FreeDelivery":
int.TryParse(e.NewValues[key].ToString(), out FreeDelivery);
break;
case "ID":
int.TryParse(e.NewValues[key].ToString(), out ID);
break;
}
}
City c = db.Cities.First(C => C.ID == ID);
c.Name = name;
c.FreeDelivery = FreeDelivery;
c.DeliveryPrice = DeliveryPrice;
db.SubmitChanges();
}
lvCities.EditIndex = -1;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["searchString"] != null)
{
string s = Session["searchString"].ToString();
using (DBDataContext db = new DBDataContext())
{
var q = from Q in db.QA
where Q.Answer.Contains(s) || Q.Header.Contains(s) || Q.Question.Contains(s)
select new
{
Link = ResolveUrl(string.Format("~/QuestionAnswer.aspx?id={0}", Q.id)),
Header = Q.Header
};
var p = from P in db.Pages
where P.Content.Contains(s) || P.DisplayLinkTitle.Contains(s) || P.Title.Contains(s)
select new
{
Link = ResolveUrl(string.Format("~/Page.aspx?id={0}", P.id)),
Header = P.Title
};
var b = from B in db.Blog
where B.Content.Contains(s) || B.Header.Contains(s)
select new
{
Link = ResolveUrl(string.Format("~/Blog.aspx?id={0}", B.id)),
Header = B.Header
};
lvSearchResults.DataSource = q.Union(p).Union(b);
lvSearchResults.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Response.Redirect("/Developing.htm");
using (DBDataContext db = new DBDataContext())
{
City[] cityList = (from CITY in db.Cities
orderby CITY.Name
select CITY).ToArray();
ddlCities.DataSource = cityList;
ddlCities.DataTextField = "Name";
ddlCities.DataValueField = "ID";
ddlCities.DataBind();
foreach (ListItem li in ddlCities.Items)
{
li.Attributes.Add("dLimit", cityList.Where(C => C.ID == int.Parse(li.Value)).First().FreeDelivery.ToString());
if (li.Value == Cart.SelectedCity)
{
li.Selected = true;
txtDeliveryLimit.InnerText = li.Attributes["dLimit"];
}
}
if (Request.Cookies["selectedCityToDeliver"] == null && ddlCities.Items.Count > 0)
{
txtDeliveryLimit.InnerText = ddlCities.Items[0].Attributes["dLimit"];
}
}
CartResponse cr = new CartResponse();
cartTotal.InnerHtml = cr.price.ToString();
cartCount.InnerHtml = cr.count.ToString();
}
public void OnDelete(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)sender;
int i = 0;
int.TryParse(btn.CommandArgument, out i);
if (i != 0)
{
using (DBDataContext db = new DBDataContext())
{
var q = (from Q in db.QA
where Q.id == i
select Q).FirstOrDefault();
if (q != null)
{
db.QA.DeleteOnSubmit(q);
db.SubmitChanges();
lblMessage.Text = "Ответ успешно удален.";
mvQuestions.SetActiveView(vNotAnswered);
var data = (from Q in db.QA
where !Q.Answered
select Q).ToArray();
lvNotAnswered.DataSource = data;
lvNotAnswered.DataBind();
}
else
lblMessage.Text = "Ошибка при удалении.";
}
}
else
{
lblMessage.Text = "Ошибка при удалении.";
}
}
public void GenerateCodeTest()
{
using (var db = new DBDataContext())
{
var appClient = db.Client.Where(a => a.Deleted == 0).FirstOrDefault();
var userAccount = db.Account.Where(e => e.Deleted == 0).FirstOrDefault();
if (appClient != null && userAccount != null)
{
var client = new ClientDao().GetClient(appClient.ID);
var code = Core.Instance.AuthManager.GenerateCode(client, userAccount);
Assert.AreNotEqual(null, code);
var token = Core.Instance.AuthManager.GetAccessToken(new AuthorizeCode
{
AccountId = userAccount.AccountId,
ClientId = client.ClientId,
CreateTime = DateTime.Now
});
Assert.AreNotEqual(null, token);
var values = token.Token.FromHexString().AESDecrypt().Split('|');
Assert.AreEqual(values[0], client.ClientId);
}
}
}
public void OnLink(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (DBDataContext db = new DBDataContext())
{
int pid = 0;
int mid = 0;
if (int.TryParse(ddlMenu.SelectedValue, out mid) && int.TryParse(ddlPage.SelectedValue, out pid))
{
var p = (from P in db.Pages
where P.id == pid
select P).FirstOrDefault();
var m = (from M in db.LeftMenu
where M.id == mid
select M).FirstOrDefault();
if (p != null && m != null)
{
m.PageID = p.id;
db.SubmitChanges();
lblMessage.Text = string.Format("Пункт меню '{0}' был успешно связан со страницей '{1}'", m.ItemName, p.Title);
}
}
}
}
}
public void OnLink(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (DBDataContext db = new DBDataContext())
{
int mid = 0;
if (int.TryParse(ddlMenu.SelectedValue, out mid))
{
var m = from M in db.LeftMenu
select M;
foreach (ListItem I in cblSubmenu.Items)
{
foreach (var M in m)
{
if (M.id.ToString() == I.Value)
{
if (I.Selected)
M.ParetnId = mid;
else
M.ParetnId = null;
}
}
}
db.SubmitChanges();
lblMessage.Text = "Сохранено";
}
}
}
}
public void OnMenuChanged(object sender, EventArgs e)
{
using (DBDataContext db = new DBDataContext())
{
var menudata = from LM in db.LeftMenu
orderby LM.Order
select LM;
int i;
if (int.TryParse(ddlMenu.SelectedValue, out i))
{
cblSubmenu.Items.Clear();
foreach (var sd in menudata)
{
if (sd.id != i && (sd.ParetnId == i || sd.ParetnId == null))
{
ListItem l = new ListItem();
l.Selected = sd.ParetnId == i;
l.Text = sd.ItemName;
l.Value = sd.id.ToString();
cblSubmenu.Items.Add(l);
}
}
}
}
}
private void InitLists()
{
using (DBDataContext db = new DBDataContext())
{
var menudata = from LM in db.LeftMenu
orderby LM.Order
select LM;
ddlMenu.DataSource = menudata;
ddlMenu.DataTextField = "ItemName";
ddlMenu.DataValueField = "id";
ddlMenu.DataBind();
int i;
if (int.TryParse(ddlMenu.SelectedValue, out i))
{
cblSubmenu.Items.Clear();
foreach (var sd in menudata)
{
if (sd.id != i && (sd.ParetnId == i || sd.ParetnId == null))
{
ListItem l = new ListItem();
l.Selected = sd.ParetnId == i;
l.Text = sd.ItemName;
l.Value = sd.id.ToString();
cblSubmenu.Items.Add(l);
}
}
}
}
}
public void OnDown(object sender, EventArgs e)
{
int i = 0;
if (int.TryParse(ddlMenu.SelectedValue, out i))
{
using (DBDataContext db = new DBDataContext())
{
var m = (from M in db.LeftMenu
where M.id == i
select M).FirstOrDefault();
if (m != null)
{
var exm = (from EXM in db.LeftMenu
where EXM.Order > m.Order
orderby EXM.Order
select EXM).FirstOrDefault();
if (exm != null)
{
int tmp = m.Order.Value;
m.Order = exm.Order.Value;
exm.Order = tmp;
db.SubmitChanges();
}
}
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
using (DBDataContext db = new DBDataContext())
{
var m = (from TM in db.LeftMenu
where TM.ParetnId == null
orderby TM.Order
select new
{
Title = TM.ItemName,
Alt = "",
Link = TM.PageID,
SubMenu = TM.LeftMenu2.ToList()
}).ToList();
var res = from M in m
select new
{
M.Alt,
M.Title,
Link = !M.Link.HasValue ? "#" : string.Format(ResolveUrl("~/Page.aspx?id={0}"), M.Link.Value),
Submenu = M.SubMenu
};
lvLeftMenu.DataSource = res;
lvLeftMenu.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
int id;
if (int.TryParse(Request["id"], out id))
{
mvNewsView.SetActiveView(vSingle);
using (DBDataContext db = new DBDataContext())
{
var n = (from N in db.News
where N.id == id
select N).FirstOrDefault();
if (n != null)
{
Page.Title = n.PageHeader;
lblContent.Text = n.Content;
h2NewsHeader.InnerText = n.Header;
}
else
lblContent.Text = "Новость была удалена с сервера.";
}
}
else
{
mvNewsView.SetActiveView(vAll);
using (DBDataContext db = new DBDataContext())
{
var res = (from N in db.News
select N).ToList();
lvNews.DataSource = res;
lvNews.DataBind();
if (res.Count() <= dpPager.PageSize)
dpPager.Visible = false;
}
}
}
protected void Edit(int id)
{
using (DBDataContext db = new DBDataContext())
{
Item itm = db.Items.FirstOrDefault(I => I.ID == id);
if (itm != null)
{
txtDescription.Text = itm.Description.Trim();
txtShortDescription.Text = itm.ShortDescription;
txtName.Text = itm.Name.Trim();
txtPrice.Text = itm.Price.ToString();
txtWeight.Text = itm.Weight.ToString();
ddlCategory.ClearSelection();
ddlCategory.Items.FindByValue(itm.Category.ToString()).Selected = true;
ddlRez.ClearSelection();
if (itm.Rezba.HasValue)
ddlRez.Items.FindByValue(itm.Rezba.ToString()).Selected = true;
ddlSize.ClearSelection();
if (itm.Size.HasValue)
ddlSize.Items.FindByValue(itm.Size.ToString()).Selected = true;
lvImages.DataSource = itm.Pics;
lvImages.DataBind();
lblItemsCount.Text = itm.IncomeOrders.Sum(IO => IO.ItemsLeft).ToString();
txtIncomePricePerItem.Text = ((int)Math.Round(itm.Price * Cart.Currency)).ToString();
}
else
Response.Redirect("/admin/Default.aspx");
}
mvItems.SetActiveView(vEdit);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = 0;
if (int.TryParse(Request["id"], out id))
{
mvBlog.SetActiveView(vSingle);
using (DBDataContext db = new DBDataContext())
{
var b = (from B in db.Blog
where B.id == id
select B).FirstOrDefault();
if (b != null)
{
phPageContent.InnerHtml = b.Content;
header.InnerHtml = b.Header;
Page.Title = b.Header;
}
}
}
else
{
mvBlog.SetActiveView(vAll);
using (DBDataContext db = new DBDataContext())
{
var b = from B in db.Blog
select B;
lvBlog.DataSource = b;
lvBlog.DataBind();
}
}
}
public void PageChanged(object sender, EventArgs e)
{
lblError.Text = "";
using (DBDataContext db = new DBDataContext())
{
int i;
if (int.TryParse(ddlPages.SelectedValue, out i))
{
if (i > 0)
{
var p = (from P in db.Pages
where P.id == i
select P).FirstOrDefault();
if (p != null)
{
txtLinkText.Text = p.DisplayLinkTitle;
txtPageHeader.Text = p.Title;
fckEditor.Value = p.Content;
btnMakeAsDefault.Visible = true;
btnDelete.Visible = true;
btnDelete.CommandArgument = p.id.ToString();
if (p.LeftMenu.Count() != 0 || p.TopMenuItem.Count() != 0)
{
StringBuilder pts = new StringBuilder();
foreach (LeftMenu lm in p.LeftMenu.ToList())
{
pts.AppendFormat(" '{0}' слева,", lm.ItemName);
}
foreach (TopMenuItem tm in p.TopMenuItem.ToList())
{
pts.AppendFormat(" '{0}' сверху,", tm.Title);
}
string str = pts.Length > 0 ? pts.ToString().Substring(0, pts.Length - 1) : "";
btnDelete.ToolTip = string.Format("Удалить эту страницу (ВНИМАНИЕ! Удаление этой страницы повлечет за собой удаление следующих пунктов меню:{0})", str);
}
else
btnDelete.ToolTip = "Удалить эту страницу";
}
else
{
btnMakeAsDefault.Visible = false;
btnDelete.Visible = false;
}
return;
}
else
{
btnMakeAsDefault.Visible = false;
btnDelete.Visible = false;
}
}
txtLinkText.Text = "";
txtPageHeader.Text = "";
fckEditor.Value = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (DBDataContext DB = new DBDataContext())
{
lvSizes.DataSource = (from C in DB.Sizes select C).ToArray();
lvSizes.DataBind();
}
}
public CONVENIADO getConveniado()
{
DBDataContext db =
new DBDataContext();
var sql = from c in db.CONVENIADOs
where SqlMethods.Like(c.TITULAR,"%Sid%")
select c;
return (CONVENIADO)sql;
}
public static string UpdateCategoryName(int id, string newName)
{
using (DBDataContext db = new DBDataContext())
{
Category cat = db.Categories.FirstOrDefault(C => C.ID == id);
cat.Name = newName;
db.SubmitChanges();
}
return newName;
}
protected void DeleteSize(object sender, EventArgs e)
{
int id = int.Parse(((Button)sender).CommandArgument);
using (DBDataContext db = new DBDataContext())
{
Size size = db.Sizes.FirstOrDefault(S => S.ID == id);
db.Sizes.DeleteOnSubmit(size);
db.SubmitChanges();
}
}
/// <summary>
/// 返回数据库结果
/// </summary>
/// <returns></returns>
public List<Item> GetResult()
{
DBDataContext ctx = new DBDataContext();
var result = from l in ctx.Items
orderby l.CreatedTime descending
select l;
return result.ToList();
}
public static void AddCategory(int parentID, string name)
{
using (DBDataContext db = new DBDataContext())
{
Category cat = new Category();
cat.ParentCategory = parentID;
cat.Name = name;
db.Categories.InsertOnSubmit(cat);
db.SubmitChanges();
}
}
public static void UpdateVisibility(int id, bool visible)
{
using (DBDataContext db = new DBDataContext())
{
Item itm = db.Items.FirstOrDefault(I => I.ID == id);
if (itm != null)
{
itm.Visible = visible;
db.SubmitChanges();
}
}
}
public static void DeleteImage(int id)
{
using (DBDataContext db = new DBDataContext())
{
Pic pic = db.Pics.FirstOrDefault(P => P.ID == id);
if (pic != null)
{
db.Pics.DeleteOnSubmit(pic);
db.SubmitChanges();
}
}
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (!IsPostBack)
{
mvSizes.SetActiveView(vAll);
}
using (DBDataContext db = new DBDataContext())
{
lvSizes.DataSource = db.Sizes;
lvSizes.DataBind();
}
}
public ActionResult DeleteFiles(string Id)
{
DBDataContext db = new DBDataContext();
int IdCur = Convert.ToInt32(Id);
fileContaner fd = db.fileContaner.FirstOrDefault(u => u.Id == IdCur);
int? predmetId = fd.predmetId;
db.ExecuteCommand("DELETE FROM Files WHERE Id=" + fd.docsId.ToString());
db.ExecuteCommand("DELETE FROM Files WHERE Id=" + fd.programId.ToString());
db.ExecuteCommand("DELETE FROM Files WHERE Id=" + fd.scanId.ToString());
db.ExecuteCommand("DELETE FROM fileContaner WHERE Id=" + Id);
return RedirectToAction("Downloads", new { id = predmetId });
}
