Example #1
0
        public TrimmacViewModel(UserInformation user, string costCentCode)
        {
            // UserInformation user = (UserInformation)App.Current.Properties["userinfo"];
            userinformation = user;
            costCenterCode  = costCentCode;
            trimmac         = new Trimmachine(userinformation);

            DDTRIMMING_MAC ddtap = trimmac.getTrimmachines(costCenterCode);

            if (ddtap == null)
            {
                ddtrimmingmac = new DDTRIMMING_MAC();
                ddtrimmingmac.COST_CENT_CODE = costCenterCode;
            }
            else
            {
                ddtrimmingmac = new DDTRIMMING_MAC();
                ddtrimmingmac.COST_CENT_CODE = ddtap.COST_CENT_CODE;
                ddtrimmingmac.FEED_TYPE      = ddtap.FEED_TYPE;
                ddtrimmingmac.MAX_AF         = ddtap.MAX_AF;
                ddtrimmingmac.MAX_PROD_DIA   = ddtap.MAX_PROD_DIA;
                ddtrimmingmac.MAX_SHANK_LEN  = ddtap.MAX_SHANK_LEN;
                ddtrimmingmac.MOTOR_POWER    = ddtap.MOTOR_POWER;
                ddtrimmingmac.TRIM_DIE_LEN   = ddtap.TRIM_DIE_LEN;
                ddtrimmingmac.TRIM_DIE_OD    = ddtap.TRIM_DIE_OD;
                ddtrimmingmac.TRIM_PUNCH_LEN = ddtap.TRIM_PUNCH_LEN;
                ddtrimmingmac.TRIM_PUNCH_OD  = ddtap.TRIM_PUNCH_OD;
            }
            this.cancelCommand = new DelegateCommand(this.CancelTrimmac);
            this.saveCommand   = new DelegateCommand(this.SaveTrimmac);
            this.unloadCommand = new DelegateCommand(this.UnloadTrimmac);
        }
Example #2
0
        public bool saveTrimmachine(DDTRIMMING_MAC trimmac)
        {
            string         mode   = "";
            DDTRIMMING_MAC trimmc = (from o in DB.DDTRIMMING_MAC
                                     where o.COST_CENT_CODE == trimmac.COST_CENT_CODE// && o.DELETE_FLAG == false
                                     select o).FirstOrDefault();

            try
            {
                if (trimmc == null)
                {
                    trimmc = new DDTRIMMING_MAC();
                    mode   = "New";
                    trimmc.COST_CENT_CODE = trimmac.COST_CENT_CODE;
                    trimmc.ROWID          = Guid.NewGuid();
                    trimmac.DELETE_FLAG   = false;
                    trimmac.ENTERED_BY    = userInformation.UserName;
                    trimmac.ENTERED_DATE  = DateTime.Now;
                }
                else
                {
                    trimmac.UPDATED_BY   = userInformation.UserName;
                    trimmac.UPDATED_DATE = DateTime.Now;
                }

                trimmc.FEED_TYPE      = trimmac.FEED_TYPE;
                trimmc.MAX_AF         = trimmac.MAX_AF;
                trimmc.MOTOR_POWER    = trimmac.MOTOR_POWER;
                trimmc.MAX_PROD_DIA   = trimmac.MAX_PROD_DIA;
                trimmc.MAX_SHANK_LEN  = trimmac.MAX_SHANK_LEN;
                trimmc.TRIM_DIE_LEN   = trimmac.TRIM_DIE_LEN;
                trimmc.TRIM_DIE_OD    = trimmac.TRIM_DIE_OD;
                trimmc.TRIM_PUNCH_LEN = trimmac.TRIM_PUNCH_LEN;
                trimmc.TRIM_PUNCH_OD  = trimmac.TRIM_PUNCH_OD;

                if (mode == "New")
                {
                    trimmc.ROWID = Guid.NewGuid();
                    DB.DDTRIMMING_MAC.InsertOnSubmit(trimmc);
                }

                DB.SubmitChanges();


                trimmc = null;

                return(true);
            }
            catch (System.Data.Linq.ChangeConflictException)
            {
                DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
            }
            catch (Exception ex)
            {
                ex.LogException();
                if (mode == "New")
                {
                    DB.DDTRIMMING_MAC.DeleteOnSubmit(trimmc);
                }
                else
                {
                    DB.DDTRIMMING_MAC.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, trimmc);
                }
            }

            return(false);
        }