public SqlDataAdapter getPrestamoMoraCuotas(string fecha, string pid)
{
string sql = String.Format("SELECT HISTORIAID,h.PRESTAMOID,CL_NOMBRE,HI_DOCUM as CUOTA,h.CL_CODIGO,HI_BALCAP as Capital, HI_BALINT as Interes FROM historia h inner join clientes c on (h.CL_CODIGO=c.CL_CODIGO) WHERE PRESTAMOID={1} and HI_FECHA <='{0}' and HI_BALCAP>0 and HI_TIPO='F' ", fecha, pid);
SqlDataAdapter dtp = dbc.dt_query(sql);
return(dtp);
}
private void setCuotaDate(string prestamoID, string cuota)
{
DateTime dateTemp;
DateTime nDate = DateTime.Now.AddMonths(1);
DateTime fDate;
string sql = string.Format("SELECT HI_FECHA,HISTORIAID FROM historia where HI_TIPO='F' and HI_DOCUM='{0}' and PRESTAMOID={1}", cuota, prestamoID);
DataSet ds = new DataSet();
SqlDataAdapter adapter = dbc.dt_query(sql);
adapter.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
dateTemp = DateTime.Parse(row["HI_FECHA"].ToString());
//fDate = new DateTime(nDate.Year, nDate.Month, dateTemp.Day);
fDate = dateTemp.AddMonths(1);
dbc.query_insert(String.Format("UPDATE historia set HI_FECHA='{1}' WHERE HISTORIAID={0}", row["HISTORIAID"], fDate.ToString("yyyy-MM-dd")));
}
}
