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); } }