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); }
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); }