private void LoadSTCaseLaws(GridView eGrid)
{
STCaselaws_GetAllTableAdapter index = new STCaselaws_GetAllTableAdapter();
DataTable dtActsIndexName = index.GetAll();
if (dtActsIndexName.Rows.Count > 0)
{
editGrid.Visible = true;
editGrid.DataSource = dtActsIndexName;
editGrid.DataBind();
if (editGrid.Columns.Count > 0)
editGrid.Columns[0].Visible = false;
else
{
editGrid.HeaderRow.Cells[1].Visible = false;
editGrid.HeaderRow.Cells[3].Visible = false;
editGrid.HeaderRow.Cells[4].Visible = false;
foreach (GridViewRow gvr in editGrid.Rows)
{
gvr.Cells[1].Visible = false;
gvr.Cells[3].Visible = false;
gvr.Cells[4].Visible = false;
}
}
// editGrid.Columns[1].Visible = false;
}
}
protected void editGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridView gv = sender as GridView;
GridViewRow row = gv.Rows[e.RowIndex];
// int? id = Int32.Parse(row.Cells[2].Text);
if (ddlsubcategory.SelectedValue.Equals("Acts") && ddlcatagory.SelectedValue.Equals("Central Excise"))
{
int? id = Int32.Parse(row.Cells[2].Text);
CEActsTableAdapter index = new CEActsTableAdapter();
index.CEDeleteById(id);
LoadCEActs(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Rules") && ddlcatagory.SelectedValue.Equals("Central Excise"))
{
int? id = Int32.Parse(row.Cells[2].Text);
CEActsTableAdapter index = new CEActsTableAdapter();
index.CEDeleteById(id);
LoadCEActs(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Forms") && ddlcatagory.SelectedValue.Equals("Central Excise"))
{
int? id = Int32.Parse(row.Cells[2].Text);
CEActsTableAdapter index = new CEActsTableAdapter();
index.CEDeleteById(id);
LoadCEActs(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Section 37B Order") && ddlcatagory.SelectedValue.Equals("Central Excise"))
{
int? id = Int32.Parse(row.Cells[2].Text);
CEActsTableAdapter index = new CEActsTableAdapter();
index.CEDeleteById(id);
LoadCEActs(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Case Laws") && ddlcatagory.SelectedValue.Equals("Central Excise"))
{
int? id = Int32.Parse(row.Cells[2].Text);
CEActsTableAdapter index = new CEActsTableAdapter();
index.CEDeleteById(id);
LoadCEActs(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Tariff 2012-13") && ddlcatagory.SelectedValue.Equals("Central Excise"))
{
int? id = Int32.Parse(row.Cells[1].Text);
CentralExcise_Tariff_GetAllTableAdapter index = new CentralExcise_Tariff_GetAllTableAdapter();
index.DeleteTariffById(id);
LoadCETariff(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Notifications") && ddlcatagory.SelectedValue.Equals("Central Excise"))
{
int? id = Int32.Parse(row.Cells[1].Text);
CECNotification_GetAllTableAdapter index = new CECNotification_GetAllTableAdapter();
index.DeleteCENotificationById(id);
LoadCENotification(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Circulars/Instructions") && ddlcatagory.SelectedValue.Equals("Central Excise"))
{
int? id = Int32.Parse(row.Cells[5].Text);
Circulars_Info_ByyearTableAdapter index = new Circulars_Info_ByyearTableAdapter();
index.DeleteCEcircularsById(id);
LoadCECircularsInstructions(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Acts") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[3].Text);
ActsTableAdapter index = new ActsTableAdapter();
index.DeleteCustomsById(id);
LoadCustoms(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Rules") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[3].Text);
ActsTableAdapter index = new ActsTableAdapter();
index.DeleteCustomsById(id);
LoadCustoms(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Forms") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[3].Text);
ActsTableAdapter index = new ActsTableAdapter();
index.DeleteCustomsById(id);
LoadCustoms(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Case Laws") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[3].Text);
ActsTableAdapter index = new ActsTableAdapter();
index.DeleteCustomsById(id);
LoadCustoms(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Regulations") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[3].Text);
ActsTableAdapter index = new ActsTableAdapter();
index.DeleteCustomsById(id);
LoadCustoms(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Tariff 2012-13") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[1].Text);
Custom_Tariff_GetAllTableAdapter index = new Custom_Tariff_GetAllTableAdapter();
index.DeleteCustomTariffById(id);
LoadCustomsTariff(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Notifications") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[1].Text);
CECNotification_GetAllTableAdapter index = new CECNotification_GetAllTableAdapter();
index.DeleteCENotificationById(id);
LoadCENotification(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Circulars/Instructions") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[5].Text);
Circulars_Info_ByyearTableAdapter index = new Circulars_Info_ByyearTableAdapter();
index.DeleteCEcircularsById(id);
LoadCECircularsInstructions(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("SEZ") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[3].Text);
ActsTableAdapter index = new ActsTableAdapter();
index.DeleteCustomsById(id);
LoadCustoms(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Drawback Schedule") && ddlcatagory.SelectedValue.Equals("Customs"))
{
int? id = Int32.Parse(row.Cells[3].Text);
ActsTableAdapter index = new ActsTableAdapter();
index.DeleteCustomsById(id);
LoadCustoms(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Act 1994") && ddlcatagory.SelectedValue.Equals("Service Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
ServiceTax_GetAllTableAdapter index = new ServiceTax_GetAllTableAdapter();
index.DeleteSTById(id);
LoadST(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("ST Rules") && ddlcatagory.SelectedValue.Equals("Service Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
ServiceTax_GetAllTableAdapter index = new ServiceTax_GetAllTableAdapter();
index.DeleteSTById(id);
LoadST(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Forms and Registers") && ddlcatagory.SelectedValue.Equals("Service Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
ServiceTax_GetAllTableAdapter index = new ServiceTax_GetAllTableAdapter();
index.DeleteSTById(id);
LoadST(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Accounting Codes for new services") && ddlcatagory.SelectedValue.Equals("Service Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
ServiceTax_GetAllTableAdapter index = new ServiceTax_GetAllTableAdapter();
index.DeleteSTById(id);
LoadST(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Case Laws") && ddlcatagory.SelectedValue.Equals("Service Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
STCaselaws_GetAllTableAdapter index = new STCaselaws_GetAllTableAdapter();
index.DeleteSTCaseLawsById(id);
LoadSTCaseLaws(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Notifications") && ddlcatagory.SelectedValue.Equals("Service Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
STN_GetAllTableAdapter index = new STN_GetAllTableAdapter();
index.DeleteSTNById(id);
LoadSTNotification(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Circulars/Instructions") && ddlcatagory.SelectedValue.Equals("Service Tax"))
{
int? id = Int32.Parse(row.Cells[5].Text);
Circulars_Info_ByyearTableAdapter index = new Circulars_Info_ByyearTableAdapter();
index.DeleteCEcircularsById(id);
LoadCECircularsInstructions(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Acts") && ddlcatagory.SelectedValue.Equals("Income Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
IncomeTaxActs_SelectAllTableAdapter index = new IncomeTaxActs_SelectAllTableAdapter();
index.DeleteITActsById(id);
LoadITActs(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Rules") && ddlcatagory.SelectedValue.Equals("Income Tax"))
{
int? id = Int32.Parse(row.Cells[9].Text);
IncomeTaxRules_SelectAllTableAdapter index = new IncomeTaxRules_SelectAllTableAdapter();
index.DeleteITRulesById(id);
LoadITRules(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Circulars") && ddlcatagory.SelectedValue.Equals("Income Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
IncomeTaxCircularsNotification_SelectAllTableAdapter index = new IncomeTaxCircularsNotification_SelectAllTableAdapter();
index.DeleteITCNById(id);
LoadITCN(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Notifications") && ddlcatagory.SelectedValue.Equals("Income Tax"))
{
int? id = Int32.Parse(row.Cells[1].Text);
IncomeTaxCircularsNotification_SelectAllTableAdapter index = new IncomeTaxCircularsNotification_SelectAllTableAdapter();
index.DeleteITCNById(id);
LoadITCN(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("FTP") && ddlcatagory.SelectedValue.Equals("DGFT"))
{
int? id = Int32.Parse(row.Cells[1].Text);
DGFT_GetAllTableAdapter index = new DGFT_GetAllTableAdapter();
index.DeleteDGFTById(id);
LoadDGFT(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("FTDR Notifications") && ddlcatagory.SelectedValue.Equals("DGFT"))
{
int? id = Int32.Parse(row.Cells[1].Text);
DGFT_GetAllTableAdapter index = new DGFT_GetAllTableAdapter();
index.DeleteDGFTById(id);
LoadDGFT(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("public notices") && ddlcatagory.SelectedValue.Equals("DGFT"))
{
int? id = Int32.Parse(row.Cells[1].Text);
DGFTpublicnotices_GETALLTableAdapter index = new DGFTpublicnotices_GETALLTableAdapter();
index.DeleteDgftPNById(id);
LoadDGFTPN(editGrid);
}
if (ddlsubcategory.SelectedValue.Equals("Circulars/Instructions") && ddlcatagory.SelectedValue.Equals("DGFT"))
{
}
if (ddlsubcategory.SelectedValue.Equals("SION") && ddlcatagory.SelectedValue.Equals("DGFT"))
{
}
}
protected void lbshowDoc_Click(object sender, EventArgs e)
{
int? id = Int32.Parse(hdnId.Value);
if (ddlcatagory.SelectedValue.Equals("Central Excise"))
{
if (ddlsubcategory.SelectedValue.Equals("Tariff 2012-13"))
{
CentralExcise_Tariff_GetAllTableAdapter indexTariff = new CentralExcise_Tariff_GetAllTableAdapter();
DataTable dataTariff = indexTariff.SelectAllById(id);
if (dataTariff.Rows.Count > 0)
{
byte[] b = ((byte[])dataTariff.Rows[0]["Document"]);
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else if (ddlsubcategory.SelectedValue.Equals("Circulars/Instructions"))
{
Circulars_Info_ByyearTableAdapter index = new Circulars_Info_ByyearTableAdapter();
DataTable dtActs = index.GetCEcircularsById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else
{
CEActsTableAdapter index = new CEActsTableAdapter();
DataTable dtActs = index.CEGetAllById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
}
if (ddlcatagory.SelectedValue.Equals("Customs"))
{
if (ddlsubcategory.SelectedValue.Equals("Tariff 2012-13"))
{
Custom_Tariff_GetAllTableAdapter indexTariff = new Custom_Tariff_GetAllTableAdapter();
DataTable dataTariff = indexTariff.SelectCustomTariffById(id);
if (dataTariff.Rows.Count > 0)
{
byte[] b = ((byte[])dataTariff.Rows[0]["Document"]);
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else if (ddlsubcategory.SelectedValue.Equals("Circulars/Instructions"))
{
Circulars_Info_ByyearTableAdapter index = new Circulars_Info_ByyearTableAdapter();
DataTable dtActs = index.GetCEcircularsById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else
{
ActsTableAdapter index = new ActsTableAdapter();
DataTable dtActs = index.GetAllCustomsById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
}
if (ddlcatagory.SelectedValue.Equals("Service Tax"))
{
if (ddlsubcategory.SelectedValue.Equals("Case Laws"))
{
STCaselaws_GetAllTableAdapter indexTariff = new STCaselaws_GetAllTableAdapter();
DataTable dataTariff = indexTariff.SelectSTCaseLawsById(id);
if (dataTariff.Rows.Count > 0)
{
byte[] b = ((byte[])dataTariff.Rows[0]["Document"]);
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else if (ddlsubcategory.SelectedValue.Equals("Notifications"))
{
STN_GetAllTableAdapter index = new STN_GetAllTableAdapter();
DataTable dtActs = index.GetAllSTNById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else if (ddlsubcategory.SelectedValue.Equals("Circulars/Instructions"))
{
Circulars_Info_ByyearTableAdapter index = new Circulars_Info_ByyearTableAdapter();
DataTable dtActs = index.GetCEcircularsById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else
{
ServiceTax_GetAllTableAdapter index = new ServiceTax_GetAllTableAdapter();
DataTable dtActs = index.SelectAllSTById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
}
if (ddlcatagory.SelectedValue.Equals("Income Tax"))
{
if (ddlsubcategory.SelectedValue.Equals("Acts"))
{
IncomeTaxActs_SelectAllTableAdapter indexTariff = new IncomeTaxActs_SelectAllTableAdapter();
DataTable dataTariff = indexTariff.GetITActsById(id);
if (dataTariff.Rows.Count > 0)
{
byte[] b = ((byte[])dataTariff.Rows[0]["Document"]);
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else if (ddlsubcategory.SelectedValue.Equals("Rules"))
{
IncomeTaxRules_SelectAllTableAdapter index = new IncomeTaxRules_SelectAllTableAdapter();
DataTable dtActs = index.GetITRulesById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else
{
IncomeTaxCircularsNotification_SelectAllTableAdapter index = new IncomeTaxCircularsNotification_SelectAllTableAdapter();
DataTable dtActs = index.GetITCNById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
}
if (ddlcatagory.SelectedValue.Equals("DGFT"))
{
if (ddlsubcategory.SelectedValue.Equals("public notices"))
{
DGFTpublicnotices_GETALLTableAdapter indexTariff = new DGFTpublicnotices_GETALLTableAdapter();
DataTable dataTariff = indexTariff.GetAllDgftPNById(id);
if (dataTariff.Rows.Count > 0)
{
byte[] b = ((byte[])dataTariff.Rows[0]["Document"]);
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
else
{
DGFT_GetAllTableAdapter index = new DGFT_GetAllTableAdapter();
DataTable dtActs = index.GetDGFTById(id);
if (dtActs.Rows.Count > 0)
{
byte[] b = ((byte[])dtActs.Rows[0]["Document"]);
//Collect Bytes from database and write in Webpage
Response.ContentType = "application/pdf";
Response.BinaryWrite(b);
}
}
}
}
