protected void btnAdd_Click(object sender, EventArgs e)
    {
        int    Oldcontractid = Convert.ToInt16(Request.QueryString[0]);
        string vardateFrom;
        string vardateTo;
        string varemail  = "";
        int    FlagCount = 0;
        int    contractid;

        FlagCount = objContract.Get_By_Contractname(txtContractName.Text);
        if (FlagCount == 0)
        {
            string[] tempdate = txtActiveFrom.Text.ToString().Split(("/").ToCharArray());
            vardateFrom = tempdate[2] + "-" + tempdate[1] + "-" + tempdate[0];

            string[] tempdate1 = txtActiveTo.Text.ToString().Split(("/").ToCharArray());
            vardateTo = tempdate1[2] + "-" + tempdate1[1] + "-" + tempdate1[0];


            objContract.Activefrom   = vardateFrom;
            objContract.Activeto     = vardateTo;
            objContract.Contractname = txtContractName.Text;
            objContract.Description  = txtdesc.Text;
            objContract.Vendorid     = Convert.ToInt16(drpVendor.SelectedValue);
            objContract.Insert();
            contractid = objContract.Get_TopContractId();
            objContractRenewed.Contractid        = Oldcontractid;
            objContractRenewed.Renewedcontractid = contractid;
            objContractRenewed.Insert();
            for (int i = ListAsset.Items.Count - 1; i >= 0; i--)
            {
                objContractToAsset.Assetid    = Convert.ToInt16(ListAsset.Items[i].Value);
                objContractToAsset.Contractid = contractid;
                objContractToAsset.Insert();
            }
            if (chkLevel1.Checked == true)
            {
                for (int i = listLevel1.Items.Count - 1; i >= 0; i--)
                {
                    if (listLevel1.Items[i].Selected == true)
                    {
                        varemail = varemail + listLevel1.Items[i].Text + ",";
                    }
                }

                objContractNotfy.Contractid       = contractid;
                objContractNotfy.Sendnotification = false;
                objContractNotfy.Sentto           = varemail;
                objContractNotfy.Beforedays       = Convert.ToInt16(txtBeforeDays.Text);
                objContractNotfy.Insert();
            }
            ClearControl();
            Response.Redirect("~/Contract/ViewContract.aspx?" + contractid + "");
        }
        else
        {
            lblErrorMsg.Text = "Contract of this name already exist";
        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {///Add Exception handilng try catch change by vishal 21-05-2012
        try
        {
            string vardateFrom;
            string vardateTo;
            string varemail  = "";
            int    FlagCount = 0;
            int    contractid;
            FlagCount = objContract.Get_By_Contractname(txtContractName.Text);
            if (FlagCount == 0)
            {
                string[] tempdate = txtActiveFrom.Text.ToString().Split(("/").ToCharArray());
                vardateFrom = tempdate[2] + "-" + tempdate[1] + "-" + tempdate[0];

                string[] tempdate1 = txtActiveTo.Text.ToString().Split(("/").ToCharArray());
                vardateTo = tempdate1[2] + "-" + tempdate1[1] + "-" + tempdate1[0];


                objContract.Activefrom   = vardateFrom;
                objContract.Activeto     = vardateTo;
                objContract.Contractname = txtContractName.Text;
                objContract.Description  = txtdesc.Text;
                objContract.Vendorid     = Convert.ToInt32(drpVendor.SelectedValue);
                objContract.Insert();
                contractid = objContract.Get_TopContractId();

                for (int i = ListAsset.Items.Count - 1; i >= 0; i--)
                {
                    objContractToAsset.Assetid    = Convert.ToInt32(ListAsset.Items[i].Value);
                    objContractToAsset.Contractid = contractid;
                    objContractToAsset.Insert();
                }
                if (chkLevel1.Checked == true)
                {
                    for (int i = listLevel1.Items.Count - 1; i >= 0; i--)
                    {
                        if (listLevel1.Items[i].Selected == true)
                        {
                            varemail = varemail + listLevel1.Items[i].Text + ",";
                        }
                    }

                    objContractNotfy.Contractid       = contractid;
                    objContractNotfy.Sendnotification = false;
                    objContractNotfy.Sentto           = varemail;
                    objContractNotfy.Beforedays       = Convert.ToInt32(txtBeforeDays.Text);
                    objContractNotfy.Insert();
                }
                ClearControl();
                Response.Redirect("~/Contract/ViewContract.aspx?" + contractid + "");
            }
            else
            {
                lblErrorMsg.Text = "Contract of this name already exist";
            }
        }
        catch (Exception ex)
        {
            string myScript;
            myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);
            return;
        }
    }