public Int32 Save(ProductUnitsMatrixDetails Details)
{
try
{
string SQL = "CALL procSaveProductUnitMatrix(@MatrixID, @ProductID, @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("ProductID", Details.ProductID);
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 Int32 Insert(ProductUnitsMatrixDetails 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);
Int32 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int32.Parse(dr[0].ToString());
}
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductUnitsMatrixDetails UnitDetails(long ProductID, long MatrixID)
{
try
{
string SQL = "SELECT a.MatrixID, a.ProductID, a.BaseUnitID, b.UnitName 'BaseUnitName', " +
"a.BaseUnitValue, a.BottomUnitID, c.UnitName 'BottomUnitName', a.BottomUnitValue " +
"FROM tblProductUnitMatrix a INNER JOIN " +
"tblUnit b ON a.BaseUnitID = b.UnitID INNER JOIN " +
"tblUnit c ON a.BottomUnitID = c.UnitID LEFT OUTER JOIN " +
"tblProducts d ON a.ProductID = d.ProductID " +
"WHERE a.ProductID = " + ProductID + " " +
"AND a.MatrixID = " + MatrixID + ";";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
// MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int16);
// prmProductID.Value = ProductID;
// cmd.Parameters.Add(prmProductID);
MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);
ProductUnitsMatrixDetails Details = new ProductUnitsMatrixDetails();
while (myReader.Read())
{
Details.MatrixID = myReader.GetInt64(0);
Details.ProductID = ProductID;
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(ProductUnitsMatrixDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductUnitsMatrixDetails LastDetails(Int64 ProductID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT a.MatrixID, a.ProductID, a.BaseUnitID, b.UnitName 'BaseUnitName', " +
"a.BaseUnitValue, a.BottomUnitID, c.UnitName 'BottomUnitName', a.BottomUnitValue " +
"FROM tblProductUnitMatrix a INNER JOIN " +
"tblUnit b ON a.BaseUnitID = b.UnitID INNER JOIN " +
"tblUnit c ON a.BottomUnitID = c.UnitID LEFT OUTER JOIN " +
"tblProducts d ON a.ProductID = d.ProductID " +
"WHERE a.ProductID = @ProductID " +
"ORDER BY a.MatrixID DESC LIMIT 1;";
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
ProductUnitsMatrixDetails Details = new ProductUnitsMatrixDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.MatrixID = Int64.Parse(dr["MatrixID"].ToString());
Details.ProductID = Int64.Parse(dr["ProductID"].ToString());
Details.BaseUnitID = Int32.Parse(dr["BaseUnitID"].ToString());
Details.BaseUnitName = dr["BaseUnitName"].ToString();
Details.BaseUnitValue = decimal.Parse(dr["BaseUnitValue"].ToString());
Details.BottomUnitID = Int32.Parse(dr["BottomUnitID"].ToString());
Details.BottomUnitName = dr["BottomUnitName"].ToString();
Details.BottomUnitValue = decimal.Parse(dr["BottomUnitValue"].ToString());
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
