private void btnNotShowProduct_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Toàn bộ số công ty trong group sẽ bị ẩn. Đồng ý", "Queuesion", MessageBoxButtons.OKCancel, MessageBoxIcon.Question)
== DialogResult.OK)
{
ProductAdapter productAdapter = new ProductAdapter(new Entities.Data.SqlDb(QT.Entities.Server.ConnectionString));
int TypeCompany = Convert.ToInt32(lookUpEdit1.EditValue);
if (TypeCompany > 0)
{
DataTable tblCompanyNeedNotShow = productAdapter.GetListCompanyByStatus(TypeCompany);
if (tblCompanyNeedNotShow != null && tblCompanyNeedNotShow.Rows.Count > 0)
{
foreach (DataRow row in tblCompanyNeedNotShow.Rows)
{
bool bOK = productAdapter.UpdateNotShowProductForCompany(Convert.ToInt64(row["id"]), false);
if (bOK == false &&
MessageBox.Show("Xem log lỗi. Chạy tiếp compnay tiếp?", "Question", MessageBoxButtons.YesNo
, MessageBoxIcon.Question) == DialogResult.Yes)
{
break;
}
}
MessageBox.Show("Success!");
}
}
}
}
catch (Exception ex01)
{
MessageBox.Show(ex01.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private static void ResesCacheProduct()
{
ProductAdapter productAdapter = new ProductAdapter(new SqlDb(Server.ConnectionString));
Console.WriteLine("1- Reset all Companies)");
Console.WriteLine("2- Reset for Company");
Console.Write("Input choose:");
int i = Convert.ToInt32(Console.ReadLine());
switch (i)
{
case 1:
{
int countProduct = 0;
var lstCompany = productAdapter.GetAllCompanyIdCrawler();
foreach (var companyID in lstCompany)
{
ResetCacheProduct(companyID);
log.Info(string.Format("Complete Company: {0} {1}/{2}", companyID, countProduct++, lstCompany.Count));
}
log.Info("Complete all company");
} break;
case 2:
{
Console.Write("Input domain:");
string strDomain = Console.ReadLine().Trim();
long companyID = productAdapter.GetCompanyIdByDomain(strDomain);
ResetCacheProduct(companyID);
log.Info(string.Format("Complete Company: {0}", companyID));
} break;
}
}
public IActionResult Remove(int id)
{
ProductRepository repo = new ProductRepository();
IProductsRepository target = new ProductAdapter(repo);
List <ShoppingBasketItem> basket = SessionHelper.GetObjectFromJson <List <ShoppingBasketItem> >(HttpContext.Session, "basket");
int index = isExist(id);
var product = target.find(id);
if (basket[index].Quantity > 1)
{
basket[index].Quantity--;
product.ItemsLeft++;
product.ItemsSold--;
}
else if (basket[index].Quantity == 1)
{
basket.RemoveAt(index);
product.ItemsLeft++;
product.ItemsSold--;
}
repo.Update(product);
SessionHelper.SetObjectAsJson(HttpContext.Session, "basket", basket);
return(RedirectToAction("Index"));
}
public void push()
{
ProductAdapter pa = new ProductAdapter();
tblCompany = sqldb.GetTblData(@"select a.ID
from Company a
inner join ManagerTypeRCompany b
on a.ID = b.IDCompany
inner join ManagerType c
on b.IDType = c.ID
where c.ID = 228
and a.TotalNewProduct > 5", CommandType.Text, new System.Data.SqlClient.SqlParameter[] { });
foreach (DataRow RowCom in tblCompany.Rows)
{
CompanyID = QT.Entities.Common.Obj2Int64(RowCom["ID"]);
tblProduct = sqldb.GetTblData("select ID from Product where Company = @CompanyID", CommandType.Text, new System.Data.SqlClient.SqlParameter[] {
sqldb.CreateParamteter("@CompanyID", CompanyID, SqlDbType.BigInt)
});
foreach (DataRow RowPro in tblProduct.Rows)
{
ProductID = QT.Entities.Common.Obj2Int64(RowPro["ID"]);
pa.PushQueueChangeChangeImage(new MQChangeImage()
{
ProductID = ProductID,
Type = 2
});
}
}
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.Product);
ImageButton btnback = FindViewById <ImageButton>(Resource.Id.btnback);
btnback.Click += Btnback_Click;
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 40
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 40
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 40
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 40
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 40
});
rv = FindViewById <RecyclerView>(Resource.Id.recycle);
//layoutmanager = new LinearLayoutManager(this.Activity);
layoutmanager = new GridLayoutManager(this, 2);
adp = new ProductAdapter(lstdata);
adp.ItemClick += Adp_ItemClick;
rv.SetAdapter(adp);
rv.SetLayoutManager(layoutmanager);
// Create your application here
}
protected override async void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
Xamarin.Essentials.Platform.Init(this, savedInstanceState);
SetContentView(Resource.Layout.activity_main);
Username = Intent.GetStringExtra(nameof(Username));
Password = Intent.GetStringExtra(nameof(Password));
// var username = Intent.GetStringExtra("Username")
var toolbar = FindViewById <Toolbar>(Resource.Id.toolbar);
SetActionBar(toolbar);
// Add floating action button
var addFab = FindViewById <FloatingActionButton>(Resource.Id.add_fab);
addFab.Click += AddFab_Click;
// Recycler View
var list = await Accounts();
ProductAdapter = new ProductAdapter(list);
ProductAdapter.ItemClick += ProductAdapter_ItemClick;
var recyclerView = FindViewById <RecyclerView>(Resource.Id.recycler_view);
recyclerView.SetLayoutManager(new LinearLayoutManager(this));
recyclerView.SetAdapter(ProductAdapter);
recyclerView.AddItemDecoration(new DividerItemDecoration(this, DividerItemDecoration.Vertical));
}
private void Calendar_DateChange(object sender, CalendarView.DateChangeEventArgs e)
{
lv.Visibility = ViewStates.Visible;
string day = "";
string month = "";
if (e.DayOfMonth < 10)
{
day = "0" + e.DayOfMonth.ToString();
}
else
{
day = e.DayOfMonth.ToString();
}
int monthInt = e.Month + 1;
if (e.Month < 10)
{
month = "0" + monthInt.ToString();
}
else
{
month = monthInt.ToString();
}
string changedDate = e.Year.ToString() + "-" + month + "-" + day;
DateTime date = DateTime.ParseExact(changedDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);
adapter = new ProductAdapter(context, pvm.FilteredProducts(date));
lv.Adapter = adapter;
}
[HttpGet] // GET /api/product
public IActionResult Get()
{
List <ProductDto> result = new List <ProductDto>();
Program.Products.ForEach(product => result.Add(ProductAdapter.ProductToProductDto(product)));
return(Ok(result));
}
public static void PushDownloadHtml(IEnumerable <string> domains)
{
SqlDb sql = new SqlDb(ConfigStatic.ProductConnection);
ProductAdapter productAdapter = new ProductAdapter(sql);
foreach (var domain in domains)
{
ProducerBasic producerBasic = new ProducerBasic(RabbitMQManager.GetRabbitMQServer(ConfigStatic.KeyRabbitMqCrlProductProperties),
ConfigStatic.GetQueueWaitDownloadHtml(domain));
string queryData = string.Format(@"
Select Id, DetailUrl
From Product
Where Company = {0}
Order by Id
"
, productAdapter.GetCompanyIdByDomain(domain));
sql.ProcessDataTableLarge(queryData,
10000, (Row, iRow) =>
{
producerBasic.PublishString(new JobDownloadHtml()
{
ProductId = Convert.ToInt64(Row["Id"]),
DetailUrl = Convert.ToString(Row["DetailUrl"]),
Domain = domain
}.GetJson());
});
}
}
public void Start()
{
ProductAdapter productAdapter = new ProductAdapter(new SqlDb(Server.ConnectionString));
List <long> lstCOmpanyDownloaded = productAdapter.GetCOmpanyDownloadedHTML();
foreach (long companyID in productAdapter.GetAllCompanyIdCrawler())
{
if (!lstCOmpanyDownloaded.Contains(companyID))
{
lst.Enqueue(companyID);
}
}
int MaxThread = 100;
for (int i = 0; i < MaxThread; i++)
{
int jThread = i;
Task.Factory.StartNew(() =>
{
WorkerExportHtml worker = new WorkerExportHtml(jThread);
worker.eventGetCompanyID += new WorkerExportHtml.GetCompanyId(GetCompanyCrawler);
worker.eventProcessHtml += new WorkerExportHtml.DelegateProcessHtml(SaveHtml);
worker.eventWhenFinish += new WorkerExportHtml.DelegateWhenFinish(EventWhenFinsih);
worker.Start();
});
}
}
private void LoadData()
{
ProductAdapter productAdapter = new ProductAdapter();
RelatedProductsRepeater.DataSource = productAdapter.GetRelatedProducts(ProductId);
RelatedProductsRepeater.DataBind();
}
private void ParseRecieptJSON(JsonValue json)
{
// Extract the array of name/value results for the field name "weatherObservation".
JsonValue productsResults = json;
List <string> itemList = new List <string>();
// Extract the "stationName" (location string) and write it to the location TextBox:
bool isSuccess = productsResults["IsSuccess"];
if (isSuccess)
{
JsonArray recieptArray = (JsonArray)productsResults["products"];
List <ProductDTO> output = new List <ProductDTO>();
foreach (JsonValue item in recieptArray)
{
ProductDTO d = new ProductDTO();
d.Name = item["Name"];
d.Quantity = item["Quantity"];
output.Add(d);
}
mlist = output;
var listView = FindViewById <ListView>(Resource.Id.listProduct);
productAdapter = new ProductAdapter(this, mlist);
listView.Adapter = productAdapter;
Toast.MakeText(this, "Product recieved successfully.", ToastLength.Short).Show();
}
else
{
string errorMessage = productsResults["Message"];
Toast.MakeText(this, errorMessage, ToastLength.Short).Show();
}
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
// Set our view from the "main" layout resource
SetContentView(Resource.Layout.Activity_Product);
CurrentPlatform.Init();
// Create the client instance, using the mobile app backend URL.
client = new MobileServiceClient(applicationURL);
productTable = client.GetTable <Products>();
pro_name = FindViewById <EditText>(Resource.Id.pro_name);
pro_calories = FindViewById <EditText>(Resource.Id.pro_calories);
pro_proteins = FindViewById <EditText>(Resource.Id.pro_proteins);
pro_carbs = FindViewById <EditText>(Resource.Id.pro_carbs);
pro_fats = FindViewById <EditText>(Resource.Id.pro_fats);
// Create an adapter to bind the items with the view
adapter = new ProductAdapter(this, Resource.Layout.Row_List_Product);
var listViewProdct = FindViewById <ListView>(Resource.Id.listViewProducts);
listViewProdct.Adapter = adapter;
// Load the items from the mobile app backend.
OnRefreshItemsSelected();
}
public IQueryable <HsrOrderApp.BL.DomainModel.Product> GetAll()
{
var Products = from c in this.db.ProductSet.AsEnumerable()
select ProductAdapter.AdaptProduct(c);
return(Products.AsQueryable());
}
private static void ExportDescription()
{
int countCompany = 0;
StreamWriter outfile = new StreamWriter("ShortDescription.txt");
List <string> lst = new List <string>();
ProductAdapter productAdapter = new ProductAdapter(new SqlDb(Server.ConnectionString));
List <long> companyIds = productAdapter.GetAllCompanyIdSystem();
foreach (long companyID in companyIds)
{
foreach (DataRow rowInfo in productAdapter.GetDescriptionData(companyID).Rows)
{
if (rowInfo["ShortDescription"] != DBNull.Value)
{
string data = rowInfo["ShortDescription"].ToString().Trim();
if (!string.IsNullOrEmpty(data))
{
outfile.Write(data + "\n:::::\n");
}
}
}
log.Info(string.Format("Success compay {0}/{1}", countCompany++, companyIds.Count));
}
outfile.Close();
log.Info("OK");
}
public void PushClassificationForCompany(long companyID, ProductAdapter productAdapter, IDatabase redisDatabase)
{
DataTable tblClassification = productAdapter.GetTblClassificationPushRedisForCompany(companyID);
foreach (DataRow rowClassification in tblClassification.Rows)
{
long ClassificationID = Convert.ToInt64(rowClassification["ID"]);
int count = 0;
while (true)
{
try
{
redisDatabase.SetAdd("classification", ClassificationID.ToString());
break;
}
catch (Exception ex)
{
count++;
if (count > 5)
{
break;
}
else
{
Thread.Sleep(1000);
}
}
}
}
productAdapter.UpdateLastSyncClassificationRedisForCompany(companyID);
}
private void btnPush_Click(object sender, EventArgs e)
{
ProductAdapter pt = new ProductAdapter(new SqlDb(QT.Entities.Server.ConnectionString));
string[] arData = txtCompanyDomain.Text.Split(new char[] { }, 500, StringSplitOptions.RemoveEmptyEntries);
int countCompany = 0;
foreach (var strCompany in arData)
{
long companyID = 0;
if (long.TryParse(strCompany, out companyID))
{
queueCompany.Enqueue(companyID);
countCompany++;
}
else
{
companyID = pt.GetCompanyIDFromDomain(strCompany);
if (companyID > 0)
{
queueCompany.Enqueue(companyID);
}
countCompany++;
}
}
if (countCompany > 0)
{
this.txtCompanyDomain.Clear();
this.lblQueueCount.Text = string.Format("Q:{0}", queueCompany.Count);
MessageBox.Show(string.Format("Added {0} companys", countCompany));
}
}
public void TestProductsToDtos()
{
Product product = new Product()
{
ProductId = 1, Name = "FakeProduct", Category = "FakeCategory", ListUnitPrice = (decimal)123.21, QuantityPerUnit = 100.2, ProductNumber = "FakeProductNumber", UnitsOnStock = 10, Version = 0
};
Assert.AreEqual(true, product.IsValid);
IQueryable <Product> products = new List <Product>()
{
product
}.AsQueryable();
IList <ProductDTO> productDtos = ProductAdapter.ProductsToDtos(products);
Assert.AreEqual <int>(1, productDtos.Count());
ProductDTO dto = productDtos.First();
Assert.AreEqual <int>(product.ProductId, dto.Id);
Assert.AreEqual <string>(product.Name, dto.Name);
Assert.AreEqual <string>(product.Category, dto.Category);
Assert.AreEqual <double>(product.QuantityPerUnit, dto.QuantityPerUnit);
Assert.AreEqual <decimal>(product.ListUnitPrice, dto.ListUnitPrice);
Assert.AreEqual(true, dto.IsValid);
}
public IQueryable <HsrOrderApp.BL.DomainModel.Product> GetAll()
{
var products = from p in this.db.Products
select ProductAdapter.AdaptProduct(p);
return(products);
}
private void PuschClassification()
{
while (true)
{
try
{
IDatabase redisDatabase = this.connectionMutilexer.GetDatabase(8);
var productAdapter = new ProductAdapter(new SqlDb(QT.Entities.Server.ConnectionString));
DataTable tbl = productAdapter.GetListCompanySynClassification();
if (tbl.Rows.Count == 0)
{
return;
}
foreach (DataRow row in tbl.Rows)
{
long companyID = Convert.ToInt64(row["ID"]);
string domain = Convert.ToString(row["Domain"]);
this.Invoke(new Action(() =>
{
lblCompanyClasification.Text = domain;
}));
PushClassificationForCompany(companyID, productAdapter, redisDatabase);
}
}
catch (ThreadAbortException ex)
{
return;
}
catch (Exception ex1)
{
Thread.Sleep(1000);
}
}
}
public void Add(ProductDto entity)
{
var adapter = ProductAdapter.BuildProduct(entity);
_repository.Add(adapter);
entity.Code = adapter.Code;
}
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
{
View v = inflater.Inflate(Resource.Layout.ProviderProductFragment, container, false);
rv = v.FindViewById <RecyclerView>(Resource.Id.recycle);
btnadd = v.FindViewById <ImageButton>(Resource.Id.btnAdd);
btnadd.Click += Btnadd_Click;
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 40
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 40
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 40
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 40
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product4, title = "Duos Shampoo og Basim 2x750ml", price = 60
});
lstdata.Add(new Product()
{
imgid = Resource.Drawable.product3, title = "Vitamino color mask 200ml", price = 40
});
//layoutmanager = new LinearLayoutManager(this.Activity);
layoutmanager = new GridLayoutManager(this.Activity, 2);
adp = new ProductAdapter(lstdata);
adp.ItemClick += Adp_ItemClick;
rv.SetAdapter(adp);
rv.SetLayoutManager(layoutmanager);
return(v);
}
public ActionResult <string> Get()
{
var products = _service.GetProducts();
var adapter = new ProductAdapter(products);
var xml = adapter.GetXml().InnerXml;
return(Content(xml, "application/xml"));
}
public async Task <IActionResult> Delete(int?id)
{
ProductRepository repo = new ProductRepository();
IProductsRepository target = new ProductAdapter(repo);
await target.Delete(id);
return(RedirectToAction(nameof(Index)));
}
private void waitFindNewDataToolStripMenuItem_Click(object sender, EventArgs e)
{
ProductAdapter sqlDb = new ProductAdapter(new SqlDb(QT.Entities.Server.ConnectionString));
var row = this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as DataRowView;
sqlDb.UpdateToWaitFindNew(Convert.ToInt64(row["ID"]));
MessageBox.Show("OK");
}
public FrmPushJobCrawler()
{
InitializeComponent();
this.productAdapter = new ProductAdapter(new Entities.Data.SqlDb(QT.Entities.Server.ConnectionString));
this.crawlerAdapter = new CrawlerProductAdapter(new SqlDb(QT.Entities.Server.ConnectionStringCrawler));
}
private void btnRefreshData_Click(object sender, EventArgs e)
{
Wait.Show("Đang xử lí dữ liệu");
ProductAdapter productAdapter = new ProductAdapter(new SqlDb(QT.Entities.Server.ConnectionString));
this.gridControl1.DataSource = productAdapter.GetReportTrackCrawlerProperties();
Wait.Close();
}
public void GetConfigurationHotProductByTest()
{
QT.Entities.Server.ConnectionString = "Data Source=42.112.28.93;Initial Catalog=QT_2;Persist Security Info=True;User ID=wss_price;Password=HzlRt4$$axzG-*UlpuL2gYDu;connection timeout=200";
ProductAdapter pa = new ProductAdapter(new SqlDb(QT.Entities.Server.ConnectionString));
var conf = pa.GetConfigurationHotProductBy(8220568010056870095);
Assert.IsNotNull(conf);
}
protected override void OnStart(string[] args)
{
log.Info("Start service");
try
{
InitializeComponent();
cancelTokenSource = new CancellationTokenSource();
string rabbitMQServerName = ConfigurationManager.AppSettings["rabbitMQServerName"];
workers = new Worker[workerCount];
rabbitMQServer = RabbitMQManager.GetRabbitMQServer(rabbitMQServerName);
string connectToSQL = @"Data Source=172.22.30.86,1455;Initial Catalog=QT_2;Persist Security Info=True;User ID=qt_vn;Password=@F4sJ=l9/ryJt9MT;connection timeout=200";
string connectToConnection = @"Data Source=42.112.28.93;Initial Catalog=QT_2;Persist Security Info=True;User ID=wss_price;Password=HzlRt4$$axzG-*UlpuL2gYDu;connection timeout=200";
CrawlerProductAdapter crawlerProductAdapter = new CrawlerProductAdapter(new SqlDb(connectToSQL));
ProductAdapter productAdapter = new ProductAdapter(new SqlDb(connectToConnection));
Encoding enc = new UTF8Encoding(true, true);
for (int i = 0; i < workerCount; i++)
{
log.InfoFormat("Start worker {i}", i.ToString());
var worker = new Worker(AddProductToSqlJobName, false, rabbitMQServer);
workers[i] = worker;
var token = this.cancelTokenSource.Token;
Task workerTask = new Task(() =>
{
worker.JobHandler = (downloadImageJob) =>
{
try
{
token.ThrowIfCancellationRequested();
string strData = enc.GetString(downloadImageJob.Data);
JobRabbitAddProduct job = JsonConvert.DeserializeObject <JobRabbitAddProduct>(strData);
if (job.DateAdd == DateTime.MinValue)
{
job.DateAdd = productAdapter.GetLastChangeOfProduct(job.ProductID);
}
crawlerProductAdapter.SaveLogAddProduct(job.ProductID, job.DetailUrl, job.IDCompnay, job.Name, job.DateAdd);
log.Info(string.Format("Log for {0}", strData));
return(true);
}
catch (OperationCanceledException opc)
{
log.Info("End worker");
return(false);
}
};
worker.Start();
}, token);
workerTask.Start();
log.InfoFormat("Worker {0} started", i);
}
}
catch (Exception ex)
{
log.Error("Start error", ex);
throw;
}
}
public CategoryViewHolder(View view, CategoryAdapter adapter) : base(view)
{
_parentAdapter = adapter;
_childAdapter = new ProductAdapter(view.Context);
_layoutManager = new LinearLayoutManager(view.Context);
_parent = view;
BindViews(_parent);
}
