public void ResizeProductLabel()
{
var Length = ProductUnitPrice.ToString().Length;
Size cardSize = card_PriceBG.Size;
Point cardLocation = card_PriceBG.Location;
if (Length >= 3)
{
//LongLabel
cardSize = new Size(77, 29);
cardLocation = new Point(99, 10);
}
else if (Length == 2)
{
//ShortLabel
cardSize = new Size(60, 29);
cardLocation = new Point(116, 10);
}
else if (Length < 2)
{
//NormalLabel
cardSize = new Size(37, 29);
cardLocation = new Point(139, 10);
}
card_PriceBG.Size = cardSize;
card_PriceBG.Location = cardLocation;
}
public static bool Update(ProductUnitPrice objProductUnitPrice)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
Boolean chk = false;
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 9);
param[0] = dbManager.getparam("@PSPID", objProductUnitPrice.PSPID);
param[1] = dbManager.getparam("@ProductID", objProductUnitPrice.ProductID);
param[2] = dbManager.getparam("@UnitID", objProductUnitPrice.UnitID);
param[3] = dbManager.getparam("@UnitQty", objProductUnitPrice.UnitQty);
param[4] = dbManager.getparam("@Price", objProductUnitPrice.Price);
param[5] = dbManager.getparam("@ActivityID", objProductUnitPrice.ActivityID);
param[6] = dbManager.getparam("@IsMinimumUnit", objProductUnitPrice.IsMinimumUnit);
param[7] = dbManager.getparam("@UpdatedBy", objProductUnitPrice.UpdatedBy);
param[8] = dbManager.getparam("@WholeSalePrice", objProductUnitPrice.WholeSalePrice);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "dbo.USP_ProductSalesPrice_Update", param);
chk = dbManager.ExecuteQuery(cmd);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
finally
{
dbManager.Dispose();
}
return(chk);
}
public static bool UpdateIsMinimumUnitFalse(ProductUnitPrice objProductUnitPrice)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
Boolean chk = false;
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 2);
param[0] = dbManager.getparam("@ProductID", objProductUnitPrice.ProductID);
param[1] = dbManager.getparam("@UpdatedBy", objProductUnitPrice.UpdatedBy);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "dbo.USP_updateIsMinimumUnitFalse", param);
chk = dbManager.ExecuteQuery(cmd);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
return(false);
}
finally
{
dbManager.Dispose();
}
return(chk);
}
public static DataTable Insert(ProductUnitPrice objProductUnitPrice)
{
ISalesPOSDBManager dbManager = new SalesPOSDBManager();
DataTable dt = new DataTable();
try
{
dbManager.Open();
IDbDataParameter[] param = SalesPOSDBManagerFactory.GetParameters(dbManager.ProviderType, 9);
param[0] = dbManager.getparam("@ProductID", objProductUnitPrice.ProductID);
param[1] = dbManager.getparam("@UnitID", objProductUnitPrice.UnitID);
param[2] = dbManager.getparam("@UnitQty", objProductUnitPrice.UnitQty);
param[3] = dbManager.getparam("@Price", objProductUnitPrice.Price);
param[4] = dbManager.getparam("@ActivityID", objProductUnitPrice.ActivityID);
param[5] = dbManager.getparam("@IsMinimumUnit", objProductUnitPrice.IsMinimumUnit);
param[6] = dbManager.getparam("@CreatedBy", objProductUnitPrice.CreatedBy);
param[7] = dbManager.getparam("@pk_code", "");
param[8] = dbManager.getparam("@WholeSalePrice", objProductUnitPrice.WholeSalePrice);
IDbCommand cmd = dbManager.getCommand(CommandType.StoredProcedure, "dbo.USP_ProductSalesPrice_Add", param);
dt = dbManager.GetDataTable(cmd);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
//return false;
}
finally
{
dbManager.Dispose();
}
return(dt);
}