Example #1
0
        public static string Update(FORECAST_ORDER fc, TAC_KANBANEntities ceRef = null)
        {
            String results           = null;
            bool   isSuccess         = false;
            bool   isRootTransaction = true;

            TAC_KANBANEntities ce;

            if (ceRef == null)
            {
                //using new entity object
                ce = new TAC_KANBANEntities();
            }
            else
            {
                //using current entity object
                ce = ceRef;
                isRootTransaction = false;
            }

            // Start transaction for update a Lease Admin record.
            try
            {
                using (TransactionScope trans = EntityUtils.CreateTransactionScope())
                {
                    if (isRootTransaction)
                    {
                        // Manually open connection to prevent EF from auto closing
                        // connection and causing issues with future queries.
                        ce.Connection.Open();
                    }

                    // Checking for version
                    ce.AttachUpdated(fc);
                    ce.SaveChanges(System.Data.Objects.SaveOptions.DetectChangesBeforeSave);

                    isSuccess = true;
                    trans.Complete();     // Transaction complete
                }
            }
            catch (OptimisticConcurrencyException oex)
            {
                // Log error in ELMAH for any diagnostic needs.

                results = "The current record has been modifed since you have " +
                          "last retrieved it. Please reload the record and " +
                          "attempt to save it again.";
            }
            catch (Exception ex)
            {
                // Error occurs
                // Log error in ELMAH for any diagnostic needs.

                isSuccess = false;
                results   = "An error occurred saving the record. Please try again.";
            }
            finally
            {
                if (isRootTransaction)
                {
                    ce.Connection.Dispose();
                }
            }

            // Finally accept all changes from the transaction.
            if (isSuccess && isRootTransaction)
            {
                ce.Dispose();
            }

            return(results);
        }
Example #2
0
        public static String Delete(int id, TAC_KANBANEntities ceRef = null)
        {
            String sResult           = null;
            bool   isSuccess         = false;
            bool   isRootTransaction = true;

            TAC_KANBANEntities ce;

            if (ceRef == null)
            {
                //using new entity object
                ce = new TAC_KANBANEntities();
            }
            else
            {
                //using current entity object
                ce = ceRef;
                isRootTransaction = false;
            }

            try
            {
                using (TransactionScope trans = EntityUtils.CreateTransactionScope())
                {
                    if (isRootTransaction)
                    {
                        // Manually open connection to prevent EF from auto closing
                        // connection and causing issues with future queries.
                        ce.Connection.Open();
                    }

                    var forecastDetail = from com in ce.FORECAST_ORDER_DETAIL
                                         where com.FORCAST_ID == id
                                         select com;

                    if (forecastDetail.Count() > 0)
                    {
                        foreach (FORECAST_ORDER_DETAIL item in forecastDetail.ToList <FORECAST_ORDER_DETAIL>())
                        {
                            ce.DeleteObject(item);
                        }
                    }

                    //Delete record
                    var forecast = from doc in ce.FORECAST_ORDER
                                   where doc.ID == id
                                   select doc;

                    if (forecast.Any())
                    {
                        FORECAST_ORDER fc = forecast.FirstOrDefault();
                        ce.FORECAST_ORDER.DeleteObject(fc);
                    }
                    else
                    {
                        throw new NullReferenceException();
                    }

                    if (isRootTransaction)
                    {
                        // We tentatively save the changes so that we can finish
                        // processing the transaction.foreach (var bk in books)
                        ce.SaveChanges(System.Data.Objects.SaveOptions.DetectChangesBeforeSave);
                    }

                    isSuccess = true;
                    trans.Complete();     //Transaction complete.
                }
            }
            catch (Exception ex)
            {
                // Log error in ELMAH for any diagnostic needs.


                sResult   = ex.ToString();
                isSuccess = false;
            }
            finally
            {
                if (isRootTransaction)
                {
                    ce.Connection.Dispose();
                }
            }

            // Finally accept all changes from the transaction.
            if (isSuccess && isRootTransaction)
            {
                ce.AcceptAllChanges();
                ce.Dispose();
            }

            return(sResult);
        }