partial void DeleteTRN_Incremental(TRN_Incremental instance);
partial void InsertTRN_Incremental(TRN_Incremental instance);
partial void UpdateTRN_Incremental(TRN_Incremental instance);
public static void InsertIncremental()
{
try
{
int totalQuere = 0;
totalQuere = CountMessageInQuere(ShareRules.Queue_Incremental);
if (totalQuere != 0)
{
for (int row = 0; row < totalQuere; row++)
{
String message = string.Empty;
message = GetDatainRabbitMQ(ShareRules.Queue_Incremental);
if (!string.IsNullOrEmpty(message))
{
Incremental data = new Incremental();
data = Newtonsoft.Json.JsonConvert.DeserializeObject <Incremental>(message);
List <TRN_Incremental> ListSaveData = new List <TRN_Incremental>();
if (data != null)
{
foreach (var items in data.items)
{
foreach (var itemstocks in items.stocks)
{
TRN_Incremental dataSave = new TRN_Incremental();
dataSave.CreateDate = DateTime.Now;
if (!ShareRules.CheckEmpty(data.updated))
{
dataSave.UpdateDate = Convert.ToDateTime(data.updated);
}
if (!ShareRules.CheckEmpty(data.seq))
{
dataSave.Seq = Convert.ToInt32(data.seq);
}
dataSave.bu = data.bu;
dataSave.@interface = "online_stock_incre";
dataSave.barcode = items.barcode;
dataSave.SKU = items.sku;
dataSave.Status = items.status;
dataSave.Itemize = items.itemize;
dataSave.Loc = itemstocks.loc;
dataSave.AvailStock = itemstocks.availStock;
dataSave.ReserveStock = itemstocks.reserveStock;
ListSaveData.Add(dataSave);
}
}
if (ListSaveData.Count > 0)
{
DBRealTimeDataContext db = ShareRules.ConnectDB(true);
db.TRN_Incrementals.InsertAllOnSubmit(ListSaveData);
db.SubmitChanges();
}
}
}
}
}
}
catch (Exception ex)
{
ShareRules.WriteLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex.ToString());
}
}