protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RouteConfig.RegisterRoutes(RouteTable.Routes);
// Rol tanımlama adımları
ProductEntities db = new ProductEntities();
RoleStore <ApplicationRole> roleStore = new RoleStore <ApplicationRole>(db);
RoleManager <ApplicationRole> roleManager = new RoleManager <ApplicationRole>(roleStore);
if (!roleManager.RoleExists("Admin"))
{
ApplicationRole adminRole = new ApplicationRole("Admin", "Sistem yöneticisi");
roleManager.Create(adminRole);
}
if (!roleManager.RoleExists("User"))
{
ApplicationRole userRole = new ApplicationRole("User", "Sistem kullanıcısı, yorum eklemek için gereklidir");
roleManager.Create(userRole);
}
// Rol tanımlama adımları
}
//
// GET: /Product/
public ActionResult Index(string name)
{
using (var db = new ProductEntities())
{
var query = from productRec in db.Products
join categoryRec in db.Categories
on productRec.CategoryId
equals categoryRec.CategoryId
where categoryRec.Name == name
select new
{
Name = productRec.Name
,
CategoryName = categoryRec.Name
};
List <ProductVM> lstProduct = new List <ProductVM>();
foreach (var record in query)
{
ProductVM productValue = new ProductVM();
productValue.Name = record.Name;
productValue.CategoryName = record.CategoryName;
lstProduct.Add(productValue);
}
return(View(lstProduct));
}
}
public ProductResponse Delete(ProductRequest request)
{
ProductItem item = request.Product;
var response = new ProductResponse();
using (var db = new ProductEntities())
{
var model = new PRODUCT
{
ID = (int)item.Id
};
var entry = db.Entry(model);
if (entry.State == System.Data.Entity.EntityState.Detached)
{
db.PRODUCTS.Attach(model);
}
db.PRODUCTS.Remove(model);
db.SaveChanges();
}
return(response);
}
public IHttpActionResult GetAllProducts()
{
using (var ctx = new ProductEntities())
{
return(Ok(ctx.Products.Include("Category").ToList()));
}
}
public Products Get(int id)
{
using (ProductEntities entities = new ProductEntities())
{
return(entities.Products.FirstOrDefault(p => p.ID == id));
}
}
private ProductEntities CreateDbContext()
{
var db = new ProductEntities();
db.Database.Log = Log;
return(db);
}
private ProductEntities CreateDbContext()
{
var db = new ProductEntities(NameOrConnectionString);
db.Database.Log = Log;
return(db);
}
private async void postView_OnLoadCompleted(object sender, NavigationEventArgs e)
{
if (e.Uri.ToString().Contains("sharer"))
{
var wv = sender as WebView;
var id = currentGroupItem.GroupId;
string script = "try{ document.getElementsByName('group_target')[0].setAttribute('value','" + id + "');}catch(err){}";
await wv.InvokeScriptAsync("eval", new string[] { script });
await Task.Delay(200);
script = "try{ document.getElementById('u_0_6').setAttribute('value','C'); }catch(err){}";
await wv.InvokeScriptAsync("eval", new string[] { script });
await Task.Delay(200);
script = "try{ document.getElementsByName('privacyx')[0].setAttribute('value','291667064279714'); }catch(err){}";
await wv.InvokeScriptAsync("eval", new string[] { script });
await Task.Delay(500);
script = @"function run(){ try{ document.getElementById('share_submit').click(); }catch(err){} setTimeout(run,500);} run();";
await wv.InvokeScriptAsync("eval", new string[] { script });
ProductEntities.Where(c => c.Id == currentPid).First().ProValue = 70;
}
}
public int DA_ValidateProduct(ProductEntities objProductDetails)
{
int val = 0;
DataTable dt = new DataTable();
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(objQuery.ValidateProduct, con);
cmd.Parameters.AddWithValue("@Product", objProductDetails.Product);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
val = 1;
}
else
{
val = 0;
}
}
catch (Exception ex)
{
ex.ToString();
//throw;
}
finally
{
con.Close();
}
return(val);
}
public ActionResult AddToCart(int ID)
{
ProductEntities db = new ProductEntities();
List <Product> cart;
//check if the Cart object already exists
if (Session["Cart"] == null)
{
//if it doesn't, make a new list of books
cart = new List <Product>();
//add this item to it
cart.Add((from b in db.Products
where b.ID == ID
select b).Single());
//add the list to the session
Session.Add("Cart", cart);
}
else
{
//if it does exist, get the list
cart = (List <Product>)(Session["Cart"]);
//add this item to it
cart.Add((from b in db.Products
where b.ID == ID
select b).Single());
}
return(View("Cart"));
}
public JsonResult GetProducts()
{
ProductEntities p = new ProductEntities();
var result = p.Products.ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public int BAaddProductDetails(ProductEntities objProductDetails)
{
DAProduct objProductDA = new DAProduct();
int returnValue = objProductDA.DAaddProductDetails(objProductDetails);
return(returnValue);
}
private async void postView_OnNavigationStarting(WebView sender, WebViewNavigationStartingEventArgs args)
{
var url = args.Uri.ToString();
if (url.Contains("story"))
{
ProductEntities.Where(c => c.Id == currentPid).First().ProValue = 100;
if (_productList.Count > 0)
{
args.Cancel = true;
var itemd = _productList.Dequeue();
var firstpro = itemd.ProductUrl;
var urls = firstpro.TrimEnd('/').Split('/');
var rid = urls[urls.Length - 1];
currentPid = itemd.Id;
await Task.Delay(1000);
var postView = WebEnginner.CreateInstance("postReq");
postView.NavigationStarting -= postView_OnNavigationStarting;
postView.LoadCompleted -= postView_OnLoadCompleted;
postView.NavigationStarting += postView_OnNavigationStarting;
postView.LoadCompleted += postView_OnLoadCompleted;
postView.Navigate(new Uri(string.Format("https://m.facebook.com/sharer.php?fs=0&sid={0}&pid={1}", rid, currentPid)));
}
}
}
public HttpResponseMessage Put([FromBody] int id, [FromUri] Product newProduct)
{
try
{
using (ProductEntities entity = new ProductEntities())
{
Product existingProduct = entity.Products.FirstOrDefault(x => x.ProductId == id);
if (existingProduct == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with Given Id does not exist!"));
}
existingProduct.Name = newProduct.Name;
existingProduct.Price = newProduct.Price;
existingProduct.Quantity = newProduct.Quantity;
existingProduct.BoxSize = newProduct.BoxSize;
entity.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, existingProduct));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public int BADeleteProduct(ProductEntities objProductdetails)
{
DAProduct objProductDA = new DAProduct();
int returnValue = objProductDA.DADeleteProduct(objProductdetails);
return(returnValue);
}
public IEnumerable <Product> LoadAllProducts()
{
using (ProductEntities entity = new ProductEntities())
{
return(entity.Products.ToList());
}
}
public IEnumerable <Products> Get()
{
using (ProductEntities entities = new ProductEntities())
{
return(entities.Products.ToList());
}
}
public ProductResponse SaveProduct(ProductRequest request)
{
ProductItem item = request.Product;
var response = new ProductResponse();
using (var db = new ProductEntities())
{
var model = new PRODUCT
{
NAME = item.Name,
QUANTITY = item.Quantity,
SALE_AMOUNT = item.SaleAmount
};
if (item.Id == null)
{
db.PRODUCTS.Add(model);
}
else
{
model.ID = (int)item.Id;
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
return(response);
}
public IHttpActionResult GetAllCategorys()
{
using (var ctx = new ProductEntities())
{
var result = ctx.Categorys.ToList();
return(Ok(result));
}
}
public List <Product> ListProducts()
{
ViewBag.Message = "List of Products";
ProductEntities db = new ProductEntities();
List <Product> products = db.Products.ToList();
return(products);
}
public async Task <bool> Update(ProductEntities product)
{
var updateResult = await _catlogContext
.Products
.ReplaceOneAsync(filter : g => g.Id == product.Id, replacement : product);
return(updateResult.IsAcknowledged &&
updateResult.ModifiedCount > 0);
}
private async void postView_OnLoadCompleted(object sender, NavigationEventArgs e)
{
if (e.Uri.ToString().Contains("sharer"))
{
string script = @"function run(){document.getElementById('share_submit').click(); setTimeout(run,500);} run();";
await WebEnginner.GetWebView("postReq").InvokeScriptAsync("eval", new string[] { script });
ProductEntities.Where(c => c.Id == currentPid).First().ProValue = 70;
}
}
public void TestIndex()
{
var db = new ProductEntities();
var controller = new ProductsController();
var result = controller.Index() as ViewResult;
Assert.IsNotNull(result);
Assert.IsInstanceOfType(result.Model, typeof(List <Product>));
Assert.AreEqual(db.Products.Count(), (result.Model as List <Product>).Count);
}
public int countItems()
{
ProductEntities p = new ProductEntities();
List <string> counting = new List <string>();
counting.Add(p.Name);
Console.WriteLine(counting.Count());
return(counting.Count());
}
protected void Dispose(bool disposing)
{
if (disposing)
{
if (db != null)
{
db.Dispose();
db = null;
}
}
}
public void AddNewProduct(ProductTable product)
{
ProductEntities entities = new ProductEntities();
if (product == null)
{
throw new Exception("Product details are not set");
}
entities.ProductTables.Add(product);
entities.SaveChanges();
}
private async void next()
{
if (_groupList.Count <= 0 && _productList.Count <= 0)
{
return;
}
await Task.Delay(5000);
PostProValue++;
if (_productList.Count > 0)
{
var itemd = _productList.Dequeue();
var firstpro = itemd.ProductUrl;
var urls = firstpro.TrimEnd('/').Split('/');
var rid = urls[urls.Length - 1];
currentPid = itemd.Id;
itemd.ProValue = 10;
CurrentPostInfo = string.Format("当前推送小组为：{0},商品为：{1}", currentGroupItem.Name, itemd.ProductName);
var postView = WebEnginner.CreateInstance("postReqg");
postView.NavigationStarting -= postView_OnNavigationStarting;
postView.LoadCompleted -= postView_OnLoadCompleted;
postView.NavigationStarting += postView_OnNavigationStarting;
postView.LoadCompleted += postView_OnLoadCompleted;
postView.Navigate(new Uri(string.Format("https://m.facebook.com/sharer.php?m=group&group_target=0&u&id&ids&sid={0}&usedialogwithselector=1&_rdr", rid)));
}
else
{
currentGroupItem = _groupList.Dequeue();
ProductEntities.ToList().ForEach(item => _productList.Enqueue(item));
var itemd = _productList.Dequeue();
var firstpro = itemd.ProductUrl;
var urls = firstpro.TrimEnd('/').Split('/');
var rid = urls[urls.Length - 1];
currentPid = itemd.Id;
itemd.ProValue = 10;
CurrentPostInfo = string.Format("当前推送小组为：{0},商品为：{1}", currentGroupItem.Name, itemd.ProductName);
var postView = WebEnginner.CreateInstance("postReqg");
postView.NavigationStarting -= postView_OnNavigationStarting;
postView.LoadCompleted -= postView_OnLoadCompleted;
postView.NavigationStarting += postView_OnNavigationStarting;
postView.LoadCompleted += postView_OnLoadCompleted;
postView.Navigate(new Uri(string.Format("https://m.facebook.com/sharer.php?m=group&group_target=0&u&id&ids&sid={0}&usedialogwithselector=1&_rdr", rid)));
}
}
public IHttpActionResult AddCategory(Category cat)
{
using (var ctx = new ProductEntities())
{
ctx.Categorys.Add(cat);
ctx.SaveChanges();
var result = ctx.Categorys.ToList();
return(Ok(result));
}
}
public HttpResponseMessage LoadProductWithId(int id)
{
using (ProductEntities entity = new ProductEntities())
{
Product product = entity.Products.FirstOrDefault(x => x.ProductId == id);
if (product == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Product with given Id does not exist!"));
}
return(Request.CreateResponse(HttpStatusCode.OK, product));
}
}
public IActionResult Add()
{
ProductEntities productEntities = new ProductEntities();
productEntities.Id = Guid.NewGuid();
productEntities.Title = "测试标题";
productEntities.Price = 20;
productEntities.AddItem(productEntities.Id, "111", "222");
_repository.Insert(productEntities);
_unitOfWork.Commit();
return(Ok("111"));
}
