public partial class Managers_clockin_graph : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            start_dpicker.SelectedDate = DateTime.Now.AddDays(-8);
            end_dpicker.SelectedDate = DateTime.Now.AddDays(-1);
        }
    }

    protected void BuildIt(ZedGraph.Web.ZedGraphWeb webObject, System.Drawing.Graphics g, ZedGraph.MasterPane pane)
    {
        pane.PaneList.Clear();
        pane.Fill.Color = System.Drawing.Color.White;
        GraphPane mypane = new GraphPane();
        mypane.Title.Text = "IVR Clock-In's by Office\nLast Seven Days";
        //mypane.XAxis.Title.Text = "Team" 
        //mypane.YAxis.Title.Text = "Total Jobs" 
        mypane.XAxis.Type = AxisType.Text;
        mypane.XAxis.MinorTic.IsInside = true;
        mypane.XAxis.MajorTic.IsBetweenLabels = true;
        System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(southernstar.ssi.connection());
        System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("stv_graph_ivr_byofc", conn);
        cmd.CommandType = CommandType.StoredProcedure;
[size=8][color=brown]            string xx = start_dpicker.SelectedDateString;
            string yy = end_dpicker.SelectedDate.ToShortDateString();
            cmd.Parameters.AddWithValue("@start", xx);
            cmd.Parameters.AddWithValue("@end", yy);[/color][/size]
        System.Data.DataTable objtb = new System.Data.DataTable();
        try
        {
            conn.Open();
            System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(cmd);
            adapter.Fill(objtb);
            conn.Close();
        }
        catch (Exception ex)
        {
            string xyz = ex.Message;
            conn.Close();
        }
        string[] str = { "0" };
        double[] x = { 0 };
        double[] y = { 0 };
        double[] z = { 0 };
        Array.Resize(ref x, objtb.Rows.Count);
        Array.Resize(ref y, objtb.Rows.Count);
        Array.Resize(ref str, objtb.Rows.Count);
        Array.Resize(ref z, objtb.Rows.Count);
        for (int i = 0; i <= objtb.Rows.Count - 1; i++)
        {
            System.Data.DataRow row = objtb.Rows[i];
            str.SetValue(row["locshort"].ToString(), i);
            x.SetValue(double.Parse(row["clockins"].ToString()), i);
            y.SetValue(double.Parse(row["jobs"].ToString()), i);
            z.SetValue(double.Parse("0"), i);
        }
        BarItem mycurve1 = mypane.AddBar("Clockins", z, x, System.Drawing.Color.Green);
        BarItem mycurve2 = mypane.AddBar("Jobs", z, y, System.Drawing.Color.Red);
        mypane.XAxis.Scale.TextLabels = str;
        mypane.XAxis.MajorTic.IsBetweenLabels = true;
        pane.Add(mypane);
        pane.AxisChange(g);
        mypane.YAxis.Scale.Max += mypane.YAxis.Scale.MajorStep;
        BarItem.CreateBarLabels(mypane, true, "F0");
    }
}