public ForgingMachineViewModel(UserInformation userInformation, string entityPrimaryKey) { bll = new ForgingMachine(userInformation); ActiveEntity = bll.GetEntityByCode(new DDFORGING_MAC() { COST_CENT_CODE = entityPrimaryKey }); if (!ActiveEntity.IsNotNullOrEmpty()) { ActiveEntity = new DDFORGING_MAC() { COST_CENT_CODE = entityPrimaryKey }; } MachineTypes = bll.GetForgingMachineTypesByID(); if (ActiveEntity.MACHINE_TYPE.ToValueAsString().Trim() != "") { SelectedRow = new ForgingMachineTypes(); SelectedRow.DESCRIPTION = ActiveEntity.MACHINE_TYPE; for (int ictr = 0; ictr <= MachineTypes.Count - 1; ictr++) { if (ActiveEntity.MACHINE_TYPE.Trim() == MachineTypes[ictr].DESCRIPTION.Trim()) { SelectedIndexType = ictr; NotifyPropertyChanged("SelectedIndexType"); } } } else { SelectedIndexType = -1; } }
public DDFORGING_MAC GetEntityByCode(DDFORGING_MAC paramEntity = null) { DDFORGING_MAC lstEntity = null; try { if (!DB.IsNotNullOrEmpty()) { return(lstEntity); } if (paramEntity.IsNotNullOrEmpty() && paramEntity.COST_CENT_CODE.IsNotNullOrEmpty()) { lstEntity = (from row in DB.DDFORGING_MAC where Convert.ToBoolean(Convert.ToInt16(row.DELETE_FLAG)) == false && row.COST_CENT_CODE == paramEntity.COST_CENT_CODE select row).SingleOrDefault <DDFORGING_MAC>(); } else { lstEntity = (from row in DB.DDFORGING_MAC where Convert.ToBoolean(Convert.ToInt16(row.DELETE_FLAG)) == false select row).SingleOrDefault <DDFORGING_MAC>(); } } catch (Exception ex) { throw ex.LogException(); } return(lstEntity); }
public bool Insert <T>(List <T> entities) { bool returnValue = false; if (!DB.IsNotNullOrEmpty()) { return(returnValue); } foreach (T entity in entities) { if ((entity as DDFORGING_MAC).IsNotNullOrEmpty()) { DDFORGING_MAC obj = entity as DDFORGING_MAC; try { obj.ROWID = Guid.NewGuid(); obj.DELETE_FLAG = false; obj.ENTERED_BY = userName; obj.ENTERED_DATE = serverDateTime; DB.DDFORGING_MAC.InsertOnSubmit(obj); DB.SubmitChanges(); } catch (ChangeConflictException) { foreach (ObjectChangeConflict conflict in DB.ChangeConflicts) { conflict.Resolve(RefreshMode.KeepChanges); } } catch (Exception ex) { ex.LogException(); DB.DDFORGING_MAC.DeleteOnSubmit(obj); } } } returnValue = true; return(returnValue); }
public bool Update <T>(List <T> entities) { bool returnValue = false; if (!DB.IsNotNullOrEmpty()) { return(returnValue); } foreach (T entity in entities) { if ((entity as DDFORGING_MAC).IsNotNullOrEmpty()) { DDFORGING_MAC obj = null; DDFORGING_MAC activeEntity = (entity as DDFORGING_MAC); try { obj = (from row in DB.DDFORGING_MAC where row.COST_CENT_CODE == activeEntity.COST_CENT_CODE select row).SingleOrDefault <DDFORGING_MAC>(); if (obj.IsNotNullOrEmpty()) { obj.MANUFACTURER = activeEntity.MANUFACTURER; obj.MACHINE_TYPE = activeEntity.MACHINE_TYPE; obj.NO_OF_STATIONS = activeEntity.NO_OF_STATIONS; obj.TONNAGE = activeEntity.TONNAGE; obj.MAX_PROD_DIA = activeEntity.MAX_PROD_DIA; obj.MIN_PROD_DIA = activeEntity.MIN_PROD_DIA; obj.MAX_PROD_LEN = activeEntity.MAX_PROD_LEN; obj.MIN_PROD_LEN = activeEntity.MIN_PROD_LEN; obj.CUTTER_TYPE = activeEntity.CUTTER_TYPE; obj.MAX_CUTOFF_DIA = activeEntity.MAX_CUTOFF_DIA; obj.MIN_CUTOFF_LEN = activeEntity.MIN_CUTOFF_LEN; obj.MAX_CUTOFF_LEN = activeEntity.MAX_CUTOFF_LEN; obj.CUTTER_OD = activeEntity.CUTTER_OD; obj.CUTTER_TICKNESS = activeEntity.CUTTER_TICKNESS; obj.QUILL_CUTTER_DIST = activeEntity.QUILL_CUTTER_DIST; obj.QUILL_TYPE = activeEntity.QUILL_TYPE; obj.QUILL_OD = activeEntity.QUILL_OD; obj.QUILL_THICKNESS = activeEntity.QUILL_THICKNESS; obj.MAX_BUTTON_DIA = activeEntity.MAX_BUTTON_DIA; obj.MAX_KNOCK_OUT = activeEntity.MAX_KNOCK_OUT; obj.PKO_AVAILABLE = activeEntity.PKO_AVAILABLE; obj.PUNCH_DIA_1 = activeEntity.PUNCH_DIA_1; obj.PUCH_LEN_1 = activeEntity.PUCH_LEN_1; obj.PUCH_DIA_2 = activeEntity.PUCH_DIA_2; obj.PUCH_LEN_2 = activeEntity.PUCH_LEN_2; obj.PUCH_DIA_3 = activeEntity.PUCH_DIA_3; obj.PUCH_LEN_3 = activeEntity.PUCH_LEN_3; obj.PUCH_DIA_4 = activeEntity.PUCH_DIA_4; obj.PUCH_LEN_4 = activeEntity.PUCH_LEN_4; obj.FINGER_MECHANISM = activeEntity.FINGER_MECHANISM; obj.TRANS_FINGER_FIX_DIM1 = activeEntity.TRANS_FINGER_FIX_DIM1; obj.TRANS_FINGER_FIX_DIM2 = activeEntity.TRANS_FINGER_FIX_DIM2; obj.TRANS_FINGER_FIX_DIM3 = activeEntity.TRANS_FINGER_FIX_DIM3; obj.TRANS_FINGER_FIX_DIM4 = activeEntity.TRANS_FINGER_FIX_DIM4; obj.CONE_TOOL_PIN_REF = activeEntity.CONE_TOOL_PIN_REF; obj.DIE_PITCH = activeEntity.DIE_PITCH; obj.MAX_PUCH_KICKOUT = activeEntity.MAX_PUCH_KICKOUT; obj.PUNCH_CLOSED_DIM = activeEntity.PUNCH_CLOSED_DIM; obj.PUCH_OPEN_DIM = activeEntity.PUCH_OPEN_DIM; obj.DIE_DIA1 = activeEntity.DIE_DIA1; obj.DIE_DIA2 = activeEntity.DIE_DIA2; obj.DIE_DIA3 = activeEntity.DIE_DIA3; obj.DIE_DIA4 = activeEntity.DIE_DIA4; obj.DIE_LEN1 = activeEntity.DIE_LEN1; obj.DIE_LEN2 = activeEntity.DIE_LEN2; obj.DIE_LEN3 = activeEntity.DIE_LEN3; obj.DIE_LEN4 = activeEntity.DIE_LEN4; obj.MOTOR_POWER = activeEntity.MOTOR_POWER; obj.ROWID = activeEntity.ROWID; obj.DELETE_FLAG = false; obj.UPDATED_BY = userName; obj.UPDATED_DATE = serverDateTime; DB.SubmitChanges(); returnValue = true; } else { returnValue = Insert <DDFORGING_MAC>(new List <DDFORGING_MAC>() { activeEntity }); } } catch (ChangeConflictException) { foreach (ObjectChangeConflict conflict in DB.ChangeConflicts) { conflict.Resolve(RefreshMode.KeepChanges); } } catch (Exception ex) { ex.LogException(); DB.DDFORGING_MAC.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, obj); } } } return(returnValue); }