public Int32 Save(ProductSubGroupUnitsMatrixDetails Details)
{
try
{
string SQL = "CALL procSaveProductSubGroupUnitMatrix(@MatrixID, @SubGroupID, @BaseUnitID, @BaseUnitValue, " +
"@BottomUnitID, @BottomUnitValue, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("SubGroupID", Details.SubGroupID);
cmd.Parameters.AddWithValue("BaseUnitID", Details.BaseUnitID);
cmd.Parameters.AddWithValue("BaseUnitValue", Details.BaseUnitValue);
cmd.Parameters.AddWithValue("BottomUnitID", Details.BottomUnitID);
cmd.Parameters.AddWithValue("BottomUnitValue", Details.BottomUnitValue);
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 Int64 Insert(ProductSubGroupUnitsMatrixDetails 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(ProductSubGroupUnitsMatrixDetails 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 ProductSubGroupUnitsMatrixDetails LastDetails(Int64 SubGroupID)
{
try
{
string SQL = "SELECT a.MatrixID, a.SubGroupID, a.BaseUnitID, b.UnitName 'BaseUnitName', " +
"a.BaseUnitValue, a.BottomUnitID, c.UnitName 'BottomUnitName', a.BottomUnitValue " +
"FROM tblProductSubGroupUnitMatrix a INNER JOIN " +
"tblUnit b ON a.BaseUnitID = b.UnitID INNER JOIN " +
"tblUnit c ON a.BottomUnitID = c.UnitID LEFT OUTER JOIN " +
"tblProductSubGroup d ON a.SubGroupID = d.ProductSubGroupID " +
"WHERE a.SubGroupID = @SubGroupID " +
"ORDER BY a.MatrixID DESC LIMIT 1;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmSubGroupID = new MySqlParameter("@SubGroupID", MySqlDbType.Int64);
prmSubGroupID.Value = SubGroupID;
cmd.Parameters.Add(prmSubGroupID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
ProductSubGroupUnitsMatrixDetails Details = new ProductSubGroupUnitsMatrixDetails();
while (myReader.Read())
{
Details.MatrixID = myReader.GetInt64(0);
Details.SubGroupID = myReader.GetInt16(1);;
Details.BaseUnitID = myReader.GetInt16(2);
Details.BaseUnitName = myReader.GetString(3);
Details.BaseUnitValue = myReader.GetDecimal(4);
Details.BottomUnitID = myReader.GetInt16(5);
Details.BottomUnitName = myReader.GetString(6);
Details.BottomUnitValue = myReader.GetDecimal(7);
}
myReader.Close();
return(Details);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void Update(ProductSubGroupUnitsMatrixDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void SaveRecord()
{
ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix();
ProductSubGroupUnitsMatrixDetails clsDetails = new ProductSubGroupUnitsMatrixDetails();
clsDetails.MatrixID = Convert.ToInt64(lblMatrixID.Text);
clsDetails.BaseUnitID = Convert.ToInt32(lblBaseUnitID.Text);
clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text);
clsDetails.BottomUnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value);
clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text);
clsUnitMatrix.Update(clsDetails);
clsUnitMatrix.CommitAndDispose();
}
private Int64 SaveRecord()
{
ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix();
ProductSubGroupUnitsMatrixDetails clsDetails = new ProductSubGroupUnitsMatrixDetails();
clsDetails.SubGroupID = Convert.ToInt32(lblSubGroupID.Text);
clsDetails.BaseUnitID = Convert.ToInt32(lblBaseUnitID.Text);
clsDetails.BaseUnitValue = Convert.ToDecimal(txtBaseUnitValue.Text);
clsDetails.BottomUnitID = Convert.ToInt32(cboBottomUnit.SelectedItem.Value);
clsDetails.BottomUnitValue = Convert.ToDecimal(txtBottomUnitValue.Text);
Int64 id = clsUnitMatrix.Insert(clsDetails);
clsUnitMatrix.CommitAndDispose();
return id;
}
public void InheritGroupUnitMatrix(Int64 ProductGroupID, Int64 ProductSubGroupID)
{
try
{
ProductGroupUnitsMatrix clsProductGroupUnitsMatrix = new ProductGroupUnitsMatrix(base.Connection, base.Transaction);
ProductSubGroupUnitsMatrix clsUnitMatrix = new ProductSubGroupUnitsMatrix(base.Connection, base.Transaction);
ProductSubGroupUnitsMatrixDetails clsProductSubGroupUnitsMatrixDetails = new ProductSubGroupUnitsMatrixDetails();
MySqlDataReader clsProductGroupUnitsMatrixList = clsProductGroupUnitsMatrix.List(ProductGroupID,"MatrixID",SortOption.Ascending);
while (clsProductGroupUnitsMatrixList.Read())
{
clsProductSubGroupUnitsMatrixDetails.SubGroupID = Convert.ToInt64(ProductSubGroupID);
clsProductSubGroupUnitsMatrixDetails.BaseUnitID = Convert.ToInt32(clsProductGroupUnitsMatrixList["BaseUnitID"]);
clsProductSubGroupUnitsMatrixDetails.BaseUnitValue = Convert.ToDecimal(clsProductGroupUnitsMatrixList["BaseUnitValue"]);
clsProductSubGroupUnitsMatrixDetails.BottomUnitID = Convert.ToInt32(clsProductGroupUnitsMatrixList["BottomUnitID"]);
clsProductSubGroupUnitsMatrixDetails.BottomUnitValue = Convert.ToDecimal(clsProductGroupUnitsMatrixList["BottomUnitValue"]);
clsUnitMatrix.Insert(clsProductSubGroupUnitsMatrixDetails);
}
clsProductGroupUnitsMatrixList.Close();
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public void Update(ProductSubGroupUnitsMatrixDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductSubGroupUnitsMatrixDetails LastDetails(Int64 SubGroupID)
{
try
{
string SQL = "SELECT a.MatrixID, a.SubGroupID, a.BaseUnitID, b.UnitName 'BaseUnitName', " +
"a.BaseUnitValue, a.BottomUnitID, c.UnitName 'BottomUnitName', a.BottomUnitValue " +
"FROM tblProductSubGroupUnitMatrix a INNER JOIN " +
"tblUnit b ON a.BaseUnitID = b.UnitID INNER JOIN " +
"tblUnit c ON a.BottomUnitID = c.UnitID LEFT OUTER JOIN " +
"tblProductSubGroup d ON a.SubGroupID = d.ProductSubGroupID " +
"WHERE a.SubGroupID = @SubGroupID " +
"ORDER BY a.MatrixID DESC LIMIT 1;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmSubGroupID = new MySqlParameter("@SubGroupID",MySqlDbType.Int64);
prmSubGroupID.Value = SubGroupID;
cmd.Parameters.Add(prmSubGroupID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
ProductSubGroupUnitsMatrixDetails Details = new ProductSubGroupUnitsMatrixDetails();
while (myReader.Read())
{
Details.MatrixID = myReader.GetInt64(0);
Details.SubGroupID = myReader.GetInt16(1);;
Details.BaseUnitID = myReader.GetInt16(2);
Details.BaseUnitName = myReader.GetString(3);
Details.BaseUnitValue = myReader.GetDecimal(4);
Details.BottomUnitID = myReader.GetInt16(5);
Details.BottomUnitName = myReader.GetString(6);
Details.BottomUnitValue = myReader.GetDecimal(7);
}
myReader.Close();
return Details;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public Int32 Save(ProductSubGroupUnitsMatrixDetails Details)
{
try
{
string SQL = "CALL procSaveProductSubGroupUnitMatrix(@MatrixID, @SubGroupID, @BaseUnitID, @BaseUnitValue, " +
"@BottomUnitID, @BottomUnitValue, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("MatrixID", Details.MatrixID);
cmd.Parameters.AddWithValue("SubGroupID", Details.SubGroupID);
cmd.Parameters.AddWithValue("BaseUnitID", Details.BaseUnitID);
cmd.Parameters.AddWithValue("BaseUnitValue", Details.BaseUnitValue);
cmd.Parameters.AddWithValue("BottomUnitID", Details.BottomUnitID);
cmd.Parameters.AddWithValue("BottomUnitValue", Details.BottomUnitValue);
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);
}
}