예제 #1
0
    public static Boolean Delete_CompanyABCDetail_Server(string CompanyLoginId)
    {
        Boolean Status = false;

        try
        {
            SqlConnection connCompserver = new SqlConnection();
            connCompserver = ServerWizard.ServerDefaultInstanceConnetionTCP(CompanyLoginId);
            if (connCompserver.State.ToString() != "Open")
            {
                connCompserver.Open();
            }
            SqlCommand cmdDel = new SqlCommand("CompanyABCDetail_AddDelUpdtSelect", connCompserver);
            cmdDel.CommandType = CommandType.StoredProcedure;
            cmdDel.Parameters.AddWithValue("@StatementType", "Delete");
            cmdDel.Parameters.AddWithValue("@CompanyLoginId", CompanyLoginId);
            cmdDel.ExecuteNonQuery();
            Status = true;
        }
        catch
        {
            Status = false;
        }
        return(Status);
    }
    public Boolean CheckDbConn()
    {
        Boolean   status        = false;
        DataTable dtdatabaseins = MyCommonfile.selectBZ(@"SELECT dbo.CodeTypeTbl.Instancename, dbo.CodeTypeTbl.ID, dbo.CodeTypeTbl.ProductCodeDetailId, dbo.ClientMaster.ServerId FROM dbo.CodeTypeTbl INNER JOIN dbo.ClientMaster INNER JOIN dbo.ProductMaster ON dbo.ClientMaster.ClientMasterId = dbo.ProductMaster.ClientMasterId INNER JOIN dbo.VersionInfoMaster ON dbo.ProductMaster.ProductId = dbo.VersionInfoMaster.ProductId ON dbo.CodeTypeTbl.ProductVersionId = dbo.VersionInfoMaster.VersionInfoId where dbo.CodeTypeTbl.ProductCodeDetailId='" + ddlctype.SelectedValue + "'");

        if (dtdatabaseins.Rows.Count > 0)
        {
            string serverid = dtdatabaseins.Rows[0]["ServerId"].ToString();
            string serversqlinstancename = dtdatabaseins.Rows[0]["Instancename"].ToString();
            conn1 = new SqlConnection();
            conn1 = ServerWizard.ServerDatabaseFromInstanceTCP(serverid, serversqlinstancename, ddlctype.SelectedItem.Text);
            try
            {
                if (conn1.State.ToString() != "Open")
                {
                    conn1.Open();
                    status = true;
                    img_dbconn.ImageUrl = "~/images/DatabaseConnection/DatabaseConnTrue.png";
                    img_dbconn.Visible  = true;
                    conn1.Close();
                }
            }
            catch
            {
                img_dbconn.ImageUrl = "~/images/DatabaseConnection/DatabaseConnFalse.png";
                img_dbconn.Visible  = true;
            }
        }
        return(status);
    }
예제 #3
0
    public static Boolean Insert_CompanyABCDetail_SERVER(string CompanyLoginId, string Z, string D1, string D2, string D3, string D4, string D5, string E1, string E2, string E3, string E4, string E5, string F1, string F2, string F3, string F4, string F5)
    {
        Boolean Status = false;

        try
        {
            SqlConnection connCompserver = new SqlConnection();
            connCompserver = ServerWizard.ServerDefaultInstanceConnetionTCP(CompanyLoginId);
            if (connCompserver.State.ToString() != "Open")
            {
                connCompserver.Open();
            }
            SqlCommand cmd = new SqlCommand("CompanyABCDetail_AddDelUpdtSelect", connCompserver);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@StatementType", "Insert");
            cmd.Parameters.AddWithValue("@CompanyLoginId", CompanyLoginId);
            cmd.Parameters.AddWithValue("@Z", Z);

            cmd.Parameters.AddWithValue("@D1", D1);
            cmd.Parameters.AddWithValue("@D2", D1);
            cmd.Parameters.AddWithValue("@D3", D3);
            cmd.Parameters.AddWithValue("@D4", D4);
            cmd.Parameters.AddWithValue("@D5", D5);

            cmd.Parameters.AddWithValue("@E1", E1);
            cmd.Parameters.AddWithValue("@E2", E1);
            cmd.Parameters.AddWithValue("@E3", E3);
            cmd.Parameters.AddWithValue("@E4", E4);
            cmd.Parameters.AddWithValue("@E5", E5);

            cmd.Parameters.AddWithValue("@F1", F1);
            cmd.Parameters.AddWithValue("@F2", F1);
            cmd.Parameters.AddWithValue("@F3", F3);
            cmd.Parameters.AddWithValue("@F4", F4);
            cmd.Parameters.AddWithValue("@F5", F5);
            cmd.ExecuteNonQuery();
            connCompserver.Close();
            Status = true;
        }
        catch
        {
            Status = false;
        }
        return(Status);
    }
    protected void FullTableSync()
    {
        Boolean connnection = false;
        string  Delete_From = "";
        string  PKname      = "";

        conn = new SqlConnection();
        try
        {
            conn = ServerWizard.ServerDefaultInstanceConnetionTCP_Serverid(ViewState["sid"].ToString());
            if (conn.State.ToString() != "Open")
            {
                conn.Open();
            }
            conn.Close();
            connnection = true;
        }
        catch (Exception ex)
        {
        }
        if (connnection == true)
        {
            encstr = ServerWizard.ServerEncrDecriKEY(ViewState["sid"].ToString());
            DataTable dt = MyCommonfile.selectBZ("Select * From ClientProductTableMaster where Id=" + ViewState["tblid"] + "");
            if (dt.Rows.Count > 0)
            {
                CreateTableDesign("" + dt.Rows[0]["TableName"].ToString() + "");
                try
                {
                    SqlCommand ccm = new SqlCommand(" Delete From " + dt.Rows[0]["TableName"].ToString() + " ", conn);
                    if (conn.State.ToString() != "Open")
                    {
                        conn.Open();
                    }
                    ccm.ExecuteNonQuery();
                    conn.Close();
                }
                catch
                {
                    conn.Close();
                }
                Dynamicaly_FullTable(dt.Rows[0]["TableName"].ToString(), dt.Rows[0]["Id"].ToString());
            }
        }
    }
예제 #5
0
 protected void PortConnectionCheck()
 {
     Portconn = false;
     conn     = new SqlConnection();
     conn     = ServerWizard.ServerDefaultInstanceConnetionTCP_Serverid(lblsid.Text);
     try
     {
         if (conn.State.ToString() != "Open")
         {
             conn.Open();
         }
         Portconn = true;
     }
     catch
     {
         Portconn = false;
     }
 }
예제 #6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            // string sidd = BZ_Common.BZ_Encrypted("5");
            if (Request.QueryString["Cid"] != null)
            {
                string companyid = Request.QueryString["Cid"];
                lblcid.Text = companyid;
                Boolean Comp__Actve__Status = CompanyWizard.Company_Active_Status(companyid);
                Boolean Comp__Licen__Active = CompanyWizard.Company_LicenseExpire_Status(companyid);
                Boolean Server__Active      = ServerWizard.Server_Active_Status(companyid);

                if (Comp__Actve__Status == true && Comp__Licen__Active == true && Server__Active == true)
                {
                    DataTable DTGetSid = CompanyWizard.SelectCompanyInfo(companyid);
                    string    sid      = DTGetSid.Rows[0]["ServerId"].ToString();
                    lblsid.Text = sid;
                    FillFrid(lblsid.Text);
                }
                else if (Comp__Actve__Status == false)
                {
                    lblmsg.Text = "Company not active ";
                }
                else if (Comp__Licen__Active == false)
                {
                    lblmsg.Text = "License Expired";
                }
                else if (Server__Active == false)
                {
                    lblmsg.Text = "Server Inactive";
                }
            }
            else
            {
                lblmsg.Text = "No any recrd for company";
            }
        }
    }
