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