private void saveChange() { //int iCount = 0; this.dvHistory.RowStateFilter = DataViewRowState.CurrentRows; for (int i = 1; i < this.dtCurr.Columns.Count; i++) { for (int j = 1; j < this.dtCurr.Columns.Count; j++) { this.dvHistory.RowFilter = "CurrencyID='" + this.dtCurr.Rows[i - 1][0].ToString() + "' and BaseCurrencyID='" + this.dtCurr.Columns[j].ColumnName + "' and " + "CurrDate <" + this.getDate(this.dateTimePicker1.Value.AddDays(1)) + " and CurrDate>=" + this.getDate(this.dateTimePicker1.Value); if (this.dvHistory.Count == 1) //(this.dvHistory.Find(new object[] {this.dtCurr.Rows[i-1][0].ToString(), this.dtCurr.Columns[j].ColumnName}) == 1) { BPS.BLL.Currency.DataSets.dsCurrHistory.CurrenciesHistoryRow rw = (BPS.BLL.Currency.DataSets.dsCurrHistory.CurrenciesHistoryRow) this.dvHistory[0].Row; //.FindRows(new object[] {this.dtCurr.Rows[i-1][0].ToString(), this.dtCurr.Columns[j].ColumnName})[0].Row; rw.CurrencyID = this.dtCurr.Columns[i].ColumnName; rw.BaseCurrencyID = this.dtCurr.Columns[j].ColumnName; rw.CurrDate = this.dateTimePicker1.Value; if (i == j) { //rw.CurrRate = 1; this.dtCurr.Rows[i - 1][j] = 1; } else if (this.dtCurr.Rows[i - 1][j] != Convert.DBNull) { rw.CurrRate = Convert.ToDouble(this.dtCurr.Rows[i - 1][j]); } rw.CurrencyName = ""; } else if (this.dvHistory.Count == 0) //(this.dvHistory.Find(new object[] {this.dtCurr.Rows[i-1][0].ToString(), this.dtCurr.Columns[j].ColumnName}) == 1) { BPS.BLL.Currency.DataSets.dsCurrHistory.CurrenciesHistoryRow rw = (BPS.BLL.Currency.DataSets.dsCurrHistory.CurrenciesHistoryRow) this.dvHistory.Table.NewRow(); rw.CurrencyID = this.dtCurr.Columns[i].ColumnName; rw.BaseCurrencyID = this.dtCurr.Columns[j].ColumnName; rw.CurrDate = this.dateTimePicker1.Value; if (i == j) { rw.CurrRate = 1; this.dtCurr.Rows[i - 1][j] = 1; } else if (this.dtCurr.Rows[i - 1][j] != Convert.DBNull) { rw.CurrRate = Convert.ToDouble(this.dtCurr.Rows[i - 1][j]); } else if (this.dtCurr.Rows[i - 1][j] == Convert.DBNull) { rw.CurrRate = 0; } rw.CurrencyName = ""; this.dvHistory.Table.Rows.Add((DataRow)rw); } } //iCount++; // } bllCurrency.UpdateHistory(); }
private void fillTableHistory() { this.dtCurr.Clear(); //if(this.dateTimePicker1.Value.Date <= DateTime.Today) { this.dvHistory.RowFilter = "CurrDate <" + this.getDate(this.dateTimePicker1.Value.AddDays(1)) + " and CurrDate>=" + this.getDate(this.dateTimePicker1.Value); // + "*"; if (this.dvHistory.Count == 0) { for (int i = 1; i < this.dtCurr.Columns.Count; i++) { for (int j = 1; j < this.dtCurr.Columns.Count; j++) { BPS.BLL.Currency.DataSets.dsCurrHistory.CurrenciesHistoryRow rw = (BPS.BLL.Currency.DataSets.dsCurrHistory.CurrenciesHistoryRow) this.dvHistory.Table.NewRow(); rw.CurrencyID = this.dtCurr.Columns[i].ColumnName; rw.BaseCurrencyID = this.dtCurr.Columns[j].ColumnName; rw.CurrDate = this.dateTimePicker1.Value; if (i == j) { rw.CurrRate = 1; } else { rw.CurrRate = 0; } rw.CurrencyName = ""; this.dvHistory.Table.Rows.Add((DataRow)rw); } } bllCurrency.UpdateHistory(); } for (int i = 1; i < this.dtCurr.Columns.Count; i++) { DataRow dr = this.dtCurr.NewRow(); dr[0] = this.dtCurr.Columns[i].ColumnName; /*for(int j=1;j<this.dtCurr.Columns.Count;j++) * { * if(Convert.ToDouble(this.dvHistory[iCount]["CurrRate"])>0) * //dr[j] = Convert.DBNull; * dr[j] = this.dvHistory[iCount]["CurrRate"].ToString(); * iCount++; * }*/ this.dtCurr.Rows.Add(dr); } //int iCount = 0; for (int j = 0; j < this.dvHistory.Count; j++) { if (Convert.ToDouble(this.dvHistory[j]["CurrRate"]) > 0) { this.dtCurr.Rows[this.dtCurr.Columns[this.dvHistory[j]["CurrencyID"].ToString()].Ordinal - 1][this.dvHistory[j]["BaseCurrencyID"].ToString()] = this.dvHistory[j]["CurrRate"].ToString(); } } } }