public LookupCategoriesController()
{
if (AdminOperation == null)
{
AdminOperation = new AdminOperation();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//顾客购买统计
var _db = new WingtipToys.Models.ProductContext();
List <OrderDetail> orderList = _db.OrderDetails.ToList();
PurchaseList.DataSource = orderList;
PurchaseList.DataBind();
//销售统计
AdminOperation admin = new AdminOperation();
List <Product> list = admin.GetAllProduct();
ProductsList.DataSource = list;
ProductsList.DataBind();
int sumNum = 0;
double sumMoeny = 0;
foreach (Product p in list)
{
sumNum += p.Sold;
sumMoeny += (double)p.Sold * (double)p.UnitPrice;
}
SumNumber.Text = "书籍销售总数：" + sumNum.ToString();
SumMoney.Text = "书籍销售总金额：" + sumMoeny.ToString();
}
public JsonResult LoginIn(string user, string pwd, string yzm)
{
long id = 0;
JsonStatus js = new AdminOperation().Login(user, pwd, yzm, (string)Session["ver"], out id);
if (js.status == "1")
{
sc.SetUserSession(id);
}
return(Json(js));
}
protected void btnAddRoom_Click(object sender, EventArgs e)
{
AdminOperation _addRoomObj = new AdminOperation();
EntityLayers.Room _entityRoomObj = new EntityLayers.Room()
{
_roomDesc = txtRoomDesc.Text,
_roomTypeID = int.Parse(ddlRoomType.SelectedValue),
_roomCharges = decimal.Parse(txtRoomCharges.Text),
_roomServices = txtRoomService.Text
};
_addRoomObj.AddRoomLinqToSql(_entityRoomObj);
Response.Write("<script>alert(' Successfully Added Room') </script> ");
Response.Redirect("AdminHome.aspx");
}
private void SetUserAdminOperation(ref UserAuthenticated userAuth, int empID)
{
DateTime today = DateTime.UtcNow.ToUtcID();
IRepository <AdminOperation> repo = _unitOfWork.GetRepository <AdminOperation>();
repo.Condition = PredicateBuilder.True <AdminOperation>().And(x => x.NIK == empID && x.ValidTo >= today);
AdminOperation adm = repo.Find().FirstOrDefault();
if (adm == null)
{
return;
}
userAuth.IsRoleValid = true;
userAuth.NIK = adm.NIK;
userAuth.Fullname = adm.FullName;
}
protected void gvAprovReq_RowCommand(object sender, GridViewCommandEventArgs e)
{
AdminOperation _aObj = new AdminOperation();
if (e.CommandName == "APPROVE")
{
SqlCommand _cmd = new SqlCommand("update Orders set OrderStatus = 'ACCEPTED' where OrderID = " + ddlOrderID.SelectedValue + " ", _conObj);
_conObj.Open();
SqlDataReader dr = _cmd.ExecuteReader();
gvAprovReq.DataSource = dr;
gvAprovReq.DataBind();
Response.Write("<script>alert('Order ID successfully APPROVED')</script>");
}
else if (e.CommandName == "REJECT")
{
SqlCommand _cmd = new SqlCommand("update Orders set OrderStatus = 'REJECTED' where OrderID = " + ddlOrderID.SelectedValue + " ", _conObj);
_conObj.Open();
SqlDataReader dr = _cmd.ExecuteReader();
gvAprovReq.DataSource = dr;
gvAprovReq.DataBind();
Response.Write("<script>alert('Order ID successfully REJECTED')</script>");
}
}
protected void btnModify_Click(object sender, EventArgs e)
{
try
{
AdminOperation _addMenuObj = new AdminOperation();
EntityLayers.Menu _entityMenuObj = new EntityLayers.Menu()
{
_menuDescription = txtMenuDescription.Text,
_menuID = int.Parse(ddlMenuID.SelectedValue),
_menuPrice = decimal.Parse(txtMenuPrice.Text),
_menuItem = txtMenuItem.Text
};
_addMenuObj.ModifyRoomLinqToSql(_entityMenuObj);
Response.Write("<script>alert(' Successfully Modified Menu') </script> ");
Response.Redirect("AdminHome.aspx");
}
catch (Exception)
{
throw;
}
}
public AdminManager()
{
_adminOperation = new AdminOperation();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
NVPAPICaller payPalCaller = new NVPAPICaller();
string retMsg = "";
string token = "";
string PayerID = "";
NVPCodec decoder = new NVPCodec();
token = Session["token"].ToString();
bool ret = payPalCaller.GetCheckoutDetails(token, ref PayerID, ref decoder, ref retMsg);
if (ret)
{
Session["payerId"] = PayerID;
var myOrder = new Order();
myOrder.OrderDate = Convert.ToDateTime(decoder["TIMESTAMP"].ToString());
myOrder.Username = User.Identity.Name;
myOrder.FirstName = decoder["FIRSTNAME"].ToString();
myOrder.LastName = decoder["LASTNAME"].ToString();
myOrder.Address = decoder["SHIPTOSTREET"].ToString();
myOrder.City = decoder["SHIPTOCITY"].ToString();
myOrder.State = decoder["SHIPTOSTATE"].ToString();
myOrder.PostalCode = decoder["SHIPTOZIP"].ToString();
myOrder.Country = decoder["SHIPTOCOUNTRYCODE"].ToString();
myOrder.Email = decoder["EMAIL"].ToString();
myOrder.Total = Convert.ToDecimal(decoder["AMT"].ToString());
// Verify total payment amount as set on CheckoutStart.aspx.
try
{
decimal paymentAmountOnCheckout = Convert.ToDecimal(Session["payment_amt"].ToString());
decimal paymentAmoutFromPayPal = Convert.ToDecimal(decoder["AMT"].ToString());
if (paymentAmountOnCheckout != paymentAmoutFromPayPal)
{
Response.Redirect("CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch.");
}
}
catch (Exception)
{
Response.Redirect("CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch.");
}
ProductContext _db = new ProductContext();
// 写入数据库
_db.Orders.Add(myOrder);
_db.SaveChanges();
// Get the shopping cart items and process them.
using (WingtipToys.Logic.ShoppingCartActions usersShoppingCart = new WingtipToys.Logic.ShoppingCartActions())
{
List <CartItem> myOrderList = usersShoppingCart.GetCartItems();
// Add OrderDetail information to the DB for each product purchased.
for (int i = 0; i < myOrderList.Count; i++)
{
// Create a new OrderDetail object.
var myOrderDetail = new OrderDetail();
myOrderDetail.OrderId = myOrder.OrderId;
myOrderDetail.Username = User.Identity.Name;
myOrderDetail.ProductId = myOrderList[i].ProductId;
myOrderDetail.Quantity = myOrderList[i].Quantity;
myOrderDetail.UnitPrice = myOrderList[i].Product.UnitPrice;
//更新已售数量
AdminOperation change = new AdminOperation();
change.ChangeSoldNumber(myOrderDetail.ProductId, myOrderDetail.Quantity);
// Add OrderDetail to DB.
_db.OrderDetails.Add(myOrderDetail);
_db.SaveChanges();
}
// Set OrderId.
Session["currentOrderId"] = myOrder.OrderId;
// 展示订单信息
List <Order> orderList = new List <Order>();
orderList.Add(myOrder);
ShipInfo.DataSource = orderList;
ShipInfo.DataBind();
// 展示订单详情
OrderItemList.DataSource = myOrderList;
OrderItemList.DataBind();
}
}
else
{
Response.Redirect("CheckoutError.aspx?" + retMsg);
}
}
}
