private void PopulateItems()
{
Item itm = new Item();
itm.GetItemByPrimaryKey(this._itemID);
if (itm.IsColumnNull("StorageTypeID"))
{
itm.StorageTypeID = 1;
itm.Save();
}
if (itm.StorageTypeID.ToString() == StorageType.BulkStore && !itm.IsColumnNull("IsStackStored") && itm.IsStackStored)
{
layoutStackedView.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
}
else
layoutStackedView.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
lblItemName.Text = itm.FullItemName;
BLL.ItemManufacturer imfr = new BLL.ItemManufacturer();
imfr.LoadManufacturersFor(this._itemID);
lstManufacturers.DataSource = imfr.DefaultView;
itemUnit.LoadAllForItem(_itemID);
gridUnits.DataSource = itemUnit.DefaultView;
}
private void gridView1_FocusedRowChanged(object sender,
DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if(ValidateForBindingNewPalletLocation()){
DataRow dr = gridView1.GetFocusedDataRow();
//for validation
Double writeoff = 0;
Double reLocate = 0;
try
{
if (dr["WriteOff"] != DBNull.Value)
{
writeoff = Double.Parse(dr["WriteOff"].ToString());
}
if (dr["ReLocate"] != DBNull.Value)
{
reLocate = Double.Parse(dr["ReLocate"].ToString());
}
}
catch (Exception exc)
{
}
// bind data set to the repository item
try
{
if (dr["WriteOff"] != DBNull.Value && writeoff>0)
{
int palletid = int.Parse(dr["PalletID"].ToString());
PalletLocation pl = new PalletLocation();
newpalletlocationrepositoryItemGridLookUpEdit.DataSource =
pl.GetPalletLocationsOnTheSameStore(palletid);
}
else if (dr["ReLocate"] != DBNull.Value & reLocate>0)
{
Item itms = new Item();
itms.GetItemByPrimaryKey(Convert.ToInt32(dr["ItemID"]));
newpalletlocationrepositoryItemGridLookUpEdit.DataSource =
PalletLocation.GetAllFreeForIntheSameStore(Convert.ToInt32(dr["ItemID"]),
int.Parse(dr["PalletID"].ToString()));
}
else
{
newpalletlocationrepositoryItemGridLookUpEdit.DataSource = null;
}
}
catch (Exception except)
{
}
}
}
/// <summary>
/// Recommends the pallet movments.
/// </summary>
/// <returns></returns>
public DataView RecommendPalletMovments()
{
// check for each pallet in bulk store
this.LoadFromRawSql(HCMIS.Repository.Queries.PalletLocation.SelectRecommendPalletMovments(StorageType.BulkStore));
DataTable dtbl = new DataTable();
dtbl.Columns.Add("ItemID");
dtbl.Columns.Add("FullItemName");
dtbl.Columns.Add("PalletNo");
dtbl.Columns.Add("FromID");
dtbl.Columns.Add("ToID");
dtbl.Columns.Add("From");
dtbl.Columns.Add("To");
int itemID = 0;
int freePreferedLocationCount = 0;
Item itms = new Item();
bool checkable = false;
PalletLocation pl = new PalletLocation();
while (!this.EOF)
{
if (Convert.ToInt32(this.DataRow["ItemID"]) != itemID)
{
itemID = Convert.ToInt32(this.DataRow["ItemID"]);
// do this if this item is a bulk storage
itms.GetItemByPrimaryKey(itemID);
if (itms.StorageTypeID.ToString() == StorageType.BulkStore)
{
checkable = true;
pl.LoadFreePrefferedLocationFor(itemID);
freePreferedLocationCount = pl.RowCount;
}
else
{
checkable = false;
}
}
if (checkable && freePreferedLocationCount > 0)
{
//add it to the table
DataRowView drv = dtbl.DefaultView.AddNew();
drv["ItemID"] = itemID;
drv["FullItemName"] = itms.FullItemName;
drv["FromID"] = this.ID;
drv["ToID"] = pl.ID;
Pallet pallet = new Pallet();
pallet.LoadByPrimaryKey(this.PalletID);
drv["PalletNo"] = pallet.PalletNo;
pl.MoveNext();
freePreferedLocationCount--;
drv["From"] = this.FullName;
drv["To"] = pl.FullName;
}
this.MoveNext();
}
return dtbl.DefaultView;
}