public static bool Insert(Breeder breeder) { try { using (var conn = new MySqlConnection(Globals.CONN_STR)) { conn.Open(); var sql = @"INSERT INTO breeder (breeder_code, breeder_name, active, create_by) VALUES(@breeder_code, @breeder_name, @active, @create_by)"; var cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("breeder_code", breeder.BreederCode); cmd.Parameters.AddWithValue("breeder_name", breeder.BreederName); cmd.Parameters.AddWithValue("active", breeder.Active); cmd.Parameters.AddWithValue("create_by", breeder.CreateBy); var affRow = cmd.ExecuteNonQuery(); } return(true); } catch (Exception) { throw; } }
public static bool Update(Breeder breeder) { try { using (var conn = new MySqlConnection(Globals.CONN_STR)) { conn.Open(); var sql = @"UPDATE breeder SET breeder_name=@breeder_name, active=@active, modified_at=CURRENT_TIMESTAMP, modified_by=@modified_by WHERE breeder_code=@breeder_code"; var cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("breeder_code", breeder.BreederCode); cmd.Parameters.AddWithValue("breeder_name", breeder.BreederName); cmd.Parameters.AddWithValue("active", breeder.Active); cmd.Parameters.AddWithValue("modified_by", breeder.ModifiedBy); var affRow = cmd.ExecuteNonQuery(); } return(true); } catch (Exception) { throw; } }
public static Breeder GetBreeder(string breeder_code) { try { using (var conn = new MySqlConnection(Globals.CONN_STR)) { conn.Open(); var sb = new StringBuilder(); sb.Append("select * from breeder"); sb.Append(" where breeder_code = @breeder_code"); var cmd = new MySqlCommand(sb.ToString(), conn); cmd.Parameters.AddWithValue("breeder_code", breeder_code); var da = new MySqlDataAdapter(cmd); var ds = new DataSet(); da.Fill(ds); var farm = new Breeder(); if (ds.Tables[0].Rows.Count > 0) { return(new Breeder { BreederCode = (int)ds.Tables[0].Rows[0]["breeder_code"], BreederName = ds.Tables[0].Rows[0]["breeder_name"].ToString(), Active = (bool)ds.Tables[0].Rows[0]["active"], CreateAt = (DateTime)ds.Tables[0].Rows[0]["create_at"], }); } else { return(null); } } } catch (Exception) { throw; } }