public ActionResult Register(Register model)
{
try
{
if (model.member.Password != model.rePassword)
{
throw new Exception("Şifre ile Şifre Tekrar Uyuşmuyor");
}
if (db.Members.Any(x => x.Email == model.member.Email))
{
throw new Exception("Email Adresi Kayıtlı");
}
model.member.IsAdmin = false;
model.member.IsEditor = false;
model.member.AddedDate = DateTime.Now;
db.Members.Add(model.member);
db.SaveChanges();
return(RedirectToAction("Login", "Account"));
}
catch (Exception ex)
{
ViewBag.ReError = ex.Message;
return(View());
}
}
public ActionResult AddMembership(string email, string password, string firstName, string lastName, string address, string city, string postalCode, string country, string phone)
{
try
{
ECommerceEntities entities = new ECommerceEntities();
Customer customer = new Customer();
ShoppingCart cart = new ShoppingCart();
entities.ShoppingCart.Add(cart);
entities.SaveChanges();
customer.Email = email;
customer.Password = password;
customer.LastName = lastName;
customer.FirstName = firstName;
customer.Address = address;
customer.City = int.Parse(city);
customer.PostalCode = postalCode;
customer.Country = int.Parse(country);
customer.Phone = phone;
customer.DateEntered = DateTime.Now;
customer.ShoppingCartID = cart.ShoppingCartID;
entities.Customer.Add(customer);
entities.SaveChanges();
ViewBag.Result = "Başarılı";
}
catch (Exception)
{
ViewBag.Result = "Olmadı";
}
return(View());
}
//[ActionName("byid")]
//[ResponseType(typeof(CustmerViewModel))]
//public IHttpActionResult GetCustomer(int id)
//{
// var model = GetCustomerModel(id);
// if (model == null)
// return NotFound();
// return Ok(model);
// //return Ok(model);
//}
// PUT api/Customer/5
public IHttpActionResult PutCustomer(int id, Customer customer)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != customer.ID)
{
return(BadRequest());
}
db.Entry(customer).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "ProductID,ProductName,ProductType,Description,Stock,Price,Discount")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Create([Bind(Include = "MemberID,UserName,Password,Email,FirstName,LastName,Phone,Gender,BirthDate")] Member member)
{
if (ModelState.IsValid)
{
db.Members.Add(member);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(member));
}
public ActionResult Create([Bind(Include = "Id,Name,Stock,Price")] Product product)
{
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult Create([Bind(Include = "Id,Name,Birthdate,City,PostalCode")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "ImageID,ProductID,ImageURL")] ProductImage productImage)
{
if (ModelState.IsValid)
{
db.ProductImages.Add(productImage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ProductID = new SelectList(db.Products, "ProductID", "ProductName", productImage.ProductID);
return(View(productImage));
}
public ActionResult Create([Bind(Include = "AddressID,MemberID,Address1,ZipCode,City,State,Country")] Address address)
{
if (ModelState.IsValid)
{
db.Addresses.Add(address);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MemberID = new SelectList(db.Members, "MemberID", "UserName", address.MemberID);
return(View(address));
}
public ActionResult Create([Bind(Include = "OrderID,MemberID,Status,OrderDate,FulfillmentDate,AddressID")] Order order)
{
if (ModelState.IsValid)
{
db.Orders.Add(order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MemberID = new SelectList(db.Members, "MemberID", "UserName", order.MemberID);
ViewBag.AddressID = new SelectList(db.Addresses, "AddressID", "Address1", order.AddressID);
return(View(order));
}
public ActionResult Create([Bind(Include = "OrderItemID,OrderID,ProductID,Quantity")] OrderItem orderItem)
{
if (ModelState.IsValid)
{
db.OrderItems.Add(orderItem);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.OrderID = new SelectList(db.Orders, "OrderID", "OrderID", orderItem.OrderID);
ViewBag.ProductID = new SelectList(db.Products, "ProductID", "ProductName", orderItem.ProductID);
return View(orderItem);
}
public ActionResult Create([Bind(Include = "Id,CustomerId,OrderDate,Status")] Order order)
{
if (ModelState.IsValid)
{
db.Orders.Add(order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", order.CustomerId);
ViewBag.CustomerId = new SelectList(db.Customers, "Id", "Name", order.CustomerId);
return(View(order));
}
private void FormAdminWindow_Load(object sender, EventArgs e)
{
//set debug after window is loaded
context.Database.Log = (s => Debug.Write(s));
context.SaveChanges();
//Display all the items on their gridviews and set the view to fill the space
ShowPostingItems();
dataGridViewProductsForSale.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
ShowOrderedItems();
dataGridViewProductsSold.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
context.SaveChanges();
}
public ActionResult Edit(Product model)
{
var user = (Member)Session["LogonUser"];
model.AddeDate = DateTime.Now;
model.OwnerUserId = user.ID;
if (model.UnitsInStock > 0)
{
model.IsContinued = true;
}
model.ImageName = db.Products.Where(x => x.ID == model.ID).Select(x => x.ImageName).FirstOrDefault();
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Product"));
}
public void RemoveFromCart(IProduct product)
{
if (!SessionUser.UserLoggedIn())
{
SessionUser.Current.CartItems.Remove(
SessionUser.Current.CartItems.Where(x => x.Product.ProductID == product.ProductID).FirstOrDefault()
);
}
else
{
//Items.Remove(SessionUser.Current.CartItems.Where(x => x.Product.ProductID == product.ProductID).FirstOrDefault());
ECommerceEntities entities = new ECommerceEntities();
Customer customer = entities.Customer.Where(x => x.CustomerID == SessionUser.Current.CustomerID).FirstOrDefault();
if (customer != null)
{
ShoppingCart cart = entities.ShoppingCart.Where(x => x.ShoppingCartID == customer.ShoppingCartID).FirstOrDefault();
if (cart != null)
{
ShoppingCartDetail detail = entities.ShoppingCartDetail.Where(x => x.ShoppingCart.ShoppingCartID == cart.ShoppingCartID && x.ProductId == product.ProductID).FirstOrDefault();
if (detail != null)
{
entities.ShoppingCartDetail.Remove(detail);
}
}
}
entities.SaveChanges();
}
}
//exception log
//orders
public Customer CreateCustomer()
{
ECommerceEntities et = new ECommerceEntities();
Customer CustomerToCreate = new Customer()
{
CustomerID = this.CustomerID,
FirstName = this.FirstName,
LastName = this.LastName,
Address = this.Address,
City = this.City,
PostalCode = this.PostalCode,
Country = this.Country,
Phone = this.Phone,
Email = this.Email,
Password = this.Password,
ShoppingCartID = this.ShoppingCart.ShoppingCartId,
IsAcountSuspended = this.IsAccountSuspended,
DateEntered = DateTime.Now
//shoppingcart
//exceptionlog
//orders
};
et.Customer.Add(CustomerToCreate);
et.SaveChanges();
return(null);
}
public ActionResult BuyItems()
{
ShoppingCartX cart = new ShoppingCartX();
List <ICartItem> myList = cart.GetItems();
if (SessionUser.UserLoggedIn())
{
foreach (var item in myList)
{
ECommerceEntities entities = new ECommerceEntities();
Product product = entities.Product.Where(x => x.ProductID == item.Product.ProductID).FirstOrDefault();
product.StockCount -= item.ItemCount;
Orders order = new Orders();
order.CustomerID = SessionUser.Current.CustomerID;
order.DateOrdered = DateTime.Now;
order.PaymentAmount = cart.TotalAmount;
order.PaymentDate = DateTime.Now;
//entities.SaveChanges();
OrderDetail detail = new OrderDetail();
//OrderDetail detail = entities.OrderDetail.Where(x => x.OrderID == order.OrderID).FirstOrDefault();
detail.OrderID = order.OrderID;
detail.OrderTime = DateTime.Now;
detail.ProductID = item.Product.ProductID;
detail.ProductPrice = item.Product.Price;
entities.SaveChanges();
}
}
return(View(myList));
}
public void AddToStock(int itemCount)
{
ECommerceEntities entities = new ECommerceEntities();
Product product = entities.Product.Where(x => x.ProductID == this.ProductID).FirstOrDefault();
product.StockCount += itemCount;
entities.SaveChanges();
}
//método para remover o cliente
public static void RemoverCliente(Cliente cliente)
{
using (var ctx = new ECommerceEntities())
{
ctx.Entry <Cliente>(cliente).State = EntityState.Deleted;
ctx.SaveChanges();
}
}
//método para alterar o cliente
public static void AlterarCliente(Cliente cliente)
{
using (var ctx = new ECommerceEntities())
{
ctx.Entry <Cliente>(cliente).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void DeleteCategory()
{
ECommerceEntities et = new ECommerceEntities();
Category category = et.Category.Where(x => x.CategoryID == this.CategoryID).FirstOrDefault();
et.Category.Remove(category);
et.SaveChanges();
}
public static void IncluirPedido(Pedido pedido)
{
using (var ctx = new ECommerceEntities())
{
ctx.Pedidos.Add(pedido);
ctx.SaveChanges();
}
}
public static void IncluirItem(Item item)
{
using (var ctx = new ECommerceEntities())
{
ctx.Itens.Add(item);
ctx.SaveChanges();
}
}
//método para alterar um produto
public static void AlterarProduto(Produto produto)
{
using (var ctx = new ECommerceEntities())
{
ctx.Entry <Produto>(produto).State = EntityState.Modified;
ctx.SaveChanges();
}
}
//método para incluir um novo cliente
public static void IncluirCliente(Cliente cliente)
{
using (var ctx = new ECommerceEntities())
{
ctx.Clientes.Add(cliente);
ctx.SaveChanges();
}
}
//método para incluir um novo produto
public static void IncluirProduto(Produto produto)
{
using (var ctx = new ECommerceEntities())
{
ctx.Produtos.Add(produto);
ctx.SaveChanges();
}
}
public void SuspendMembership(bool status)
{
ECommerceEntities entities = new ECommerceEntities();
Customer customer = entities.Customer.Where(x => x.CustomerID == this.CustomerID).FirstOrDefault();
customer.IsAcountSuspended = status;
entities.SaveChanges();
}
public ActionResult Product(Comment comment)
{
try
{
Member user = (Member)Session["LogonUser"];
comment.MemberId = user.ID;
comment.AddedDate = DateTime.Now;
db.Comments.Add(comment);
db.SaveChanges();
}
catch (Exception ex)
{
ViewBag.MyError = ex.Message;
}
return(RedirectToAction("Product", "Home"));
}
//METODO PARA INCLUIR UM NOVO CLIENTE
public static void IncluirCliente(Cliente cliente)
{
//ctx É A ABREVIAÇÃO PARA CONTEXT E O ECommerceEntities É O CONTEXTO QUE POSSUI AS TABELAS
//ABRIRÁ E FECHARÁ O BANCO
using (var ctx = new ECommerceEntities())
{
ctx.Clientes.Add(cliente);
ctx.SaveChanges();
}
}
public ActionResult SendMessage(SendMessages message)
{
var user = (Member)Session["LogonUser"];
if (Session["LogonUser"] == null)
{
return(RedirectToAction("Login", "Account"));
}
Message mesaj = new Message()
{
AddedDate = DateTime.Now,
IsRead = false,
Subject = message.Subject,
MemberFromId = user.ID,
MemberToId = message.ToUserId
};
db.Messages.Add(mesaj);
int messageId = db.MessageReplies.OrderByDescending(x => x.AddedDate).Select(x => x.MessageId).Take(1).SingleOrDefault();
MessageReply mr = new MessageReply()
{
AddedDate = DateTime.Now,
MemberFromId = user.ID,
Text = message.MessageBody,
MemberToId = message.ToUserId,
};
if (mr.MessageId == 0)
{
mr.MessageId = messageId + 1;
}
else
{
mr.MessageId = 1;
}
db.MessageReplies.Add(mr);
db.SaveChanges();
return(RedirectToAction("Index", "Messages"));
}
