// 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; } }