public Int64 InsertBaseVariation(ProductSubGroupBaseVariationsMatrixDetails Details)
{
try
{
ProductSubGroupBaseVariationsMatrix clsProductSubGroupBaseVariationsMatrix = new ProductSubGroupBaseVariationsMatrix(base.Connection, base.Transaction);
return clsProductSubGroupBaseVariationsMatrix.Insert(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private bool SaveRecord()
{
ProductSubGroupVariationsMatrixDetails clsDetails;
ProductSubGroupVariationsMatrix clsProductSubGroupVariationsMatrix = new ProductSubGroupVariationsMatrix();
string stringVariationDesc = null;
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
clsDetails = new ProductSubGroupVariationsMatrixDetails();
clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsDetails.SubGroupID = Convert.ToInt64(lblSubGroupID.Text);
clsDetails.VariationID = Convert.ToInt32(chkList.Value);
clsDetails.Description = txtDescription.Text;
if (clsProductSubGroupVariationsMatrix.IsVariationExists(clsDetails.MatrixID, clsDetails.VariationID) == false)
{
clsProductSubGroupVariationsMatrix.InsertVariation(clsDetails);
}
else
{
clsProductSubGroupVariationsMatrix.Update(clsDetails);
}
HyperLink lnkVariationType = (HyperLink)item.FindControl("lnkVariationType");
stringVariationDesc += txtDescription.Text + "; ";
}
//update base variation matrix
ProductSubGroupBaseVariationsMatrixDetails clsBaseDetails = new ProductSubGroupBaseVariationsMatrixDetails();
clsBaseDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsBaseDetails.SubGroupID = Convert.ToInt64(lblSubGroupID.Text);
clsBaseDetails.Description = stringVariationDesc;
clsBaseDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value);
clsBaseDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsBaseDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsBaseDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsBaseDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsBaseDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsBaseDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsProductSubGroupVariationsMatrix.UpdateBaseVariation(clsBaseDetails);
clsProductSubGroupVariationsMatrix.CommitAndDispose();
return(true);
}
private void LoadRecord()
{
ProductSubGroupVariationsMatrix clsProductSubGroupVariationsMatrix = new ProductSubGroupVariationsMatrix();
ProductSubGroupBaseVariationsMatrixDetails clsBaseDetails = clsProductSubGroupVariationsMatrix.BaseDetails(Convert.ToInt32(lblMatrixID.Text), Convert.ToInt32(lblSubGroupID.Text));
clsProductSubGroupVariationsMatrix.CommitAndDispose();
cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsBaseDetails.UnitID.ToString()));
txtProductPrice.Text = clsBaseDetails.Price.ToString("#,##0.#0");
txtPurchasePrice.Text = clsBaseDetails.PurchasePrice.ToString("#,##0.#0");
chkIncludeInSubtotalDiscount.Checked = clsBaseDetails.IncludeInSubtotalDiscount;
txtVAT.Text = clsBaseDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsBaseDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsBaseDetails.LocalTax.ToString("#,##0.#0");
}
public bool UpdateBaseVariation(ProductSubGroupBaseVariationsMatrixDetails Details)
{
try
{
ProductSubGroupBaseVariationsMatrix clsProductSubGroupBaseVariationsMatrix = new ProductSubGroupBaseVariationsMatrix(base.Connection, base.Transaction);
clsProductSubGroupBaseVariationsMatrix.Update(Details);
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductSubGroupBaseVariationsMatrixDetails BaseDetails(Int64 MatrixID, Int64 SubGroupID)
{
try
{
string SQL= "SELECT " +
"MatrixID, " +
"SubGroupID, " +
"description, " +
"a.UnitID, " +
"b.UnitName, " +
"a.Price, " +
"a.PurchasePrice, " +
"a.IncludeInSubtotalDiscount, " +
"a.VAT, " +
"a.EVAT, " +
"a.LocalTax " +
"FROM tblProductSubGroupBaseVariationsMatrix a INNER JOIN " +
"tblUnit b ON a.UnitID = b.UnitID " +
"WHERE MatrixID = @MatrixID AND a.SubGroupID = @SubGroupID;";
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);
MySqlParameter prmSubGroupID = new MySqlParameter("@SubGroupID",MySqlDbType.Int64);
prmSubGroupID.Value = SubGroupID;
cmd.Parameters.Add(prmSubGroupID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
ProductSubGroupBaseVariationsMatrixDetails Details = new ProductSubGroupBaseVariationsMatrixDetails();
while (myReader.Read())
{
Details.MatrixID = myReader.GetInt64("MatrixID");
Details.SubGroupID = myReader.GetInt64("SubGroupID");
Details.Description = "" + myReader["Description"].ToString();
Details.UnitID = myReader.GetInt32("UnitID");
Details.UnitName = "" + myReader["UnitName"].ToString();
Details.Price = myReader.GetDecimal("Price");
Details.PurchasePrice = myReader.GetDecimal("PurchasePrice");
Details.IncludeInSubtotalDiscount = myReader.GetBoolean("IncludeInSubtotalDiscount");
Details.VAT = myReader.GetDecimal("VAT");
Details.EVAT = myReader.GetDecimal("EVAT");
Details.LocalTax = myReader.GetDecimal("LocalTax");
}
myReader.Close();
return Details;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void InheritGroupVariationsMatrix(Int64 ProductGroupID, Int64 ProductSubGroupID)
{
try
{
ProductSubGroupBaseVariationsMatrixDetails clsSubGroupBaseDetails;
ProductGroupVariationsMatrix clsProductGroupVariationsMatrix = new ProductGroupVariationsMatrix(base.Connection, base.Transaction);
ProductSubGroupVariationsMatrix clsProductSubGroupVariationsMatrix = new ProductSubGroupVariationsMatrix(base.Connection, base.Transaction);
ProductSubGroupVariationsMatrixDetails clsProductSubGroupVariationsMatrixDetails = new ProductSubGroupVariationsMatrixDetails();
MySqlDataReader clsProductGroupVariationsMatrixList;
MySqlDataReader clsProductGroupBaseVariationsMatrixList = clsProductGroupVariationsMatrix.BaseList(ProductGroupID,"MatrixID",SortOption.Ascending);
Int64 GroupBaseMatrixID = 0;
while (clsProductGroupBaseVariationsMatrixList.Read())
{
clsSubGroupBaseDetails = new ProductSubGroupBaseVariationsMatrixDetails();
clsSubGroupBaseDetails.SubGroupID = ProductSubGroupID;
clsSubGroupBaseDetails.Description = "" + clsProductGroupBaseVariationsMatrixList["Description"].ToString();
clsSubGroupBaseDetails.UnitID = Convert.ToInt32(clsProductGroupBaseVariationsMatrixList["UnitID"]);
clsSubGroupBaseDetails.Price = Convert.ToDecimal(clsProductGroupBaseVariationsMatrixList["Price"]);
clsSubGroupBaseDetails.PurchasePrice = Convert.ToDecimal(clsProductGroupBaseVariationsMatrixList["PurchasePrice"]);
clsSubGroupBaseDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(clsProductGroupBaseVariationsMatrixList["IncludeInSubtotalDiscount"]);
clsSubGroupBaseDetails.VAT = Convert.ToDecimal(clsProductGroupBaseVariationsMatrixList["VAT"]);
clsSubGroupBaseDetails.EVAT = Convert.ToDecimal(clsProductGroupBaseVariationsMatrixList["EVAT"]);
clsSubGroupBaseDetails.LocalTax = Convert.ToDecimal(clsProductGroupBaseVariationsMatrixList["LocalTax"]);
clsSubGroupBaseDetails.MatrixID = clsProductSubGroupVariationsMatrix.InsertBaseVariation(clsSubGroupBaseDetails);
GroupBaseMatrixID = clsProductGroupBaseVariationsMatrixList.GetInt64(0);
clsProductGroupVariationsMatrix = new ProductGroupVariationsMatrix(base.Connection, base.Transaction);
clsProductGroupVariationsMatrixList = clsProductGroupVariationsMatrix.List(GroupBaseMatrixID);
while (clsProductGroupVariationsMatrixList.Read())
{
clsProductSubGroupVariationsMatrixDetails = new ProductSubGroupVariationsMatrixDetails();
clsProductSubGroupVariationsMatrixDetails.MatrixID = clsSubGroupBaseDetails.MatrixID;
clsProductSubGroupVariationsMatrixDetails.SubGroupID = ProductSubGroupID;
clsProductSubGroupVariationsMatrixDetails.VariationID = Convert.ToInt32(clsProductGroupVariationsMatrixList["VariationID"]);
clsProductSubGroupVariationsMatrixDetails.Description = "" + clsProductGroupVariationsMatrixList["Description"].ToString();
clsProductSubGroupVariationsMatrix.InsertVariation(clsProductSubGroupVariationsMatrixDetails);
}
clsProductGroupVariationsMatrixList.Close();
}
clsProductGroupBaseVariationsMatrixList.Close();
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
private bool SaveRecord()
{
ProductSubGroupVariationsMatrixDetails clsDetails;
ProductSubGroupVariationsMatrix clsProductSubGroupVariationsMatrix = new ProductSubGroupVariationsMatrix();
string stringVariationDesc = null;
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList");
TextBox txtDescription = (TextBox) item.FindControl("txtDescription");
clsDetails = new ProductSubGroupVariationsMatrixDetails();
clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsDetails.SubGroupID = Convert.ToInt64(lblSubGroupID.Text);
clsDetails.VariationID = Convert.ToInt32(chkList.Value);
clsDetails.Description = txtDescription.Text;
if (clsProductSubGroupVariationsMatrix.IsVariationExists(clsDetails.MatrixID, clsDetails.VariationID) == false)
{
clsProductSubGroupVariationsMatrix.InsertVariation(clsDetails);
}
else
{
clsProductSubGroupVariationsMatrix.Update(clsDetails);
}
HyperLink lnkVariationType = (HyperLink)item.FindControl("lnkVariationType");
stringVariationDesc += txtDescription.Text + "; ";
}
//update base variation matrix
ProductSubGroupBaseVariationsMatrixDetails clsBaseDetails = new ProductSubGroupBaseVariationsMatrixDetails();
clsBaseDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsBaseDetails.SubGroupID = Convert.ToInt64(lblSubGroupID.Text);
clsBaseDetails.Description = stringVariationDesc;
clsBaseDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value);
clsBaseDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsBaseDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsBaseDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsBaseDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsBaseDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsBaseDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsProductSubGroupVariationsMatrix.UpdateBaseVariation(clsBaseDetails);
clsProductSubGroupVariationsMatrix.CommitAndDispose();
return true;
}
