public CharacteristicsDetails Details(Int32 CharacteristicsID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"CharacteristicsID, " +
"CharacteristicsCode, " +
"CharacteristicsName " +
"FROM tblCharacteristics " +
"WHERE CharacteristicsID = @CharacteristicsID;";
cmd.Parameters.AddWithValue("@CharacteristicsID", CharacteristicsID);
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);
CharacteristicsDetails Details = new CharacteristicsDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.CharacteristicsID = Int32.Parse(dr["CharacteristicsID"].ToString());
Details.CharacteristicsCode = dr["CharacteristicsCode"].ToString();
Details.CharacteristicsName = dr["CharacteristicsName"].ToString();
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(CharacteristicsDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "INSERT INTO tblCharacteristics (CharacteristicsCode, CharacteristicsName) VALUES (@CharacteristicsCode, @CharacteristicsName);";
cmd.Parameters.AddWithValue("@CharacteristicsCode", Details.CharacteristicsCode);
cmd.Parameters.AddWithValue("@CharacteristicsName", Details.CharacteristicsName);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
return Int32.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(CharacteristicsDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "INSERT INTO tblCharacteristics (CharacteristicsCode, CharacteristicsName) VALUES (@CharacteristicsCode, @CharacteristicsName);";
cmd.Parameters.AddWithValue("@CharacteristicsCode", Details.CharacteristicsCode);
cmd.Parameters.AddWithValue("@CharacteristicsName", Details.CharacteristicsName);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
return(Int32.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(CharacteristicsDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL= "UPDATE tblCharacteristics SET " +
"CharacteristicsCode = @CharacteristicsCode, " +
"CharacteristicsName = @CharacteristicsName " +
"WHERE CharacteristicsID = @CharacteristicsID;";
cmd.Parameters.AddWithValue("@CharacteristicsCode", Details.CharacteristicsCode);
cmd.Parameters.AddWithValue("@CharacteristicsName", Details.CharacteristicsName);
cmd.Parameters.AddWithValue("@CharacteristicsID", Details.CharacteristicsID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(CharacteristicsDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblCharacteristics SET " +
"CharacteristicsCode = @CharacteristicsCode, " +
"CharacteristicsName = @CharacteristicsName " +
"WHERE CharacteristicsID = @CharacteristicsID;";
cmd.Parameters.AddWithValue("@CharacteristicsCode", Details.CharacteristicsCode);
cmd.Parameters.AddWithValue("@CharacteristicsName", Details.CharacteristicsName);
cmd.Parameters.AddWithValue("@CharacteristicsID", Details.CharacteristicsID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public CharacteristicsDetails Details(Int32 CharacteristicsID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL= "SELECT " +
"CharacteristicsID, " +
"CharacteristicsCode, " +
"CharacteristicsName " +
"FROM tblCharacteristics " +
"WHERE CharacteristicsID = @CharacteristicsID;";
cmd.Parameters.AddWithValue("@CharacteristicsID", CharacteristicsID);
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);
CharacteristicsDetails Details = new CharacteristicsDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.CharacteristicsID = Int32.Parse(dr["CharacteristicsID"].ToString());
Details.CharacteristicsCode = dr["CharacteristicsCode"].ToString();
Details.CharacteristicsName = dr["CharacteristicsName"].ToString();
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
