protected void btnupdate_Click(object sender, EventArgs e)
{
collierymaster objcolliery = new collierymaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objcolliery.collierymaster_SRNO = -1;
objcolliery.collierymaster_COLLIERYNAME = txtcollieryname.Text.Trim().ToString();
objcolliery.collierymaster_COLLIERYCODE = txtcollierycode.Text.Trim().ToString();
objcolliery.collierymaster_CMPID = General.Parse<int>(Session["cmpid"].ToString());
if (rdnagpur.Checked == true)
{
objcolliery.collierymaster_COLLIERYREGION = rdnagpur.Text.ToString();
}
else if (rdwani.Checked == true)
{
objcolliery.collierymaster_COLLIERYREGION = rdwani.Text.ToString();
}
objcolliery.collierymaster_STATUS = General.Parse<int>(ddlstatus.SelectedValue.ToString().Trim());
string condition = "SRNO=" + ViewState["COLLIERYID"].ToString().Trim();
if (objcolliery.Insert(false, "collierymaster", condition))
{
if (coaltyperepeater.Items.Count > 0)
{
SqlConnection Connection = new SqlConnection("Data Source=50.28.62.129,1433;Network Library=DBMSSOCN;Initial Catalog=db_fuel;User ID=fuel;Password= lSa2@11h");
string qry = "delete from collierydetailmaster where collieryid=" + ViewState["COLLIERYID"].ToString();
Connection.Open();
SqlCommand com = new SqlCommand(qry, Connection);
com.ExecuteNonQuery();
Connection.Close();
for (int i = 0; i < coaltyperepeater.Items.Count; i++)
{
CheckBox chkcoaltype = (CheckBox)coaltyperepeater.Items[i].FindControl("chkcoaltype");
if (chkcoaltype.Checked == true)
{
TextBox grade = (TextBox)coaltyperepeater.Items[i].FindControl("txtgrade");
TextBox notifiedfrice = (TextBox)coaltyperepeater.Items[i].FindControl("txtnotifiedprice");
TextBox commbenifitchg = (TextBox)coaltyperepeater.Items[i].FindControl("txtcommbenifitchrg");
TextBox crushing = (TextBox)coaltyperepeater.Items[i].FindControl("txtcrushingcharges");
TextBox stc = (TextBox)coaltyperepeater.Items[i].FindControl("txtstc");
TextBox sed = (TextBox)coaltyperepeater.Items[i].FindControl("txtsed");
TextBox cec = (TextBox)coaltyperepeater.Items[i].FindControl("txtcec");
TextBox royalty = (TextBox)coaltyperepeater.Items[i].FindControl("txtroyalty");
TextBox mprdtax = (TextBox)coaltyperepeater.Items[i].FindControl("txtmprdtax");
TextBox transit = (TextBox)coaltyperepeater.Items[i].FindControl("txttransitfee");
TextBox entry = (TextBox)coaltyperepeater.Items[i].FindControl("txtentryfee");
collierydetailmaster objdetails = new collierydetailmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objdetails.collierydetailmaster_SRNO = -1;
objdetails.collierydetailmaster_COALID = General.Parse<int>(chkcoaltype.CssClass.ToString().Trim());
objdetails.collierydetailmaster_COLLIERYID = General.Parse<int>(ViewState["COLLIERYID"].ToString().Trim());
objdetails.collierydetailmaster_GRADE = grade.Text.Trim().ToString();
objdetails.collierydetailmaster_NOTIFIEDPRICE = General.Parse<double>(notifiedfrice.Text.Trim().ToString());
objdetails.collierydetailmaster_COMMBENIFITCHARGES = General.Parse<double>(commbenifitchg.Text.Trim().ToString());
objdetails.collierydetailmaster_CRUSHINGCHARGES = General.Parse<double>(crushing.Text.Trim().ToString());
objdetails.collierydetailmaster_STC = General.Parse<double>(stc.Text.Trim().ToString());
objdetails.collierydetailmaster_SED = General.Parse<double>(sed.Text.Trim().ToString());
objdetails.collierydetailmaster_CEC = General.Parse<double>(cec.Text.Trim().ToString());
objdetails.collierydetailmaster_ROYALTY = General.Parse<double>(royalty.Text.Trim().ToString());
objdetails.collierydetailmaster_MPRDTAX = General.Parse<double>(mprdtax.Text.Trim().ToString());
objdetails.collierydetailmaster_TRANSITTAX = General.Parse<double>(transit.Text.Trim().ToString());
objdetails.collierydetailmaster_ENTRYFEE = General.Parse<double>(entry.Text.Trim().ToString());
objdetails.collierydetailmaster_STATUS = 0;
if (objdetails.Insert(true, "collierydetailmaster"))
{
}
}
}
Response.Redirect("collierylist.aspx?ID=1");
}
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
Handler hdnpartycode=new Handler();
DataTable dtpartycode = hdnpartycode.GetTable("SELECT SRNO FROM COLLIERYMASTER PM WHERE STATUS=0 AND COLLIERYCODE='" + txtcollierycode.Text.Trim().ToString() + "'");
if (dtpartycode.Rows.Count == 0)
{
collierymaster objcolliery = new collierymaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objcolliery.collierymaster_SRNO = -1;
objcolliery.collierymaster_COLLIERYNAME = txtcollieryname.Text.Trim().ToString();
objcolliery.collierymaster_COLLIERYCODE = txtcollierycode.Text.Trim().ToString();
objcolliery.collierymaster_CMPID = General.Parse<int>(Session["cmpid"].ToString());
if (rdnagpur.Checked == true)
{
objcolliery.collierymaster_COLLIERYREGION = rdnagpur.Text.ToString();
}
else if (rdwani.Checked == true)
{
objcolliery.collierymaster_COLLIERYREGION = rdwani.Text.ToString();
}
objcolliery.collierymaster_STATUS = 0;
if (objcolliery.Insert(true, "collierymaster"))
{
string sqlmax = "SELECT MAX(CM.SRNO) FROM collierymaster CM WHERE STATUS=0 AND COLLIERYNAME='" + txtcollieryname.Text.ToString().Trim() + "'";
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++)
{
CheckBox chkcoaltype = (CheckBox)coaltyperepeater.Items[i].FindControl("chkcoaltype");
if (chkcoaltype.Checked == true)
{
TextBox grade = (TextBox)coaltyperepeater.Items[i].FindControl("txtgrade");
TextBox notifiedfrice = (TextBox)coaltyperepeater.Items[i].FindControl("txtnotifiedprice");
TextBox commbenifitchg = (TextBox)coaltyperepeater.Items[i].FindControl("txtcommbenifitchrg");
TextBox crushing = (TextBox)coaltyperepeater.Items[i].FindControl("txtcrushingchg");
TextBox stc = (TextBox)coaltyperepeater.Items[i].FindControl("txtstc");
TextBox sed = (TextBox)coaltyperepeater.Items[i].FindControl("txtsed");
TextBox cec = (TextBox)coaltyperepeater.Items[i].FindControl("txtroyalty");
TextBox royalty = (TextBox)coaltyperepeater.Items[i].FindControl("txtcec");
TextBox mprdtax = (TextBox)coaltyperepeater.Items[i].FindControl("txtmprdtax");
TextBox transit = (TextBox)coaltyperepeater.Items[i].FindControl("txttransitfee");
TextBox entry = (TextBox)coaltyperepeater.Items[i].FindControl("txtentryfee");
collierydetailmaster objdetails = new collierydetailmaster(HttpContext.Current.Server.MapPath("~/XML/database.xml"));
objdetails.collierydetailmaster_SRNO = -1;
objdetails.collierydetailmaster_COALID = General.Parse<int>(chkcoaltype.CssClass.ToString().Trim());
objdetails.collierydetailmaster_COLLIERYID = General.Parse<int>(dtmax.Rows[0][0].ToString());
objdetails.collierydetailmaster_GRADE = grade.Text.Trim().ToString();
objdetails.collierydetailmaster_NOTIFIEDPRICE = General.Parse<double>(notifiedfrice.Text.Trim().ToString());
objdetails.collierydetailmaster_COMMBENIFITCHARGES = General.Parse<double>(commbenifitchg.Text.Trim().ToString());
objdetails.collierydetailmaster_CRUSHINGCHARGES = General.Parse<double>(crushing.Text.Trim().ToString());
objdetails.collierydetailmaster_STC = General.Parse<double>(stc.Text.Trim().ToString());
objdetails.collierydetailmaster_SED = General.Parse<double>(sed.Text.Trim().ToString());
objdetails.collierydetailmaster_CEC = General.Parse<double>(cec.Text.Trim().ToString());
objdetails.collierydetailmaster_ROYALTY = General.Parse<double>(royalty.Text.Trim().ToString());
objdetails.collierydetailmaster_MPRDTAX = General.Parse<double>(mprdtax.Text.Trim().ToString());
objdetails.collierydetailmaster_TRANSITTAX = General.Parse<double>(transit.Text.Trim().ToString());
objdetails.collierydetailmaster_ENTRYFEE = General.Parse<double>(entry.Text.Trim().ToString());
objdetails.collierydetailmaster_STATUS = 0;
if (objdetails.Insert(true, "collierydetailmaster"))
{
}
}
}
//Response.Redirect("collierydetails.aspx?ID=1&COLLIERYID=" + dtmax.Rows[0][0].ToString());
Response.Redirect("collierylist.aspx?ID=2");
}
}
}
else
{
MessageBox("Colliery Code Already Present");
}
}