public mAbout fGetAboutPanel(mAbout pAbout)
{
try
{
var vAbout = (from a in Db.tbl_about
where a.about_us_id == (pAbout.about_us_id)
select new mAbout
{
about_us_id = a.about_us_id,
about_exp_en_one = a.about_exp_en_one,
about_us_type = a.about_us_type,
about_exp_en_two = a.about_exp_en_two,
about_summery = a.about_summery,
about_us_exp_one = a.about_us_exp_one,
about_us_exp_two = a.about_us_exp_two,
about_us_img = a.about_us_img,
about_us_title = a.about_us_title,
about_us_img_alt = a.about_us_img_alt
}).FirstOrDefault();
return(vAbout);
}
catch (Exception)
{
return(null);
}
}
public bool fUpdateAbout(mAbout pAbout)
{
try
{
tbl_about l = new tbl_about();
l.about_us_id = pAbout.about_us_id;
l.about_exp_en_one = pAbout.about_exp_en_one;
l.about_exp_en_two = pAbout.about_exp_en_two;
l.about_summery = pAbout.about_summery;
l.about_us_exp_one = pAbout.about_us_exp_one;
l.about_us_exp_two = pAbout.about_us_exp_two;
l.about_us_img = pAbout.about_us_img;
l.about_us_img_alt = pAbout.about_us_img_alt;
l.about_us_img_height = pAbout.about_us_img_height;
l.about_us_img_width = pAbout.about_us_img_width;
l.about_us_title = pAbout.about_us_title;
l.about_us_type = pAbout.about_us_type;
Db.tbl_about.Attach(l);
Db.Entry(l).State = System.Data.Entity.EntityState.Modified;
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
public bool InsertAbout(mAbout pAbout)
{
try
{
tbl_about vAbout = new tbl_about();
var query = from b in Db.tbl_about
orderby b.about_us_id descending
select b;
vAbout = query.FirstOrDefault();
tbl_about l = new tbl_about();
l.about_exp_en_one = pAbout.about_exp_en_one;
l.about_exp_en_two = pAbout.about_exp_en_two;
l.about_summery = pAbout.about_summery;
l.about_us_exp_one = pAbout.about_us_exp_one;
l.about_us_exp_two = pAbout.about_us_exp_two;
l.about_us_img = pAbout.about_us_img;
l.about_us_img_alt = pAbout.about_us_img_alt;
l.about_us_img_height = pAbout.about_us_img_height;
l.about_us_img_width = pAbout.about_us_img_width;
l.about_us_title = pAbout.about_us_title;
l.about_us_type = pAbout.about_us_type;
l.about_us_id = vAbout.about_us_id + 1;
Db.tbl_about.Add(l);
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
public ActionResult report()
{
try
{
mAbout vAbout = new mAbout();
List <mAbout> aAbout = new List <mAbout>();
vAbout.about_us_type = 6;
mHome vHome = new mHome();
vAbout = a.fGetAbout(vAbout);
if (vAbout == null)
{
vAbout = new mAbout();
}
else
{
vHome.About = vAbout;
}
return(View(vHome));
}
catch
{
return(RedirectToAction("_Error", "Home"));
}
}
public ActionResult manager()
{
try
{
mAbout vAbout = new mAbout();
mAbout vAbout2 = new mAbout();
mHome vHome = new mHome();
vAbout.about_us_type = 3;
vAbout2.about_us_type = 4;
vAbout = a.fGetAbout(vAbout);
vAbout2 = a.fGetAbout(vAbout2);
vHome.About = vAbout;
vHome.About2 = vAbout2;
int pId = 3;
List <mGallery> aGallery = new List <mGallery>();
aGallery = g.fGalleryList(pGet, pSkip, pId);
if (aGallery != null)
{
vHome.aGallery = aGallery;
}
return(View(vHome));
}
catch
{
return(RedirectToAction("_Error", "Home"));
}
}
public ActionResult AboutPost(mAbout pAbout)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
if (!(ModelState.IsValid))
{
ViewBag.error = "خطا در اطلاعات ورودی !";
return(View(pAbout));
}
else
{
if (pAbout.img_file != null && pAbout.img_file.ContentLength > 0)
{
if (pAbout.img_file.ContentLength < 10485760)
{
Random rnd = new Random();
string img = rnd.Next().ToString() + ".jpg";
string Path = System.IO.Path.Combine(Server.MapPath("~/images/about/"));
pAbout.img_file.SaveAs(Path + img);
using (MemoryStream ms = new MemoryStream())
{
pAbout.img_file.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
pAbout.about_us_img = img;
}
}
else
{
ViewBag.error = "حد اکثر اندازه فایل را رعایت نکرده اید !";
return(View(pAbout));
}
}
if (pAbout.about_us_id > 0)
{
if (a.fUpdateAbout(pAbout))
{
return(RedirectToAction("index", new { pId = pAbout.about_us_id }));
}
ViewBag.error = "خطا در انجام عملیات ! ";
}
else
{
if (a.InsertAbout(pAbout))
{
return(RedirectToAction("index", new { pId = pAbout.about_us_id }));
}
ViewBag.error = "خطا در انجام عملیات ! ";
}
}
return(View(pAbout));
}
public ActionResult representative()
{
try
{
mAbout vAbout = new mAbout();
List <mAbout> aAbout = new List <mAbout>();
vAbout.about_us_type = 5;
mHome vHome = new mHome();
mArticle vArticle = new mArticle();
vAbout = a.fGetAbout(vAbout);
List <mLink> aLinks = new List <mLink>();
List <mProduct> aProduct = new List <mProduct>();
mLink vLink = new mLink();
vLink.link_status = 2;
List <mArticle> aArticle = new List <mArticle>();
aArticle = ar.fArticlesListMostVisited(6, pSkip, vArticle, vHome);
aLinks = l.fLinkList(12, 0, vLink);
if (aArticle != null && aArticle.Count > 0)
{
vHome.aArticles = aArticle;
}
else
{
vHome.aArticles = new List <mArticle>();
}
if (aLinks != null && aLinks.Count > 0)
{
vHome.aLink = aLinks;
}
else
{
vHome.aLink = new List <mLink>();
}
if (vAbout == null)
{
vAbout = new mAbout();
}
else
{
vHome.About = vAbout;
}
return(View(vHome));
}
catch
{
return(RedirectToAction("_Error", "Home"));
}
}
public ActionResult payments()
{
try
{
mAbout vAbout = new mAbout();
List <mAbout> aAbout = new List <mAbout>();
vAbout.about_us_type = 7;
mHome vHome = new mHome();
vAbout = a.fGetAbout(vAbout);
if (vAbout == null)
{
vAbout = new mAbout();
}
else
{
vHome.About = vAbout;
}
mLink vLink = new mLink();
vLink.link_status = 2;
List <mLink> aLinks = new List <mLink>();
List <mProduct> aProduct = new List <mProduct>();
List <mNews> aNews = new List <mNews>();
aNews = b.fNewsList(pGet, pSkip);
aLinks = l.fLinkList(12, 0, vLink);
if (aNews != null && aNews.Count > 0)
{
vHome.aNews = aNews;
}
else
{
vHome.aNews = new List <mNews>();
}
if (aLinks != null && aLinks.Count > 0)
{
vHome.aLink = aLinks;
}
else
{
vHome.aLink = new List <mLink>();
}
return(View(vHome));
}
catch
{
return(RedirectToAction("_Error", "Home"));
}
}
public ActionResult Index(int pId)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
List <mAbout> aAbout = new List <mAbout>();
mAbout pAbout = new mAbout();
pAbout.about_us_id = pId;
aAbout = a.fAboutList(pGet, pSkip, pAbout);
return(View(aAbout));
}
public ActionResult AboutGet(int pId = 0)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
mAbout vAbout = new mAbout();
if (pId > 0)
{
vAbout.about_us_id = pId;
vAbout = a.fGetAboutPanel(vAbout);
}
else
{
vAbout = new mAbout();
}
return(View("_About", vAbout));
}
// GET: Category
public ActionResult About()
{
try
{
mAbout vAbout = new mAbout();
mAbout vAbout2 = new mAbout();
mHome vHome = new mHome();
vAbout.about_us_type = 1;
vAbout2.about_us_type = 2;
vAbout = a.fGetAbout(vAbout);
vAbout2 = a.fGetAbout(vAbout2);
vHome.About = vAbout;
vHome.About2 = vAbout2;
return(View(vHome));
}
catch
{
return(RedirectToAction("_Error", "Home"));
}
}
public List <mAbout> fAboutList(int pGet, int pSkip, mAbout pAbout)
{
IQueryable <mAbout> vAbout;
vAbout = (from a in Db.tbl_about
where a.about_us_id == pAbout.about_us_id
select new mAbout
{
about_us_id = a.about_us_id,
about_exp_en_one = a.about_exp_en_one,
about_us_type = a.about_us_type,
about_exp_en_two = a.about_exp_en_two,
about_summery = a.about_summery,
about_us_exp_one = a.about_us_exp_one,
about_us_exp_two = a.about_us_exp_two,
about_us_img = a.about_us_img,
about_us_title = a.about_us_title,
about_us_img_alt = a.about_us_img_alt
}).OrderByDescending(b => b.about_us_type).Skip(pSkip).Take(pGet);
return(vAbout.ToList());
}
