public Int32 Insert(ProductCharacteristicsMatrixDetails Details) { try { string SQL = "INSERT INTO tblProductCharacteristicsMatrix (ProductAttributeCode, ProductAttributeName) VALUES (@ProductAttributeCode, @ProductAttributeName);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; // MySqlParameter prmProductAttributeCode = new MySqlParameter("@ProductAttributeCode",MySqlDbType.String); // prmProductAttributeCode.Value = Details.ProductAttributeCode; // cmd.Parameters.Add(prmProductAttributeCode); // // MySqlParameter prmProductAttributeName = new MySqlParameter("@ProductAttributeName",MySqlDbType.String); // prmProductAttributeName.Value = Details.ProductAttributeName; // cmd.Parameters.Add(prmProductAttributeName); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); 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 Int32 Insert(ProductCharacteristicsMatrixDetails Details) { try { string SQL = "INSERT INTO tblProductCharacteristicsMatrix (ProductAttributeCode, ProductAttributeName) VALUES (@ProductAttributeCode, @ProductAttributeName);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; // MySqlParameter prmProductAttributeCode = new MySqlParameter("@ProductAttributeCode",MySqlDbType.String); // prmProductAttributeCode.Value = Details.ProductAttributeCode; // cmd.Parameters.Add(prmProductAttributeCode); // // MySqlParameter prmProductAttributeName = new MySqlParameter("@ProductAttributeName",MySqlDbType.String); // prmProductAttributeName.Value = Details.ProductAttributeName; // cmd.Parameters.Add(prmProductAttributeName); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); 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 ProductCharacteristicsMatrixDetails Details(Int32 ProductAttributeID) { try { string SQL = "SELECT * FROM tblProductCharacteristicsMatrix " + "WHERE ProductAttributeID = @ProductAttributeID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductAttributeID = new MySqlParameter("@ProductAttributeID", MySqlDbType.Int16); prmProductAttributeID.Value = ProductAttributeID; cmd.Parameters.Add(prmProductAttributeID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); ProductCharacteristicsMatrixDetails Details = new ProductCharacteristicsMatrixDetails(); while (myReader.Read()) { // Details.a = ProductAttributeID; // Details.ProductAttributeCode = myReader.GetString(1); // Details.ProductAttributeName = myReader.GetString(2); } myReader.Close(); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(ProductCharacteristicsMatrixDetails Details) { try { string SQL = "UPDATE tblProductCharacteristicsMatrix SET " + "ProductAttributeCode = @ProductAttributeCode, " + "ProductAttributeName = @ProductAttributeName " + "WHERE ProductAttributeID = @ProductAttributeID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; // MySqlParameter prmProductAttributeCode = new MySqlParameter("@ProductAttributeCode",MySqlDbType.String); // prmProductAttributeCode.Value = Details.ProductAttributeCode; // cmd.Parameters.Add(prmProductAttributeCode); // // MySqlParameter prmProductAttributeName = new MySqlParameter("@ProductAttributeName",MySqlDbType.String); // prmProductAttributeName.Value = Details.ProductAttributeName; // cmd.Parameters.Add(prmProductAttributeName); // // MySqlParameter prmProductAttributeID = new MySqlParameter("@ProductAttributeID",MySqlDbType.Int16); // prmProductAttributeID.Value = Details.ProductAttributeID; // cmd.Parameters.Add(prmProductAttributeID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductCharacteristicsMatrixDetails Details(Int32 ProductAttributeID) { try { string SQL= "SELECT * FROM tblProductCharacteristicsMatrix " + "WHERE ProductAttributeID = @ProductAttributeID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductAttributeID = new MySqlParameter("@ProductAttributeID",MySqlDbType.Int16); prmProductAttributeID.Value = ProductAttributeID; cmd.Parameters.Add(prmProductAttributeID); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); ProductCharacteristicsMatrixDetails Details = new ProductCharacteristicsMatrixDetails(); while (myReader.Read()) { // Details.a = ProductAttributeID; // Details.ProductAttributeCode = myReader.GetString(1); // Details.ProductAttributeName = myReader.GetString(2); } myReader.Close(); return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(ProductCharacteristicsMatrixDetails Details) { try { string SQL= "UPDATE tblProductCharacteristicsMatrix SET " + "ProductAttributeCode = @ProductAttributeCode, " + "ProductAttributeName = @ProductAttributeName " + "WHERE ProductAttributeID = @ProductAttributeID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; // MySqlParameter prmProductAttributeCode = new MySqlParameter("@ProductAttributeCode",MySqlDbType.String); // prmProductAttributeCode.Value = Details.ProductAttributeCode; // cmd.Parameters.Add(prmProductAttributeCode); // // MySqlParameter prmProductAttributeName = new MySqlParameter("@ProductAttributeName",MySqlDbType.String); // prmProductAttributeName.Value = Details.ProductAttributeName; // cmd.Parameters.Add(prmProductAttributeName); // // MySqlParameter prmProductAttributeID = new MySqlParameter("@ProductAttributeID",MySqlDbType.Int16); // prmProductAttributeID.Value = Details.ProductAttributeID; // cmd.Parameters.Add(prmProductAttributeID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }