//-------------------------- // SELECT Get_LastPago_for_Servicio //-------------------------- public DataTable Get_LastPago_for_Servicio(BE_ReqLastFecPago_for_Servicio Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_LastPago_for_Servicio]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("cPerCodigo", Request.cPerCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//------------------------ //select Get_LastPago_for_Servicio //------------------------ public DataTable Get_LastPago_for_Servicio(string cPerCodigo) { BE_ReqLastFecPago_for_Servicio Request = new BE_ReqLastFecPago_for_Servicio(); DA_LastFecPago_for_Servicio Obj = new DA_LastFecPago_for_Servicio(); //Request.cCtaCteRecibo = cCtaCteRecibo; Request.cPerCodigo = cPerCodigo; return Obj.Get_LastPago_for_Servicio(Request); }