Update products with new price todo ( estamte time 3-4 hours work)
Hi
the project got insert working everyfast. the data is comming form a csv file in batch of max 2000 rows.
to check if the products exists in the db you need create a new collections with sql somethin like this
"select * from products p inner join products_prices pp on p=productsid = [login to view URL] where storeid = x and csvproductid = IN ( 1,2,3,4... )" then use linq to extract wich rows is for update and wich rows is for insert.
instead for updating prices do a new bulkinsert like
dataSource = new PostgreSqlDataSource([login to view URL]);
var keys = [login to view URL]("products_prices", rows_for_updates).ToInt64List().Execute();
code from the file
using System;
using [login to view URL];
using [login to view URL];
using [login to view URL];
using [login to view URL];
using [login to view URL];
using [login to view URL];
using Npgsql;
namespace csvtodb
{
class CsvToDatabase
{
PostgreSqlDataSource dataSource;
public bool doUpdateOrInsert( ref List<CSV_ROWS_DATA> records)
{
// ToDo add update if the products exists already
// filed IN CSV_ROWS_DATA idstore and storeproductid use thuse field to check if records exists or not
doInsert(ref records);
return true;
}
public doUpdate( ref List<CSV_ROWS_DATA> records ) {
}
// It can do lest 668 products insert within 4.32 sec
public bool doInsert( ref List<CSV_ROWS_DATA> rows)
{
int productsCount;
string strKeys;
Hi there,
I just got your invitation for biding this job.
After read the description carefully, I am confident that I can help you to implement this within hours.
I am a fullstack developer with more than 9 years experience.
Please give me this oppotunity and I will show you all my best.
Thank you very much and looking forward hearing from you soon!
$30 USD in 7 days
5.0 (12 reviews)
3.7
3.7
4 freelancers are bidding on average $51 USD for this job
hello sir ,
I am a full time freelancer and have 10 years of experience in
1 web and window development in asp.net c#, javascript,sql server
2 Android mobile development
i can do work as per your requirement .
I can quickly understand the details and idea of your project so I think my technology is suitable for your project.
please inbox me so that we can talk.
Thanks
Sanjay
Hi, I am Anas. I have 8+ years of experience in Desktop Application, web and mobile applications. I have worked financial/ trading application for brokage houses in Stock market. I am best fit for your task. you are requested to please hire me for this job. I am looking forward for your respond.
Thank you
Projects i completed in my career :
1- Attendance Management System Connected with "ZKTECO Biometric Machine".
2- Calling system having ASTERISK WITH FREEPBX, GRANDSTEAM & ZYCOO providers hardware.
3- Cloth management system having for 4 components.
- Yarn management
- warping management
- dying management
- Folding management
4- Card management system
5 - Scanner System using WIA driver
6- Account Management System