public JsonResult OutSys(string MyChecked)
{
inquiryContact n = new inquiryContact();
inquiryContactData nd = new inquiryContactData();
var array = MyChecked.Split(',');
if (MyChecked != "" && MyChecked != null)
{
for (var i = 0; i < array.Length; i++)
{
//var Original = nd.Get().ToList().Where(a => a.num.ToString() == array[i]).SingleOrDefault();
//var DelPath = System.IO.Path.Combine(Server.MapPath("~/upload/News/"), Original.pic1);
//System.IO.File.Delete(DelPath);
//if (Original.jsonimg != "no_img.jpg")
//{
// var jsonstr = JsonConvert.DeserializeObject<List<jsonSer>>(Original.jsonimg);
// var DelJsonPath = Server.MapPath("~/upload/photograhy/");
// foreach (var j in jsonstr)
// {
// var DelJsonPathing = System.IO.Path.Combine(DelJsonPath, j.content);
// System.IO.File.Delete(DelJsonPathing);
// }
//}
n.isdel = 1;
n.udate = DateTime.Now;
n.num = Convert.ToInt32(array[i]);
nd.Delete(n);
}
}
return Json("");
}
public ActionResult SendMsg(inquiryContact inquiryCon)
{
//if (Session["Account"] != null)
//{
inquiryCon.isdel = 0;
inquiryCon.memberID = 0;
inquiryCon.wdate = DateTime.Now;
inquiryCon.udate = DateTime.Now;
var prodata = pd.Get().ToList().Where(a => a.isdel == 0);
Dictionary<string, object> dic = new Dictionary<string, object>();
List<proinquiryCart> list = new List<proinquiryCart>();
foreach (var i in prodata)
{
if (Request.Cookies["cartVal_" + i.num.ToString()] != null)
{
if (i.num.ToString() == Request.Cookies["cartVal_" + i.num.ToString()]["num"])
{
list.Add(new proinquiryCart()
{
num = i.num,
qty = Convert.ToInt32(Request.Cookies["cartVal_" + i.num.ToString()]["qty"]),
price = i.price,
total = Convert.ToInt32(Request.Cookies["cartVal_" + i.num.ToString()]["qty"]) * i.price,
});
}
}
}
inquiryCon.jsonword = JsonConvert.SerializeObject(list);
iqcd.Create(inquiryCon);
//var inquirydata = icd.Get().ToList().Where(a => a.memberID == mdata.num && a.isSend == 0 && a.isdel == 0);
//foreach (var i in inquirydata)
//{
// ic.isSend = 1;
// ic.udate = DateTime.Now;
// ic.num = i.num;
// icd.Update_Send(ic);
//}
var result = "<table border='1' cellspacing='1' cellpadding='1'>";
result += "<tbody>";
result += "<tr>";
result += "<th>公司</th>";
result += "<td>" + inquiryCon.uCompany + "</td>";
result += "</tr>";
result += "<tr>";
result += "<th>國家</th>";
result += "<td>" + inquiryCon.uCountry + "</td>";
result += "</tr>";
result += "<tr>";
result += "<th>姓名</th>";
result += "<td>" + inquiryCon.uName + "</td>";
result += "</tr>";
result += "<tr>";
result += "<th>電話</th>";
result += "<td>" + inquiryCon.uPhone + "</td>";
result += "</tr>";
result += "<tr>";
result += "<th>Email</th>";
result += "<td>" + inquiryCon.uEmail + "</td>";
result += "</tr>";
result += "<tr>";
result += "<th>類別</th>";
result += "<td>" + Contact_fn.GetQA(inquiryCon.need.ToString()) + "</td>";
result += "</tr>";
result += "<tr>";
result += "<th>訊息</th>";
result += "<td>" + inquiryCon.uMsg + "</td>";
result += "</tr>";
result += "</tbody>";
result += "</table><br>";
result += "<table>";
result += "<tr>";
result += "<td>商品名稱</td>";
result += "<td>數量</td>";
result += "<td>單價</td>";
result += "<td>金額</td>";
result += "</tr>";
foreach (var i in prodata)
{
if (Request.Cookies["cartVal_" + i.num.ToString()] != null)
{
if (i.num.ToString() == Request.Cookies["cartVal_" + i.num.ToString()]["num"])
{
result += "<tr>";
result += "<td>" + i.pname + "</td>";
result += "<td>" + Request.Cookies["cartVal_" + i.num.ToString()]["qty"] + "</td>";
result += "<td>" + i.price + "</td>";
result += "<td>" + Convert.ToInt32(Request.Cookies["cartVal_" + i.num.ToString()]["qty"]) * i.price + "</td>";
result += "</tr>";
}
}
}
result += "</table>";
//[email protected]
SendMailToEveryOne.SendMail("*****@*****.**", inquiryCon.uEmail, "杉魁詢價表單", "杉魁詢價表單", result, false);
TempData["msg"] = "詢價標單已送出";
return RedirectToAction("Index", "Home");
//}
//else
//{
// TempData["msg"] = "請先登入會員";
// return RedirectToAction("Index", "login");
//}
}