예제 #7
0
 protected void PortConnectionCheck()
 {
     Portconn = false;
     conn     = new SqlConnection();
     conn     = ServerWizard.ServerDefaultInstanceConnetionTCP_Serverid(ddlserver.SelectedValue);
     try
     {
         if (conn.State.ToString() != "Open")
         {
             conn.Open();
         }
         link_openport.Text    = "";
         link_openport.Enabled = false;
         Portconn = true;
     }
     catch
     {
         link_openport.Text    = "";
         link_openport.Enabled = true;
         Portconn = false;
     }
 }
예제 #8
0
    protected void InsertAtServer____FromJob3(string SId)
    {
        Boolean connnection  = false;
        int     c            = 0;
        string  Delete_From  = "";
        string  PKname       = "";
        string  deleteJob3ID = "";

        conn = new SqlConnection();
        try
        {
            conn = ServerWizard.ServerDefaultInstanceConnetionTCP_Serverid(SId);
            if (conn.State.ToString() != "Open")
            {
                conn.Open();
            }
            conn.Close();
            connnection = true;
        }
        catch (Exception ex)
        {
        }

        if (connnection == true)
        {
            int       totalrec          = 0;
            string    Bunchinsert       = "";
            string    seridstatus       = "";
            string    Insert_IntoCommon = "";
            DataTable dtcln             = new DataTable();
            DataTable dtJob1            = MyCommonfile.selectBZ(@" SELECT DISTINCT Satelitte_Server_Sync_Job_Master.Id AS Job1ID, Satelitte_Server_Sync_Job_Master.SatelliteServerID,ServerMasterTbl.ServerName,ServerMasterTbl.serverloction, dbo.Satelitte_Server_Sync_Job_Master.JobDateTime FROM dbo.Satelitte_Server_Sync_Job_Master INNER JOIN dbo.ServerMasterTbl ON dbo.Satelitte_Server_Sync_Job_Master.SatelliteServerID = dbo.ServerMasterTbl.Id Where Satelitte_Server_Sync_Job_Master.SatelliteServerID='" + SId + "'");
            if (dtJob1.Rows.Count > 0)
            {
                encstr = ServerWizard.ServerEncrDecriKEY(SId);
                for (int i1 = 0; i1 < dtJob1.Rows.Count; i1++)
                {
                    string    Job1ID     = dtJob1.Rows[i1]["Job1ID"].ToString();
                    string    ServerName = dtJob1.Rows[i1]["ServerName"].ToString();
                    DataTable dtJob2     = MyCommonfile.selectBZ(@" SELECT TOP(1) Satellite_Server_Sync_Job_Details.ID AS Job2ID,Satellite_Server_Sync_Job_Details.TableID, dbo.ClientProductTableMaster.Id, dbo.ClientProductTableMaster.TableName FROM dbo.Satellite_Server_Sync_Job_Details INNER JOIN dbo.ClientProductTableMaster INNER JOIN dbo.SatelliteSyncronisationrequiringTablesMaster ON dbo.SatelliteSyncronisationrequiringTablesMaster.TableID = dbo.ClientProductTableMaster.Id ON dbo.Satellite_Server_Sync_Job_Details.TableID = dbo.SatelliteSyncronisationrequiringTablesMaster.TableID Where Satellite_Server_Sync_Job_Details.Satelitte_Server_Sync_Job_Master_ID='" + Job1ID + "' ");
                    if (dtJob2.Rows.Count > 0)
                    {
                        for (int i2 = 0; i2 < dtJob2.Rows.Count; i2++)
                        {
                            string Job2ID    = dtJob2.Rows[i2]["Job2ID"].ToString();
                            string TableName = dtJob2.Rows[i2]["TableName"].ToString();
                            string TableId   = dtJob2.Rows[i2]["TableID"].ToString();
                            CreateTableDesign(TableName);

                            DataTable dtJob3 = MyCommonfile.selectBZ(@" SELECT TOP(500) Satelite_Server_Sync_Log_Deatils.ID AS Job3ID,Satelite_Server_Sync_Log_Deatils.TypeOfOperationDone , Satelite_Server_Sync_Log_Deatils.RecordID, SyncActionMaster.ActionName FROM Satelite_Server_Sync_Log_Deatils INNER JOIN dbo.SyncActionMaster ON dbo.Satelite_Server_Sync_Log_Deatils.TypeOfOperationDone = dbo.SyncActionMaster.ID Where Satelite_Server_Sync_Log_Deatils.Satellite_Server_Sync_Job_Details_ID='" + Job2ID + "'  ");
                            if (dtJob3.Rows.Count > 0)
                            {
                                Insert_IntoCommon = " INSERT INTO " + TableName + "(  ";
                                DataTable dts1 = MyCommonfile.selectBZ(" select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + TableName + "'");
                                for (int k = 0; k < dts1.Rows.Count; k++)
                                {
                                    Insert_IntoCommon += ("" + dts1.Rows[k]["column_name"] + " ,");
                                }
                                Insert_IntoCommon  = Insert_IntoCommon.Remove(Insert_IntoCommon.Length - 1);
                                Insert_IntoCommon += ") Values ";

                                // DataTable maxiddesid = MyCommonfile.selectBZ(" select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tablename + "'");
                                PKname = TableRelated.SatelliteSyncronisationrequiringTablesMaster_WherePKIDName(TableId);
                                if (PKname.Length > 0)
                                {
                                }
                                else
                                {
                                    PKname = dts1.Rows[0]["column_name"].ToString();
                                }
                                for (int iii = 0; iii < dtJob3.Rows.Count; iii++)
                                {
                                    string Job3ID        = dtJob3.Rows[iii]["Job3ID"].ToString();
                                    string RecordID      = dtJob3.Rows[iii]["RecordID"].ToString();
                                    string Typeoperation = dtJob3.Rows[iii]["TypeOfOperationDone"].ToString();
                                    deleteJob3ID += Job3ID + ",";
                                    try
                                    {
                                        if (Typeoperation == "1")
                                        {
                                            DataTable dtr = MyCommonfile.selectBZ(" Select * From " + TableName + " where " + PKname + "=" + RecordID + " ");
                                            foreach (DataRow itm in dtr.Rows)
                                            {
                                                c++;
                                                string Insert_Into = "";
                                                Insert_Into += " (";
                                                for (int k = 0; k < dts1.Rows.Count; k++)
                                                {
                                                    Insert_Into += "'" + Encrypted(Convert.ToString(itm["" + dts1.Rows[k]["column_name"] + ""])) + "' ,";
                                                }
                                                Insert_Into  = Insert_Into.Remove(Insert_Into.Length - 1);
                                                Insert_Into += " ),";
                                                Bunchinsert += Insert_Into;
                                                if (c == 200)
                                                {
                                                    Bunchinsert = Bunchinsert.Remove(Bunchinsert.Length - 1);
                                                    string     ss  = Insert_IntoCommon + Bunchinsert;
                                                    SqlCommand ccm = new SqlCommand(ss, conn);
                                                    if (conn.State.ToString() != "Open")
                                                    {
                                                        conn.Open();
                                                    }
                                                    ccm.ExecuteNonQuery();
                                                    conn.Close();

                                                    deleteJob3ID = deleteJob3ID.Remove(deleteJob3ID.Length - 1);
                                                    SqlCommand ccmm = new SqlCommand(" Delete From Satelite_Server_Sync_Log_Deatils Where ID IN (" + deleteJob3ID + ")", con);
                                                    if (con.State.ToString() != "Open")
                                                    {
                                                        con.Open();
                                                    }
                                                    ccmm.ExecuteNonQuery();
                                                    con.Close();

                                                    deleteJob3ID = "";
                                                    Bunchinsert  = "";
                                                    c            = 0;
                                                }
                                            }
                                        }
                                        totalrec++;
                                        //Permanent Record Functionality
                                        //----****
                                        //
                                        // lblmsg.Text = " Successfully synchronization ";//" + totalrec + " records for " + lblname.Text + " server record " + lbl_RecordID.Text + "<br><br>";
                                    }
                                    catch
                                    {
                                        seridstatus  = SId;
                                        Bunchinsert  = "";
                                        lbl_Msg.Text = " Some problem when synchronization with " + ServerName + " server <br><br>";//e1.ToString()+"<br>";
                                    }
                                }//Job1 Loop
                                if (Bunchinsert.Length > 0)
                                {
                                    Bunchinsert = Bunchinsert.Remove(Bunchinsert.Length - 1);
                                    string     ss  = Insert_IntoCommon + Bunchinsert;
                                    SqlCommand ccm = new SqlCommand(ss, conn);
                                    if (conn.State.ToString() != "Open")
                                    {
                                        conn.Open();
                                    }
                                    ccm.ExecuteNonQuery();
                                    conn.Close();

                                    deleteJob3ID = deleteJob3ID.Remove(deleteJob3ID.Length - 1);
                                    SqlCommand ccmm = new SqlCommand(" Delete From Satelite_Server_Sync_Log_Deatils Where ID IN (" + deleteJob3ID + ")", con);
                                    if (con.State.ToString() != "Open")
                                    {
                                        con.Open();
                                    }
                                    ccmm.ExecuteNonQuery();
                                    con.Close();

                                    deleteJob3ID = "";
                                    Bunchinsert  = "";
                                    c            = 0;
                                }
                                //  Boolean DeletestatusJob2 = Syncro_Tables.DeleteJob2____Satelite_Server_Sync_Log_Deatils(Job2ID);
                                //Test
                                DataTable dtfindtab = MyCommonfile.selectBZ(@" SELECT Count(dbo.Satelite_Server_Sync_Log_Deatils.ID) as TotalCount
                                                        From    dbo.Satellite_Server_Sync_Job_Details INNER JOIN dbo.ClientProductTableMaster INNER JOIN dbo.SatelliteSyncronisationrequiringTablesMaster ON dbo.SatelliteSyncronisationrequiringTablesMaster.TableID = dbo.ClientProductTableMaster.Id ON  dbo.Satellite_Server_Sync_Job_Details.TableID = dbo.SatelliteSyncronisationrequiringTablesMaster.TableID AND dbo.Satellite_Server_Sync_Job_Details.TableID = dbo.ClientProductTableMaster.Id INNER JOIN dbo.Satelitte_Server_Sync_Job_Master ON  dbo.Satellite_Server_Sync_Job_Details.Satelitte_Server_Sync_Job_Master_ID = dbo.Satelitte_Server_Sync_Job_Master.Id INNER JOIN dbo.ServerMasterTbl ON dbo.Satelitte_Server_Sync_Job_Master.SatelliteServerID = dbo.ServerMasterTbl.Id INNER JOIN dbo.Satelite_Server_Sync_Log_Deatils ON dbo.Satellite_Server_Sync_Job_Details.ID = dbo.Satelite_Server_Sync_Log_Deatils.Satellite_Server_Sync_Job_Details_ID INNER JOIN dbo.SyncActionMaster ON dbo.Satelite_Server_Sync_Log_Deatils.TypeOfOperationDone = dbo.SyncActionMaster.ID
                                                        Where ServerMasterTbl.Id='" + SId + "' ");//  and dbo.Satelitte_Server_Sync_Job_Master.Id='" + ViewState["JobID"] + "' and
                                lbl_Msg.Text += " Please waite for some moment we syncronice " + dtfindtab.Rows[0]["TotalCount"] + " record at server ";
                            }
                            else
                            {
                                //Norecord in Job3 for Job2
                                Boolean DeletestatusJob2 = Syncro_Tables.DeleteJob2____Satellite_Server_Sync_Job_Details(Job2ID);
                            }
                        }//Job2 Lopp
                         // Boolean DeletestatusJob1 = Syncro_Tables.DeleteJob1____Satelitte_Server_Sync_Job_Master(Job1ID);
                    }
                    else
                    {
                        //No Record in Job2 for selected job1
                        Boolean DeletestatusJob1 = Syncro_Tables.DeleteJob1____Satelitte_Server_Sync_Job_Master(Job1ID);
                    }
                }//Job1 Loop
            }
            else
            {
                img_loading.Visible = false;
                lbl_Msg.Text       += "<br> Job Done Successfully ";
                Timer1.Enabled      = false;
            }
        }
        else
        {
            lbl_Msg.Text = " No connection possible with server <br> you are tying to connect database with this connection string ( " + conn.ConnectionString + " )";//e1.ToString()+"<br>";
        }
    }
    protected void CreateTableDesign(string tablename, string SId)
    {
        Boolean connnection = false;

        conn = new SqlConnection();
        try
        {
            conn = ServerWizard.ServerDefaultInstanceConnetionTCPWithPublicIP_Serverid(SId);
            if (conn.State.ToString() != "Open")
            {
                conn.Open();
            }
            conn.Close();
            connnection = true;
        }
        catch (Exception ex)
        {
            Timer1.Enabled = true;
            lbl_Msg.Text   = conn.ConnectionString + " Conetiong at here but some problem";
            return;
        }
        if (connnection == true)
        {
            string    st1  = "CREATE TABLE " + tablename + "(";
            DataTable dts1 = MyCommonfile.selectBZ("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tablename + "'");
            for (int k = 0; k < dts1.Rows.Count; k++)
            {
                if (k == 0)
                {
                    //st1 += ("" + dts1.Rows[k]["column_name"] + " int Identity(1,1),");
                    st1 += ("" + dts1.Rows[k]["column_name"] + " nvarchar(500),");
                }
                else
                {
                    st1 += ("" + dts1.Rows[k]["column_name"] + " " + dts1.Rows[k]["data_type"] + "(" + dts1.Rows[k]["CHARACTER_MAXIMUM_LENGTH"] + "),");
                }
            }
            st1  = st1.Remove(st1.Length - 1);
            st1 += ")";
            //st1 = st1.Replace("int()", "int");
            st1 = st1.Replace("bigint()", "nvarchar(500)");
            st1 = st1.Replace("int()", "nvarchar(500)");
            st1 = st1.Replace("(-1)", "(MAX)");
            st1 = st1.Replace("datetime()", "nvarchar(500)");
            st1 = st1.Replace("nvarchar(50)", "nvarchar(500)");
            st1 = st1.Replace("decimal()", "nvarchar(500)");
            st1 = st1.Replace("decimal", "nvarchar(500)");
            st1 = st1.Replace("bit()", "nvarchar(500)");//st1 = st1.Replace("bit()", "bit");
            st1 = st1.Replace("nvarchar(20)", "nvarchar(500)");
            st1 = st1.Replace("nvarchar(10)", "nvarchar(500)");
            st1 = st1.Replace("nvarchar(100)", "nvarchar(500)");
            DataTable dts = selectSer("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tablename + "'");
            if (dts.Rows.Count <= 0)
            {
                SqlCommand cmdr = new SqlCommand(st1, conn);
                if (conn.State.ToString() != "Open")
                {
                    conn.Open();
                }
                cmdr.ExecuteNonQuery();
                conn.Close();
            }
            else
            {
                string    strBC = " CREATE TABLE " + tablename + "(";
                DataTable DTBC  = selectSer("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tablename + "'");
                for (int k = 0; k < DTBC.Rows.Count; k++)
                {
                    if (k == 0)
                    {
                        strBC += ("" + DTBC.Rows[k]["column_name"] + " nvarchar(500),");
                    }
                    else
                    {
                        strBC += ("" + DTBC.Rows[k]["column_name"] + " " + DTBC.Rows[k]["data_type"] + "(" + DTBC.Rows[k]["CHARACTER_MAXIMUM_LENGTH"] + "),");
                    }
                }
                strBC  = strBC.Remove(strBC.Length - 1);
                strBC += ")";
                st1    = st1.Replace("bigint()", "nvarchar(500)");
                st1    = st1.Replace("int()", "nvarchar(500)");
                st1    = st1.Replace("(-1)", "(MAX)");
                st1    = st1.Replace("datetime()", "nvarchar(500)");
                st1    = st1.Replace("nvarchar(50)", "nvarchar(500)");
                st1    = st1.Replace("decimal()", "nvarchar(500)");
                st1    = st1.Replace("decimal", "nvarchar(500)");
                st1    = st1.Replace("bit()", "nvarchar(500)");
                st1    = st1.Replace("nvarchar(20)", "nvarchar(500)");
                st1    = st1.Replace("nvarchar(10)", "nvarchar(500)");
                st1    = st1.Replace("nvarchar(100)", "nvarchar(500)");
                if (strBC != st1)
                {
                    SqlCommand cmdrX = new SqlCommand("Drop table " + tablename, conn);
                    if (conn.State.ToString() != "Open")
                    {
                        conn.Open();
                    }
                    cmdrX.ExecuteNonQuery();
                    //Create Table
                    SqlCommand cmdr = new SqlCommand(st1, conn);
                    cmdr.ExecuteNonQuery();
                    conn.Close();
                }
                else
                {
                    //SqlCommand cmdrX = new SqlCommand("Delete  from  " + tablename, conn);
                    //if (conn.State.ToString() != "Open")
                    //{
                    //    conn.Open();
                    //}
                    //cmdrX.ExecuteNonQuery();
                }
            }
        }
    }
예제 #10
0
    protected void SyncroniceData()
    {
        string portopenserID = "";

        lblmsg.Text = "";
        int    totalrec    = 0;
        string pcateid     = "";
        string seridstatus = "";

        conn = new SqlConnection();
        DataTable dtcln = new DataTable();

        foreach (GridViewRow item in grdserver.Rows)
        {
            string   syncreqid           = grdserver.DataKeys[item.RowIndex].Value.ToString();
            Label    lbltabname          = (Label)item.FindControl("lbltabname");
            Label    lblseid             = (Label)item.FindControl("lblseid");
            Label    lblattempt          = (Label)item.FindControl("lblattempt");
            CheckBox cbItem              = (CheckBox)item.FindControl("cbItem");
            Label    lbl_TableId         = (Label)item.FindControl("lbl_TableId");
            Label    lbl_jobdetail       = (Label)item.FindControl("lbl_jobdetail");
            Label    lbl_typeoperation   = (Label)item.FindControl("lbl_typeoperation");
            Label    lbl_JobReordTableID = (Label)item.FindControl("lbl_JobReordTableID");
            Label    lbl_RecordID        = (Label)item.FindControl("lbl_RecordID");
            Label    lblname             = (Label)item.FindControl("lblname");
            Boolean  serconn             = true;
            if (cbItem.Checked == true)
            {
                if (lblseid.Text != seridstatus)
                {
                    if (portopenserID != lblseid.Text)
                    {
                        portopenserID = lblseid.Text;
                    }
                    try
                    {
                        conn = new SqlConnection();
                        conn = ServerWizard.ServerDefaultInstanceConnetionTCP_Serverid(lblseid.Text);
                        if (conn.State.ToString() != "Open")
                        {
                            conn.Open();
                        }
                        encstr = ServerWizard.ServerEncrDecriKEY(lblseid.Text);
                        string tablename = lbltabname.Text;

                        if (lbl_typeoperation.Text == "2" || lbl_typeoperation.Text == "3")
                        {
                            DeleteTableRecord(tablename, lbl_RecordID.Text);
                        }
                        if (lbl_typeoperation.Text == "1" || lbl_typeoperation.Text == "2")
                        {
                            DynamicalyTable(tablename, lbl_RecordID.Text);
                        }
                        totalrec++;
                        Boolean Deletestatus = Delete_Only_ID_Satelite_Server_Sync_Log_Deatils(lbl_JobReordTableID.Text);
                        Boolean statuss      = Update_Satellite_Server_Sync_Job_Details(lbl_jobdetail.Text, true, true, DateTime.Now, true, DateTime.Now);
                        try
                        {
                            DataTable Satallite_Server_Sync_RecordsMasterTblID = MyCommonfile.selectBZ(" Select Id as SatalliteServerSyncTblTecordStatusID From Satallite_Server_Sync_RecordsMasterTbl Where TableId='" + lbl_TableId.Text + "' and ServerID='" + lblseid.Text + "' ");
                            if (lbl_typeoperation.Text == "1")
                            {
                                Insert___Satallite_Server_Sync_RecordsDetailTbl(Satallite_Server_Sync_RecordsMasterTblID.Rows[0]["Satallite_Server_Sync_RecordsMasterTblID"].ToString(), lbl_RecordID.Text, DateTime.Now, lbl_typeoperation.Text, lbl_typeoperation.Text);
                            }
                            if (lbl_typeoperation.Text == "3")
                            {
                                Delete___Satallite_Server_Sync_RecordsDetailTbl(Satallite_Server_Sync_RecordsMasterTblID.Rows[0]["Satallite_Server_Sync_RecordsMasterTblID"].ToString(), lbl_RecordID.Text);
                            }
                        }
                        catch
                        {
                        }
                        lblmsg.Text = " Successfully synchronization server record ";
                    }
                    catch
                    {
                        seridstatus = lblseid.Text;
                        lblmsg.Text = " some problem when synchronization with server ";//e1.ToString()+"<br>";
                    }
                }
            }
        }
    }
예제 #11
0
    protected void Dynamicaly_FullTable(string tanlename, string lbl_TableId)
    {
        encstr = ServerWizard.ServerEncrDecriKEY(ddlserver.SelectedValue);
        string    PKname   = "";
        string    Temp2    = " INSERT INTO " + tanlename + "(  ";
        string    Temp3val = "";
        DataTable dts1     = MyCommonfile.selectBZ(" select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tanlename + "'");

        for (int k = 0; k < dts1.Rows.Count; k++)
        {
            if (k == 0)
            {
                // PKname = dts1.Rows[k]["column_name"].ToString();
            }
            Temp2 += ("" + dts1.Rows[k]["column_name"] + " ,");
        }
        Temp2  = Temp2.Remove(Temp2.Length - 1);
        Temp2 += ") VAlues";
        string    InsertInto  = Temp2;
        string    AfterVAlues = "";
        DataTable maxiddesid  = MyCommonfile.selectBZ(" select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tanlename + "'");
        string    QueryName   = "";
        DataTable dtr;
        DataTable DtWhere = MyCommonfile.selectBZ(" Select * FROM SatelliteSyncronisationrequiringTablesMaster_SerWhere Where TableId='" + lbl_TableId + "'");

        if (DtWhere.Rows.Count > 0)
        {
            //Select_Query
            string PKTableName  = DtWhere.Rows[0]["PKTableName"].ToString();
            string PKIdName     = DtWhere.Rows[0]["PKIdName"].ToString();
            string Select_Query = DtWhere.Rows[0]["Select_Query"].ToString();
            string WhereForPKID = "";
            // WhereForPKID = " Where " + PKTableName + "." + PKIdName + "=" + RecordID;
            string SelectWhere2 = " and PricePlanMaster.PricePlanId IN ( Select PricePlanId From  CompanyMaster Where active=1 and ServerId=" + ddlserver.SelectedValue + ") ";
            Select_Query = Select_Query + WhereForPKID + SelectWhere2;
            dtr          = MyCommonfile.selectBZ("" + Select_Query + " ");
        }
        else
        {
            dtr = MyCommonfile.selectBZ(" Select * From " + tanlename + " " + QueryName + "");
        }
        try
        {
            //DataTable dtrcount = MyCommonfile.selectBZ(" Select Count(" + PKname + ") as PKname From " + tanlename + " " + QueryName + "");
            //string ss = TableRelated.AAAAAAA_Record(tanlename, dtrcount.Rows[0]["PKname"].ToString(), ddlserver.SelectedValue);
        }
        catch
        {
        }
        int    c    = 0;
        int    Cont = 0;
        string cccd = "";

        string FilenamewithExt = "";
        string filepath        = Convert.ToString(Server.MapPath(""));

        foreach (DataRow itm in dtr.Rows)
        {
            FilenamewithExt = tanlename;
            c++;
            cccd = InsertInto + " (";
            DataTable dtsccc = MyCommonfile.selectBZ("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tanlename + "'");
            for (int k = 0; k < dtsccc.Rows.Count; k++)
            {
                cccd += "'" + Encrypted(Convert.ToString(itm["" + dtsccc.Rows[k]["column_name"] + ""])) + "' ,";
            }
            cccd  = cccd.Remove(cccd.Length - 1);
            cccd += " )";
            if (Temp3val.Length > 0)
            {
                // Temp3val += ",";
            }
            Temp3val += cccd;
            if (Temp3val.Length > 0 && c == 200)
            {
                Cont++;
                //if (conn.State.ToString() != "Open")
                //{
                //    conn.Open();
                //}
                //SqlCommand ccm = new SqlCommand(Temp3val, conn);
                //ccm.ExecuteNonQuery();
                //conn.Close();
                //c = 0;
                //cccd = "";
                string ss = SQLCommonfile.GenerateAndSaveFile(FilenamewithExt + Convert.ToString(Cont) + ".sql", Temp3val, filepath);
                cccd = "";
            }
        }
        if (Temp3val.Length > 0)
        {
            Cont++;
            //if (conn.State.ToString() != "Open")
            //{
            //    conn.Open();
            //}
            //SqlCommand ccm = new SqlCommand(Temp3val, conn);
            //ccm.ExecuteNonQuery();
            //conn.Close();
            string ss = SQLCommonfile.GenerateAndSaveFile(FilenamewithExt + Convert.ToString(Cont) + ".sql", Temp3val, filepath);
        }
    }
    protected void SeprateDatabase()
    {
        Boolean connnection = false;
        string  Delete_From = "";
        string  PKname      = "";

        conn = new SqlConnection();
        try
        {
            conn = ServerWizard.ServerDefaultInstanceConnetionTCP_Serverid(ViewState["sid"].ToString());
            if (conn.State.ToString() != "Open")
            {
                conn.Open();
            }
            conn.Close();
            connnection = true;
        }
        catch (Exception ex)
        {
        }
        if (connnection == true)
        {
            int    totalrec    = 0;
            string pcateid     = "";
            string seridstatus = "";
            conn = new SqlConnection();
            DataTable dtcln = new DataTable();
            foreach (GridViewRow item in grdserver.Rows)
            {
                string   syncreqid           = grdserver.DataKeys[item.RowIndex].Value.ToString();
                Label    lbltabname          = (Label)item.FindControl("lbltabname");
                Label    lblseid             = (Label)item.FindControl("lblseid");
                Label    lblattempt          = (Label)item.FindControl("lblattempt");
                CheckBox cbItem              = (CheckBox)item.FindControl("cbItem");
                Label    lbl_TableId         = (Label)item.FindControl("lbl_TableId");
                Label    lbl_jobdetail       = (Label)item.FindControl("lbl_jobdetail");
                Label    lbl_typeoperation   = (Label)item.FindControl("lbl_typeoperation");
                Label    lbl_JobReordTableID = (Label)item.FindControl("lbl_JobReordTableID");
                Label    lbl_RecordID        = (Label)item.FindControl("lbl_RecordID");
                Label    lblname             = (Label)item.FindControl("lblname");
                Boolean  serconn             = true;
                conn = ServerWizard.ServerDefaultInstanceConnetionTCP_Serverid(lblseid.Text);
                if (cbItem.Checked == true)
                {
                    if (lblseid.Text != seridstatus)
                    {
                        try
                        {
                            encstr = ServerWizard.ServerEncrDecriKEY(lblseid.Text);
                            string tablename = lbltabname.Text;
                            if (lbl_typeoperation.Text == "2" || lbl_typeoperation.Text == "3")
                            {
                                //  DeleteTableRecord(tablename, lbl_RecordID.Text);
                                //((((((((((--Need To  Delete Column))))))))))))))))))))
                                Delete_From = " Delete From " + tablename + " Where ";
                                string    Temp3val = "";
                                DataTable dts1     = MyCommonfile.selectBZ(" select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tablename + "'");
                                if (dts1.Rows.Count > 0)
                                {
                                    PKname = TableRelated.SatelliteSyncronisationrequiringTablesMaster_WherePKIDName(lbl_TableId.Text);
                                    if (PKname.Length > 0)
                                    {
                                        Delete_From += "" + PKname + "=" + "'" + Encrypted(lbl_RecordID.Text) + "' ";
                                    }
                                    else
                                    {
                                        Delete_From += "" + dts1.Rows[0]["column_name"] + "=" + "'" + Encrypted(lbl_RecordID.Text) + "' ";
                                    }
                                }
                                try
                                {
                                    SqlCommand ccm = new SqlCommand(Delete_From, conn);
                                    if (conn.State.ToString() != "Open")
                                    {
                                        conn.Open();
                                    }
                                    ccm.ExecuteNonQuery();
                                    conn.Close();
                                }
                                catch
                                {
                                }
                                //"""""""""""""--CLOSE Need To  Delete Column"""""""""""""""""
                            }



                            if (lbl_typeoperation.Text == "1" || lbl_typeoperation.Text == "2")
                            {
                                //DynamicalyTable(tablename, lbl_RecordID.Text);
                                //((((((((((--Need To  Insert Column))))))))))))))))))))
                                string    Insert_Into = " INSERT INTO " + tablename + "(  ";
                                string    Temp3val    = "";
                                DataTable dts1        = MyCommonfile.selectBZ(" select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tablename + "'");
                                for (int k = 0; k < dts1.Rows.Count; k++)
                                {
                                    Insert_Into += ("" + dts1.Rows[k]["column_name"] + " ,");
                                }
                                Insert_Into  = Insert_Into.Remove(Insert_Into.Length - 1);
                                Insert_Into += ") Values ";
                                DataTable maxiddesid = MyCommonfile.selectBZ(" select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tablename + "'");
                                PKname = TableRelated.SatelliteSyncronisationrequiringTablesMaster_WherePKIDName(lbl_TableId.Text);
                                if (PKname.Length > 0)
                                {
                                }
                                else
                                {
                                    PKname = dts1.Rows[0]["column_name"].ToString();
                                }
                                DataTable dtr = MyCommonfile.selectBZ(" Select * From " + tablename + " where " + PKname + "=" + lbl_RecordID.Text + " ");
                                foreach (DataRow itm in dtr.Rows)
                                {
                                    int c = 0;
                                    Insert_Into += " (";
                                    DataTable dtsccc = MyCommonfile.selectBZ("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + tablename + "'");
                                    for (int k = 0; k < dtsccc.Rows.Count; k++)
                                    {
                                        Insert_Into += "'" + Encrypted(Convert.ToString(itm["" + dtsccc.Rows[k]["column_name"] + ""])) + "' ,";
                                    }
                                    Insert_Into  = Insert_Into.Remove(Insert_Into.Length - 1);
                                    Insert_Into += " )";
                                }

                                if (Insert_Into.Length > 0)
                                {
                                    SqlCommand ccm = new SqlCommand(Insert_Into, conn);
                                    if (conn.State.ToString() != "Open")
                                    {
                                        conn.Open();
                                    }
                                    ccm.ExecuteNonQuery();
                                    conn.Close();
                                    lblmsg.Text = "";
                                }
                                //"""""""""""""--CLOSE Need To  Insert Column"""""""""""""""""
                            }
                            totalrec++;

                            // Boolean statuss = Update_Satellite_Server_Sync_Job_Details(lbl_jobdetail.Text, true, true, DateTime.Now, true, DateTime.Now);
                            try
                            {
                                //DataTable Satallite_Server_Sync_RecordsMasterTblID = MyCommonfile.selectBZ(" Select Id as SatalliteServerSyncTblTecordStatusID From Satallite_Server_Sync_RecordsMasterTbl Where TableId='" + lbl_TableId.Text + "' and ServerID='" + lblseid.Text + "' ");
                                //if (lbl_typeoperation.Text == "1")
                                //{
                                //    Insert___Satallite_Server_Sync_RecordsDetailTbl(Satallite_Server_Sync_RecordsMasterTblID.Rows[0]["Satallite_Server_Sync_RecordsMasterTblID"].ToString(), lbl_RecordID.Text, DateTime.Now, lbl_typeoperation.Text, lbl_typeoperation.Text);
                                //}
                                //if (lbl_typeoperation.Text == "3")
                                //{
                                //    Delete___Satallite_Server_Sync_RecordsDetailTbl(Satallite_Server_Sync_RecordsMasterTblID.Rows[0]["Satallite_Server_Sync_RecordsMasterTblID"].ToString(), lbl_RecordID.Text);
                                //}
                            }
                            catch
                            {
                            }
                            // lblmsg.Text = " Successfully synchronization ";//" + totalrec + " records for " + lblname.Text + " server record " + lbl_RecordID.Text + "<br><br>";
                        }
                        catch
                        {
                            seridstatus = lblseid.Text;
                            lblmsg.Text = " Some problem when synchronization with " + lblname.Text + " server <br><br>";//e1.ToString()+"<br>";
                        }
                        Boolean Deletestatus = Delete_Only_ID_Satelite_Server_Sync_Log_Deatils(lbl_JobReordTableID.Text);
                    }
                }
                else
                {
                }
            }
        }
        else
        {
            lblmsg.Text = " No connection possible with server <br> you are tying to connect database with this connection string ( " + conn.ConnectionString + " )"; //e1.ToString()+"<br>";
        }
    }
예제 #13
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["sid"] != null && Request.QueryString["compid"] != null)
            {
                string sid = Request.QueryString["sid"].ToString().Replace(" ", "+");
                sid = PageMgmt.Decrypted(sid);
                // string versionid = PageMgmt.Decrypted(Request.QueryString["versionid"]);
                //  string compid =PageMgmt.Decrypted(Request.QueryString["compid"].ToString());
                string compidaa = Request.QueryString["compid"].ToString().Replace(" ", "+");
                string compid   = PageMgmt.Decrypted(compidaa.ToString());
                //sid = "5";
                //compid = "aswathy";
                DataTable ds = MyCommonfile.selectBZ(" SELECT TOP (1) dbo.PortalMasterTbl.Id AS portlID, dbo.PortalMasterTbl.PortalName, dbo.PricePlanMaster.VersionInfoMasterId,dbo.PricePlanMaster.Producthostclientserver,dbo.ClientMaster.ClientURL, dbo.ClientMaster.ServerId AS ClientServerid, dbo.ServerMasterTbl.*, dbo.CompanyMaster.ServerId FROM dbo.CompanyMaster INNER JOIN dbo.PricePlanMaster ON dbo.PricePlanMaster.PricePlanId = dbo.CompanyMaster.PricePlanId INNER JOIN dbo.PortalMasterTbl ON dbo.PricePlanMaster.PortalMasterId1 = dbo.PortalMasterTbl.Id INNER JOIN dbo.VersionInfoMaster ON dbo.PricePlanMaster.VersionInfoMasterId = dbo.VersionInfoMaster.VersionInfoId INNER JOIN dbo.ProductMaster ON dbo.VersionInfoMaster.ProductId = dbo.ProductMaster.ProductId INNER JOIN dbo.ClientMaster ON dbo.ProductMaster.ClientMasterId = dbo.ClientMaster.ClientMasterId INNER JOIN dbo.ServerMasterTbl ON dbo.CompanyMaster.ServerId = dbo.ServerMasterTbl.Id  where CompanyLoginId='" + compid + "' ");
                if (ds.Rows.Count > 0)
                {
                    string ComServerId = ds.Rows[0]["ServerId"].ToString();
                    string versionid   = ds.Rows[0]["VersionInfoMasterId"].ToString();

                    lbl_serverurl.Text = ds.Rows[0]["Busiwizsatellitesiteurl"].ToString();
                    string sqlservernameip            = ds.Rows[0]["PublicIp"].ToString();
                    string Comp_serversqlinstancename = ds.Rows[0]["DefaultsqlInstance"].ToString();
                    string sqlinstancename            = ds.Rows[0]["Sqlinstancename"].ToString();


                    string DefaultMdfpath = ds.Rows[0]["DefaultMdfpath"].ToString();
                    string DefaultLdfpath = ds.Rows[0]["DefaultLdfpath"].ToString();
                    string iispath        = ds.Rows[0]["serverdefaultpathforiis"].ToString();

                    string Comp_Ser_Masterpath    = ds.Rows[0]["folderpathformastercode"].ToString();
                    string Comp_Ser_iispath       = ds.Rows[0]["serverdefaultpathforiis"].ToString();
                    string Comp_ServEnckey        = ds.Rows[0]["Enckey"].ToString();
                    string Comp_serversqlserverip = ds.Rows[0]["sqlurl"].ToString();

                    // string Comp_serversqlport = ds.Rows[0]["port"].ToString();
                    string Comp_serversqldbname = ds.Rows[0]["DefaultDatabaseName"].ToString();
                    //  string Comp_serversqlpwd = ds.Rows[0]["Sapassword"].ToString();
                    Comp_serverweburl = ds.Rows[0]["Busiwizsatellitesiteurl"].ToString();
                    sqlserverport     = ds.Rows[0]["port"].ToString();

                    string sqlCompport28  = ds.Rows[0]["PortforCompanymastersqlistance"].ToString();//2810
                    string ClientServerid = ds.Rows[0]["ClientServerid"].ToString();
                    string ClientURL      = ds.Rows[0]["ClientURL"].ToString();



                    DataTable DTclientServerid = MyCommonfile.selectBZ(" Select * From ServerMasterTbl Where id='" + ClientServerid + "'");
                    clientServerfolderpathformastercode = DTclientServerid.Rows[0]["folderpathformastercode"].ToString();
                    FTP         = DTclientServerid.Rows[0]["FTPforMastercode"].ToString();
                    FTPUserName = DTclientServerid.Rows[0]["FTPuseridforDefaultIISpath"].ToString();
                    FTPPassword = DTclientServerid.Rows[0]["FtpPasswordforDefaultIISpath"].ToString();
                    FTPport     = DTclientServerid.Rows[0]["FTPportfordefaultIISpath"].ToString();

                    bool SerConnstatust = false;
                    int  timeconncheck  = 1;

                    connCompserver = ServerWizard.ServerDefaultInstanceConnetionTCP(compid);
                    string Compserverconnnstr = connCompserver.ConnectionString;
                    while ((!SerConnstatust) && (timeconncheck < 2))
                    {
                        try
                        {
                            if (connCompserver.State.ToString() != "Open")
                            {
                                connCompserver.Open();
                                SerConnstatust = true;
                            }
                            else
                            {
                                SerConnstatust = true;
                            }
                        }
                        catch
                        {
                            timeconncheck++;
                            //Port Open
                            //Page Y
                            string pagenamemainY = "Satelliteservfunction.aspx?PO=OpenPort&PortNo=" + BZ_Common.Encrypted_satsrvencryky(sqlserverport) + "&Port2No=" + BZ_Common.Encrypted_satsrvencryky(sqlCompport28) + "";//&SilentPageRequestTblID=" + PageMgmt.Encrypted(SilentPageRequestTblID) + "
                            //Page X
                            string mycurrenturlX          = Request.Url.AbsoluteUri;
                            Random random                 = new Random();
                            int    randomNumber           = random.Next(1, 10);
                            string Randomkeyid            = Convert.ToString(randomNumber);
                            string SilentPageRequestTblID = CompanyRelated.Insert_SilentPageRequestTbl(ComServerId, pagenamemainY, DateTime.Now.ToString(), "", false, Randomkeyid, mycurrenturlX);
                            string url = "";
                            url = "http://" + Comp_serverweburl + "/vfysrv.aspx?licensesilentpagerequesttblid=" + BZ_Common.Encrypted_satsrvencryky(SilentPageRequestTblID) + "&pageredirecturl=" + BZ_Common.Encrypted_satsrvencryky(pagenamemainY) + "&mstrsrvky=" + BZ_Common.Encrypted_satsrvencryky(BZ_Common.satsrvencryky()) + "&returnurl=" + BZ_Common.Encrypted_satsrvencryky(ClientURL) + "";
                            Response.Redirect("" + url + "");
                        }
                    }

                    if (SerConnstatust == true)//if conn open (port open)
                    {
                        InsertServerMaster(sid);

                        Database_Latest_Code_Insert(compid, sid, versionid, Compserverconnnstr, Comp_Ser_iispath, Comp_Ser_Masterpath, Comp_serverweburl, ClientServerid, DefaultMdfpath, DefaultLdfpath, sqlservernameip, sqlinstancename);

                        Website_Latest_Code_Insert(sid, versionid, compid, Compserverconnnstr, iispath, Comp_ServEnckey, Comp_Ser_Masterpath, Comp_serverweburl, iispath);

                        lbl_compid.Text = compid;
                        string pagenames = "";
                        pagenames = "http://" + Comp_serverweburl + "/Satelliteservfunction.aspx?ftpurl=" + BZ_Common.BZ_Encrypted(FTP) + "&userid=" + BZ_Common.BZ_Encrypted(FTPUserName) + "&password="******"&portno=" + BZ_Common.BZ_Encrypted(FTPport) + "&Compid=" + BZ_Common.BZ_Encrypted(compid) + "&ServerID=" + BZ_Common.BZ_Encrypted(sid) + "&PortSecID=1";
                        Response.Redirect("" + pagenames + "");
                        // FillGrid_ComCreNeedCode();
                    }
                    else
                    {
                        lblmsg.Text = "Connecting to server database problem";
                    }
                }
                else
                {
                    lblmsg.Text = "No record available for  ";
                }
            }
        }
    }
예제 #14
0
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        //if (con.State.ToString() != "Open")
        //{
        //    con.Open();
        //}
        //SqlCommand cmddel = new SqlCommand("MasterSaelliteServerSyncRequiringTablesTbl_AddDelUpdtSelect", con);
        //cmddel.CommandType = CommandType.StoredProcedure;
        //cmddel.Parameters.AddWithValue("@StatementType", "Delete");
        //cmddel.ExecuteNonQuery();
        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_serverid       = (Label)(item.FindControl("lbl_serverid"));
                CheckBox     cbItem             = (CheckBox)(item.FindControl("cbItem"));
                DropDownList DDLLiceTableName   = (DropDownList)(item.FindControl("DDLLiceTableName"));
                string       TbleName           = DDLLiceTableName.SelectedItem.Text;
                Boolean      servConn           = true;
                conn = ServerWizard.ServerDatabaseFromInstanceTCP(lbl_serverid.Text, lnl_LBInstance.Text, lbl_LBDAtabaseName.Text);
                try
                {
                    if (conn.State.ToString() != "Open")
                    {
                        conn.Open();
                    }
                }
                catch
                {
                    servConn = false;
                }
                if (DDLLiceTableName.SelectedIndex > 0 && servConn == true)
                {
                    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 + "'");

                    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 (conn.State.ToString() != "Open")
                        {
                            conn.Open();
                        }
                        try
                        {
                            SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_DELETE]", conn);
                            commandD1.ExecuteNonQuery();
                        }
                        catch
                        {
                        }
                        SqlCommand command1 = new SqlCommand(script1, conn);
                        command1.ExecuteNonQuery();



                        if (conn.State.ToString() != "Open")
                        {
                            conn.Open();
                        }
                        try
                        {
                            SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_INSERT]", conn);
                            commandD1.ExecuteNonQuery();
                        }
                        catch
                        {
                        }
                        SqlCommand command2 = new SqlCommand(script2, conn);
                        command2.ExecuteNonQuery();



                        if (conn.State.ToString() != "Open")
                        {
                            conn.Open();
                        }
                        try
                        {
                            SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_UPDATE]", conn);
                            commandD1.ExecuteNonQuery();
                        }
                        catch
                        {
                        }
                        SqlCommand command3 = new SqlCommand(script3, conn);
                        command3.ExecuteNonQuery();
                    }
                    catch (Exception ex)
                    {
                        servConn    = false;
                        lblmsg.Text = ex.ToString();
                    }

                    if (servConn == true)
                    {
                        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();



                        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();
                    }
                }
                else
                {
                    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();

                    if (servConn == true)
                    {
                        try
                        {
                            SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_DELETE]", conn);
                            commandD1.ExecuteNonQuery();
                        }
                        catch
                        {
                        }
                        try
                        {
                            SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_INSERT]", conn);
                            commandD1.ExecuteNonQuery();
                        }
                        catch
                        {
                        }
                        try
                        {
                            SqlCommand commandD1 = new SqlCommand("DROP TRIGGER [dbo].[" + TbleName + "_UPDATE]", conn);
                            commandD1.ExecuteNonQuery();
                        }
                        catch
                        {
                        }
                    }

                    // DROP TRIGGER [dbo].[Customers_DELETE1]
                }
            }
            lblmsg.Text = "Record Update Successfully";
            Cleare();
            FillDefault();

            btn_submit.Text = "Edit";
            pnlpr.Enabled   = false;
        }
        else
        {
            btn_submit.Text = "Update";
            pnlpr.Enabled   = true;
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        string ss      = BZ_Common.BZ_Decrypted("d2fu/WL5XmM=");
        string ssdd    = BZ_Common.BZ_Decrypted("member");
        string ssddfdf = BZ_Common.BZ_Encrypted("member");

        //ABC Key Insert At Server DB
        if (Request.QueryString["comid"] != null && Request.QueryString["ABCenckey"] != null && Request.QueryString["returl"] != null)
        {
            //string hh = BZ_Common.BZ_Decrypted(Request.QueryString["comid"].ToString().Replace(" ", "+"));
            string companyid = BZ_Common.BZ_Decrypted(Request.QueryString["comid"].ToString().Replace(" ", "+"));

            DataTable DtServid = MyCommonfile.selectBZ(" Select ServerMasterTbl.Busiwizsatellitesiteurl,CompanyMaster.CompanyLoginId,ServerMasterTbl.Id FROM dbo.ServerMasterTbl INNER JOIN dbo.CompanyMaster ON dbo.ServerMasterTbl.Id = dbo.CompanyMaster.ServerId Where CompanyMaster.CompanyLoginId='" + companyid + "' ");
            if (DtServid.Rows.Count > 0)
            {
                string  Busiwizsatellitesiteurl = DtServid.Rows[0]["Busiwizsatellitesiteurl"].ToString();
                string  ServerId            = DtServid.Rows[0]["Id"].ToString();
                Boolean Comp__Actve__Status = CompanyWizard.Company_Active_Status(companyid);
                Boolean Comp__Licen__Active = CompanyWizard.Company_LicenseExpire_Status(companyid);
                Boolean Server__Active      = ServerWizard.Server_Active_Status(companyid);
                if (Comp__Actve__Status == true && Comp__Licen__Active == true && Server__Active == true)
                {
                    Boolean Insert_Today_Key = CompKeyIns.BtnABCKey(companyid, ServerId);
                    if (Insert_Today_Key == true)
                    {
                        string Z  = "";
                        string D1 = "";
                        string D2 = "";
                        string D3 = "";
                        string D4 = "";
                        string D5 = "";

                        string E1 = "";
                        string E2 = "";
                        string E3 = "";
                        string E4 = "";
                        string E5 = "";

                        string    F1 = "";
                        string    F2 = "";
                        string    F3 = "";
                        string    F4 = "";
                        string    F5 = "";
                        DataTable Dt = MyCommonfile.selectBZ(" Select TOP(15)* From CompanyABCDetail Where CompanyLoginId='" + companyid + "' Order By Id Desc ");
                        foreach (DataRow drmaxdb in Dt.Rows)
                        {
                            Z += drmaxdb["Z"].ToString() + ",";

                            D1 += drmaxdb["D1"].ToString() + ",";
                            D2 += drmaxdb["D2"].ToString() + ",";
                            D3 += drmaxdb["D3"].ToString() + ",";
                            D4 += drmaxdb["D4"].ToString() + ",";
                            D5 += drmaxdb["D5"].ToString() + ",";

                            E1 += drmaxdb["E1"].ToString() + ",";
                            E2 += drmaxdb["E2"].ToString() + ",";
                            E3 += drmaxdb["E3"].ToString() + ",";
                            E4 += drmaxdb["E4"].ToString() + ",";
                            E5 += drmaxdb["E5"].ToString() + ",";

                            F1 += drmaxdb["F1"].ToString() + ",";
                            F2 += drmaxdb["F2"].ToString() + ",";
                            F3 += drmaxdb["F3"].ToString() + ",";
                            F4 += drmaxdb["F4"].ToString() + ",";
                            F5 += drmaxdb["F5"].ToString() + ",";
                        }
                        if (Dt.Rows.Count > 0)
                        {
                            Z = Z.Remove(Z.Length - 1);

                            D1 = D1.Remove(D1.Length - 1);
                            D2 = D2.Remove(D2.Length - 1);
                            D3 = D3.Remove(D3.Length - 1);
                            D4 = D4.Remove(D4.Length - 1);
                            D5 = D5.Remove(D5.Length - 1);

                            E1 = E1.Remove(E1.Length - 1);
                            E2 = E2.Remove(E2.Length - 1);
                            E3 = E3.Remove(E3.Length - 1);
                            E4 = E4.Remove(E4.Length - 1);
                            E5 = E5.Remove(E5.Length - 1);

                            F1 = F1.Remove(F1.Length - 1);
                            F2 = F2.Remove(F2.Length - 1);
                            F3 = F3.Remove(F3.Length - 1);
                            F4 = F4.Remove(F4.Length - 1);
                            F5 = F5.Remove(F5.Length - 1);

                            //Response.Redirect("http://" + Busiwizsatellitesiteurl + "/Satelliteservfunction.aspx?Compid=" + BZ_Common.BZ_Encrypted(companyid) + "&E1=" + BZ_Common.BZ_Encrypted(E1) + "&E2=" + BZ_Common.BZ_Encrypted(E2) + "&E3=" + BZ_Common.BZ_Encrypted(E3) + "&E4=" + BZ_Common.BZ_Encrypted(E4) + "&E5=" + BZ_Common.BZ_Encrypted(E5) + "&D1=" + BZ_Common.BZ_Encrypted(D1) + "&D2=" + BZ_Common.BZ_Encrypted(D2) + "&D3=" + BZ_Common.BZ_Encrypted(D3) + "&D4=" + BZ_Common.BZ_Encrypted(D4) + "&D5=" + BZ_Common.BZ_Encrypted(D5) + "&Z=" + BZ_Common.BZ_Encrypted(Z) + "&F1=" + BZ_Common.BZ_Encrypted(F1) + "&F2=" + BZ_Common.BZ_Encrypted(F2) + "&F3=" + BZ_Common.BZ_Encrypted(F3) + "&F4=" + BZ_Common.BZ_Encrypted(F4) + "&F5=" + BZ_Common.BZ_Encrypted(F5) + "");
                            Response.Redirect("http://" + Busiwizsatellitesiteurl + "/Satelliteservfunction.aspx?Compid=" + BZ_Common.BZ_Encrypted(companyid) + "&E1=" + E1 + "&E2=" + E2 + "&E3=" + E3 + "&E4=" + E4 + "&E5=" + E5 + "&D1=" + D1 + "&D2=" + D2 + "&D3=" + D3 + "&D4=" + D4 + "&D5=" + D5 + "&Z=" + Z + "&F1=" + F1 + "&F2=" + F2 + "&F3=" + F3 + "&F4=" + F4 + "&F5=" + F5 + "&returl=" + Request.QueryString["returl"] + "");
                        }
                        lbl_msg.Text = "Successfully ";
                    }
                    else
                    {
                        lbl_msg.Text = "Some problem when we try to adding records in database ";
                    }
                }
                else if (Comp__Actve__Status == false)
                {
                    lbl_msg.Text = "Company not active ";
                }
                else if (Comp__Licen__Active == false)
                {
                    lbl_msg.Text = "License Expired";
                }
                else if (Server__Active == false)
                {
                    lbl_msg.Text = "Server Inactive";
                }
            }
        }
    }