public void SaveMainRow() { if (SelectedDetailRow != null) { var valiationCollection = new List <ValidationResult>(); var isvalid = Validator.TryValidateObject(SelectedDetailRow, new ValidationContext(SelectedDetailRow, null, null), valiationCollection, true); if (isvalid) { var save = SelectedDetailRow.votglserial == 0; if (AllowUpdate != true) { MessageBox.Show(strings.AllowAddMsg); return; } var saveRow = new tblcurrencydailyexchange(); saveRow.InjectFrom(SelectedDetailRow); Client.ServerConnectionsAsync(LoggedUserInfo.Ip, LoggedUserInfo.Port, LoggedUserInfo.DatabasEname); Client.UpdateOrInsertTblCurrencyDailyExchangeAsync(saveRow, save, 0, LoggedUserInfo.DatabasEname); } else { MessageBox.Show("Data Was Not Saved"); } } }
private List <tblcurrencydailyexchange> GenerateCurrencyDailyExchange(DateTime fromDate, DateTime toDate, float rate, int currency, string company) { using (var context = new ccnewEntities(GetSqlConnectionString(company))) { var listOfRows = new List <tblcurrencydailyexchange>(); foreach (DateTime day in EachDay(fromDate, toDate)) { var oldRow = (from e in context.tblcurrencydailyexchanges where e.DocDate == day && e.TblCurrency == currency select e).SingleOrDefault(); if (oldRow != null) { oldRow.ExchRate = rate; listOfRows.Add(oldRow); } else { var newrow = new tblcurrencydailyexchange { DocDate = day, ExchRate = rate, TblCurrency = currency }; listOfRows.Add(newrow); context.tblcurrencydailyexchanges.AddObject(newrow); } } context.SaveChanges(); return(listOfRows); } }
private int DeleteTblCurrencyDailyExchange(tblcurrencydailyexchange row, string company) { using (var context = new ccnewEntities(GetSqlConnectionString(company))) { var oldRow = (from e in context.tblcurrencydailyexchanges where e.votglserial == row.votglserial select e).SingleOrDefault(); if (oldRow != null) { context.DeleteObject(oldRow); } context.SaveChanges(); } return(row.votglserial); }
private tblcurrencydailyexchange UpdateOrInsertTblCurrencyDailyExchange(tblcurrencydailyexchange newRow, bool save, int index, out int outindex, string company) { outindex = index; using (var context = new ccnewEntities(GetSqlConnectionString(company))) { if (save) { context.tblcurrencydailyexchanges.AddObject(newRow); } else { var oldRow = (from e in context.tblcurrencydailyexchanges where e.votglserial == newRow.votglserial select e).SingleOrDefault(); if (oldRow != null) { GenericUpdate(oldRow, newRow, context); } } context.SaveChanges(); return(newRow); } }