Exemple #1
0
        public bool Update <T>(List <T> entities)
        {
            bool returnValue = false;

            foreach (T entity in entities)
            {
                if ((entity as TOOL_ISSUES).IsNotNullOrEmpty())
                {
                    TOOL_ISSUES obj          = null;
                    TOOL_ISSUES activeEntity = (entity as TOOL_ISSUES);

                    obj = (from row in DB.TOOL_ISSUES
                           where row.TOOL_CD == activeEntity.TOOL_CD && row.ISSUE_NO == activeEntity.ISSUE_NO
                           select row).SingleOrDefault <TOOL_ISSUES>();
                    if (obj.IsNotNullOrEmpty())
                    {
                        try
                        {
                            obj.TOOL_CD     = activeEntity.TOOL_CD;
                            obj.ISSUE_NO    = activeEntity.ISSUE_NO;
                            obj.ISSUE_DATE  = activeEntity.ISSUE_DATE;
                            obj.ALTERATIONS = activeEntity.ALTERATIONS;
                            obj.INTL        = activeEntity.INTL;
                            DB.SubmitChanges();

                            System.Data.Linq.ChangeSet cs = DB.GetChangeSet();
                            returnValue = cs.Updates.Count > 0 ? true : false;
                            returnValue = true;
                        }
                        catch (System.Data.Linq.ChangeConflictException)
                        {
                            foreach (System.Data.Linq.ObjectChangeConflict conflict in DB.ChangeConflicts)
                            {
                                conflict.Resolve(System.Data.Linq.RefreshMode.KeepChanges);
                            }
                        }
                        catch (Exception ex)
                        {
                            ex.LogException();
                            DB.TOOL_ISSUES.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, obj);
                        }
                    }
                    else
                    {
                        returnValue = Delete <TOOL_ISSUES>(new List <TOOL_ISSUES> {
                            activeEntity
                        });
                        returnValue = Insert <TOOL_ISSUES>(new List <TOOL_ISSUES> {
                            activeEntity
                        });
                    }
                }
            }
            returnValue = true;
            return(returnValue);
        }
Exemple #2
0
        public bool Insert <T>(List <T> entities)
        {
            bool returnValue = false;

            foreach (T entity in entities)
            {
                if ((entity as TOOL_ISSUES).IsNotNullOrEmpty())
                {
                    TOOL_ISSUES obj = entity as TOOL_ISSUES;
                    try
                    {
                        if (!obj.TOOL_CD.IsNotNullOrEmpty())
                        {
                            obj.TOOL_CD = GenerateNextNumber("TOOL_ISSUES", "TOOL_CD");
                        }

                        DB.TOOL_ISSUES.InsertOnSubmit(obj);
                        DB.SubmitChanges();

                        System.Data.Linq.ChangeSet cs = DB.GetChangeSet();
                        returnValue = cs.Inserts.Count > 0 ? true : false;
                    }
                    catch (System.Data.Linq.ChangeConflictException)
                    {
                        foreach (System.Data.Linq.ObjectChangeConflict conflict in DB.ChangeConflicts)
                        {
                            conflict.Resolve(System.Data.Linq.RefreshMode.KeepChanges);
                        }
                    }
                    catch (Exception ex)
                    {
                        ex.LogException();
                        DB.TOOL_ISSUES.DeleteOnSubmit(obj);
                    }
                }
            }

            returnValue = true;
            return(returnValue);
        }