public bool InsertFeedback(mFeedback pFeedback)
{
try
{
tbl_customer_feedback vFeedback = new tbl_customer_feedback();
var query = from b in Db.tbl_customer_feedback
orderby b.cust_feedback_id descending
select b;
vFeedback = query.FirstOrDefault();
tbl_customer_feedback f = new tbl_customer_feedback();
f.cust_feedback_title = pFeedback.cust_feedback_title;
f.cust_feedback_img = pFeedback.cust_feedback_img;
f.cust_feedback_exp = pFeedback.cust_feedback_exp;
f.cust_address = pFeedback.cust_address;
f.cust_company_title = pFeedback.cust_company_title;
f.cust_feedback_project_img = pFeedback.cust_feedback_project_img;
f.cust_feedback_id = vFeedback.cust_feedback_id + 1;
Db.tbl_customer_feedback.Add(f);
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
public ActionResult FeedbackPost(mFeedback pFeedback)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
ViewBag.title = "ویرایش فایل";
if (!(ModelState.IsValid))
{
ViewBag.error = "خطا در اطلاعات ورودی !";
return(View(pFeedback));
}
else
{
if (pFeedback.img_file != null && pFeedback.img_file.ContentLength > 0)
{
if (pFeedback.img_file.ContentLength < 10485760)
{
Random rnd = new Random();
string img = rnd.Next().ToString() + ".jpeg";
string Path = System.IO.Path.Combine(Server.MapPath("~/images/feedback/"));
pFeedback.img_file.SaveAs(Path + img);
using (MemoryStream ms = new MemoryStream())
{
pFeedback.img_file.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
pFeedback.cust_feedback_img = img;
}
}
else
{
ViewBag.error = "حد اکثر اندازه فایل را رعایت نکرده اید !";
return(View(pFeedback));
}
}
if (pFeedback.cust_feedback_id > 0)
{
if (f.fUpdateFeedback(pFeedback))
{
return(RedirectToAction("index"));
}
ViewBag.error = "خطا در انجام عملیات ! ";
}
else
{
if (f.InsertFeedback(pFeedback))
{
return(RedirectToAction("index"));
}
ViewBag.error = "خطا در انجام عملیات ! ";
}
}
return(View(pFeedback));
}
public ActionResult RemoveFeedback(int pId)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("Login", "LoginForm"));
}
mFeedback vFeedback = new mFeedback();
if (f.fDeleteFeedback(pId))
{
return(Json(pId, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(pId, JsonRequestBehavior.AllowGet));
}
}
public ActionResult FeedbackGet(int pId = 0)
{
if (fUserControl() == 0)
{
ViewBag.Message = "شما وارد سایت نشده اید...";
return(RedirectToAction("LoginForm", "Login"));
}
mFeedback vFeedback = new mFeedback();
if (pId > 0)
{
vFeedback.cust_feedback_id = pId;
vFeedback = f.fGetFeedback(vFeedback);
}
else
{
vFeedback = new mFeedback();
}
return(View("_Feedback", vFeedback));
}
public bool fUpdateFeedback(mFeedback pFeedback)
{
try
{
tbl_customer_feedback f = new tbl_customer_feedback();
f.cust_feedback_id = pFeedback.cust_feedback_id;
f.cust_company_title = pFeedback.cust_company_title;
f.cust_feedback_img = pFeedback.cust_feedback_img;
f.cust_feedback_exp = pFeedback.cust_feedback_exp;
f.cust_address = pFeedback.cust_address;
f.cust_feedback_title = pFeedback.cust_feedback_title;
f.cust_feedback_project_img = pFeedback.cust_feedback_project_img;
Db.tbl_customer_feedback.Attach(f);
Db.Entry(f).State = System.Data.Entity.EntityState.Modified;
return(Convert.ToBoolean(Db.SaveChanges()));
}
catch (Exception)
{
return(false);
}
}
public mFeedback fGetFeedback(mFeedback pFeedback)
{
try
{
var vFeedback = (from f in Db.tbl_customer_feedback
where f.cust_feedback_id.Equals(pFeedback.cust_feedback_id)
select new mFeedback
{
cust_feedback_id = f.cust_feedback_id,
cust_company_title = f.cust_company_title,
cust_address = f.cust_address,
cust_feedback_exp = f.cust_feedback_exp,
cust_feedback_img = f.cust_feedback_img,
cust_feedback_title = f.cust_feedback_title,
cust_feedback_project_img = f.cust_feedback_project_img
}).FirstOrDefault();
return(vFeedback);
}
catch (Exception)
{
return(null);
}
}
