public AddUpdatePallet(int palletId)
{
InitializeComponent();
BindingContext = viewModel = new PalletItemViewModel();
Item = new PalletItem();
Item.Palletid = palletId;
viewModel.Palletid = palletId;
}
private void AddItem_Clicked(object sender, EventArgs e)
{
Item = new PalletItem();
Description.Text = "";
Barcode.Text = "";
Inner.Text = "";
Outer.Text = "";
Quatity.Text = "";
WrapperName.Text = "";
ItemId = 0;
ItemNewId = 0;
popupLoadingView.IsVisible = true;
}
public async Task <bool> AddPalletItemAsync(PalletItem palletItem)
{
DBConnection dBConnection = new DBConnection();
var result = dBConnection.GetQueryResult("Select MAX(id) From pallet_item", null);
int insertedId = 0;
if (result != null)
{
int maxPalletItemId = Convert.ToInt32(((DataSet)result).Tables[0].Rows[0][0] is DBNull ? 0 : ((DataSet)result).Tables[0].Rows[0][0]);
string query = "Insert INTO pallet_item(id,quantity,barcode,description,`outer`, `inner`,wrapper_name,pallet_id) values " +
"(@Id" + ", @Quantity" + ", @Barcode" + ", @Description" + ", @Outer" + ",@Inner" + ",@WrapperName" + ",@Palletid" + ")";
ObservableCollection <Params> dbParams1 = new ObservableCollection <Params>();
dbParams1.Add(new Params()
{
Name = "Id" + "", Value = maxPalletItemId + 1
});
dbParams1.Add(new Params()
{
Name = "Quantity" + "", Value = palletItem.Quantity
});
dbParams1.Add(new Params()
{
Name = "Barcode", Value = palletItem.Barcode
});
dbParams1.Add(new Params()
{
Name = "Description", Value = palletItem.Description
});
dbParams1.Add(new Params()
{
Name = "Outer", Value = palletItem.Outer
});
dbParams1.Add(new Params()
{
Name = "Inner", Value = palletItem.Inner
});
dbParams1.Add(new Params()
{
Name = "WrapperName", Value = palletItem.WrapperName
});
dbParams1.Add(new Params()
{
Name = "Palletid", Value = palletItem.Palletid
});
insertedId = dBConnection.ExecuteNonQuery(query, dbParams1);
}
return(await Task.FromResult(insertedId > 0?true : false));
}
public async Task <bool> UpdatePalletItem(PalletItem palletItem)
{
bool result = false;
try
{
result = await DataStore.UpdatePalletItemAsync(palletItem);
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
return(result);
}
private async void Done_Clicked(object sender, EventArgs e)
{
Item = new PalletItem();
Item.Description = Description.Text;
Item.Barcode = Barcode.Text;
Item.Inner = Inner.Text;
Item.Outer = Outer.Text;
Item.Quantity = Quatity.Text;
Item.WrapperName = WrapperName.Text;
Item.NewId = ItemNewId;
Item.Id = ItemId;
if (ItemId != 0 || ItemNewId != 0)
{
foreach (var newItem in viewModel.PalletItems)
{
if (ItemNewId < 0 && newItem.NewId == ItemNewId || ItemId > 0 && newItem.Id == ItemId)
{
viewModel.PalletItems.Remove(newItem);
break;
}
}
if (ItemId > 0)
{
var result = await viewModel.UpdatePalletItem(Item);
if (result)
{
await DisplayAlert("Message", "Item has been updated successfully.", "Ok");
}
}
}
else
{
Item.NewId = -1 - viewModel.PalletItems.Count();
}
viewModel.PalletItems.Add(Item);
popupLoadingView.IsVisible = false;
}
public async Task <bool> UpdatePalletItemAsync(PalletItem item)
{
DBConnection dBConnection = new DBConnection();
string query = "Update pallet_item set quantity = @quantity,barcode=@barcode,description=@description,`outer`=@outer, `inner`=@inner,wrapper_name=@wrapper_name where id =@Id;";
ObservableCollection <Params> dbParams = new ObservableCollection <Params>();
dbParams.Add(new Params()
{
Name = "id", Value = item.Id
});
dbParams.Add(new Params()
{
Name = "quantity", Value = item.Quantity
});
dbParams.Add(new Params()
{
Name = "barcode", Value = item.Barcode
});
dbParams.Add(new Params()
{
Name = "description", Value = item.Description
});
dbParams.Add(new Params()
{
Name = "outer", Value = item.Outer
});
dbParams.Add(new Params()
{
Name = "inner", Value = item.Inner
});
dbParams.Add(new Params()
{
Name = "wrapper_name", Value = item.WrapperName
});
int result = dBConnection.ExecuteNonQuery(query, dbParams);
return(await Task.FromResult(result > 0?true : false));
}
private void OnEdit_Tapped(object sender, EventArgs e)
{
Image lblClicked = (Image)sender;
var item = (TapGestureRecognizer)lblClicked.GestureRecognizers[0];
var id = Convert.ToInt32(item.CommandParameter);
var editItem = viewModel.PalletItems.FirstOrDefault(p => p.Id == id);
if (id == 0)
{
id = ((PalletItem)lblClicked.BindingContext).NewId;
editItem = viewModel.PalletItems.FirstOrDefault(p => p.NewId == id);
}
Item = new PalletItem();
Description.Text = editItem.Description;
Barcode.Text = editItem.Barcode;
Inner.Text = editItem.Inner;
Outer.Text = editItem.Outer;
Quatity.Text = editItem.Quantity;
WrapperName.Text = editItem.WrapperName;
ItemId = editItem.Id;
ItemNewId = editItem.NewId;
popupLoadingView.IsVisible = true;
}
public AddUpdatePallet()
{
InitializeComponent();
BindingContext = viewModel = new PalletItemViewModel();
Item = new PalletItem();
}
private async void SubmitCommandRecieverAsync()
{
List <PalletItem> palletItems = new List <PalletItem>();
PalletItem pallet = null;
PalletRequestModel palletRequestModel = null;
var barCodeCollection = ConstantManager.Barcodes;
PalletResponseModel palletResponseModel = null;
try
{
Loader.StartLoading();
foreach (var item in barCodeCollection)
{
pallet = new PalletItem
{
Barcode = item.Barcode,
ScanDate = DateTimeOffset.Now,
};
foreach (var tag in ConstantManager.Tags)
{
pallet.Tags.Add(tag);
}
palletItems.Add(pallet);
}
palletRequestModel = new PalletRequestModel
{
Barcode = ManifestId.Split('-').LastOrDefault(),
BuildDate = DateTimeOffset.Now,
OwnerId = AppSettings.CompanyId,
PalletId = _uuidManager.GetUuId(),
ReferenceKey = "",
StockLocation = StockLocation.PartnerId,
StockLocationId = StockLocation.PartnerId,
StockLocationName = StockLocation.FullName,
};
foreach (var item in palletItems)
{
palletRequestModel.PalletItems.Add(item);
}
foreach (var item in ConstantManager.Tags)
{
palletRequestModel.Tags.Add(item);
}
palletResponseModel = new PalletResponseModel
{
Barcode = ManifestId.Split('-').LastOrDefault(),
BuildDate = DateTimeOffset.Now,
Container = null,
CreatedDate = DateTimeOffset.Now,
DataInfo = new Model.PrintPDF.DateInfo {
},
Location = new Owner {
},
Owner = new Owner {
},
PalletId = palletRequestModel.PalletId,
PalletItems = palletItems,
ReferenceKey = string.Empty,
StockLocation = new Owner {
FullName = StockLocation.FullName, PartnerTypeName = StockLocation.PartnerTypeName
},
TargetLocation = new Model.PrintPDF.TargetLocation {
},
Tags = ConstantManager.Tags,
};
var current = Connectivity.NetworkAccess;
if (current == NetworkAccess.Internet)
{
var value = await _palletizeService.PostPalletAsync(palletRequestModel, AppSettings.SessionId, Configuration.NewPallet);
}
else
{
try
{
palletRequestModel.IsQueue = true;
var RealmDb = Realm.GetInstance(RealmDbManager.GetRealmDbConfig());
RealmDb.Write(() =>
{
RealmDb.Add(palletRequestModel, update: true);
});
}
catch (Exception ex)
{
Crashes.TrackError(ex);
}
}
PrintPallet();
await _navigationService.NavigateAsync("PalletizeDetailView", new NavigationParameters
{
{ "LoadInfo", palletResponseModel }, { "Contents", ConstantManager.Contents }
}, animated : false);
}
catch (Exception ex)
{
Crashes.TrackError(ex);
}
finally
{
Loader.StopLoading();
palletItems = null;
pallet = null;
barCodeCollection = null;
palletRequestModel = null;
Cleanup();
}
}
public async Task <Pallet> GetPalletAsync(int id)
{
DBConnection dBConnection = new DBConnection();
ObservableCollection <Params> dbParams = new ObservableCollection <Params>();
dbParams.Add(new Params()
{
Name = "PalletId", Value = id
});
var result = dBConnection.GetQueryResult("Select * From pallet where id =@PalletId; Select * from pallet_item where pallet_id = @PalletId", dbParams);
Pallet pallet = new Pallet();
if (result != null)
{
DataTable dataTable = new DataTable();
dataTable = ((DataSet)result).Tables[1];
List <PalletItem> palletItems = new List <PalletItem>();
PalletItem palletItem = null;
for (int i = 0; i < dataTable.Rows.Count; i++)
{
palletItem = new PalletItem()
{
Id = Convert.ToInt32(dataTable.Rows[i]["id"]),
Quantity = Convert.ToString(dataTable.Rows[i]["quantity"]),
Barcode = Convert.ToString(dataTable.Rows[i]["barcode"]),
Description = Convert.ToString(dataTable.Rows[i]["description"]),
Outer = Convert.ToString(dataTable.Rows[i]["outer"]),
Inner = Convert.ToString(dataTable.Rows[i]["inner"]),
WrapperName = Convert.ToString(dataTable.Rows[i]["wrapper_name"]),
Palletid = Convert.ToInt32(dataTable.Rows[i]["pallet_id"])
};
palletItems.Add(palletItem);
}
;
dataTable = ((DataSet)result).Tables[0];
for (int i = 0; i < dataTable.Rows.Count; i++)
{
pallet = new Pallet()
{
Id = Convert.ToInt32(dataTable.Rows[i]["id"]),
Status = Convert.ToString(dataTable.Rows[i]["status"]),
WrappedDate = Convert.ToString(dataTable.Rows[i]["wrapped_date"]),
SentDate = Convert.ToString(dataTable.Rows[i]["sent_date"]),
FreightCompany = Convert.ToString(dataTable.Rows[i]["freight_company"]),
ConNumber = Convert.ToString(dataTable.Rows[i]["con_number"]),
PackedBy = Convert.ToString(dataTable.Rows[i]["packed_by"]),
OtherNotes = Convert.ToString(dataTable.Rows[i]["other_notes"]),
ReceivedDate = Convert.ToString(dataTable.Rows[i]["received_date"]),
ReceivedBy = Convert.ToString(dataTable.Rows[i]["received_by"]),
StoreId = Convert.ToInt32(dataTable.Rows[i]["store_id"]),
Contents = Convert.ToString(dataTable.Rows[i]["Contents"]),
WrappedBy = Convert.ToString(dataTable.Rows[i]["wrapped_by"]),
BuiltBy = Convert.ToString(dataTable.Rows[i]["built_by"]),
Category = Convert.ToString(dataTable.Rows[i]["category"]),
PalletType = Convert.ToString(dataTable.Rows[i]["pallet_type"]),
Weight = Convert.ToString(dataTable.Rows[i]["weight"]),
Supplier = Convert.ToString(dataTable.Rows[i]["supplier"]),
PalletItem = palletItems
};
}
;
}
return(await Task.FromResult(pallet));
}
