private void ScanBarcode()
{
if (txtbarcode.Text != string.Empty)
{
int orderid = Convert.ToInt16(txtorderid.Text);
ProductReleases pr = new ProductReleases();
pr = _release.ProductReleaseFind(orderid, txtbarcode.Text);
if (pr != null)
{
lblPcode.Text = pr.productcode;
lblPid.Text = pr.product_id.ToString();
lblPname.Text = pr.ProductName;
txtqty.Text = pr.QTY.ToString();
if (_release.isItemExists(orderid, pr.sales_detail_id) == false)
{
ReleaseItem(pr);
}
else
{
MessageBox.Show("Item already released");
}
}
else
{
MessageBox.Show("Item not found");
}
}
txtbarcode.Text = string.Empty;
txtqty.Text = string.Empty;
LoadProducts();
}
private void ReleaseItem(ProductReleases pr)
{
bool result = _release.ProductRelease(pr.sales_detail_id, pr.product_id.Value, pr.QTY.Value, true);
if (result == true)
{
int qtys = Convert.ToInt16(txtqty.Text);
_release.ReleaseItemInsert(pr.sales_detail_id, pr.sales_id.Value, qtys);
loadReleasedLists();
}
}
public ProductReleases ProductReleaseFind(int salesid, string barcode)
{
trn_transactionsales_product_details_Result trx = pEntity.trn_transactionsales_product_details(salesid, barcode).FirstOrDefault();
ProductReleases result = new ProductReleases();
if (trx != null)
{
result.Barcode = trx.Barcode;
result.productcode = trx.productcode;
result.ProductName = trx.ProductName;
result.product_id = trx.product_id;
result.QTY = trx.QTY;
result.TotalAmount = trx.TotalAmount;
result.sales_detail_id = trx.sales_detail_id;
result.sales_id = trx.sales_id;
}
else
{
result = null;
}
return(result);
}
public List <ProductReleases> ProductReleaseSelect(int salesid)
{
var trxn = pEntity.trn_transactionsales_product_details_select(salesid);
ProductReleases result = new ProductReleases();
List <ProductReleases> result2 = new List <ProductReleases>();
foreach (trn_transactionsales_product_details_select_Result trx in trxn)
{
result.Barcode = trx.Barcode;
result.productcode = trx.productcode;
result.ProductName = trx.ProductName;
result.product_id = trx.product_id;
result.QTY = trx.QTY;
result.RetailPrice = trx.RetailPrice;
result.TotalAmount = trx.TotalAmount;
result.isCheckedout = trx.isCheckedout;
result.sales_detail_id = trx.sales_detail_id;
result.sales_id = trx.sales_id;
result2.Add(result);
}
return(result2);
}
/// <summary>
/// Update the target database to the latest version of the product.
/// </summary>
/// <returns>True if the Update was from a "clean" install.</returns>
private bool Update()
{
// Get the currently installed version of the product.
var currentVersion = GetCurrentlyInstalledVersion(Context.TargetDatabaseConnectionString);
// Log some Information
_log.Info("Current Version: " + currentVersion);
_log.Info("Target Version: " + ProductVersion);
// Figure out what is going on.
var isNewInstall = currentVersion == new Version(0, 0, 0, 0);
var isCurrentVersion = ProductVersion == currentVersion;
var isNewerVersion = currentVersion > ProductVersion;
// Just in Case
if (isNewerVersion)
{
throw new Exception("The version of the system (" + currentVersion + ") is newer than this installation (" + ProductVersion +
"). Please contact your system administrator.");
}
// Gather any Releases that have not been applied yet.
var pendingUpdates = ProductReleases
.Where(x => x.Version > currentVersion)
.ToList();
#region Inform the User
// Log some Information
if (isNewInstall)
{
_log.Info("Beginning new product installation.");
}
else
{
// We ain't illiterate...
switch (pendingUpdates.Count)
{
case 0:
// We are running against a server that is already on the latest product version.
_log.Info("Current version is already installed.");
break;
case 1:
_log.Info("There is one pending update to apply.");
break;
default:
_log.Info("There are " + pendingUpdates.Count + " pending updates to apply.");
break;
}
}
#endregion
// Execute any PreUpdate Logic
PreUpdate(pendingUpdates);
// If We are Installing the Same Version over an existing Installation
// allow any pending migrations within that version to be applied.
if (isCurrentVersion && !pendingUpdates.Any())
{
// Let the user know we will attempt to apply any outstanding schema migrations
// within the current product version.
_log.Info("Checking for pending version migrations...");
// Add the latest release to the empty list of pending updates.
pendingUpdates.Add(ProductReleases.First(x => x.Version == ProductVersion));
}
// Apply the pending releases in version order.
foreach (var update in pendingUpdates.OrderBy(x => x.Version))
{
update.Apply();
}
// Execute any PostUpdate Logic
PostUpdate(isNewInstall);
// Return true if the original version was 0.
return(isNewInstall);
}
