public List <TaskDetail> GetDataByHeaderId(Int64 TaskHeaderID)
{
String Query = "SELECT * FROM TaskDetail WHERE TaskHeaderID = @TaskHeaderID";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
return(DataParser.ToList <TaskDetail>(oDm.GetTable()));
}
public List <TaskHeader> GetData(Int64 ScheduleID)
{
String Query = "SELECT * FROM TaskHeader WITH (NOLOCK) WHERE ScheduleID = @ScheduleID";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
return(DataParser.ToList <TaskHeader>(oDm.GetTable()));
}
public int DeleteByHeaderId(Int64 TaskHeaderID)
{
String Query = "DELETE FROM TaskDetail WHERE TaskHeaderID = @TaskHeaderID";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
return(oDm.RunActionQuery());
}
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 int UpdateImageByID(Int64 ID, String SmallImage, String BigImage)
{
String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET SmallImage = @SmallImage, BigImage = @BigImage WHERE ID = @ID";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddVarcharPara("SmallImage", 4000, SmallImage);
oDm.AddVarcharPara("BigImage", 4000, BigImage);
oDm.AddIntegerBigPara("ID", ID);
return(oDm.RunActionQuery());
}
public int UpdateIgnitoMode(Int64 TaskID, Boolean IgnitoMode)
{
String Query = "UPDATE TaskDetail SET IgnitoMode = @IgnitoMode, UpdatedOn = @UpdatedOn) WHERE TaskID = @TaskID";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskID", TaskID);
oDm.AddBoolPara("IgnitoMode", IgnitoMode);
oDm.AddDateTimePara("UpdatedOn", DateTime.Now);
return(oDm.RunActionQuery());
}
public List <TaskDetail> GetDataBySite(Int64 TaskHeaderID, String TaskSite, Int32[] TaskStatus)
{
String Query = "SELECT * FROM TaskDetail WHERE TaskHeaderID = @TaskHeaderID AND TaskSite = @TaskSite AND TaskStatus IN ({0})";
Query = String.Format(Query, String.Join(",", TaskStatus.Select(x => x.ToString()).ToArray()));
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
return(DataParser.ToList <TaskDetail>(oDm.GetTable()));
}
public int UpdateStatus(Int64 TaskID, String TaskStatusText, int TaskStatus)
{
String Query = "UPDATE TaskDetail SET TaskStatusText = @TaskStatusText, TaskStatus = @TaskStatus, UpdatedOn = @UpdatedOn WHERE TaskID = @TaskID";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskID", TaskID);
oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
oDm.AddIntegerPara("TaskStatus", TaskStatus);
oDm.AddDateTimePara("UpdatedOn", DateTime.Now);
return(oDm.RunActionQuery());
}
public int Update(Int64 TaskID, Int64 TaskHeaderID, string TaskNameText, string TaskNameValue, string TaskStatusText, int TaskStatus, bool DownloadImages, bool IgnitoMode, string TaskType, String TaskMode, string TaskSite)
{
String Query = "UPDATE TaskDetail SET TaskHeaderID = @TaskHeaderID, TaskNameText = @TaskNameText, TaskNameValue = @TaskNameValue, TaskStatusText = @TaskStatusText, TaskStatus = @TaskStatus, "
+ "DownloadImages = @DownloadImages, IgnitoMode = @IgnitoMode, TaskType = @TaskType, TaskMode = @TaskMode, TaskSite = @TaskSite, UpdatedOn = @UpdatedOn WHERE TaskID = @TaskID";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskID", TaskID);
oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
oDm.AddVarcharPara("TaskNameText", 4000, TaskNameText);
oDm.AddVarcharPara("TaskNameValue", 4000, TaskNameValue);
oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
oDm.AddIntegerPara("TaskStatus", TaskStatus);
oDm.AddBoolPara("DownloadImages", DownloadImages);
oDm.AddBoolPara("IgnitoMode", IgnitoMode);
oDm.AddVarcharPara("TaskType", 4000, TaskType);
oDm.AddVarcharPara("TaskMode", 4000, TaskMode);
oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
oDm.AddDateTimePara("UpdatedOn", DateTime.Now);
return(oDm.RunActionQuery());
}
public int Insert(Int64 TaskID, Int64 TaskHeaderID, String TaskNameText, String TaskNameValue, String TaskStatusText, int TaskStatus, Boolean DownloadImages, Boolean IgnitoMode, String TaskType, String TaskMode, String TaskSite)
{
String Query = "INSERT INTO TaskDetail (TaskHeaderID, TaskNameText ,TaskNameValue ,TaskStatusText ,TaskStatus, DownloadImages, IgnitoMode, TaskType, TaskMode ,TaskSite ,CreatedOn, UpdatedOn) "
+ "VALUES (@TaskHeaderID, @TaskNameText ,@TaskNameValue ,@TaskStatusText ,@TaskStatus, @DownloadImages, @IgnitoMode ,@TaskType, @TaskMode ,@TaskSite ,@CreatedOn, @UpdatedOn)";
SqlCeDataManager oDm = new SqlCeDataManager(ConnectionString, Query, true);
oDm.AddIntegerBigPara("TaskHeaderID", TaskHeaderID);
oDm.AddVarcharPara("TaskNameText", 4000, TaskNameText);
oDm.AddVarcharPara("TaskNameValue", 4000, TaskNameValue);
oDm.AddVarcharPara("TaskStatusText", 4000, TaskStatusText);
oDm.AddIntegerPara("TaskStatus", TaskStatus);
oDm.AddBoolPara("DownloadImages", DownloadImages);
oDm.AddBoolPara("IgnitoMode", IgnitoMode);
oDm.AddVarcharPara("TaskType", 4000, TaskType);
oDm.AddVarcharPara("TaskMode", 4000, TaskMode);
oDm.AddVarcharPara("TaskSite", 4000, TaskSite);
oDm.AddDateTimePara("CreatedOn", DateTime.Now);
oDm.AddDateTimePara("UpdatedOn", null);
return(oDm.RunActionQuery());
}
public int Update(Int64 ScheduleID, String TaskName, String TaskDescription, String Site, DateTime ScheduleFrom
, Boolean TaskRepeat, Int32 TaskRepeatInterval, String TaskRepeatUnit, Boolean Enabled)
{
String Query = "UPDATE [TaskHeader] SET [TaskName] = @TaskName, [TaskDescription] = @TaskDescription, [Site] = @Site, "
+ "[ScheduleFrom] = @ScheduleFrom, [TaskRepeat] = @TaskRepeat, [TaskRepeatInterval] = @TaskRepeatInterval, "
+ "[TaskRepeatUnit] = @TaskRepeatUnit, [Enabled] = @Enabled "
+ "WHERE [ScheduleID] = @ScheduleID";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
oDm.AddVarcharPara("TaskName", 4000, TaskName);
oDm.AddVarcharPara("TaskDescription", 4000, TaskDescription);
oDm.AddVarcharPara("Site", 4000, Site);
oDm.AddDateTimePara("ScheduleFrom", ScheduleFrom);
oDm.AddBoolPara("TaskRepeat", TaskRepeat);
oDm.AddIntegerPara("TaskRepeatInterval", TaskRepeatInterval);
oDm.AddVarcharPara("TaskRepeatUnit", 4000, TaskRepeatUnit);
oDm.AddBoolPara("Enabled", Enabled);
return(oDm.RunActionQuery());
}
public void GenerateScheduleNextRun(Int64 ScheduleID)
{
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()) AND ScheduleID = @ScheduleID";
oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
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()) AND ScheduleID = @ScheduleID";
oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
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()) AND ScheduleID = @ScheduleID";
oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
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()) AND ScheduleID = @ScheduleID";
oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
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()) AND ScheduleID = @ScheduleID";
oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
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()) AND ScheduleID = @ScheduleID";
oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
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()) AND ScheduleID = @ScheduleID";
oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ScheduleID", ScheduleID);
oDm.RunActionQuery();
}
public int UpdateByID(
Int64 ID,
String AdiNumber,
String VendorName,
String VendorNumber,
String VendorModel,
String PartNumber,
String Name,
String Url,
String AllowedToBuy,
String DangerousGoodsMessage,
String InventoryMessage,
String MarketingMessage,
decimal?MinQty,
String ModelNumber,
decimal?Price,
String ProductDescription,
String ProductImagePath,
String RecycleFee,
String SaleMessageIndicator,
String SaleType,
String ST,
String SMI,
String InventoryMessageCode,
String CatagoryID,
String SmallImage,
String BigImage,
bool IsUpdating,
int UpdateInterval,
DateTime LastUpdateDatetime
)
{
String Query = "UPDATE ADIProduct1 WITH (ROWLOCK) SET AdiNumber = @AdiNumber, VendorName = @VendorName, VendorNumber = @VendorNumber, "
+ "VendorModel = @VendorModel, PartNumber = @PartNumber, Name = @Name, Url = @Url, AllowedToBuy = @AllowedToBuy, "
+ "DangerousGoodsMessage = @DangerousGoodsMessage, InventoryMessage = @InventoryMessage, MarketingMessage = @MarketingMessage, "
+ "MinQty = @MinQty, ModelNumber = @ModelNumber, Price = @Price, ProductDescription = @ProductDescription, ProductImagePath = @ProductImagePath, "
+ "RecycleFee = @RecycleFee, SaleMessageIndicator = @SaleMessageIndicator, SaleType = @SaleType, ST = @ST, SMI = @SMI, "
+ "InventoryMessageCode = @InventoryMessageCode, CatagoryID = @CatagoryID, SmallImage = @SmallImage, BigImage = @BigImage, "
+ "IsUpdating = @IsUpdating, UpdateInterval = @UpdateInterval, LastUpdateDatetime = @LastUpdateDatetime "
+ "WHERE ID = @ID";
SqlCeDataManager oDm = new SqlCeDataManager(this.ConnectionString, Query, true);
oDm.AddIntegerBigPara("ID", ID);
oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
oDm.AddVarcharPara("VendorName", 4000, VendorName);
oDm.AddVarcharPara("VendorNumber", 4000, VendorNumber);
oDm.AddVarcharPara("VendorModel", 4000, VendorModel);
oDm.AddVarcharPara("PartNumber", 4000, PartNumber);
oDm.AddVarcharPara("Name", 4000, Name);
oDm.AddVarcharPara("Url", 4000, Url);
oDm.AddVarcharPara("AllowedToBuy", 4000, AllowedToBuy);
oDm.AddVarcharPara("DangerousGoodsMessage", 4000, DangerousGoodsMessage);
oDm.AddVarcharPara("InventoryMessage", 4000, InventoryMessage);
oDm.AddVarcharPara("MarketingMessage", 4000, MarketingMessage);
oDm.AddDecimalPara("MinQty", 2, 10, MinQty);
oDm.AddVarcharPara("ModelNumber", 4000, ModelNumber);
oDm.AddDecimalPara("Price", 2, 10, Price);
oDm.AddVarcharPara("ProductDescription", 4000, ProductDescription);
oDm.AddVarcharPara("ProductImagePath", 4000, ProductImagePath);
oDm.AddVarcharPara("RecycleFee", 4000, RecycleFee);
oDm.AddVarcharPara("SaleMessageIndicator", 4000, SaleMessageIndicator);
oDm.AddVarcharPara("SaleType", 4000, SaleType);
oDm.AddVarcharPara("ST", 4000, ST);
oDm.AddVarcharPara("SMI", 4000, SMI);
oDm.AddVarcharPara("InventoryMessageCode", 4000, InventoryMessageCode);
oDm.AddVarcharPara("CatagoryID", 4000, CatagoryID);
oDm.AddVarcharPara("SmallImage", 4000, SmallImage);
oDm.AddVarcharPara("BigImage", 4000, BigImage);
oDm.AddBoolPara("IsUpdating", IsUpdating);
oDm.AddIntegerPara("UpdateInterval", UpdateInterval);
oDm.AddDateTimePara("LastUpdateDatetime", LastUpdateDatetime);
return(oDm.RunActionQuery());
}
