public int SubmitLookups(LookupsData Lookups)
        {
            LookupsDal LookupsDal = new LookupsDal();

            //using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required))
            try
            {
                switch (Lookups.DataStatus)
                {
                case DataStatus.New:
                    LookupsDal.Add(Lookups);
                    break;

                case DataStatus.Modified:
                    LookupsDal.Update(Lookups);
                    break;

                case DataStatus.Deleted:
                    LookupsDal.Delete(Lookups);
                    //ts.Complete();
                    return(0);

                default:
                    break;
                }
                //ts.Complete();
                return(Lookups._ID);
            }
            catch (Exception ex)
            {
                //ts.Dispose();
                throw ex;
            }
        }