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