public JsonResult UploadImage(IFormFile photo, string CPhone)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
TMember mem新增圖片 = (from n in db.TMembers
where n.CPhone == CPhone
select n).FirstOrDefault();
if (photo != null)
{
string photoname = Guid.NewGuid().ToString() + ".jpg";
using (var MemberPhoto = new FileStream(iv_host.WebRootPath + @"\MemberPhoto\" + photoname, FileMode.Create))
{
photo.CopyTo(MemberPhoto);
}
mem新增圖片.CPicture = @"/MemberPhoto/" + photoname;
db.SaveChanges();
return(Json(new { result = true }));
}
else
{
mem新增圖片.CPicture = @"/MemberPhoto/無人頭.jpg";
db.SaveChanges();
}
return(Json(new { result = false }));
}
public void orderCancel(int?id)
{
if (id != null)
{
TOrder l_order被修改 = db.TOrders.FirstOrDefault(n => n.COrderId == id);
TMember l_member被修改 = db.TMembers.FirstOrDefault(n => n.CMemberId == l_order被修改.CMemberId);
TCupon l_cupon被修改 = db.TCupons.FirstOrDefault(n => n.CCuponId == l_order被修改.CCuponId);
TCuponCategory p折扣金額 = db.TCuponCategories.FirstOrDefault(n => n.CCuponCategoryId == l_cupon被修改.CCuponCategoryId);
IEnumerable <TOrderDetail> table = null;
table = db.TOrderDetails.Where(n => n.COrderId == id);
List <TOrderDetail> list = new List <TOrderDetail>();
foreach (var item in table)
{
list.Add(item);
}
decimal p總價 = 0;
decimal p價格 = 0;
int p數量 = 0;
int pID = 0;
for (int i = 0; i < list.Count(); i++)
{
//消費金額
p價格 = list[i].CPriceAtTheTime.Value;
p數量 = list[i].CQuantity.Value;
p總價 += (p價格 * p數量);
//產品庫存
pID = list[i].CProductId;
TProduct l_product被修改 = db.TProducts.FirstOrDefault(n => n.CProductId == pID);
l_product被修改.CQuantity += p數量;
}
if (l_order被修改.CPayTypeId.Value == 1)
{
//無折扣
if (l_order被修改.CCuponId.Value == 1)
{
l_order被修改.COrderStatusId = 3;
l_member被修改.CDeposit += p總價;
}
//有折扣
else
{
l_order被修改.COrderStatusId = 3;
l_member被修改.CDeposit += (p總價 - p折扣金額.CCutPrice.Value);
l_cupon被修改.CBeUsed = 0;
}
}
else
{
l_order被修改.COrderStatusId = 3;
}
db.SaveChanges();
}
}
public IActionResult CreateCategory(CCategoryViewModel p_產品類別新增)
{
if (!string.IsNullOrEmpty(p_產品類別新增.CCategoryName))
{
db.TProductCategories.Add(p_產品類別新增.allTProductCategory);
db.SaveChanges();
}
return(RedirectToAction("CategoryList"));
}
public void saveCombo([FromBody] List <jComboDetail> list)
{
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
if (list.First().cID != 0)
{
TCombo reviseTarget = dbcontext.TCombos.FirstOrDefault(n => n.CComboId == list.First().cID);
reviseTarget.CComboName = list.First().cName;
var removetarget = dbcontext.TComboDetails.Where(n => n.CComboId == list[0].cID);
dbcontext.TComboDetails.RemoveRange(removetarget);
foreach (var item in list)
{
for (int i = 0; i < item.q; i++)
{
TComboDetail detail = new TComboDetail
{
CComboId = item.cID,
CProductId = item.pID,
};
dbcontext.TComboDetails.Add(detail);
}
;
}
;
dbcontext.SaveChanges();
}
else
{
TCombo newcombo = new TCombo
{
CComboName = list.First().cName,
CMemberId = list.First().mID,
};
dbcontext.TCombos.Add(newcombo);
dbcontext.SaveChanges();
int newcomboID = dbcontext.TCombos.Where(n => n.CMemberId == list.First().mID).OrderByDescending(n => n.CComboId).First().CComboId;
foreach (var item in list)
{
for (int i = 0; i < item.q; i++)
{
TComboDetail detail = new TComboDetail
{
CComboId = newcomboID,
CProductId = item.pID,
};
dbcontext.TComboDetails.Add(detail);
}
;
}
;
dbcontext.SaveChanges();
}
//return "done";
}
public JsonResult getDetailValue(int StarValue, string ReviewInput, int orderdetailID)
{
string test = $"{StarValue}分,{ReviewInput},編號{orderdetailID}號";
var UpdateScore = db.TOrderDetails.Where(n => n.COrderDetailId == orderdetailID).FirstOrDefault();
UpdateScore.CScores = StarValue;
UpdateScore.CReview = ReviewInput;
UpdateScore.CFeedBackStatus = 1;
db.SaveChanges();
return(Json(UpdateScore));
}
public JsonResult getOrderTime()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var OrderIDs = db.TOrders.Select(n => n.COrderId).ToList();
foreach (var ID in OrderIDs)
{
var getOrderTime = db.TOrders.Where(n => n.COrderId == ID).Select(n => n.COrderDate).FirstOrDefault();
DateTime OrderTime = DateTime.ParseExact(getOrderTime, "yyyy/MM/dd HH:mm:ss", null);
var getPrepTime = db.TOrderDetails.Where(n => n.COrderId == ID).OrderByDescending(n => n.CProduct.CFinishedTime).Select(n => n.CProduct.CFinishedTime).FirstOrDefault().GetValueOrDefault();
var TransportTIme = db.TOrders.Where(n => n.COrderId == ID).Select(n => n.CTransportMinute).FirstOrDefault().GetValueOrDefault();
DateTime TimeOfArrival = OrderTime.AddMinutes((getPrepTime + TransportTIme));
if (DateTime.Now >= TimeOfArrival)
{
var StatusID = db.TOrders.FirstOrDefault(n => n.COrderId == ID);
if (StatusID.COrderStatusId == 1)
{
StatusID.COrderStatusId = 4;
db.SaveChanges();
}
}
}
return(Json(null));
}
public IActionResult ActionEdit(yuActivityViewModel p)
{
if (p != null)
{
if (p.img != null)
{
string pohotoname = Guid.NewGuid().ToString() + ".jpg";
using (var photo = new FileStream(iv_host.WebRootPath + @"\imgs\" + pohotoname, FileMode.Create))
{
p.img.CopyTo(photo);
}
p.CPicture = @"../imgs/" + pohotoname;
}
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
TActivity table = db.TActivities.FirstOrDefault(a => a.CActivityId == p.CActivityId);
if (table != null)
{
table.CActivityName = p.CActivityName;
table.CDescription = p.CDescription;
table.CLink = p.CLink;
table.CStatus = p.CStatus;
if (p.CPicture != null)
{
table.CPicture = p.CPicture;
}
db.SaveChanges();
}
}
return(RedirectToAction("ActivityList"));
}
public IActionResult Create(MemberManagementViewModel newMember)
{
string photoName = Guid.NewGuid().ToString() + ".jpg";
if (newMember.image != null)
{
using (var photo = new FileStream(iv_host.WebRootPath + @"\MemberPhoto\" + photoName, FileMode.Create))
{
newMember.image.CopyTo(photo);
}
}
newMember.CPicture = @"/MemberPhoto/" + photoName;
db.TMembers.Add(newMember.member);
db.SaveChanges();
return(RedirectToAction("List"));
}
//[HttpPost]
//public IActionResult List(string pkeyword ,string pkeyword2)
//{
// IEnumerable<TProduct> table = null;
// string a = pkeyword2;
// if (string.IsNullOrEmpty(pkeyword))
// {
// table = from p in (new 擺腹BuyFoodContext()).TProducts
// select p;
// }
// else
// {
// table = from p in (new 擺腹BuyFoodContext()).TProducts
// where((p.CProductName).ToLower()).Contains(pkeyword.ToLower())
// select p;
// }
// if(pkeyword2 != null)
// {
// table = from p in (new 擺腹BuyFoodContext()).TProducts
// where p.CCategoryId == int.Parse(pkeyword2)
// select p;
// }
// List<CProductViewModel> list = new List<CProductViewModel>();
// foreach (TProduct t in table)
// {
// list.Add(new CProductViewModel(t));
// }
// return View(list);
//}
#region 產品販售狀況
public JsonResult changeSaleonoff(int?PrId, int PrTimeId)
{
if (PrId != null)
{
TProduct l_p販售狀態 = db.TProducts.FirstOrDefault(n => n.CProductId == PrId);
if (PrTimeId == 1)
{
PrTimeId = 2;
l_p販售狀態.CIsOnSaleId = PrTimeId;
}
else if (PrTimeId == 2)
{
PrTimeId = 3;
l_p販售狀態.CIsOnSaleId = PrTimeId;
}
else
{
PrTimeId = 1;
l_p販售狀態.CIsOnSaleId = PrTimeId;
}
db.SaveChanges();
}
return(Json(PrTimeId));
}
public JsonResult saveProfile([FromBody] TMember member)
{
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
TMember data = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == member.CMemberId);
data.CName = member.CName;
dbcontext.SaveChanges();
return(Json(data));
}
public void do_all_review_0()
{
擺腹BuyFoodContext db = (new 擺腹BuyFoodContext());
var table = db.TChatRooms.Where(n => n.CReview == 0).Select(n => n).ToList();
foreach (var item in table)
{
item.CReview = 1;
db.SaveChanges();
}
}
public void ActionUpRank(int?id)
{
if (id != null)
{
TActivity table = db.TActivities.FirstOrDefault(n => n.CActivityId == id);
if (table != null)
{
if (table.CRank == 99)
{
var newnum = (from x in db.TActivities where x.CRank != 99 && x.CStatus != 0 select x).Count();
table.CRank = newnum + 1;
}
else
{
table.CRank = 99;
}
}
db.SaveChanges();
}
}
public void clearAllnewOrderMessage()
{
擺腹BuyFoodContext db = (new 擺腹BuyFoodContext());
var mesR = db.TMessageOrders.Select(n => n).OrderByDescending(n => n.CSaveTime).Take(20).ToList();
foreach (var n in mesR)
{
n.CIsRead = 1;
db.SaveChanges();
}
}
//public JsonResult addCombo(string id)
//{
// 擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
// var combos = dbcontext.TCombos.Where(n => n.CMemberId == int.Parse(id)).Count() +1;
// TCombo newCombo = new TCombo
// {
// CComboName = "套餐" + combos,
// CMemberId = int.Parse(id)
// };
// dbcontext.TCombos.Add(newCombo);
// dbcontext.SaveChanges();
// TCombo data = dbcontext.TCombos.Where(n => n.CMemberId == int.Parse(id)).OrderByDescending(n => n.CComboId).FirstOrDefault();
// return Json(data);
//}
public void deleteCombo(string id)
{
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
var comboDetails = dbcontext.TComboDetails.Where(n => n.CComboId == int.Parse(id));
dbcontext.TComboDetails.RemoveRange(comboDetails);
var combo = dbcontext.TCombos.FirstOrDefault(n => n.CComboId == int.Parse(id));
dbcontext.TCombos.Remove(combo);
dbcontext.SaveChanges();
}
public void ActionDeletealone(int?id)
{
if (id != null)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var table = db.TActivities.FirstOrDefault(n => n.CActivityId == id);
if (table != null)
{
db.Remove(table);
}
db.SaveChanges();
}
}
public void saveTheNewOrders(string userName, string OrderMessage)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
DateTime dn = DateTime.Now;
TMessageOrder messageOrder = new TMessageOrder
{
CMessageOrder = OrderMessage,
CUserName = userName,
CIsRead = 0,
CSaveTime = dn
};
db.Add(messageOrder);
db.SaveChanges();
}
public IActionResult ActivityCreat(yuActivityViewModel p)
{
string pohotoname = Guid.NewGuid().ToString() + ".jpg";
using (var photo = new FileStream(iv_host.WebRootPath + @"\imgs\" + pohotoname, FileMode.Create))
{
p.img.CopyTo(photo);
}
p.CPicture = @"../imgs/" + pohotoname;
p.CTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
db.TActivities.Add(p.Activity);
db.SaveChanges();
return(RedirectToAction("ActivityList"));
}
public string usecoupon()
{
Random r = new Random();
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var orders = db.TOrders.Select(n => new
{
n.COrderId,
sum = n.TOrderDetails.Sum(m => m.CPriceAtTheTime * m.CQuantity)
}).Where(n => n.sum > 400).ToList();
foreach (var order in orders)
{
var target = db.TOrders.First(n => n.COrderId == order.COrderId);
target.CCuponId = r.Next(1, 5);
}
db.SaveChanges();
return("done");
}
public string savePassword([FromBody] changePassword data)
{
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
TMember reviseTarget = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == int.Parse(data.memberID));
ShareFunction sf = new ShareFunction();
SHA1 sha1 = SHA1.Create();
string SHAoPassword = sf.GetHash(sha1, data.oPassword);
//string SHAoPassword = data.oPassword;
string SHAnPassword = sf.GetHash(sha1, data.nPassword);
if (SHAoPassword != reviseTarget.CPassword)
{
return("1");
}
reviseTarget.CPassword = SHAnPassword;
dbcontext.SaveChanges();
return("0");
}
public IActionResult memberConfirm()
{
string memberOpenID = HttpContext.Request.Query["ID"];
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
TMember openMember = (from n in db.TMembers
where n.CMemberId == int.Parse(memberOpenID)
select n).FirstOrDefault();
openMember.COpenMember = 1;
db.SaveChanges();
HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERNAME, openMember.CName);
HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERPHOTO, openMember.CPicture);
HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERID, openMember.CMemberId.ToString());
return(Redirect("~/HomePage/Home"));
}
public bool gotoblack(int?id)
{
TOrderDetail table = db.TOrderDetails.FirstOrDefault(n => n.COrderDetailId == id);
bool x = true;
if (table != null)
{
if (table.CFeedBackStatus == 1)
{
table.CFeedBackStatus = 0;
}
else
{
table.CFeedBackStatus = 1;
x = false;
}
}
db.SaveChanges();
return(x);
}
public IActionResult ActionUpDelete(int?id)
{
if (id != null)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
TActivity table = db.TActivities.FirstOrDefault(n => n.CActivityId == id);
if (table != null)
{
if (table.CStatus == 1)
{
table.CStatus = 0;
table.CRank = 99;
}
else
{
table.CStatus = 1;
}
}
db.SaveChanges();
}
return(RedirectToAction("ActivityList"));
}
public JsonResult UploadOneFile(IFormFile photo)
{
string memberID = HttpContext.Session.GetString(CDictionary.CURRENT_LOGINED_USERID);
if (!string.IsNullOrEmpty(memberID) && photo.Length > 0)
{
string photoName = Guid.NewGuid().ToString() + ".jpg";
string photoPath = iv_host.WebRootPath + @"\MemberPhoto\" + photoName;
using (
var addphoto = new FileStream(photoPath, FileMode.Create))
{
photo.CopyTo(addphoto);
}
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
TMember target = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == int.Parse(memberID));
target.CPicture = @"/MemberPhoto/" + photoName;
dbcontext.SaveChanges();
HttpContext.Session.SetString(CDictionary.CURRENT_LOGINED_USERPHOTO, target.CPicture);
return(Json(new { result = "1", msg = "上傳成功", src = target.CPicture }));
}
return(Json(new { result = "0", msg = "上傳失敗" }));
}
public void DetailBoardDelete([FromBody] List <yupushstrViewModel> Array)
{
if (Array != null)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
for (int i = 0; i < Array.Count; i++)
{
TOrderDetail table = db.TOrderDetails.FirstOrDefault(a => a.COrderDetailId.ToString() == Array[i].strmember);
if (table != null)
{
if (table.CFeedBackStatus == 1)
{
table.CFeedBackStatus = 0;
}
else
{
table.CFeedBackStatus = 1;
}
}
db.SaveChanges();
}
}
}
public void saveContext(string MemberName, string Content, string MessageTime, string foto, int userID, int difChatRoomID)
{
if (userID != 16 || difChatRoomID == 16)
{
return;
}
DateTime theSaveTime = DateTime.Now;
TChatRoom cr = new TChatRoom()
{
CContent = Content,
CMessageTime = MessageTime,
CSaveTime = theSaveTime,
CMemberId = userID,
CPhoto = foto,
CDifRoomId = difChatRoomID,
CReview = 1
};
db.TChatRooms.Add(cr);
db.SaveChanges();
}
public JsonResult forgetMemberCheck([FromBody] CForgetPasswordViewModel forgetPwdMember)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
var check信箱 = from n in db.TMembers
select n.CEmail;
if (check信箱.Any(n => n == forgetPwdMember.CEmail) == true)
{
TMember checkPhone = (from n in db.TMembers
where n.CEmail == forgetPwdMember.CEmail
select n).FirstOrDefault();
if (checkPhone.CPhone == forgetPwdMember.CPhone)
{
SHA1 sha1 = SHA1.Create();
string RandomPwd = shareFun.產生亂數(16);
string ReplacementPwd = shareFun.GetHash(sha1, RandomPwd);
checkPhone.CPassword = ReplacementPwd;
db.SaveChanges();
string val信件內容 = "您的密碼已被修改成 : " + RandomPwd + " , 請登入後自行修改密碼";
shareFun.sendGrid(checkPhone.CEmail, checkPhone.CName, "BuyFood帳號開通認證信", val信件內容);
return(Json("EditSuccess"));
}
else
{
return(Json("wrongPhone"));
}
}
else
{
return(Json("noEmail"));
}
}
public void ActionDelete([FromBody] List <yupushstrViewModel> Array)
{
if (Array != null)
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
for (int i = 0; i < Array.Count; i++)
{
TActivity table = db.TActivities.FirstOrDefault(a => a.CActivityId.ToString() == Array[i].strmember);
if (table != null)
{
if (table.CPicture != null)
{
FileInfo file = new FileInfo(table.CPicture);
if (file.Exists)
{
file.Delete();
}
}
db.Remove(table);
db.SaveChanges();
}
}
}
}
public void getMessage(string MemberName, string Content, string MessageTime, string foto, int userID)
{
if (userID == 16)
{
return;
}
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
DateTime theSaveTime = DateTime.Now;
TChatRoom cr = new TChatRoom()
{
CContent = Content,
CMessageTime = MessageTime,
CSaveTime = theSaveTime,
CMemberId = userID,
CPhoto = foto,
CDifRoomId = userID,
CReview = 0
};
db.TChatRooms.Add(cr);
db.SaveChanges();
}
public void saveDepositResult(ViewModelForOPay returnData)
{
DateTime now = DateTime.Now;
擺腹BuyFoodContext dbcontext = new 擺腹BuyFoodContext();
TMember changeTarget = dbcontext.TMembers.FirstOrDefault(n => n.CMemberId == int.Parse(returnData.StoreID));
if (returnData.RtnCode == 1)
{
TDeposit result = new TDeposit
{
CMemberId = int.Parse(returnData.StoreID),
CDepositTime = now,
CDepositAmount = returnData.TradeAmt,
CDepositRecordNo = returnData.MerchantTradeNo
};
dbcontext.TDeposits.Add(result);
changeTarget.CDeposit += returnData.TradeAmt;
int couponCategory = 0;
switch (returnData.TradeAmt)
{
case 1000:
couponCategory = 2;
break;
case 2000:
couponCategory = 4;
break;
case 5000:
couponCategory = 7;
break;
default:
break;
}
if (couponCategory != 0)
{
string dsCode = "";
while (dsCode == "")
{
bool check = false;
string newCode = (new ShareFunction()).產生亂數(6);
var data = dbcontext.TCupons;
foreach (var item in data)
{
if (item.CDiscountCode == newCode)
{
check = true;
break;
}
}
if (!check)
{
dsCode = newCode;
}
}
TCupon newCoupon = new TCupon
{
CCuponCategoryId = couponCategory,
CMenberId = int.Parse(returnData.StoreID),
CDiscountCode = dsCode,
CValidDate = now.AddDays(60),
CReceivedTime = now
};
dbcontext.TCupons.Add(newCoupon);
}
dbcontext.SaveChanges();
}
string EmailContent = returnData.RtnCode == 1 ?
$"已成功於{now.ToString("yyyy/MM/dd")}加值共{returnData.TradeAmt}擺腹幣" :
$"加值失敗，請重新加值並確認付款內容。";
(new ShareFunction()).sendGrid(changeTarget.CEmail, changeTarget.CName, "通知-加值結果", EmailContent);
}
public JsonResult newOrder()
{
擺腹BuyFoodContext db = new 擺腹BuyFoodContext();
int[] memberBox = new int[]
{
11, 17, 21, 30, 31
};
string[] addressBox = new string[]
{
"106台北市大安區復興南路一段303號9樓",
"106台北市大安區信義路三段147巷11弄1號1樓",
"106台北市大安區瑞安街31巷1號",
"106台北市大安區通安街115號",
"106台北市大安區新生南路二段50號",
"105台北市松山區敦化北路199號",
"106台北市大安區忠孝東路四段77巷28號",
"104台北市中山區市民大道三段143號",
"106台北市大安區安和路二段92號B1F",
"106台北市大安區復興南路二段102號",
"106台北市大安區仁愛路三段26-5號",
"106台北市大安區建國南路二段231號",
"106台北市大安區通安街115號",
"106台北市大安區新生南路二段50號",
"105台北市松山區敦化北路199號",
"110台北市信義區信義路五段1號",
"106台北市大安區光復南路180巷11號",
};
string[] dateBox = new string[]
{
"2021/01/01 10:10:10",
"2021/02/01 10:10:10",
"2021/03/01 10:10:10",
"2021/04/01 10:10:10",
"2020/01/01 10:10:10",
"2020/02/01 10:10:10",
"2020/03/01 10:10:10",
"2020/04/01 10:10:10",
"2020/05/01 10:10:10",
"2020/06/01 10:10:10",
"2020/07/01 10:10:10",
"2020/08/01 10:10:10",
"2020/09/01 10:10:10",
"2020/10/01 10:10:10",
"2020/11/01 10:10:10",
"2020/12/01 10:10:10",
};
Random random = new Random();
var productBox = db.TProducts.ToList();
for (int i = 0; i < 2000; i++)
{
TOrder order = new TOrder()
{
CMemberId = memberBox[random.Next(0, 3)],
COrderStatusId = 2,
CCuponId = 1,
CArrivedAddress = addressBox[random.Next(0, 8)],
CPayTypeId = 1,
COrderDate = dateBox[random.Next(0, dateBox.Count())],
CTransportMinute = random.Next(5, 30)
};
db.TOrders.Add(order);
db.SaveChanges();
var orderdetailCount = random.Next(1, 6);
for (int p = 0; p < orderdetailCount; p++)
{
var productID = productBox[random.Next(0, productBox.Count())].CProductId;
TOrderDetail od = new TOrderDetail()
{
CProductId = productID,
COrderId = order.COrderId,
CQuantity = random.Next(1, 4),
CPriceAtTheTime = productBox.First(n => n.CProductId == productID).CPrice,
};
db.TOrderDetails.Add(od);
}
}
db.SaveChanges();
return(Json("done"));
}
