// protected void Create__Job3_From_Log2(string SId,string Job1ID)
//{
// Int64 recordid = 0;
// recordid = 0;
// DataTable dstbl = MyCommonfile.selectBZ(" SELECT DISTINCT TOP (1) dbo.Satellite_Server_Sync_Job_Details.TableID, dbo.Satellite_Server_Sync_Job_Details.ID, dbo.ClientProductTableMaster.TableName FROM dbo.Satellite_Server_Sync_Job_Details INNER JOIN dbo.ClientProductTableMaster ON dbo.Satellite_Server_Sync_Job_Details.TableID = dbo.ClientProductTableMaster.Id where Satelitte_Server_Sync_Job_Master_ID='" + Job1ID + "' and CheckingStatus=0 Order By TableID ");
// if (dstbl.Rows.Count>0)
// {
// DataTable ds = MyCommonfile.selectBZ(" Select * From Sync_Need_Logs_AtServer where sid='" + SId + "' and TAbleId='" + dstbl.Rows[0]["TableID"].ToString() + "' Order By LogId ");
// for (int iii = 0; iii < ds.Rows.Count; iii++)
// {
// recordid++;
// string ID = ds.Rows[iii]["ID"].ToString();
// string LogId = ds.Rows[iii]["LogId"].ToString();
// string Rcordid = ds.Rows[iii]["Rcordid"].ToString();
// string TableId = ds.Rows[iii]["TAbleId"].ToString();
// string action = "1";
// if (ds.Rows[iii]["ACTION"].ToString() == "INSERT")
// {
// action = "1";
// }
// else if (ds.Rows[iii]["ACTION"].ToString() == "Updated")
// {
// action = "2";
// }
// else if (ds.Rows[iii]["ACTION"].ToString() == "Deleted")
// {
// action = "3";
// }
// // Int64 ReturnID = Insert_Satallite_Server_Sync_RecordsDetailTbl(Convert.ToString(Satallite_Server_Sync_RecordsMasterTblID), Rcordid, DateTime.Now, action, action);
// Int64 ReturnID2 =Syncro_Tables.InsertJob3___Satelite_Server_Sync_Log_Deatils(dstbl.Rows[0]["ID"].ToString(), Rcordid, DateTime.Now, action, "", false);
// Syncro_Tables.DELETE___Sync_Need_Logs_AtServer(ID);
// }
// lbl_Msg.Text += "<br> Total " + recordid + " Record Are Inseted In " + dstbl.Rows[0]["TableName"].ToString() + " Table ";
// Boolean jobc2heckstatus = Syncro_Tables.UpdateJob2___Satellite_Server_Sync_Job_Details(dstbl.Rows[0]["ID"].ToString(), false, true, DateTime.Now, false, DateTime.Now);
// }
// else
// {
// img_loading.Visible = false;
// lbl_Msg.Text += "<br> Job Done Successfully ";
// Boolean status2 = Syncro_Tables.UpdateJob1___Satelitte_Server_Sync_Job_Master(Convert.ToString(Job1ID), true, DateTime.Now);
// Timer1.Enabled = false;
// }
//}
protected void GetSync_Create_Serv_List___InsertAtLog2(string ServerID)
{
DataTable DTTable = MyCommonfile.selectBZ(@" SELECT DISTINCT dbo.ClientProductTableMaster.Id AS TableId, dbo.ClientProductTableMaster.TableName, dbo.SatelliteSyncronisationrequiringTablesMaster_SerWhere.PKTableName, dbo.SatelliteSyncronisationrequiringTablesMaster_SerWhere.PKIdName, dbo.SatelliteSyncronisationrequiringTablesMaster_SerWhere.Select_Query FROM dbo.ClientProductTableMaster INNER JOIN dbo.SatelliteSyncronisationrequiringTablesMaster ON dbo.SatelliteSyncronisationrequiringTablesMaster.TableID = dbo.ClientProductTableMaster.Id INNER JOIN dbo.SatelliteSyncronisationrequiringTablesMaster_SerWhere ON dbo.SatelliteSyncronisationrequiringTablesMaster.TableID = dbo.SatelliteSyncronisationrequiringTablesMaster_SerWhere.TableId ");
for (int iicouts = 0; iicouts < DTTable.Rows.Count; iicouts++)
{
Int64 RecordInserted = Table_DatabaseSQL.All_Table_All_Record__InsertAtLog2(DTTable.Rows[iicouts]["TableName"].ToString(), DTTable.Rows[iicouts]["TableId"].ToString(), ServerID, DTTable.Rows[iicouts]["PKTableName"].ToString(), DTTable.Rows[iicouts]["PKIdName"].ToString(), DTTable.Rows[iicouts]["Select_Query"].ToString());
lbl_Msg.Text = "Total " + RecordInserted + " Record Are Inseted In " + DTTable.Rows[iicouts]["TableName"].ToString() + " Table ";
//pnl_loading.Visible = true;
//Timer1.Enabled = true;
}
lblContentThreeDate.Text = "All Table Record Inserted Successfully";
// Response.Redirect("Silent_Synchronoze.aspx?sid=" + ServerID + "&job=yes");
}
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;
}
}
