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