public Int64 Insert(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
Save(Details);
string SQL = "SELECT LAST_INSERT_ID();";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
Save(Details);
string SQL = "SELECT LAST_INSERT_ID();";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
string SQL = "CALL procSaveProductGroupBaseVariationsMatrix(@MatrixID, @GroupID, @Description, @UnitID," +
"@Price, @PurchasePrice, @IncludeInSubtotalDiscount," +
"@VAT, @EVAT, @LocalTax, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("Description", Details.Description);
cmd.Parameters.AddWithValue("UnitID", Details.UnitID);
cmd.Parameters.AddWithValue("Price", Details.Price);
cmd.Parameters.AddWithValue("PurchasePrice", Details.PurchasePrice);
cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount);
cmd.Parameters.AddWithValue("VAT", Details.VAT);
cmd.Parameters.AddWithValue("EVAT", Details.EVAT);
cmd.Parameters.AddWithValue("LocalTax", Details.LocalTax);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public bool UpdateVariationDesc(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
string SQL = "UPDATE tblProductGroupBaseVariationsMatrix SET " +
"Description = @Description " +
"WHERE GroupID = @GroupID AND MatrixID = @MatrixID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("@Description", Details.Description);
base.ExecuteNonQuery(cmd);
return(true);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 InsertBaseVariation(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
ProductGroupBaseVariationsMatrix clsProductGroupBaseVariationsMatrix = new ProductGroupBaseVariationsMatrix(base.Connection, base.Transaction);
return(clsProductGroupBaseVariationsMatrix.Insert(Details));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 InsertBaseVariation(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
ProductGroupBaseVariationsMatrix clsProductGroupBaseVariationsMatrix = new ProductGroupBaseVariationsMatrix(base.Connection, base.Transaction);
return clsProductGroupBaseVariationsMatrix.Insert(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public bool Update(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
Save(Details);
return(true);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public bool UpdateBaseVariation(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
ProductGroupBaseVariationsMatrix clsProductGroupBaseVariationsMatrix = new ProductGroupBaseVariationsMatrix(base.Connection, base.Transaction);
clsProductGroupBaseVariationsMatrix.Update(Details);
return(true);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public bool Update(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
Save(Details);
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductGroupBaseVariationsMatrixDetails BaseDetails(Int64 MatrixID, Int64 GroupID)
{
try
{
string SQL= "SELECT " +
"MatrixID, " +
"GroupID, " +
"description, " +
"a.UnitID, " +
"b.UnitName, " +
"a.Price, " +
"a.PurchasePrice, " +
"a.IncludeInSubtotalDiscount, " +
"a.VAT, " +
"a.EVAT, " +
"a.LocalTax " +
"FROM tblProductGroupBaseVariationsMatrix a INNER JOIN " +
"tblUnit b ON a.UnitID = b.UnitID " +
"WHERE MatrixID = @MatrixID AND GroupID = @GroupID;";
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 prmGroupID = new MySqlParameter("@GroupID",MySqlDbType.Int64);
prmGroupID.Value = GroupID;
cmd.Parameters.Add(prmGroupID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
ProductGroupBaseVariationsMatrixDetails Details = new ProductGroupBaseVariationsMatrixDetails();
while (myReader.Read())
{
Details.MatrixID =myReader.GetInt64("MatrixID");
Details.GroupID = myReader.GetInt64("GroupID");
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 Int32 Save(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
string SQL = "CALL procSaveProductGroupBaseVariationsMatrix(@MatrixID, @GroupID, @Description, @UnitID," +
"@Price, @PurchasePrice, @IncludeInSubtotalDiscount," +
"@VAT, @EVAT, @LocalTax, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("Description", Details.Description);
cmd.Parameters.AddWithValue("UnitID", Details.UnitID);
cmd.Parameters.AddWithValue("Price", Details.Price);
cmd.Parameters.AddWithValue("PurchasePrice", Details.PurchasePrice);
cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount);
cmd.Parameters.AddWithValue("VAT", Details.VAT);
cmd.Parameters.AddWithValue("EVAT", Details.EVAT);
cmd.Parameters.AddWithValue("LocalTax", Details.LocalTax);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public bool UpdateVariationDesc(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
string SQL = "UPDATE tblProductGroupBaseVariationsMatrix SET " +
"Description = @Description " +
"WHERE GroupID = @GroupID AND MatrixID = @MatrixID;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@GroupID", Details.GroupID);
cmd.Parameters.AddWithValue("@MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("@Description", Details.Description);
base.ExecuteNonQuery(cmd);
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private bool SaveRecord()
{
ProductGroupVariationsMatrixDetails clsDetails;
ProductGroupVariationsMatrix clsProductGroupVariationsMatrix = new ProductGroupVariationsMatrix();
string stringVariationDesc = null;
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox) item.FindControl("chkList");
TextBox txtDescription = (TextBox) item.FindControl("txtDescription");
clsDetails = new ProductGroupVariationsMatrixDetails();
clsDetails.MatrixID = Convert.ToInt32(lblMatrixID.Text);
clsDetails.GroupID = Convert.ToInt32(lblGroupID.Text);
clsDetails.VariationID = Convert.ToInt32(chkList.Value);
clsDetails.Description = txtDescription.Text;
if (clsProductGroupVariationsMatrix.IsVariationExists(clsDetails.MatrixID, clsDetails.VariationID) == false)
{
clsProductGroupVariationsMatrix.InsertVariation(clsDetails);
}
else
{
clsProductGroupVariationsMatrix.UpdateVariation(clsDetails);
}
//Label lblVariationType = (Label) item.FindControl("lblVariationType");
//stringVariationDesc += lblVariationType.Text + ":" + txtDescription.Text + "; ";
stringVariationDesc += txtDescription.Text + "; ";
}
//update the base variation matrix
ProductGroupBaseVariationsMatrixDetails clsBaseDetails = new ProductGroupBaseVariationsMatrixDetails();
clsBaseDetails.MatrixID = Convert.ToInt32(lblMatrixID.Text);
clsBaseDetails.GroupID = Convert.ToInt32(lblGroupID.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 = Convert.ToBoolean(chkIncludeInSubtotalDiscount.Checked);
clsBaseDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsBaseDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsBaseDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsProductGroupVariationsMatrix.UpdateBaseVariation(clsBaseDetails);
clsProductGroupVariationsMatrix.CommitAndDispose();
return true;
}
public ProductGroupBaseVariationsMatrixDetails BaseDetails(Int64 MatrixID, Int64 GroupID)
{
try
{
string SQL = "SELECT " +
"MatrixID, " +
"GroupID, " +
"description, " +
"a.UnitID, " +
"b.UnitName, " +
"a.Price, " +
"a.PurchasePrice, " +
"a.IncludeInSubtotalDiscount, " +
"a.VAT, " +
"a.EVAT, " +
"a.LocalTax " +
"FROM tblProductGroupBaseVariationsMatrix a INNER JOIN " +
"tblUnit b ON a.UnitID = b.UnitID " +
"WHERE MatrixID = @MatrixID AND GroupID = @GroupID;";
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 prmGroupID = new MySqlParameter("@GroupID", MySqlDbType.Int64);
prmGroupID.Value = GroupID;
cmd.Parameters.Add(prmGroupID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
ProductGroupBaseVariationsMatrixDetails Details = new ProductGroupBaseVariationsMatrixDetails();
while (myReader.Read())
{
Details.MatrixID = myReader.GetInt64("MatrixID");
Details.GroupID = myReader.GetInt64("GroupID");
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 bool UpdateBaseVariation(ProductGroupBaseVariationsMatrixDetails Details)
{
try
{
ProductGroupBaseVariationsMatrix clsProductGroupBaseVariationsMatrix = new ProductGroupBaseVariationsMatrix(base.Connection, base.Transaction);
clsProductGroupBaseVariationsMatrix.Update(Details);
return true;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
