public void Update(MatrixPackageDetails Details, long pvtUID, DateTime pvtChangeDate, string pvtHistoryRemarks)
{
try
{
// Update MatrixPackagePriceHistory first to get the history
MatrixPackagePriceHistoryDetails clsMatrixPackagePriceHistoryDetails = new MatrixPackagePriceHistoryDetails();
clsMatrixPackagePriceHistoryDetails.UID = pvtUID;
clsMatrixPackagePriceHistoryDetails.PackageID = Details.PackageID;
clsMatrixPackagePriceHistoryDetails.ChangeDate = pvtChangeDate;
clsMatrixPackagePriceHistoryDetails.PurchasePrice = Details.PurchasePrice;
clsMatrixPackagePriceHistoryDetails.Price = Details.Price;
clsMatrixPackagePriceHistoryDetails.VAT = Details.VAT;
clsMatrixPackagePriceHistoryDetails.EVAT = Details.EVAT;
clsMatrixPackagePriceHistoryDetails.LocalTax = Details.LocalTax;
clsMatrixPackagePriceHistoryDetails.Remarks = pvtHistoryRemarks;
MatrixPackagePriceHistory clsMatrixPackagePriceHistory = new MatrixPackagePriceHistory(base.Connection, base.Transaction);
clsMatrixPackagePriceHistory.Insert(clsMatrixPackagePriceHistoryDetails);
string SQL = "CALL procMatrixPackageUpdate(@PackageID, @MatrixID, @UnitID, @Price, @WSPrice, @PurchasePrice, @Quantity, @VAT, @EVAT, @LocalTax);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@PackageID", Details.PackageID);
cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("@UnitID", Details.UnitID);
cmd.Parameters.AddWithValue("@Price", Details.Price);
cmd.Parameters.AddWithValue("@WSPrice", Details.WSPrice);
cmd.Parameters.AddWithValue("@PurchasePrice", Details.PurchasePrice);
cmd.Parameters.AddWithValue("@Quantity", Details.Quantity);
cmd.Parameters.AddWithValue("@VAT", Details.VAT);
cmd.Parameters.AddWithValue("@EVAT", Details.EVAT);
cmd.Parameters.AddWithValue("@LocalTax", Details.LocalTax);
base.ExecuteNonQuery(cmd);
if (Details.Quantity == 1)
{
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
//clsProductVariationsMatrix.UpdateByPackage(Details.MatrixID, Details.UnitID, Details.Price, Details.WSPrice, Details.PurchasePrice, Details.VAT, Details.EVAT, Details.LocalTax);
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public MatrixPackageDetails DetailsByMatrixID(Int64 MatrixID)
{
try
{
string SQL = SQLSelect() + "WHERE 1=1 AND a.MatrixID = @MatrixID LIMIT 1;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID", MySqlDbType.Int64);
prmMatrixID.Value = MatrixID;
cmd.Parameters.Add(prmMatrixID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
MatrixPackageDetails clsDetails = new MatrixPackageDetails();;
while (myReader.Read())
{
clsDetails.PackageID = myReader.GetInt64("PackageID");
clsDetails.MatrixID = myReader.GetInt64("MatrixID");
clsDetails.UnitID = myReader.GetInt32("UnitID");
clsDetails.UnitCode = "" + myReader["UnitCode"].ToString();
clsDetails.UnitName = "" + myReader["UnitName"].ToString();
clsDetails.Price = myReader.GetDecimal("Price");
clsDetails.WSPrice = myReader.GetDecimal("WSPrice");
clsDetails.PurchasePrice = myReader.GetDecimal("PurchasePrice");
clsDetails.Quantity = myReader.GetDecimal("Quantity");
clsDetails.VAT = myReader.GetDecimal("VAT");
clsDetails.EVAT = myReader.GetDecimal("EVAT");
clsDetails.LocalTax = myReader.GetDecimal("LocalTax");
}
myReader.Close();
return(clsDetails);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void UpdateByMatrixIDUnitIDAndQuantity(MatrixPackageDetails Details, long pvtUID, DateTime pvtChangeDate, string pvtHistoryRemarks)
{
try
{
string SQL = "SELECT PackageID FROM tblMatrixPackage WHERE MatrixID = @MatrixID " +
"AND UnitID = @UnitID "+
"AND Quantity = @Quantity;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("@UnitID", Details.MatrixID);
cmd.Parameters.AddWithValue("@Quantity", Details.Quantity);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
while (myReader.Read())
{
Details.PackageID = myReader.GetInt64("PackageID");
}
myReader.Close();
Update(Details, pvtUID, pvtChangeDate, pvtHistoryRemarks);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public MatrixPackageDetails DetailsByMatrixID(Int64 MatrixID)
{
try
{
string SQL = SQLSelect() + "WHERE 1=1 AND a.MatrixID = @MatrixID LIMIT 1;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID", MySqlDbType.Int64);
prmMatrixID.Value = MatrixID;
cmd.Parameters.Add(prmMatrixID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
MatrixPackageDetails clsDetails = new MatrixPackageDetails(); ;
while (myReader.Read())
{
clsDetails.PackageID = myReader.GetInt64("PackageID");
clsDetails.MatrixID = myReader.GetInt64("MatrixID");
clsDetails.UnitID = myReader.GetInt32("UnitID");
clsDetails.UnitCode = "" + myReader["UnitCode"].ToString();
clsDetails.UnitName = "" + myReader["UnitName"].ToString();
clsDetails.Price = myReader.GetDecimal("Price");
clsDetails.WSPrice = myReader.GetDecimal("WSPrice");
clsDetails.PurchasePrice = myReader.GetDecimal("PurchasePrice");
clsDetails.Quantity = myReader.GetDecimal("Quantity");
clsDetails.VAT = myReader.GetDecimal("VAT");
clsDetails.EVAT = myReader.GetDecimal("EVAT");
clsDetails.LocalTax = myReader.GetDecimal("LocalTax");
}
myReader.Close();
return clsDetails;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void UpdateByMatrixIDUnitIDAndQuantity(MatrixPackageDetails Details, long pvtUID, DateTime pvtChangeDate, string pvtHistoryRemarks)
{
try
{
string SQL = "SELECT PackageID FROM tblMatrixPackage WHERE MatrixID = @MatrixID " +
"AND UnitID = @UnitID " +
"AND Quantity = @Quantity;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("@UnitID", Details.MatrixID);
cmd.Parameters.AddWithValue("@Quantity", Details.Quantity);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
while (myReader.Read())
{ Details.PackageID = myReader.GetInt64("PackageID"); }
myReader.Close();
Update(Details, pvtUID, pvtChangeDate, pvtHistoryRemarks);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void Update(MatrixPackageDetails Details, long pvtUID, DateTime pvtChangeDate, string pvtHistoryRemarks)
{
try
{
// Update MatrixPackagePriceHistory first to get the history
MatrixPackagePriceHistoryDetails clsMatrixPackagePriceHistoryDetails = new MatrixPackagePriceHistoryDetails();
clsMatrixPackagePriceHistoryDetails.UID = pvtUID;
clsMatrixPackagePriceHistoryDetails.PackageID = Details.PackageID;
clsMatrixPackagePriceHistoryDetails.ChangeDate = pvtChangeDate;
clsMatrixPackagePriceHistoryDetails.PurchasePrice = Details.PurchasePrice;
clsMatrixPackagePriceHistoryDetails.Price = Details.Price;
clsMatrixPackagePriceHistoryDetails.VAT = Details.VAT;
clsMatrixPackagePriceHistoryDetails.EVAT = Details.EVAT;
clsMatrixPackagePriceHistoryDetails.LocalTax = Details.LocalTax;
clsMatrixPackagePriceHistoryDetails.Remarks = pvtHistoryRemarks;
MatrixPackagePriceHistory clsMatrixPackagePriceHistory = new MatrixPackagePriceHistory(base.Connection, base.Transaction);
clsMatrixPackagePriceHistory.Insert(clsMatrixPackagePriceHistoryDetails);
string SQL = "CALL procMatrixPackageUpdate(@PackageID, @MatrixID, @UnitID, @Price, @WSPrice, @PurchasePrice, @Quantity, @VAT, @EVAT, @LocalTax);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@PackageID", Details.PackageID);
cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("@UnitID", Details.UnitID);
cmd.Parameters.AddWithValue("@Price", Details.Price);
cmd.Parameters.AddWithValue("@WSPrice", Details.WSPrice);
cmd.Parameters.AddWithValue("@PurchasePrice", Details.PurchasePrice);
cmd.Parameters.AddWithValue("@Quantity", Details.Quantity);
cmd.Parameters.AddWithValue("@VAT", Details.VAT);
cmd.Parameters.AddWithValue("@EVAT", Details.EVAT);
cmd.Parameters.AddWithValue("@LocalTax", Details.LocalTax);
base.ExecuteNonQuery(cmd);
if (Details.Quantity == 1)
{
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
//clsProductVariationsMatrix.UpdateByPackage(Details.MatrixID, Details.UnitID, Details.Price, Details.WSPrice, Details.PurchasePrice, Details.VAT, Details.EVAT, Details.LocalTax);
}
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Insert(MatrixPackageDetails Details)
{
try
{
string SQL = "INSERT INTO tblMatrixPackage (" +
"MatrixID, " +
"UnitID, " +
"Price, " +
"WSPrice, " +
"PurchasePrice, " +
"Quantity, " +
"VAT, " +
"EVAT, " +
"LocalTax" +
") VALUES (" +
"@MatrixID, " +
"@UnitID, " +
"@Price, " +
"@WSPrice, " +
"@PurchasePrice, " +
"@Quantity, " +
"@VAT, " +
"@EVAT, " +
"@LocalTax" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID", MySqlDbType.Int64);
prmMatrixID.Value = Details.MatrixID;
cmd.Parameters.Add(prmMatrixID);
MySqlParameter prmUnitID = new MySqlParameter("@UnitID", MySqlDbType.Int32);
prmUnitID.Value = Details.UnitID;
cmd.Parameters.Add(prmUnitID);
cmd.Parameters.AddWithValue("@Price", Details.Price);
cmd.Parameters.AddWithValue("@WSPrice", Details.WSPrice);
cmd.Parameters.AddWithValue("@PurchasePrice", Details.PurchasePrice);
MySqlParameter prmQuantity = new MySqlParameter("@Quantity", MySqlDbType.Decimal);
prmQuantity.Value = Details.Quantity;
cmd.Parameters.Add(prmQuantity);
MySqlParameter prmVAT = new MySqlParameter("@VAT", MySqlDbType.Decimal);
prmVAT.Value = Details.VAT;
cmd.Parameters.Add(prmVAT);
MySqlParameter prmEVAT = new MySqlParameter("@EVAT", MySqlDbType.Decimal);
prmEVAT.Value = Details.EVAT;
cmd.Parameters.Add(prmEVAT);
MySqlParameter prmLocalTax = new MySqlParameter("@LocalTax", MySqlDbType.Decimal);
prmLocalTax.Value = Details.LocalTax;
cmd.Parameters.Add(prmLocalTax);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
private bool SaveRecord()
{
MatrixPackageDetails clsDetails = new MatrixPackageDetails();
clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
MatrixPackage clsMatrixPackage = new MatrixPackage();
clsMatrixPackage.Insert(clsDetails);
clsMatrixPackage.CommitAndDispose();
return true;
}
public void Insert(MatrixPackageDetails Details)
{
try
{
string SQL = "INSERT INTO tblMatrixPackage (" +
"MatrixID, " +
"UnitID, " +
"Price, " +
"WSPrice, " +
"PurchasePrice, " +
"Quantity, " +
"VAT, " +
"EVAT, " +
"LocalTax" +
") VALUES (" +
"@MatrixID, " +
"@UnitID, " +
"@Price, " +
"@WSPrice, " +
"@PurchasePrice, " +
"@Quantity, " +
"@VAT, " +
"@EVAT, " +
"@LocalTax" +
");";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmMatrixID = new MySqlParameter("@MatrixID", MySqlDbType.Int64);
prmMatrixID.Value = Details.MatrixID;
cmd.Parameters.Add(prmMatrixID);
MySqlParameter prmUnitID = new MySqlParameter("@UnitID", MySqlDbType.Int32);
prmUnitID.Value = Details.UnitID;
cmd.Parameters.Add(prmUnitID);
cmd.Parameters.AddWithValue("@Price", Details.Price);
cmd.Parameters.AddWithValue("@WSPrice", Details.WSPrice);
cmd.Parameters.AddWithValue("@PurchasePrice", Details.PurchasePrice);
MySqlParameter prmQuantity = new MySqlParameter("@Quantity", MySqlDbType.Decimal);
prmQuantity.Value = Details.Quantity;
cmd.Parameters.Add(prmQuantity);
MySqlParameter prmVAT = new MySqlParameter("@VAT", MySqlDbType.Decimal);
prmVAT.Value = Details.VAT;
cmd.Parameters.Add(prmVAT);
MySqlParameter prmEVAT = new MySqlParameter("@EVAT", MySqlDbType.Decimal);
prmEVAT.Value = Details.EVAT;
cmd.Parameters.Add(prmEVAT);
MySqlParameter prmLocalTax = new MySqlParameter("@LocalTax", MySqlDbType.Decimal);
prmLocalTax.Value = Details.LocalTax;
cmd.Parameters.Add(prmLocalTax);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
private bool SaveRecord()
{
long lngUID = long.Parse(Session["UID"].ToString());
DateTime dteChangeDate = DateTime.Now;
MatrixPackage clsMatrixPackage = new MatrixPackage();
MatrixPackageDetails clsDetails = new MatrixPackageDetails();
clsDetails.PackageID = Convert.ToInt64(lblPackageID.Text);
clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsMatrixPackage.Update(clsDetails, lngUID, dteChangeDate, "Matrix Package update.");
clsMatrixPackage.CommitAndDispose();
return true;
}