public CircularRollingViewModel(UserInformation user, string costCentCode)
        {
            // UserInformation user = (UserInformation)App.Current.Properties["userinfo"];
            userinformation = user;
            costCenterCode  = costCentCode;

            circularroll = new CircularRolling(userinformation);

            DDCIR_THREAD_ROLL_MAC ddcirroll = circularroll.getCircularRollings(costCenterCode);

            if (ddcirroll == null)
            {
                ddcircularroll = new DDCIR_THREAD_ROLL_MAC();
                ddcircularroll.COST_CENT_CODE = costCenterCode;
            }
            else
            {
                ddcircularroll = new DDCIR_THREAD_ROLL_MAC();
                ddcircularroll.COST_CENT_CODE      = ddcirroll.COST_CENT_CODE;
                ddcircularroll.BACKLASH_ELIMINATOR = ddcirroll.BACKLASH_ELIMINATOR;
                ddcircularroll.DIE_MOVEMENT_BOTH   = ddcirroll.DIE_MOVEMENT_BOTH;
                ddcircularroll.MAX_PROD_DIA        = ddcirroll.MAX_PROD_DIA;
                ddcircularroll.MAX_PITCH           = ddcirroll.MAX_PITCH;
                ddcircularroll.MOTOR_POWER         = ddcirroll.MOTOR_POWER;
                ddcircularroll.MAX_ROLL_DIA        = ddcirroll.MAX_ROLL_DIA;
                ddcircularroll.MAX_TILT_ANGLE      = ddcirroll.MAX_TILT_ANGLE;
                ddcircularroll.MIN_PITCH           = ddcirroll.MIN_PITCH;
                ddcircularroll.MIN_PROD_DIA        = ddcirroll.MIN_PROD_DIA;
                ddcircularroll.OUTBOARD_BEARINGS   = ddcirroll.OUTBOARD_BEARINGS;
                ddcircularroll.ROLL_PRESSURE       = ddcirroll.ROLL_PRESSURE;
                ddcircularroll.THROUGH_FEED        = ddcirroll.THROUGH_FEED;
                ddcircularroll.TYPE_WORKREST_BLADE = ddcirroll.TYPE_WORKREST_BLADE;
            }
            this.cancelCommand       = new DelegateCommand(this.CancelCircularRolling);
            this.saveCommand         = new DelegateCommand(this.SaveCircularRolling);
            this.unloadCommand       = new DelegateCommand(this.UnloadCircularRolling);
            this.textBoxValueChanged = new DelegateCommand(this.TextChanged);
        }
Example #2
0
        public bool saveCircularRolling(DDCIR_THREAD_ROLL_MAC circularroll)
        {
            string mode   = "";
            bool   submit = false;
            bool   insert = false;
            bool   update = false;
            DDCIR_THREAD_ROLL_MAC cirroll = new DDCIR_THREAD_ROLL_MAC();

            try
            {
                cirroll = (from o in DB.DDCIR_THREAD_ROLL_MAC
                           where o.COST_CENT_CODE == circularroll.COST_CENT_CODE //&& o.DELETE_FLAG == false
                           select o).SingleOrDefault();
                if (cirroll == null)
                {
                    cirroll = new DDCIR_THREAD_ROLL_MAC();
                    mode    = "New";
                    cirroll.COST_CENT_CODE    = circularroll.COST_CENT_CODE;
                    cirroll.ROWID             = Guid.NewGuid();
                    circularroll.DELETE_FLAG  = false;
                    circularroll.ENTERED_BY   = userInformation.UserName;
                    circularroll.ENTERED_DATE = DateTime.Now;
                    insert = true;
                }
                else
                {
                    circularroll.UPDATED_BY   = userInformation.UserName;
                    circularroll.UPDATED_DATE = DateTime.Now;
                    update = true;
                }

                cirroll.BACKLASH_ELIMINATOR = circularroll.BACKLASH_ELIMINATOR;
                cirroll.DIE_MOVEMENT_BOTH   = circularroll.DIE_MOVEMENT_BOTH;
                cirroll.MOTOR_POWER         = circularroll.MOTOR_POWER;
                cirroll.MAX_PROD_DIA        = circularroll.MAX_PROD_DIA;
                cirroll.MIN_PITCH           = circularroll.MIN_PITCH;
                cirroll.MAX_PITCH           = circularroll.MAX_PITCH;
                cirroll.MAX_TILT_ANGLE      = circularroll.MAX_TILT_ANGLE;
                cirroll.MAX_ROLL_DIA        = circularroll.MAX_ROLL_DIA;
                cirroll.MIN_PROD_DIA        = Convert.ToDecimal(circularroll.MIN_PROD_DIA);
                cirroll.OUTBOARD_BEARINGS   = circularroll.OUTBOARD_BEARINGS;
                cirroll.ROLL_PRESSURE       = circularroll.ROLL_PRESSURE;
                cirroll.THROUGH_FEED        = circularroll.THROUGH_FEED;
                cirroll.TYPE_WORKREST_BLADE = circularroll.TYPE_WORKREST_BLADE;

                if (mode == "New")
                {
                    DB.DDCIR_THREAD_ROLL_MAC.InsertOnSubmit(cirroll);
                }
                submit = true;
                DB.SubmitChanges();

                return(true);
            }
            catch (Exception ex)
            {
                if (submit == true)
                {
                    if (insert == true)
                    {
                        DB.DDCIR_THREAD_ROLL_MAC.DeleteOnSubmit(cirroll);
                    }
                    if (update == true)
                    {
                        DB.DDCIR_THREAD_ROLL_MAC.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, cirroll);
                    }
                }
                ex.LogException();
            }
            return(false);
        }