protected void btnaddrecord_Click(object sender, EventArgs e)
 {
    reportingmaster obj = new reportingmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
     obj.reportingmaster_SRNO = -1;
     obj.reportingmaster_NAME = txtprospect.Text.Trim();
     obj.reportingmaster_CONTACTNO = txtcontactno.Text.Trim();
     obj.reportingmaster_ACTIVITY = txtactivity.Text.Trim();
     obj.reportingmaster_RESULT = txtresult.Text.Trim();
     obj.reportingmaster_REMARK = txtremark.Text.Trim();
     obj.reportingmaster_RELATIONSHIPID = -1;
     obj.reportingmaster_STATUS = -1;
     string condition = "SRNO=" + ViewState["srno"].ToString();
     if (obj.Insert(false, "reportingmaster", condition))
     {
         DataTable dtcontract = FillMemberList(txtfromdate.Text.Trim(), txttodate.Text.Trim(), txtname.Text.Trim());
         ViewState["list"] = dtcontract;
         if (dtcontract.Rows.Count > 0)
         {
             gvmemberlist.DataSource = (DataTable)ViewState["list"];
             gvmemberlist.DataBind();
         }
         else
         {
             gvmemberlist.DataSource = null;
             gvmemberlist.DataBind();
         }
     }
 }
 protected void lnkdelete_Click(object sender, EventArgs e)
 {
     LinkButton lnk = (LinkButton)sender;
     reportingmaster obj = new reportingmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
     obj.reportingmaster_SRNO = -1;
     obj.reportingmaster_RELATIONSHIPID = -1;
     obj.reportingmaster_STATUS = 1;
     string condition = "SRNO=" + lnk.CommandArgument.ToString();
     if (obj.Insert(false, "reportingmaster", condition))
     {
         DataTable dtcontract = FillMemberList(txtfromdate.Text.Trim(), txttodate.Text.Trim(), txtname.Text.Trim());
         ViewState["list"] = dtcontract;
         if (dtcontract.Rows.Count > 0)
         {
             gvmemberlist.DataSource = (DataTable)ViewState["list"];
             gvmemberlist.DataBind();
         }
         else
         {
             gvmemberlist.DataSource = null;
             gvmemberlist.DataBind();
         }
     }
 }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        if (ViewState["data"] != null)
        {
            if (((DataTable)ViewState["data"]).Rows.Count > 0)
            {
                DataTable dt = (DataTable)ViewState["data"];
                ViewState["data"] = null;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (dt.Rows[i][0].ToString().Trim() != string.Empty)
                    {
                        reportingmaster obj = new reportingmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
                        obj.reportingmaster_SRNO = -1;
                        obj.reportingmaster_DATE = txtdate.Text.Trim();
                        obj.reportingmaster_NAME = dt.Rows[i][1].ToString();
                        obj.reportingmaster_CONTACTNO = dt.Rows[i][2].ToString();
                        obj.reportingmaster_ACTIVITY = dt.Rows[i][3].ToString();
                        obj.reportingmaster_RESULT = dt.Rows[i][4].ToString();
                        obj.reportingmaster_REMARK = dt.Rows[i][5].ToString();
                        obj.reportingmaster_RELATIONSHIPID = General.Parse<int>(Session["userid"].ToString());
                        obj.reportingmaster_STATUS = 0;
                        if (obj.Insert(true, "reportingmaster"))
                        {
                            dt.Rows[i].Delete();

                        }
                    }
                }
                Response.Redirect("searchrecord.aspx?upload=1");
            }
        }
        else
        {
            MessageBox("Please Upload Record");
        }
        btnsubmit.Enabled = true;
    }