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