public int DeleteByPart(String AdiNumber) { String Query = "DELETE FROM ADIInventory WHERE AdiNumber = @AdiNumber"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); return oDm.RunActionQuery(); }
public List<FinalExport> GetBySite(String ExportSite) { String Query = "SELECT * FROM FinalExport WHERE ExportSite = @ExportSite ORDER BY CreatedDate"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("ExportSite", 4000, ExportSite); return DataParser.ToList<FinalExport>(oDm.GetTable()); }
public int DeleteById(Int64 TaskID) { String Query = "DELETE FROM TaskDetail WHERE TaskID = @TaskID"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddIntegerBigPara("TaskID", TaskID); return oDm.RunActionQuery(); }
public List<AdiCategory> GetCategoryByParent(String ParentValue) { String Query = "SELECT * FROM ADICategory WITH (NOLOCK) WHERE ParentValue = @ParentValue"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("ParentValue", 255, ParentValue); return DataParser.ToList<AdiCategory>(oDm.GetTable()); }
public List<TaskDetail> GetDataById(Int64 TaskID) { String Query = "SELECT * FROM TaskDetail WHERE TaskID = @TaskID"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddIntegerBigPara("TaskID", TaskID); return DataParser.ToList<TaskDetail>(oDm.GetTable()); }
//public List<ADIInventoryExport> FillByProduct(String PART_NUM) //{ // String Query = "SELECT * FROM ADIInventoryExport WHERE PART_NUM = @PART_NUM"; // SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); // oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); // return DataParser.ToList<ADIInventoryExport>(oDm.GetTable()); //} public int ProductCount(String PART_NUM) { String Query = "SELECT COUNT(1) FROM ADIInventoryExport WITH (NOLOCK) WHERE PART_NUM = @PART_NUM"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); return (int) oDm.GetTable().Rows[0][0]; }
public int DeleteById(Int64 ScheduleID) { String Query = "DELETE FROM [TaskHeader] WHERE [ScheduleID] = @ScheduleID"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddIntegerBigPara("ScheduleID", ScheduleID); return oDm.RunActionQuery(); }
public DataTable GetDataTableByPartNumber(String PART_NUM) { String Query = "SELECT * FROM ADIChild WITH (NOLOCK) WHERE PART_NUM = @PART_NUM"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); return oDm.GetTable(); }
private int Insert(String ManufacturerCode, InManufacturerSeries manufacturer) { String Query = "INSERT INTO [SecLockManufacturerSeries]([ManufacturerCode],[Name]) VALUES('" + ManufacturerCode + "','" + manufacturer.Name + "');"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public FinalExport GetTop() { String Query = "SELECT TOP 1 * FROM FinalExport ORDER BY CreatedDate"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); List<FinalExport> finalExports = DataParser.ToList<FinalExport>(oDm.GetTable()); return finalExports.Count == 0 ? null : finalExports[0]; }
public void GenerateScheduleNextRun() { String Query = String.Empty; SqlCeDataManager oDm; Query = "UPDATE [TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(yy, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE [TaskRepeatUnit] = 'YEAR' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE())"; oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); Query = "UPDATE [TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(q, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE [TaskRepeatUnit] = 'QUARTER' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE())"; oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); Query = "UPDATE [TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(m, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE [TaskRepeatUnit] = 'MONTH' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE())"; oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); Query = "UPDATE [TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(ww, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE [TaskRepeatUnit] = 'WEEK' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE())"; oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); Query = "UPDATE [TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(d, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE [TaskRepeatUnit] = 'DAY' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE())"; oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); Query = "UPDATE [TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(hh, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE [TaskRepeatUnit] = 'HOUR' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE())"; oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); Query = "UPDATE [TaskHeader] WITH (ROWLOCK) SET [NextRun] = DATEADD(mi, [TaskRepeatInterval], CASE WHEN [LastRun] IS NULL THEN [ScheduleFrom] ELSE [LastRun] END) WHERE [TaskRepeatUnit] = 'MINUTE' AND (ISNULL([NextRun]) = 1 OR [NextRun] < GETDATE())"; oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); }
public List<ADICategoryExport> GetDataByCatagoryID(String Value) { String Query = "SELECT * FROM ADICategoryExport WITH (NOLOCK) WHERE Value = @Value"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("Value", 255, Value); return DataParser.ToList<ADICategoryExport>(oDm.GetTable()); }
public List<AdiProduct> GetData() { String Query = "SELECT * FROM ADIProduct1 WITH (NOLOCK)"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.ConnectionString = this.ConnectionString; return DataParser.ToList<AdiProduct>(oDm.GetTable()); }
public List<AdiProduct> GetAllPriorityProducts() { String Query = "SELECT * FROM ADIProduct1 WITH (NOLOCK) WHERE PriorityProduct = 1 AND LastUpdateDatetime <= DATEADD(d, -1, GETDATE())"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.ConnectionString = this.ConnectionString; return DataParser.ToList<AdiProduct>(oDm.GetTable()); }
public int Insert(String AdiNumber, String id, String dc, String region, String storeName, String address1, String address2, String address3 , String country, String city, String state, String stateName, String zip, String phone, String fax, float? lat, float? lon, String inventory , String manager, String responseCode, String responseMessage, Boolean IsHub) { String Query = "INSERT INTO ADIInventory (AdiNumber, id ,dc ,region ,storeName ,address1 ,address2 ,address3 ,country ,city ,state ,stateName ,zip ,phone ,fax ,lat ,lon ,inventory ,manager ,responseCode ,responseMessage ,IsHub, LastUpdate) " + "VALUES (@AdiNumber, @id ,@dc ,@region ,@storeName ,@address1 ,@address2 ,@address3 ,@country ,@city ,@state ,@stateName ,@zip ,@phone ,@fax ,@lat ,@lon ,@inventory ,@manager ,@responseCode ,@responseMessage ,@IsHub, @LastUpdate)"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); oDm.AddVarcharPara("id", 4000, id); oDm.AddVarcharPara("dc", 4000, dc); oDm.AddVarcharPara("region", 4000, region); oDm.AddVarcharPara("storeName", 4000, storeName); oDm.AddVarcharPara("address1", 4000, address1); oDm.AddVarcharPara("address2", 4000, address2); oDm.AddVarcharPara("address3", 4000, address3); oDm.AddVarcharPara("country", 4000, country); oDm.AddVarcharPara("city", 4000, city); oDm.AddVarcharPara("state", 4000, state); oDm.AddVarcharPara("stateName", 4000, stateName); oDm.AddVarcharPara("zip", 4000, zip); oDm.AddVarcharPara("phone", 4000, phone); oDm.AddVarcharPara("fax", 4000, fax); oDm.AddFloatPara("lat", lat); oDm.AddFloatPara("lon", lon); oDm.AddVarcharPara("inventory", 4000, inventory); oDm.AddVarcharPara("manager", 4000, manager); oDm.AddVarcharPara("responseCode", 4000, responseCode); oDm.AddVarcharPara("responseMessage", 4000, responseMessage); oDm.AddBoolPara("IsHub", IsHub); oDm.AddDateTimePara("LastUpdate", DateTime.Now); return oDm.RunActionQuery(); }
private int Update(String ManufacturerCode, InManufacturerSeries manufacturer) { String Query = "UPDATE [SecLockManufacturerSeries] SET [Name] = '" + manufacturer.Name + "',[ManufacturerCode] = '" + ManufacturerCode + "' WHERE [Name] = '" + manufacturer.Name + "'"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public FinalExport GetTopBySite(String ExportSite) { String Query = "SELECT TOP 1 * FROM FinalExport WHERE ExportSite = @ExportSite ORDER BY CreatedDate"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("ExportSite", 4000, ExportSite); List<FinalExport> finalExports = DataParser.ToList<FinalExport>(oDm.GetTable()); return finalExports.Count == 0 ? null : finalExports[0]; }
public DataTable GetDataTableByPartNumber(String AdiNumber) { String Query = "SELECT * FROM ADIInventory WHERE AdiNumber = @AdiNumber"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); return oDm.GetTable(); }
public List<ADIInventoryDetails> GetDataByPartNumber(String AdiNumber) { String Query = "SELECT * FROM ADIInventory WHERE AdiNumber = @AdiNumber"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); return DataParser.ToList<ADIInventoryDetails>(oDm.GetTable()); }
public ADIInventoryExport GetDataByProduct(String PART_NUM) { String Query = "SELECT * FROM ADIInventoryExport WITH (NOLOCK) WHERE PART_NUM = @PART_NUM"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); var list = DataParser.ToList<ADIInventoryExport>(oDm.GetTable()); return list.Count == 1 ? list[0] : null; }
public List<TaskDetail> GetDataBySite(Int64 TaskHeaderID, String TaskSite, Int32 TaskStatus) { String Query = "SELECT * FROM TaskDetail WHERE TaskSite = @TaskSite AND TaskStatus = @TaskStatus"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("TaskSite", 4000, TaskSite); oDm.AddIntegerPara("TaskStatus", TaskStatus); return DataParser.ToList<TaskDetail>(oDm.GetTable()); }
public int Insert(String PART_NUM, String PropertyName, String PropertyValue) { String Query = "INSERT INTO [ADIChild] WITH (ROWLOCK) ([PART_NUM],[PropertyName],[PropertyValue])VALUES(@PART_NUM, @PropertyName, @PropertyValue)"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); oDm.AddVarcharPara("PropertyName", 4000, PropertyName); oDm.AddVarcharPara("PropertyValue", 4000, PropertyValue); return oDm.RunActionQuery(); }
public void GenerateExport() { String Query = "INSERT INTO [ADICategoryExport] ([RootValue] ,[RootDisplayName] ,[ParentValue] ,[ParentDisplayName] ,[Value] ,[DisplayName] ,[CategoryUrl]) " + "SELECT ROOT.[Value] ,ROOT.[DisplayName] ,PARENT.[Value] ,PARENT.[DisplayName] ,CHILD.[Value] ,CHILD.[DisplayName] ,CHILD.[CategoryUrl] " + "FROM [ADICategory] ROOT WITH (NOLOCK) JOIN [ADICategory] PARENT WITH (NOLOCK) ON ROOT.[Value] = PARENT.[ParentValue] " + "JOIN [ADICategory] CHILD WITH (NOLOCK) ON PARENT.[Value] = CHILD.[ParentValue] " + "WHERE ROOT.[ParentValue] IS NULL"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); }
public int Delete(String ExportSite, String ExportType, String ExportValue, DateTime CreatedDate) { String Query = "DELETE FROM FinalExport WHERE " + "ExportSite = @ExportSite AND ExportType = @ExportType AND ExportValue = @ExportValue AND CreatedDate = @CreatedDate"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("ExportSite", 4000, ExportSite); oDm.AddVarcharPara("ExportType", 4000, ExportType); oDm.AddVarcharPara("ExportValue", 4000, ExportValue); oDm.AddDateTimePara("CreatedDate", CreatedDate); return oDm.RunActionQuery(); }
public int Insert(String ExportSite, String ExportType, String ExportValue) { String Query = "INSERT INTO FinalExport (ExportSite, ExportType, ExportValue, CreatedDate) " + "VALUES (@ExportSite, @ExportType, @ExportValue, @CreatedDate)"; SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("ExportSite", 4000, ExportSite); oDm.AddVarcharPara("ExportType", 4000, ExportType); oDm.AddVarcharPara("ExportValue", 4000, ExportValue); oDm.AddDateTimePara("CreatedDate", DateTime.Now); return oDm.RunActionQuery(); }
private int Insert(InProduct product) { String Query = "INSERT INTO [SecLockProduct] ([Code] ,[Name] ,[Url] ,[ManufacturerCode],[ManufacturerName],[ManufacturerSeries],[CategoyCode],[CategoryName], [YourPrice] ,[ListPrice] ,[ImageUrl1],[ImageUrl2] ,[Stock] ,[Description] ,[TechDoc]) " + "VALUES ('" + product.Code + "' ,'" + product.Name + "' ,'" + product.Url + "' ,'" + product.ManufacturerCode +"', '"+ product.ManufacturerName +"', '"+ product.ManufacturerSeries +"', '" + product.CategoyCode +"', '"+ product.CategoryName +"', '" + product.YourPrice + "' ,'" + product.ListPrice + "' ,'" + product.ImageUrl1 + "' ,'" + product.ImageUrl2 + "', '" + product.Stock + "' ,'" + (String.IsNullOrEmpty(product.Description) ? String.Empty : product.Description.Replace("\'", "\'\'")) + "' ,'" + (String.IsNullOrEmpty(product.TechDoc) ? String.Empty : product.TechDoc.Replace("'", "''")) + "')"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public String GetValue(String PART_NUM, String PropertyName) { String Query = "SELECT ID, PART_NUM, PropertyName, PropertyValue FROM ADIChild WITH (NOLOCK) WHERE PART_NUM = @PART_NUM AND PropertyName = @PropertyName"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); oDm.AddVarcharPara("PropertyName", 4000, PropertyName); List<ADIChild> childs = DataParser.ToList<ADIChild>(oDm.GetTable()); if (childs.Count > 0) return childs[0].PropertyValue; else return null; }
private int Update(InProduct product) { String Query = "UPDATE [SecLockProduct] SET [Name] = '" + product.Name + "', [Url] = '" + product.Url + "', [ManufacturerCode] = '" + product.ManufacturerCode + "', [ManufacturerName] = '" + product.ManufacturerName + "', [ManufacturerSeries] = '" + product.ManufacturerSeries + "', [CategoyCode] = '" + product.CategoyCode + "', [CategoryName] = '" + product.CategoryName + "', [YourPrice] = " + product.YourPrice + " , [ListPrice] = " + product.ListPrice + " , [ImageUrl1] = '" + product.ImageUrl1 + "', [ImageUrl2] = '" + product.ImageUrl2 + "', [Stock] = '" + product.Stock + "', [Description] = '" + (String.IsNullOrEmpty(product.Description) ? String.Empty : product.Description.Replace("\'", "\'\'")) + "', [TechDoc] = '" + (String.IsNullOrEmpty(product.TechDoc) ? String.Empty : product.TechDoc.Replace("'", "''")) + "' WHERE [Code] = '" + product.Code + "';"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public int UpdateByPartNum(String PART_NUM, int TotalInventory, int Dallas, int DC_AtlantaHub, int DC_Dallas_Hub, int DC_Elk_Grove_Hub, int DC_Feura_Bush, int DC_Louisville_Hub , int DC_Reno_Hub, int DC_Richmond_Dist_Ctr, int Oklahama, int RemainingBranches, DateTime LastUpdate) { String Query = "UPDATE ADIInventoryExport WITH (ROWLOCK) SET TotalInventory = @TotalInventory, Dallas = @Dallas, DC_AtlantaHub = @DC_AtlantaHub, DC_Dallas_Hub = @DC_Dallas_Hub, DC_Elk_Grove_Hub = @DC_Elk_Grove_Hub, DC_Feura_Bush = @DC_Feura_Bush, DC_Louisville_Hub = @DC_Louisville_Hub, DC_Reno_Hub = @DC_Reno_Hub,DC_Richmond_Dist_Ctr = @DC_Richmond_Dist_Ctr, Oklahama = @Oklahama, RemainingBranches = @RemainingBranches, LastUpdate = @LastUpdate WHERE PART_NUM = @PART_NUM"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); oDm.AddIntegerPara("TotalInventory", TotalInventory); oDm.AddIntegerPara("Dallas", Dallas); oDm.AddIntegerPara("DC_AtlantaHub", DC_AtlantaHub); oDm.AddIntegerPara("DC_Dallas_Hub", DC_Dallas_Hub); oDm.AddIntegerPara("DC_Elk_Grove_Hub", DC_Elk_Grove_Hub); oDm.AddIntegerPara("DC_Feura_Bush", DC_Feura_Bush); oDm.AddIntegerPara("DC_Louisville_Hub", DC_Louisville_Hub); oDm.AddIntegerPara("DC_Reno_Hub", DC_Reno_Hub); oDm.AddIntegerPara("DC_Richmond_Dist_Ctr", DC_Richmond_Dist_Ctr); oDm.AddIntegerPara("Oklahama", Oklahama); oDm.AddIntegerPara("RemainingBranches", RemainingBranches); oDm.AddDateTimePara("LastUpdate", LastUpdate); return oDm.RunActionQuery(); }
public int Insert(String PART_NUM, int TotalInventory, int Dallas, int DC_AtlantaHub, int DC_Dallas_Hub, int DC_Elk_Grove_Hub, int DC_Feura_Bush, int DC_Louisville_Hub , int DC_Reno_Hub, int DC_Richmond_Dist_Ctr, int Oklahama, int RemainingBranches, DateTime LastUpdate) { String Query = "INSERT INTO ADIInventoryExport WITH (ROWLOCK) (PART_NUM, TotalInventory, Dallas, DC_AtlantaHub, DC_Dallas_Hub, DC_Elk_Grove_Hub, DC_Feura_Bush, DC_Louisville_Hub, DC_Reno_Hub, DC_Richmond_Dist_Ctr, Oklahama, RemainingBranches, LastUpdate) " + "VALUES (@PART_NUM, @TotalInventory, @Dallas, @DC_AtlantaHub, @DC_Dallas_Hub, @DC_Elk_Grove_Hub, @DC_Feura_Bush, @DC_Louisville_Hub, @DC_Reno_Hub, @DC_Richmond_Dist_Ctr, @Oklahama, @RemainingBranches, @LastUpdate)"; SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); oDm.AddIntegerPara("TotalInventory", TotalInventory); oDm.AddIntegerPara("Dallas", Dallas); oDm.AddIntegerPara("DC_AtlantaHub", DC_AtlantaHub); oDm.AddIntegerPara("DC_Dallas_Hub", DC_Dallas_Hub); oDm.AddIntegerPara("DC_Elk_Grove_Hub", DC_Elk_Grove_Hub); oDm.AddIntegerPara("DC_Feura_Bush", DC_Feura_Bush); oDm.AddIntegerPara("DC_Louisville_Hub", DC_Louisville_Hub); oDm.AddIntegerPara("DC_Reno_Hub", DC_Reno_Hub); oDm.AddIntegerPara("DC_Richmond_Dist_Ctr", DC_Richmond_Dist_Ctr); oDm.AddIntegerPara("Oklahama", Oklahama); oDm.AddIntegerPara("RemainingBranches", RemainingBranches); oDm.AddDateTimePara("LastUpdate", LastUpdate); return oDm.RunActionQuery(); }