internal static int UpdateClassification()
{
n = 0;
try
{
daClassification = new TblClassificationTableAdapter();
dtClassification = new DsLiveOutlook.TblClassificationDataTable();
daClassification.FillByID(dtClassification, ClassificationInfo.ID, ClassificationInfo.AClass);
drwClassification = dtClassification[0];
drwClassification.BeginEdit();
drwClassification.ID = ClassificationInfo.NewID.Trim();
drwClassification.Display = ClassificationInfo.Display.Trim();
drwClassification.Value = ClassificationInfo.Value;
drwClassification.EndEdit();
n = daClassification.Update(dtClassification);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static DataTable GetAllClassificationsByID()
{
try
{
dt = new DataTable();
daClassification = new TblClassificationTableAdapter();
dtClassification = new DsLiveOutlook.TblClassificationDataTable();
daClassification.FillByID(dtClassification, ClassificationInfo.ID, ClassificationInfo.AClass);
dt = dtClassification;
}
catch (Exception ex)
{
Interactive.LInfoError("Could not load Classification Information\n" + ex.Message, "Database connection failure");
}
return(dt);
}