private int DeleteTblCostDimSetupHeader(TblCostDimSetupHeader row, string company) { using (var context = new ccnewEntities(GetSqlConnectionString(company))) { var oldRow = (from e in context.TblCostDimSetupHeaders where e.Iserial == row.Iserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.Iserial); }
private TblCostDimSetupHeader UpdateOrInsertTblCostDimSetupHeader(TblCostDimSetupHeader newRow, bool save, int index, out int outindex, string company) { outindex = index; using (var context = new ccnewEntities(GetSqlConnectionString(company))) { if (save) { context.TblCostDimSetupHeaders.AddObject(newRow); } else { var oldRow = (from e in context.TblCostDimSetupHeaders where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); return(newRow); } }
public void SaveMainRow() { if (SelectedMainRow != null) { var valiationCollection = new List <ValidationResult>(); var isvalid = Validator.TryValidateObject(SelectedMainRow, new ValidationContext(SelectedMainRow, null, null), valiationCollection, true); if (isvalid) { var save = SelectedMainRow.Iserial == 0; if (AllowUpdate != true && !save) { MessageBox.Show(strings.AllowUpdateMsg); return; } var saveRow = new TblCostDimSetupHeader(); saveRow.InjectFrom(SelectedMainRow); Glclient.UpdateOrInsertTblCostDimSetupHeaderAsync(saveRow, save, MainRowList.IndexOf(SelectedMainRow), LoggedUserInfo.DatabasEname); } } }
private TblCostDimHeader GetTblCostDimSetupHeaderForAccount(int tblJournalAccountType, int?iserial, string company, out TblCostDimSetupHeader HeaderRow, out int tblJournalAccType) { using (var entity = new ccnewEntities(GetSqlConnectionString(company))) { tblJournalAccType = tblJournalAccountType; if (iserial == null) { HeaderRow = entity.TblCostDimSetupHeaders.Include("TblCostDimSetupDetails.TblCostCenterOption1").Include("TblCostDimSetupDetails.TblCostCenterType1").FirstOrDefault(x => x.TblJournalAccountType == tblJournalAccountType); return(null); } HeaderRow = null; return(entity.TblCostDimHeaders.Include("TblCostDimDetails.TblCostCenter1").FirstOrDefault(x => x.Iserial == iserial)); } }