public void createRateView(BPS.BLL.Clients.DataSets.dsClients.ClientsRow rwC)
{
this.dsInterestRate1.InterestRate.Clear();
for (int i = 0; i < this.dsReqTypes1.ClientsRequestTypes.Count; i++)
{
BPS.BLL.ClientRequest.DataSets.dsReqTypes.ClientsRequestTypesRow rw = DSReqTypes.ClientsRequestTypes[i];
BLL.Clients.DataSets.dsInterestRate.InterestRateRow dr = this.dsInterestRate1.InterestRate.NewInterestRateRow();
dr.ReqType = rw.RequestTypeID;
dr.ReqTypeName = rw.RequestTypeName;
DataRow [] drCharge = this.dsInterestRateList1.InterestRates.Select("ClientID=" + rwC.ClientID.ToString() +
" and RequestTypeID=" + rw.RequestTypeID.ToString() + " and IsNormal=false");
if (drCharge.Length == 0)
{
dr.SetRateBlackNull();
}
else
{
dr.RateBlack = (double)drCharge[0]["ServiceCharge"] * 100;
}
DataRow [] drChargeN = this.dsInterestRateList1.InterestRates.Select("ClientID=" + rwC.ClientID.ToString() +
" and RequestTypeID=" + rw.RequestTypeID.ToString() + " and IsNormal=true");
if (drChargeN.Length == 0)
{
dr.SetRateNormalNull();
}
else
{
dr.RateNormal = (double)drChargeN[0]["ServiceCharge"] * 100;
}
this.dsInterestRate1.InterestRate.AddInterestRateRow(dr);
}
this.dsInterestRate1.InterestRate.AcceptChanges();
}
public void CreateRateView()
{
this.dsInterestRate1.InterestRate.Clear();
for (int i = 0; i < this.dsReqTypes1.ClientsRequestTypes.Count; i++)
{
BPS.BLL.ClientRequest.DataSets.dsReqTypes.ClientsRequestTypesRow rw = this.dsReqTypes1.ClientsRequestTypes[i];
BLL.Clients.DataSets.dsInterestRate.InterestRateRow dr = this.dsInterestRate1.InterestRate.NewInterestRateRow();
dr.ReqType = rw.RequestTypeID;
dr.ReqTypeName = rw.RequestTypeName;
dr.SetRateBlackNull();
dr.SetRateNormalNull(); // = Convert.DBNull;
this.dsInterestRate1.InterestRate.AddInterestRateRow(dr); //.dtRate.Rows.Add(dr);
}
this.dsInterestRate1.InterestRate.AcceptChanges();
}
public void SaveChangesRates(BPS.BLL.Clients.DataSets.dsClients.ClientsRow rw)
{
int iClientID = rw.ClientID;
for (int i = 0; i < this.dsInterestRate1.InterestRate.Rows.Count; i++)
{
BLL.Clients.DataSets.dsInterestRate.InterestRateRow dr = (BLL.Clients.DataSets.dsInterestRate.InterestRateRow) this.dsInterestRate1.InterestRate.Rows[i];
DataRow [] drInterest = this.dsInterestRateList1.InterestRates.Select("ClientID=" + iClientID.ToString() +
" and RequestTypeID=" + dr.ReqType.ToString() + " and IsNormal=false");
if (!dr.IsRateBlackNull()) // != Convert.DBNull)
{
if (drInterest.Length == 0)
{
BPS.BLL.Clients.DataSets.dsInterestRateList.InterestRatesRow newIntRow = (BPS.BLL.Clients.DataSets.dsInterestRateList.InterestRatesRow) this.dsInterestRateList1.InterestRates.NewRow();
newIntRow.ClientID = iClientID;
newIntRow.RequestTypeID = dr.ReqType;
newIntRow.IsNormal = false;
newIntRow.ServiceCharge = dr.RateBlack / 100;
newIntRow.MaxSum = 0;
this.dsInterestRateList1.InterestRates.Rows.Add((DataRow)newIntRow);
}
else
{
drInterest[0]["ServiceCharge"] = ((double)dr.RateBlack / 100).ToString();
}
}
else
{
if (drInterest.Length == 1)
{
drInterest[0].Delete();
}
}
DataRow [] drInterestN = this.dsInterestRateList1.InterestRates.Select("ClientID=" + iClientID.ToString() +
" and RequestTypeID=" + dr.ReqType.ToString() + " and IsNormal=true");
if (!dr.IsRateNormalNull())
{
if (drInterestN.Length == 0)
{
BPS.BLL.Clients.DataSets.dsInterestRateList.InterestRatesRow newIntRow = (BPS.BLL.Clients.DataSets.dsInterestRateList.InterestRatesRow) this.dsInterestRateList1.InterestRates.NewRow();
newIntRow.ClientID = iClientID;
newIntRow.RequestTypeID = dr.ReqType;
newIntRow.IsNormal = true;
newIntRow.ServiceCharge = dr.RateNormal / 100;
newIntRow.MaxSum = 0;
this.dsInterestRateList1.InterestRates.Rows.Add((DataRow)newIntRow);
}
else
{
drInterestN[0]["ServiceCharge"] = (dr.RateNormal / 100).ToString();
}
}
else
{
if (drInterestN.Length == 1)
{
drInterestN[0].Delete();
}
}
}
UpdateInterestRateList();
}
