protected void btnsubmit_Click(object sender, EventArgs e)
    {
        auctionmaster objauctionmaster = new auctionmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
        objauctionmaster.auctionmaster_AUCTIONID = -1;
        objauctionmaster.auctionmaster_AUCTIONNAME = txtauctionname.Text.Trim().ToString();
        objauctionmaster.auctionmaster_CMPID = General.Parse<int>(Session["cmpid"].ToString());
        objauctionmaster.auctionmaster_AUCTIONDATE = txtauctiondate.Text.Trim().ToString();
        objauctionmaster.auctionmaster_STARTDATE = txtstartdate.Text.Trim().ToString();
        objauctionmaster.auctionmaster_ENDDATE = txtenddate.Text.Trim().ToString();
        objauctionmaster.auctionmaster_DESCRIPTION = txtdescription.Text.Trim().ToString();
        objauctionmaster.auctionmaster_STATUS = 0;
        if (objauctionmaster.Insert(true, "auctionmaster"))
        {
            string sqlmax = "SELECT MAX(AM.AUCTIONID) FROM AUCTIONMASTER AM WHERE AM.STATUS=0 AND AM.AUCTIONNAME='"+txtauctionname.Text.Trim().ToString()+"' AND"+
                            " AM.AUCTIONDATE='" + txtauctiondate.Text.Trim().ToString() + "' AND AM.CMPID=" + Session["cmpid"].ToString();
            Handler hdnmax = new Handler();
            DataTable dtmax = hdnmax.GetTable(sqlmax);
            if (dtmax.Rows.Count > 0 && coaltyperepeater.Items.Count > 0)
            {
                for (int i = 0; i < coaltyperepeater.Items.Count; i++)
                {
                    DropDownList ddlcoaltype = (DropDownList)coaltyperepeater.Items[i].FindControl("ddlcoaltype");
                    DropDownList ddlcoalgrade = (DropDownList)coaltyperepeater.Items[i].FindControl("ddlcoalgrade");
                    DropDownList ddlquantityunit = (DropDownList)coaltyperepeater.Items[i].FindControl("ddlquantityunit");
                    TextBox txtcoalrate = (TextBox)coaltyperepeater.Items[i].FindControl("txtcoalrate");
                    TextBox txtquantity = (TextBox)coaltyperepeater.Items[i].FindControl("txtquantity");


                    auctionspecification objspecification = new auctionspecification(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
                    objspecification.auctionspecification_SRNO = -1;
                    objspecification.auctionspecification_CONTRACTTYPE = "AUCTION";
                    objspecification.auctionspecification_CONTRACTID = General.Parse<int>(dtmax.Rows[0][0].ToString());
                    objspecification.auctionspecification_COALTYPE = ddlcoaltype.SelectedItem.Text.Trim();
                    objspecification.auctionspecification_GRADE = ddlcoalgrade.SelectedItem.Text.Trim();
                    objspecification.auctionspecification_QUANTITY = General.Parse<double>(txtquantity.Text.Trim().ToString());
                    objspecification.auctionspecification_RATE = General.Parse<double>(txtcoalrate.Text.Trim().ToString());
                    objspecification.auctionspecification_QUANTITYUNIT = ddlquantityunit.SelectedValue.ToString();
                    objspecification.auctionspecification_STATUS = 0;
                    if (objspecification.Insert(true, "auctionspecification"))
                    {
                    }


                }
            }
            Response.Redirect("auctiondetails.aspx?AUCTIONID=" + dtmax.Rows[0][0].ToString().Trim());
        }
    }
    protected void btnupdate_Click(object sender, EventArgs e)
    {
        auctionmaster objauctionmaster = new auctionmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
        objauctionmaster.auctionmaster_AUCTIONID = -1;
        objauctionmaster.auctionmaster_AUCTIONNAME = txtauctionname.Text.Trim().ToString();
        objauctionmaster.auctionmaster_CMPID = -1;
        objauctionmaster.auctionmaster_AUCTIONDATE = txtauctiondate.Text.Trim().ToString();
        objauctionmaster.auctionmaster_STARTDATE = txtstartdate.Text.Trim().ToString();
        objauctionmaster.auctionmaster_ENDDATE = txtenddate.Text.Trim().ToString();
        objauctionmaster.auctionmaster_DESCRIPTION = txtdescription.Text.Trim().ToString();
        objauctionmaster.auctionmaster_STATUS =General.Parse<int>(ddlstatus.SelectedValue.Trim().ToString());
        string condition = "AUCTIONID=" + ViewState["AUCTIONID"].ToString().Trim();
        if (objauctionmaster.Insert(false, "auctionmaster", condition))
        {
            if (coaltyperepeater.Items.Count > 0)
            {
                for (int i = 0; i < coaltyperepeater.Items.Count; i++)
                {
                    DropDownList ddlcoaltype = (DropDownList)coaltyperepeater.Items[i].FindControl("ddlcoaltype");
                    DropDownList ddlcoalgrade = (DropDownList)coaltyperepeater.Items[i].FindControl("ddlcoalgrade");
                    DropDownList ddlquantityunit = (DropDownList)coaltyperepeater.Items[i].FindControl("ddlquantityunit");
                    TextBox txtcoalrate = (TextBox)coaltyperepeater.Items[i].FindControl("txtcoalrate");
                    TextBox txtquantity = (TextBox)coaltyperepeater.Items[i].FindControl("txtquantity");


                    auctionspecification objspecification = new auctionspecification(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
                    objspecification.auctionspecification_SRNO = -1;
                    objspecification.auctionspecification_CONTRACTID = -1;
                    objspecification.auctionspecification_COALTYPE = ddlcoaltype.SelectedItem.Text.Trim();
                    objspecification.auctionspecification_GRADE = ddlcoalgrade.SelectedItem.Text.Trim();
                    objspecification.auctionspecification_QUANTITY = General.Parse<double>(txtquantity.Text.Trim().ToString());
                    objspecification.auctionspecification_RATE = General.Parse<double>(txtcoalrate.Text.Trim().ToString());
                    objspecification.auctionspecification_QUANTITYUNIT = ddlquantityunit.SelectedValue.ToString();
                    objspecification.auctionspecification_STATUS = 0;
                    string condition1 = "CONTRACTTYPE='AUCTION' AND CONTRACTID=" + ViewState["AUCTIONID"].ToString().Trim();
                    if (objspecification.Insert(false, "auctionspecification", condition1))
                    {
                    }


                }
            }
        }
    }