public ActionResult Registeration(tCustomer p)
{
try
{
if (p != null)
{
dbMSIT126TeamEntities db = new dbMSIT126TeamEntities();
p.fUserName = Session[CDictionary.SK_Logon_UserName].ToString();
db.tCustomers.Add(p);
db.SaveChanges();
var q = (from c in db.tCustomers
where c.fUserName == p.fUserName
select c.fCustomerID).FirstOrDefault();
Session[CDictionary.SK_Logon_ID] = q.ToString();
return(RedirectToAction("Index", "Home"));
}
return(View());
}
catch
{
p.fUserName = User.Identity.Name;
db.tCustomers.Add(p);
db.SaveChanges();
var q = (from c in db.tCustomers
where c.fUserName == p.fUserName
select c.fCustomerID).FirstOrDefault();
Session[CDictionary.SK_Logon_ID] = q.ToString();
return(RedirectToAction("Index", "Manage"));
}
}
public ActionResult EditCompany(tCustomer p)
{
tCustomer c = db.tCustomers.FirstOrDefault(u => u.fCustomerID == p.fCustomerID);
if (c == null)
{
return(RedirectToAction("EditCompany"));
}
else
{
c.fContactName = p.fContactName;
c.fCompanyName = p.fCompanyName;
c.fCity = p.fCity;
c.fAddress = p.fAddress;
c.fFox = p.fFox;
c.fPhone = p.fPhone;
c.fTaxID = p.fTaxID;
c.fTelephone = p.fTelephone;
db.SaveChanges();
return(RedirectToAction("Index", new { Message = ManageMessageId.ChangeCompanyInfoSuccess }));
}
//string username = Session[CDictionary.SK_Logon_UserName].ToString();
//var q = (from p in db.tCustomers
// where p.fUserName == username
// select p).FirstOrDefault();
}
public string SendMailToSales(string heading, string content)
{
string h = heading;
string c = content;
var customer = GetUserName();
if (h != null && c != null)
{
tCase a = new tCase();
a.fheading = h;
a.fcontent = c;
a.fCustomerID = customer.fCustomerID;
db.tCases.Add(a);
db.SaveChanges();
return "<span style=\"font-weight: bold\">--------訊息已發送成功，請耐心等待業務員的回覆，謝謝!!-------- </span>";
}
else
{
return "<span style=\"font-weight: bold\">--------請檢查輸入是否正確，謝謝!!-------- </span>";
}
}
// GET: del
public void del()
{
dbMSIT126TeamEntities db = new dbMSIT126TeamEntities();
var x = db.tCustomers.Where(p => p.fUserName == "*****@*****.**").FirstOrDefault();
var y = db.AspNetUsers.Where(p => p.UserName == "*****@*****.**").FirstOrDefault();
if (x != null)
{
db.tCustomers.Remove(x);
db.SaveChanges();
}
if (y != null)
{
db.AspNetUsers.Remove(y);
db.SaveChanges();
}
}
public ActionResult Create(tEmployee e) //建立員工帳號
{
e.fJobTitleID = 0;
e.fDepartmentID = 0;
e.fUpdateDate = DateTime.Now.ToLocalTime();
db.tEmployees.Add(e);
db.SaveChanges();
return(RedirectToAction("thanks"));
}
public ActionResult addCheck(tCheck tC, bool fPayByCash)
{
dbChecks.tChecks.Add(tC);
dbChecks.SaveChanges();
return(RedirectToAction("allCheckBook"));
}
public ActionResult Index(tOrder theOrder)
{
//取得購物車
var currentCart = operation.GetCurrentCart();
using (dbMSIT126TeamEntities db = new dbMSIT126TeamEntities())
{
//建立 tOrder 物件
var order = new tOrder()
{
fCustomerID = theOrder.fCustomerID,
fDeliverDate1 = theOrder.fDeliverDate1,
fDeliverDate2 = theOrder.fDeliverDate1.AddDays(30),
fDeliverDate3 = theOrder.fDeliverDate1.AddDays(60),
fDeliverDate4 = theOrder.fDeliverDate1.AddDays(180),
fOrderDate = theOrder.fOrderDate,
fEmployeeID = 18, //預設18號
fMaterialPrice = 140, //鋁料價格寫死 140
fDoorFee = 1.3, //預設 1.3
fScreenFee = 1.3, //預設 1.3
fInstallationFee = 1.3, //預設 1.3
fGlassFee = 1, //預設 1
fWaterwayFee = 1, //預設 1
fCrackFee = 1, //預設 1
fOrderConfirm = "0" //預設 0 (未確認)
};
//儲存面更
db.tOrders.Add(order);
db.SaveChanges();
//取得購物車裡面的 order detail
var orderDetail = currentCart.TOrderDetailList
(
order.fOrderID,
(decimal)order.fMaterialPrice,
(double)order.fDoorFee,
(double)order.fScreenFee,
(double)order.fInstallationFee,
(double)order.fGlassFee,
(double)order.fWaterwayFee,
(double)order.fCrackFee
);
//加入 order detail 資料後儲存
db.tOrderDetails.AddRange(orderDetail);
db.SaveChanges();
//把訂單總額寫進 tOrder
decimal OrderTotal = (decimal)db.tOrderDetails.Where(p => p.fOrderID == order.fOrderID).Select(p => p.fQuantity * p.fSubTotal).Sum(p => p) * 1.05m; //含稅5%
order.fGetMoneyBack1 = OrderTotal * 0.4m;
order.fGetMoneyBack2 = OrderTotal * 0.4m;
order.fGetMoneyBack3 = OrderTotal * 0.1m;
order.fGetMoneyBack4 = OrderTotal * 0.1m;
db.SaveChanges();
}
//return Content("訂購成功");
return(RedirectToAction("Index", "Home"));
}
public ActionResult New(tOrder p)
{
db.tOrders.Add(p);
db.SaveChanges();
return(RedirectToAction("sales"));
}
