protected void btnSubmit_Click(object sender, EventArgs e)
{
if (btn_submit.Text == "Update")
{
foreach (GridViewRow item in GV_ServerTable.Rows)
{
Label lbl_TableID = (Label)(item.FindControl("lbl_TableID"));
Label lbl_LBDAtabaseName = (Label)(item.FindControl("lbl_LBDAtabaseName"));
Label lnl_LBInstance = (Label)(item.FindControl("lnl_LBInstance"));
Label lbl_Tablename = (Label)(item.FindControl("lbl_Tablename"));
Label lbl_serverid = (Label)(item.FindControl("lbl_serverid"));
CheckBox cbItem = (CheckBox)(item.FindControl("cbItem"));
DropDownList DDLLiceTableName = (DropDownList)(item.FindControl("DDLLiceTableName"));
//DropDownList DDLLiceTablepkname = (DropDownList)(item.FindControl("DDLLiceTablepkname"));
TextBox txt_fkname = (TextBox)(item.FindControl("txt_fkname"));
TextBox txt_addquery = (TextBox)(item.FindControl("txt_addquery"));
string TbleName = DDLLiceTableName.SelectedItem.Text;
if (cbItem.Checked == true)
{
//Create Temp Table
// Table_DatabaseSQL.Create_Temp_Table_Design_With_Change_Datatype(DDLLiceTableName.SelectedItem.Text);
string filepath = Server.MapPath("");
DataTable GetColum1 = MyCommonfile.selectBZ("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + DDLLiceTableName.SelectedItem.Text + "'");
if (GetColum1.Rows.Count > 0)
{
string script1 = "";
string script2 = "";
string script3 = "";
Delete_TRIGGER(filepath, TbleName, GetColum1.Rows[0][0].ToString(), DDLLiceTableName.SelectedValue);
Insert_TRIGGER(filepath, TbleName, GetColum1.Rows[0][0].ToString(), DDLLiceTableName.SelectedValue);
Update_TRIGGER(filepath, TbleName, GetColum1.Rows[0][0].ToString(), DDLLiceTableName.SelectedValue);
script1 = File.ReadAllText(filepath + "\\sqlfile1.sql");
script2 = File.ReadAllText(filepath + "\\sqlfile2.sql");
script3 = File.ReadAllText(filepath + "\\sqlfile3.sql");
try
{
if (con.State.ToString() != "Open")
{
con.Open();
}
try
{
SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_DELETE]", con);
commandD1.ExecuteNonQuery();
}
catch
{
}
SqlCommand command1 = new SqlCommand(script1, con);
command1.ExecuteNonQuery();
if (con.State.ToString() != "Open")
{
con.Open();
}
try
{
SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_INSERT]", con);
commandD1.ExecuteNonQuery();
}
catch
{
}
SqlCommand command2 = new SqlCommand(script2, con);
command2.ExecuteNonQuery();
if (con.State.ToString() != "Open")
{
con.Open();
}
try
{
SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_UPDATE]", con);
commandD1.ExecuteNonQuery();
}
catch
{
}
SqlCommand command3 = new SqlCommand(script3, con);
command3.ExecuteNonQuery();
}
catch (Exception ex)
{
lblmsg.Text = ex.ToString();
}
}
SqlCommand cmd2 = new SqlCommand("SatelliteSyncronisationrequiringTablesMaster_AddDelUpdtSelect", con);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@StatementType", "DeleteSTBLID");
cmd2.Parameters.AddWithValue("@ServerTableID", lbl_TableID.Text);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd2.ExecuteNonQuery();
con.Close();
SqlCommand cmd = new SqlCommand("SatelliteSyncronisationrequiringTablesMaster_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@ProductVersionID", LBproductversion);
cmd.Parameters.AddWithValue("@TableId", DDLLiceTableName.SelectedValue);
cmd.Parameters.AddWithValue("@Name", DDLLiceTableName.SelectedItem.Text);
cmd.Parameters.AddWithValue("@Status", cbItem.Checked);
cmd.Parameters.AddWithValue("@TableName", DDLLiceTableName.SelectedItem.Text);
cmd.Parameters.AddWithValue("@ServerTableID", lbl_TableID.Text);
cmd.Parameters.AddWithValue("@ServerDatabaseID", ddlcodetype.SelectedValue);
cmd.Parameters.AddWithValue("@ServerProductVersionID", ddlProductname.SelectedValue);
cmd.Parameters.AddWithValue("@ServerTableName", ddlProductname.SelectedValue);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
SqlCommand cmd1 = new SqlCommand("SatelliteSyncronisationrequiringTablesMaster_SerWhere_AddDelUpdtSelect", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@StatementType", "Insert");
cmd1.Parameters.AddWithValue("@PKTableName", DDLLiceTableName.SelectedItem.Text);
cmd1.Parameters.AddWithValue("@PKIdName", txt_fkname.Text);
cmd1.Parameters.AddWithValue("@Select_Query", txt_addquery.Text);
cmd1.Parameters.AddWithValue("@TableId", DDLLiceTableName.SelectedValue);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd1.ExecuteNonQuery();
con.Close();
//
}
else
{
try
{
Table_DatabaseSQL.Delete_Temp_Table(lbl_Tablename.Text);
}
catch
{
}
SqlCommand cmd = new SqlCommand("SatelliteSyncronisationrequiringTablesMaster_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "DeleteSTBLID");
cmd.Parameters.AddWithValue("@ServerTableID", lbl_TableID.Text);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
SqlCommand cmd1 = new SqlCommand("SatelliteSyncronisationrequiringTablesMaster_SerWhere_AddDelUpdtSelect", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@StatementType", "DeleteTableId");
cmd1.Parameters.AddWithValue("@TableId", lbl_TableID.Text);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmd1.ExecuteNonQuery();
con.Close();
try
{
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_DELETE]", con);
commandD1.ExecuteNonQuery();
con.Close();
}
catch
{
con.Close();
}
try
{
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_INSERT]", con);
commandD1.ExecuteNonQuery();
con.Close();
}
catch
{
con.Close();
}
try
{
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_UPDATE]", con);
commandD1.ExecuteNonQuery();
con.Close();
}
catch
{
con.Close();
}
}
}
lblmsg.Text = "Record Update Successfully";
Cleare();
FillDefault();
btn_submit.Text = "Edit";
pnlpr.Enabled = false;
}
else
{
btn_submit.Text = "Update";
pnlpr.Enabled = true;
}
}
