using System;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.Design;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public class InsuranceService {

    public DataSet LookupClaimsByUnderwriter(string customerId) {
        
	    DataSet s = new DataSet();
	
		DataTable t;
		DataColumn c;
		DataRow r;
	
		t = new DataTable("ClaimHistory");
		c = new DataColumn("ID", typeof(Int32));
		c.AutoIncrement = true;
		c.AutoIncrementSeed = 2177;
		t.Columns.Add(c);
		c = new DataColumn ("PlanType", typeof(String));
		t.Columns.Add(c);
		c = new DataColumn ("Date", typeof(String));
		t.Columns.Add(c);
		c = new DataColumn ("Description", typeof(String));
		t.Columns.Add(c);
		c = new DataColumn ("Value", typeof(String));
		t.Columns.Add(c);
	
        if (customerId != "")
        {
            r = t.NewRow ();
            r["PlanType"] = "Building";
            r["Date"] = "05/06/2002";
            r["Description"] = "Water Damage on Roof";
            r["Value"] = "$3,000";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Building";
            r["Date"] = "07/08/2002";
            r["Description"] = "Broken Security Camera";
            r["Value"] = "$2,000";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Building";
            r["Date"] = "09/10/2002";
            r["Description"] = "Kitchen Fire";
            r["Value"] = "$10,000";
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "7/10/2002";
            r["Description"] = "Employee Car Accident";
            r["Value"] = "$10,000";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "11/10/2002";
            r["Description"] = "Stolen Car";
            r["Value"] = "$24,500";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "11/10/2002";
            r["Description"] = "Employee Car Accident";
            r["Value"] = "$2,400";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Health";
            r["Date"] = "02/06/2002";
            r["Description"] = "Extended Leave for Broken Leg";
            r["Value"] = "$20,000";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Health";
            r["Date"] = "06/06/2002";
            r["Description"] = "Prescription Drug Fee";
            r["Value"] = "$15,000";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Legal";
            r["Date"] = "02/28/2002";
            r["Description"] = "General Counsel Service";
            r["Value"] = "$35,700";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Property";
            r["Date"] = "07/14/2002";
            r["Description"] = "Stolen Servers";
            r["Value"] = "$8,700";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Property";
            r["Date"] = "07/15/2002";
            r["Description"] = "Laptop Repairs";
            r["Value"] = "$11,400";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Building";
            r["Date"] = "09/25/2002";
            r["Description"] = "Rain Damage in Flooring";
            r["Value"] = "$177,800";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Building";
            r["Date"] = "05/05/2002";
            r["Description"] = "Seismic Retrofitting";
            r["Value"] = "$820,700";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "10/10/2002";
            r["Description"] = "Rental Car Damage";
            r["Value"] = "$10,000";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "07/10/2002";
            r["Description"] = "Stolen Car";
            r["Value"] = "$33,500";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "01/10/2002";
            r["Description"] = "Employee Car Accident";
            r["Value"] = "$3,400";
            t.Rows.Add (r);

/* new */
            r = t.NewRow ();
            r["PlanType"] = "Health";
            r["Date"] = "03/18/2002";
            r["Description"] = "Monthly Subscription Taxes";
            r["Value"] = "$35,400";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Legal";
            r["Date"] = "03/30/2002";
            r["Description"] = "Legal Assistance";
            r["Value"] = "$3,700";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Property";
            r["Date"] = "04/11/2002";
            r["Description"] = "Furniture Repairs";
            r["Value"] = "$700";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Property";
            r["Date"] = "09/11/2002";
            r["Description"] = "Cabinet Replacement";
            r["Value"] = "$8,400";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Building";
            r["Date"] = "12/25/2002";
            r["Description"] = "Roof Leak Repairs";
            r["Value"] = "$6,800";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Building";
            r["Date"] = "12/04/2002";
            r["Description"] = "Broken Windows";
            r["Value"] = "$2,700";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "08/18/2002";
            r["Description"] = "Basic Liability";
            r["Value"] = "$7,000";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "05/10/2002";
            r["Description"] = "Stolen Car";
            r["Value"] = "$2,500";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "02/11/2002";
            r["Description"] = "Employee Car Accident";
            r["Value"] = "$13,400";
            t.Rows.Add (r);
            r = t.NewRow ();
            r["PlanType"] = "Automobile";
            r["Date"] = "02/03/2002";
            r["Description"] = "New Fleet Insurance";
            r["Value"] = "$645,000";
            t.Rows.Add (r);
        }

		s.Tables.Add (t);

        return s;
    }

}
