private bool CodeExists()
{
string sql = "NatureCode = '" + txtProductNatureCode.Text.Trim() + "'";
ProductNatureCollection natureList = ProductNature.LoadCollection(sql);
if (natureList.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
private void FillParentNatureList()
{
string sql = "NatureId NOT IN ('" + this.ProductNatureId.ToString() + "')";
string[] orderBy = new string[] { "NatureCode" };
ProductNatureCollection oProductNatureList = ProductNature.LoadCollection(sql, orderBy, true);
oProductNatureList.Add(new ProductNature());
cboParentNature.DataSource = oProductNatureList;
cboParentNature.DisplayMember = "NatureCode";
cboParentNature.ValueMember = "NatureId";
cboParentNature.SelectedIndex = cboParentNature.Items.Count - 1;
}
/// <summary>
/// Loads a collection of ProductNature objects from the database.
/// </summary>
/// <returns>A collection containing all of the ProductNature objects in the database.</returns>
public static ProductNatureCollection LoadCollection(string spName, SqlParameter[] parms)
{
ProductNatureCollection result = new ProductNatureCollection();
using (SqlDataReader reader = SqlHelper.Default.ExecuteReader(spName, parms))
{
while (reader.Read())
{
ProductNature tmp = new ProductNature();
tmp.LoadFromReader(reader);
result.Add(tmp);
}
}
return(result);
}
private void FillNatureList()
{
ProductNatureList natureList = new ProductNatureList();
cboNature.Items.Clear();
string[] orderBy = new string[] { "NatureCode" };
ProductNatureCollection oNatureList = ProductNature.LoadCollection(orderBy, true);
foreach (ProductNature nature in oNatureList)
{
natureList.Add(new ProductNatureRec(nature.NatureId, nature.NatureCode + " - " + nature.NatureName));
}
cboNature.DataSource = natureList;
cboNature.DisplayMember = "ProductNatureCode";
cboNature.ValueMember = "ProductNatureId";
cboNature.SelectedIndex = 1; //default N - Normal
}
