//Close Port protected void ClosePort() { DataTable ds = MyCommonfile.selectBZ(" Select dbo.ClientMaster.ClientURL,dbo.ServerMasterTbl.* From dbo.ServerMasterTbl INNER JOIN dbo.ClientMaster ON dbo.ServerMasterTbl.Id = dbo.ClientMaster.ServerId Where dbo.ServerMasterTbl.Id='" + lblsid.Text + "' "); if (ds.Rows.Count > 0) { string sqlCompport28 = ds.Rows[0]["PortforCompanymastersqlistance"].ToString();//2810 string Comp_serverweburl = ds.Rows[0]["Busiwizsatellitesiteurl"].ToString(); string sqlserverport = ds.Rows[0]["port"].ToString(); string mycurrenturlX = Request.Url.AbsoluteUri; Random random = new Random(); int randomNumber = random.Next(1, 10); string Randomkeyid = Convert.ToString(randomNumber); string ClientURL = ds.Rows[0]["ClientURL"].ToString(); string pagenamemainY = "Satelliteservfunction.aspx?CP=ClosePort&PortNo=" + BZ_Common.Encrypted_satsrvencryky(sqlserverport) + "";//&SilentPageRequestTblID=" + PageMgmt.Encrypted(SilentPageRequestTblID) + " string SilentPageRequestTblID = CompanyRelated.Insert_SilentPageRequestTbl(lblsid.Text, 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) + ""; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "window.open('" + url + "');", true); } }
protected void btnsyncsilent_Click(object sender, EventArgs e) { DataTable ds = MyCommonfile.selectBZ(" Select dbo.ClientMaster.ClientURL,dbo.ServerMasterTbl.* From dbo.ServerMasterTbl INNER JOIN dbo.ClientMaster ON dbo.ServerMasterTbl.Id = dbo.ClientMaster.ServerId Where dbo.ServerMasterTbl.Id='" + ddlserver.SelectedValue + "' "); if (ds.Rows.Count > 0) { lblmsg.Text = ""; //Timer1.Enabled = true; //Paneldoc.Visible = true; string sqlCompport28 = ds.Rows[0]["PortforCompanymastersqlistance"].ToString();//2810 string Comp_serverweburl = ds.Rows[0]["Busiwizsatellitesiteurl"].ToString(); string sqlserverport = ds.Rows[0]["port"].ToString(); string mycurrenturlX = Request.Url.AbsoluteUri; Random random = new Random(); int randomNumber = random.Next(1, 10); string Randomkeyid = Convert.ToString(randomNumber); string ClientURL = ds.Rows[0]["ClientURL"].ToString(); string pagenamemainY = "Satelliteservfunction.aspx?PO=OpenPort&PortNo=" + BZ_Common.Encrypted_satsrvencryky(sqlserverport) + "";//&SilentPageRequestTblID=" + PageMgmt.Encrypted(SilentPageRequestTblID) + " string SilentPageRequestTblID = CompanyRelated.Insert_SilentPageRequestTbl(ddlserver.SelectedValue, pagenamemainY, DateTime.Now.ToString(), "", false, Randomkeyid, mycurrenturlX); //Page X 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 + ""); ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "window.open('" + url + "');", true); Response.Redirect("http://license.busiwiz.com/BeforeLogin/Silent_SyncData_WithServer.aspx?sid=" + BZ_Common.BZ_Encrypted(ddlserver.SelectedValue) + "Transfer=1"); // Response.Redirect("http://license.busiwiz.com/Silent_Sync_Need_DailySync.aspx?sid=" +BZ_Common.BZ_Encrypted(ddlserver.SelectedValue) + ""); } else { lblmsg.Text = "Server no available"; } }
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 "; } } } }
protected void Database_Latest_Code_Insert(string compid, string comsid, string VersionInfoMasterId, string STRconnCompserver, string Comp_Ser_iispath, string Comp_Ser_Masterpath, string serverurl, string ClientServerid, string DefaultMdfpath, string DefaultLdfpath, string sqlservernameip, string sqlinstancename) { // database // Find All Product code and versionno here ie. OADB , USERLOG, EXTMSGDB Etc DataTable dsmaxiddatabase = MyCommonfile.selectBZ(" SELECT dbo.ProductMasterCodeTbl.ProductVerID, dbo.ProductMasterCodeTbl.CodeTypeID, MAX(dbo.ProductMasterCodeTbl.codeversionnumber) AS codeversionnumber, dbo.ProductCodeDetailTbl.CodeTypeName FROM dbo.ProductMasterCodeTbl INNER JOIN dbo.CodeTypeTbl ON dbo.CodeTypeTbl.ID = dbo.ProductMasterCodeTbl.CodeTypeID INNER JOIN dbo.CodeTypeCategory ON dbo.CodeTypeCategory.CodeMasterNo = dbo.CodeTypeTbl.CodeTypeCategoryId INNER JOIN dbo.ProductCodeDetailTbl ON dbo.ProductCodeDetailTbl.Id = dbo.CodeTypeTbl.ProductCodeDetailId where ProductCodeDetailTbl.Active=1 and ProductMasterCodeTbl.ProductVerID='" + VersionInfoMasterId + "' and CodeTypeCategory.CodeMasterNo In ('2') GROUP BY dbo.ProductMasterCodeTbl.ProductVerID, dbo.ProductMasterCodeTbl.CodeTypeID, dbo.ProductCodeDetailTbl.CodeTypeName "); if (dsmaxiddatabase.Rows.Count > 0) { foreach (DataRow drmaxdb in dsmaxiddatabase.Rows) { DataTable dtmastcode = MyCommonfile.selectBZ(" SELECT * From ProductMasterCodeTbl Where codeversionnumber='" + drmaxdb["codeversionnumber"].ToString() + "' and CodeTypeID='" + drmaxdb["CodeTypeID"].ToString() + "' "); DataTable dtsercheck = MyCommonfile.selectBZ(" SELECT * From ProductMasterCodeonsatelliteserverTbl Where ProductMastercodeID='" + dtmastcode.Rows[0]["ID"].ToString() + "' and dbo.ProductMasterCodeonsatelliteserverTbl.ServerID='" + comsid + "' "); string filename = dtmastcode.Rows[0]["filename"].ToString(); string ftpphysicalpath = Comp_Ser_Masterpath + "\\" + filename; if (dtsercheck.Rows.Count == 0) { string strsatelliteserverinsert = " Insert into ProductMasterCodeonsatelliteserverTbl(ProductMastercodeID,ServerID,Successfullyuploadedtoserver,Physicalpath,filename) values ('" + dtmastcode.Rows[0]["ID"].ToString() + "','" + comsid + "','0','" + ftpphysicalpath + "','" + filename + "')"; SqlCommand cmdsatelliteserverinsert = new SqlCommand(strsatelliteserverinsert, con); if (con.State.ToString() != "Open") { con.Open(); } cmdsatelliteserverinsert.ExecuteNonQuery(); con.Close(); } //dtsercheck = MyCommonfile.selectBZ(" SELECT max(id) as maxcodeid From ProductMasterCodeonsatelliteserverTbl "); dtsercheck = MyCommonfile.selectBZ(" SELECT * From ProductMasterCodeonsatelliteserverTbl Where ProductMastercodeID='" + dtmastcode.Rows[0]["ID"].ToString() + "' and dbo.ProductMasterCodeonsatelliteserverTbl.ServerID='" + comsid + "' "); string strftpdetails = " Select * From ProductMasterCodeonsatelliteserverTbl Where Id='" + dtsercheck.Rows[0]["Id"].ToString() + "' "; SqlCommand cmdftpdetail = new SqlCommand(strftpdetails, connCompserver); DataTable dtftpdetail = new DataTable(); SqlDataAdapter adpftpdetail = new SqlDataAdapter(cmdftpdetail); adpftpdetail.Fill(dtftpdetail); if (dtftpdetail.Rows.Count == 0) { string strserverinsert = " Insert into ProductMasterCodeonsatelliteserverTbl (ID,ProductMastercodeID,ServerID,Successfullyuploadedtoserver,Physicalpath,filename,DownloadStart,DownloadFinish) values ('" + dtsercheck.Rows[0]["Id"].ToString() + "','" + dtmastcode.Rows[0]["ID"].ToString() + "','" + comsid + "','0','" + ftpphysicalpath + "','" + filename + "','0','0')";//,'" + sqlservernameip + "','" + sqlinstancename + "' SqlCommand cmdserverinsert = new SqlCommand(strserverinsert, connCompserver); if (connCompserver.State.ToString() != "Open") { connCompserver.Open(); } cmdserverinsert.ExecuteNonQuery(); connCompserver.Close(); } else { //For License Table Updating Status string strProdMastServ = " Update ProductMasterCodeonsatelliteserverTbl SET Successfullyuploadedtoserver='" + dtftpdetail.Rows[0]["Successfullyuploadedtoserver"].ToString() + "' where ID='" + dtftpdetail.Rows[0]["ID"].ToString() + "'"; SqlCommand cmdProdMastServ = new SqlCommand(strProdMastServ, con); if (con.State.ToString() != "Open") { con.Open(); } cmdProdMastServ.ExecuteNonQuery(); con.Close(); } DataTable dtlice = MyCommonfile.selectBZ(" SELECT dbo.ProductMasterCodeonsatelliteserverTbl.ID,dbo.CodeTypeTbl.CodeTypeCategoryId, dbo.ProductMasterCodeonsatelliteserverTbl.ProductMastercodeID, dbo.ProductMasterCodeonsatelliteserverTbl.ServerID, dbo.ProductMasterCodeonsatelliteserverTbl.Successfullyuploadedtoserver, dbo.ProductMasterCodeonsatelliteserverTbl.Physicalpath, dbo.ProductMasterCodeonsatelliteserverTbl.filename, dbo.ProductMasterCodeTbl.ProductVerID, dbo.ProductMasterCodeTbl.CodeTypeID, dbo.ProductMasterCodeTbl.codeversionnumber, dbo.ProductCodeDetailTbl.Id AS CodedetailID ,dbo.ProductCodeDetailTbl.CodeTypeName,dbo.ProductCodeDetailTbl.CompanyDefaultData,dbo.ProductCodeDetailTbl.BusiwizSynchronization, dbo.ProductCodeDetailTbl.AdditionalPageInserted FROM dbo.ProductMasterCodeonsatelliteserverTbl INNER JOIN dbo.ProductMasterCodeTbl ON dbo.ProductMasterCodeonsatelliteserverTbl.ProductMastercodeID = dbo.ProductMasterCodeTbl.ID INNER JOIN dbo.CodeTypeTbl ON dbo.ProductMasterCodeTbl.CodeTypeID = dbo.CodeTypeTbl.ID INNER JOIN dbo.ProductCodeDetailTbl ON dbo.CodeTypeTbl.ProductCodeDetailId = dbo.ProductCodeDetailTbl.Id where dbo.ProductMasterCodeTbl.ID='" + dtmastcode.Rows[0]["ID"].ToString() + "' and dbo.CodeTypeTbl.ProductVersionId='" + VersionInfoMasterId + "' and dbo.ProductMasterCodeonsatelliteserverTbl.ServerID='" + comsid + "' "); if (dtlice.Rows.Count > 0) { string Client_latestcodeZipFilePath = dtmastcode.Rows[0]["TemporaryPath"].ToString().Replace("\\\\", "\\"); string strftpdetail = " "; string codetypeid = drmaxdb["CodeTypeID"].ToString(); string codeversionno = drmaxdb["codeversionnumber"].ToString(); string dnsname = ""; string tocopymdfldffilenameOnSer = ""; string ProductCodeDetailId = dtlice.Rows[0]["CodedetailID"].ToString(); string CodeTypeCategoryId = dtlice.Rows[0]["CodeTypeCategoryId"].ToString(); //"2" //Database string CodeTypeName = dtlice.Rows[0]["CodeTypeName"].ToString(); Boolean CompanyDefaultData = Convert.ToBoolean(dtlice.Rows[0]["CompanyDefaultData"].ToString()); Boolean AdditionalPageInserted = Convert.ToBoolean(dtlice.Rows[0]["AdditionalPageInserted"].ToString()); Boolean BusiwizSynchronization = Convert.ToBoolean(dtlice.Rows[0]["BusiwizSynchronization"].ToString()); // string ldffilexten = Path.GetExtension("2056_2_2_172_201672933747982056_2_3_6_201310372975512056_2_3_4_2013812102621554blankcopytest_log.ldf"); string ldffilexten = dtlice.Rows[0]["filename"].ToString(); ldffilexten = Path.GetExtension(ldffilexten); string mastersourcepathOnSer = dtlice.Rows[0]["Physicalpath"].ToString(); if (ldffilexten == ".LDF" || ldffilexten == ".ldf") { tocopymdfldffilenameOnSer = DefaultLdfpath; } if (ldffilexten == ".MDF" || ldffilexten == ".mdf") { tocopymdfldffilenameOnSer = DefaultMdfpath; } DataTable DTNeedcode = MyCommonfile.selectBZ(" SELECT * From CompanyCreationNeedCode Where CodeTypeId='" + codetypeid + "' and CodeVersionNo='" + codeversionno + "' and CompanyLoginId='" + compid + "' and ProductVersionId='" + VersionInfoMasterId + "' "); if (DTNeedcode.Rows.Count == 0) { CompanyRelated.Insert_CompanyCreationNeedCode(compid, codetypeid, CodeTypeCategoryId, ProductCodeDetailId, codeversionno, VersionInfoMasterId, Comp_Ser_Masterpath + "\\" + dtmastcode.Rows[0]["filename"].ToString(), dtmastcode.Rows[0]["filename"].ToString(), dnsname, CodeTypeName, AdditionalPageInserted, Client_latestcodeZipFilePath, CompanyDefaultData, BusiwizSynchronization, sqlservernameip, sqlinstancename, dtlice.Rows[0]["Successfullyuploadedtoserver"].ToString(), dtmastcode.Rows[0]["ID"].ToString(), "", false, tocopymdfldffilenameOnSer); DataTable Dmaxcodeid = selectSer(" SELECT max(Id) as maxid From CompanyCreationNeedCode "); if (DTNeedcode.Rows.Count == 0) { Insert_CompanyCreationNeedCode_Server(compid, codetypeid, CodeTypeCategoryId, ProductCodeDetailId, codeversionno, VersionInfoMasterId, Comp_Ser_Masterpath + "\\" + dtmastcode.Rows[0]["filename"].ToString(), dtmastcode.Rows[0]["filename"].ToString(), dnsname, CodeTypeName, AdditionalPageInserted, Client_latestcodeZipFilePath, CompanyDefaultData, BusiwizSynchronization, sqlservernameip, sqlinstancename, dtlice.Rows[0]["Successfullyuploadedtoserver"].ToString(), dtmastcode.Rows[0]["ID"].ToString(), Dmaxcodeid.Rows[0]["maxid"].ToString(), "", false, tocopymdfldffilenameOnSer); } } } } } }
//----------------------------------------------------------------------------------- protected void Website_Latest_Code_Insert(string comsid, string VersionInfoMasterId, string compid, string STRconnCompserver, string iispath, string Comp_ServEnckey, string Comp_Ser_Masterpath, string Comp_serverweburl, string Comp_IISPath) { string ftpphysicalpath = ""; DataTable dsmaxidget = MyCommonfile.selectBZ(" SELECT dbo.ProductMasterCodeTbl.ProductVerID, dbo.ProductMasterCodeTbl.CodeTypeID, MAX(dbo.ProductMasterCodeTbl.codeversionnumber) AS codeversionnumber, dbo.ProductCodeDetailTbl.CodeTypeName FROM dbo.ProductMasterCodeTbl INNER JOIN dbo.CodeTypeTbl ON dbo.CodeTypeTbl.ID = dbo.ProductMasterCodeTbl.CodeTypeID INNER JOIN dbo.CodeTypeCategory ON dbo.CodeTypeCategory.CodeMasterNo = dbo.CodeTypeTbl.CodeTypeCategoryId INNER JOIN dbo.ProductCodeDetailTbl ON dbo.ProductCodeDetailTbl.Id = dbo.CodeTypeTbl.ProductCodeDetailId where ProductMasterCodeTbl.ProductVerID='" + VersionInfoMasterId + "' and CodeTypeCategory.CodeMasterNo In ('1') GROUP BY dbo.ProductMasterCodeTbl.ProductVerID, dbo.ProductMasterCodeTbl.CodeTypeID, dbo.ProductCodeDetailTbl.CodeTypeName "); if (dsmaxidget.Rows.Count > 0) { foreach (DataRow drmaxdb in dsmaxidget.Rows) { DataTable dtmastcode = MyCommonfile.selectBZ(" SELECT * From ProductMasterCodeTbl Where codeversionnumber='" + drmaxdb["codeversionnumber"].ToString() + "' and CodeTypeID='" + drmaxdb["CodeTypeID"].ToString() + "' "); if (dtmastcode.Rows.Count > 0) { string filename = dtmastcode.Rows[0]["filename"].ToString(); ftpphysicalpath = Comp_Ser_Masterpath + "\\" + filename; DataTable dtsercheck = MyCommonfile.selectBZ(" SELECT * From ProductMasterCodeonsatelliteserverTbl Where ProductMastercodeID='" + dtmastcode.Rows[0]["ID"].ToString() + "' and dbo.ProductMasterCodeonsatelliteserverTbl.ServerID='" + comsid + "' "); #region if (dtsercheck.Rows.Count == 0) { string strsatelliteserverinsert = " Insert into ProductMasterCodeonsatelliteserverTbl(ProductMastercodeID,ServerID,Successfullyuploadedtoserver,Physicalpath,filename) values ('" + dtmastcode.Rows[0]["ID"].ToString() + "','" + comsid + "','0','" + ftpphysicalpath + "','" + filename + "')"; SqlCommand cmdsatelliteserverinsert = new SqlCommand(strsatelliteserverinsert, con); if (con.State.ToString() != "Open") { con.Open(); } cmdsatelliteserverinsert.ExecuteNonQuery(); con.Close(); DataTable maxproductcodeid = MyCommonfile.selectBZ(" SELECT max(id) as maxcodeid From ProductMasterCodeonsatelliteserverTbl "); string strftpdetail = " Select * From ProductMasterCodeonsatelliteserverTbl Where Id='" + maxproductcodeid.Rows[0]["maxcodeid"].ToString() + "' "; SqlCommand cmdftpdetail = new SqlCommand(strftpdetail, connCompserver); DataTable dtftpdetail = new DataTable(); SqlDataAdapter adpftpdetail = new SqlDataAdapter(cmdftpdetail); adpftpdetail.Fill(dtftpdetail); if (dtftpdetail.Rows.Count == 0) { string strserverinsert = " Insert into ProductMasterCodeonsatelliteserverTbl (ID,ProductMastercodeID,ServerID,Successfullyuploadedtoserver,Physicalpath,filename,DownloadStart,DownloadFinish) values ('" + maxproductcodeid.Rows[0]["maxcodeid"].ToString() + "','" + dtmastcode.Rows[0]["ID"].ToString() + "','" + comsid + "','0','" + ftpphysicalpath + "','" + filename + "','0','0')";//,'" + sqlservernameip + "','" + sqlinstancename + "' SqlCommand cmdserverinsert = new SqlCommand(strserverinsert, connCompserver); if (connCompserver.State.ToString() != "Open") { connCompserver.Open(); } cmdserverinsert.ExecuteNonQuery(); connCompserver.Close(); } else { string strProdMastServ = " Update ProductMasterCodeonsatelliteserverTbl SET Successfullyuploadedtoserver='" + dtftpdetail.Rows[0]["Successfullyuploadedtoserver"].ToString() + "' where ID='" + dtftpdetail.Rows[0]["ID"].ToString() + "'"; SqlCommand cmdProdMastServ = new SqlCommand(strProdMastServ, con); if (con.State.ToString() != "Open") { con.Open(); } cmdProdMastServ.ExecuteNonQuery(); con.Close(); } } #endregion DataTable dtlice = MyCommonfile.selectBZ(" SELECT dbo.ProductMasterCodeonsatelliteserverTbl.ID,dbo.CodeTypeTbl.CodeTypeCategoryId, dbo.ProductMasterCodeonsatelliteserverTbl.ProductMastercodeID, dbo.ProductMasterCodeonsatelliteserverTbl.ServerID, dbo.ProductMasterCodeonsatelliteserverTbl.Successfullyuploadedtoserver, dbo.ProductMasterCodeonsatelliteserverTbl.Physicalpath, dbo.ProductMasterCodeonsatelliteserverTbl.filename, dbo.ProductMasterCodeTbl.ProductVerID, dbo.ProductMasterCodeTbl.CodeTypeID, dbo.ProductMasterCodeTbl.codeversionnumber, dbo.ProductCodeDetailTbl.Id AS CodedetailID ,dbo.ProductCodeDetailTbl.CodeTypeName,dbo.ProductCodeDetailTbl.CompanyDefaultData,dbo.ProductCodeDetailTbl.BusiwizSynchronization, dbo.ProductCodeDetailTbl.AdditionalPageInserted,dbo.WebsiteMaster.DNSserver, dbo.WebsiteMaster.DNSname FROM dbo.ProductMasterCodeonsatelliteserverTbl INNER JOIN dbo.ProductMasterCodeTbl ON dbo.ProductMasterCodeonsatelliteserverTbl.ProductMastercodeID = dbo.ProductMasterCodeTbl.ID INNER JOIN dbo.CodeTypeTbl ON dbo.ProductMasterCodeTbl.CodeTypeID = dbo.CodeTypeTbl.ID INNER JOIN dbo.ProductCodeDetailTbl ON dbo.CodeTypeTbl.ProductCodeDetailId = dbo.ProductCodeDetailTbl.Id INNER JOIN dbo.WebsiteMaster ON dbo.CodeTypeTbl.WebsiteID = dbo.WebsiteMaster.ID where dbo.ProductMasterCodeTbl.ID='" + dtmastcode.Rows[0]["ID"].ToString() + "' and dbo.WebsiteMaster.VersionInfoId='" + VersionInfoMasterId + "' and dbo.ProductMasterCodeonsatelliteserverTbl.ServerID='" + comsid + "' "); if (dtlice.Rows.Count > 0) { string ProductCodeDetailId = dtlice.Rows[0]["CodedetailID"].ToString(); string CodeTypeCategoryId = dtlice.Rows[0]["CodeTypeCategoryId"].ToString(); string CodeTypeName = dtlice.Rows[0]["CodeTypeName"].ToString(); string dnsname = dtlice.Rows[0]["DNSname"].ToString(); string DNSserverid = dtlice.Rows[0]["DNSserver"].ToString(); string ProductMastercodeID = dtlice.Rows[0]["ProductMastercodeID"].ToString(); string YourDomaiUrl = ""; string str = " SELECT CompanyMaster.*,PortalMasterTbl.id as portlID, PortalMasterTbl.PortalName,PricePlanMaster.VersionInfoMasterId,PricePlanMaster.Producthostclientserver, dbo.ClientMaster.ServerId AS ClientServerid 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 where CompanyLoginId='" + compid + "' "; SqlCommand cmd = new SqlCommand(str, con); SqlDataAdapter adp = new SqlDataAdapter(cmd); DataTable ds = new DataTable(); adp.Fill(ds); if (ds.Rows.Count > 0) { Boolean AdditionalPageInserted = false; Boolean CompanyDefaultData = false; Boolean BusiwizSynchronization = false; try { AdditionalPageInserted = Convert.ToBoolean(dtlice.Rows[0]["AdditionalPageInserted"].ToString()); } catch { } #region string codetypeid = dtmastcode.Rows[0]["CodeTypeID"].ToString(); string codeversionno = dtmastcode.Rows[0]["codeversionnumber"].ToString(); string serverconnnstr = connCompserver.ConnectionString; //Start--------Company's Server Connectionstring //Start ............................Client Code Path string Client_latestcodeZipFilePath = dtmastcode.Rows[0]["TemporaryPath"].ToString().Replace("\\\\", "\\"); //ex: D:\ALLNEWCOMPANYMASTERCOPY\35\IJobcenterMaster\WWW\PublishCode\2692017183317\10090_1_9078_1_262017918309.zip string zipfolder = Path.GetFileName(Client_latestcodeZipFilePath.TrimEnd(Path.DirectorySeparatorChar)); if (File.Exists(Client_latestcodeZipFilePath)) { DataTable DTNeedcode = MyCommonfile.selectBZ(" SELECT * From CompanyCreationNeedCode Where CodeTypeId='" + codetypeid + "' and CodeVersionNo='" + codeversionno + "' and CompanyLoginId='" + compid + "' and ProductVersionId='" + VersionInfoMasterId + "' "); if (DTNeedcode.Rows.Count == 0) { bool DNSAddingStatus = false; CompanyRelated.Insert_CompanyCreationNeedCode(compid, codetypeid, CodeTypeCategoryId, ProductCodeDetailId, codeversionno, VersionInfoMasterId, ftpphysicalpath, zipfolder, dnsname, CodeTypeName, AdditionalPageInserted, Client_latestcodeZipFilePath, CompanyDefaultData, BusiwizSynchronization, "", "", dtlice.Rows[0]["Successfullyuploadedtoserver"].ToString(), ProductMastercodeID, DNSserverid, DNSAddingStatus, Comp_IISPath); DataTable Dmaxcodeid = selectSer(" SELECT max(Id) as maxid From CompanyCreationNeedCode "); if (DTNeedcode.Rows.Count == 0) { Insert_CompanyCreationNeedCode_Server(compid, codetypeid, CodeTypeCategoryId, ProductCodeDetailId, codeversionno, VersionInfoMasterId, ftpphysicalpath, zipfolder, dnsname, CodeTypeName, AdditionalPageInserted, Client_latestcodeZipFilePath, CompanyDefaultData, BusiwizSynchronization, "", "", dtlice.Rows[0]["Successfullyuploadedtoserver"].ToString(), ProductMastercodeID, Dmaxcodeid.Rows[0]["maxid"].ToString(), DNSserverid, DNSAddingStatus, Comp_IISPath); } } } else { lblmsg.Text = " File not available at this path " + Client_latestcodeZipFilePath; } #endregion } } } else { lblmsg.Text = " Client's server or ProductMasterCodeTbl Table records not available"; } } } }
protected void Page_Load(object sender, EventArgs e) { //string comid = BZ_Common.BZ_Encrypted("zzzzpp"); if (!IsPostBack) { if (Request.QueryString["uid"] != null && Request.QueryString["pwd"] != null && Request.QueryString["cid"] != null) { //http://license.busiwiz.com/DNSentry.aspx?uid=6CAPiQfUhC7BELibxx9a8Q==&pwd=6CAPiQfUhC7BELibxx9a8Q==&cid=6CAPiQfUhC7BELibxx9a8Q== string cid = Request.QueryString["cid"].ToString().ToString().Replace(" ", "+"); // cid = BZ_Common.BZ_Decrypted(cid); string uid = Request.QueryString["uid"].ToString().ToString().Replace(" ", "+"); // uid = BZ_Common.BZ_Decrypted(uid); string pwd = Request.QueryString["pwd"].ToString().ToString().Replace(" ", "+"); // pwd = BZ_Common.BZ_Decrypted(pwd); if (Request.QueryString["Id"] != null && Request.QueryString["status"] != null) { string idNeedCode = Request.QueryString["Id"].ToString().ToString().Replace(" ", "+"); // idNeedCode = BZ_Common.BZ_Encrypted(cid); SqlCommand cmd = new SqlCommand(" update CompanyCreationNeedCode set DNSAddingStatus='" + Request.QueryString["status"] + "' where id='" + idNeedCode + "'", con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } string ipaddress = ""; // "72.38.84.98"; string dnsServerName = Environment.MachineName; // c3 string dnsentryservername = ""; //c3.safestserver.com DataTable dtserver = MyCommonfile.selectBZ("Select ServerMasterTbl.* from CompanyMaster inner join ServerMasterTbl on ServerMasterTbl.Id=CompanyMaster.ServerId where CompanyMaster.CompanyLoginId='" + cid + "'"); //serverdetail(cid); if (dtserver.Rows.Count > 0) { ipaddress = dtserver.Rows[0]["ipaddress"].ToString();//Publicip dnsentryservername = dtserver.Rows[0]["Busiwizsatellitesiteurl"].ToString(); string sqlservername = dtserver.Rows[0]["sqlurl"].ToString(); string defaultinstancename = dtserver.Rows[0]["DefaultsqlInstance"].ToString(); string sqlserverport = dtserver.Rows[0]["port"].ToString(); string defaultdatabasename = dtserver.Rows[0]["DefaultDatabaseName"].ToString(); string sapassword = PageMgmt.Decrypted(dtserver.Rows[0]["Sapassword"].ToString()); condefaultinstance = new SqlConnection(); condefaultinstance.ConnectionString = @"Data Source =" + sqlservername + "\\" + defaultinstancename + "," + sqlserverport + "; Initial Catalog = " + defaultdatabasename + "; User ID=sa; Password="******"; Persist Security Info=true; "; condefaultinstance.Close(); // condefaultinstance.ConnectionString = @"Data Source =192.168.2.100,40000; Initial Catalog = C3SATELLITESERVER; User ID=sa; Password=06De1963++; Persist Security Info=true; "; if (condefaultinstance.State.ToString() != "Open") { condefaultinstance.Open(); } condefaultinstance.Close(); ipaddress = dtserver.Rows[0]["PublicIp"].ToString(); DataTable dtzoneweb = MyCommonfile.selectBZ(" Select Top(1) * From CompanyCreationNeedCode where CodeTypeCategoryId=1 and CompanyLoginId='" + cid + "' and (DNSAddingStatus IS NULL OR DNSAddingStatus=0)");// SearchDNS(cid); foreach (DataRow dr in dtzoneweb.Rows) { string CodeDetailId = dr["CodeDetailId"].ToString(); DataTable DNSWebsiteName = MyCommonfile.selectBZ(" SELECT Top(1) dbo.WebsiteMaster.ID, dbo.ClientMaster.ClientURL,dbo.ServerMasterTbl.Id as sid, dbo.CodeTypeTbl.ID AS CodeTypeID, dbo.ProductCodeDetailTbl.Id AS CodeDetailID, dbo.WebsiteMaster.DNSserver, dbo.WebsiteMaster.DNSname, dbo.ServerMasterTbl.Busiwizsatellitesiteurl,dbo.ServerMasterTbl.PublicIp,dbo.ServerMasterTbl.Ipaddress FROM dbo.VersionInfoMaster INNER JOIN dbo.ProductMaster ON dbo.VersionInfoMaster.ProductId = dbo.ProductMaster.ProductId INNER JOIN dbo.WebsiteMaster INNER JOIN dbo.CodeTypeTbl ON dbo.WebsiteMaster.ID = dbo.CodeTypeTbl.WebsiteID INNER JOIN dbo.ProductCodeDetailTbl ON dbo.CodeTypeTbl.ProductCodeDetailId = dbo.ProductCodeDetailTbl.Id INNER JOIN dbo.ServerMasterTbl ON dbo.WebsiteMaster.DNSserver = dbo.ServerMasterTbl.Id ON dbo.VersionInfoMaster.VersionInfoId = dbo.CodeTypeTbl.ProductVersionId INNER JOIN dbo.ClientMaster ON dbo.ProductMaster.ClientMasterId = dbo.ClientMaster.ClientMasterId Where ProductCodeDetailTbl.ID='" + CodeDetailId + "' "); if (DNSWebsiteName.Rows.Count > 0) { string ds_Com_ServerId = DNSWebsiteName.Rows[0]["sid"].ToString(); string domainName = DNSWebsiteName.Rows[0]["DNSname"].ToString(); string arecord = cid; string ipDestination = DNSWebsiteName.Rows[0]["PublicIp"].ToString(); string ipaddres = DNSWebsiteName.Rows[0]["Ipaddress"].ToString(); string Comp_serverweburl = DNSWebsiteName.Rows[0]["Busiwizsatellitesiteurl"].ToString(); string sateliteserversilentpagerequesttblid = "0"; //bool update = CompanyRelated.Update_CompanyCreationNeedCode(dr["Id"].ToString(), true); string pagename = "http://" + Comp_serverweburl + "/Satelliteservfunction.aspx?domainName=" + BZ_Common.BZ_Encrypted(domainName) + "&arecord=" + BZ_Common.BZ_Encrypted(arecord) + "&ipDestination=" + BZ_Common.BZ_Encrypted(ipDestination) + "&ipaddres=" + BZ_Common.BZ_Encrypted(ipaddres) + "&sateliteserversilentpagerequesttblid=" + sateliteserversilentpagerequesttblid + "&uid=" + Request.QueryString["uid"] + "&pwd=" + Request.QueryString["pwd"] + "&cid=" + Request.QueryString["cid"] + "&Id=" + dr["Id"].ToString() + ""; // Response.Redirect("" + pagename + ""); string ClientURL = DNSWebsiteName.Rows[0]["ClientURL"].ToString() + "//Silent_CompanyCreationDNSInfoUpdate.aspx?p2=" + dr["Id"].ToString(); string pagenamemainY = "Satelliteservfunction.aspx?domainName=" + BZ_Common.BZ_Encrypted(domainName) + "&arecord=" + BZ_Common.BZ_Encrypted(arecord) + "&ipDestination=" + BZ_Common.BZ_Encrypted(ipDestination) + "&ipaddres=" + BZ_Common.BZ_Encrypted(ipaddres) + "&sateliteserversilentpagerequesttblid=" + BZ_Common.BZ_Encrypted(sateliteserversilentpagerequesttblid) + "&uid=" + Request.QueryString["uid"] + "&pwd=" + Request.QueryString["pwd"] + "&cid=" + Request.QueryString["cid"] + "&Id=" + dr["Id"].ToString() + ""; //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(ds_Com_ServerId, pagenamemainY, DateTime.Now.ToString(), "", false, Randomkeyid, mycurrenturlX); string url = ""; //Decrypted_DasdasdasdadynamicKey url = "http://" + Comp_serverweburl + "/vfysrv.aspx?licensesilentpagerequesttblid=" + BZ_Common.Encrypted_DasdasdasdadynamicKey(SilentPageRequestTblID, Randomkeyid) + "&pageredirecturl=" + BZ_Common.Encrypted_DasdasdasdadynamicKey(pagenamemainY, Randomkeyid) + "&mstrsrvky=" + BZ_Common.Encrypted_DasdasdasdadynamicKey(BZ_Common.satsrvencryky(), Randomkeyid) + "&returnurl=" + ClientURL + "&rnkendecke=" + Randomkeyid + ""; Response.Redirect("" + pagename + ""); //ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", "window.open( '" + pagename + "');", true); } else { lblmsg.Text = "Need to refress again "; } } } else { lblmsg.Text = "No Record found for " + cid + " compay"; } DataTable dtzoneweb1 = MyCommonfile.selectBZ(" Select Top(1) * From CompanyCreationNeedCode where AdditionalPageInserted=1 and CompanyLoginId='" + cid + "'");// SearchDNS(cid); foreach (DataRow dr in dtzoneweb1.Rows) { string CodeDetailId = dr["CodeDetailId"].ToString(); string DNSname = dr["DNSname"].ToString(); DataTable DNSWebsiteName2 = MyCommonfile.selectBZ(" SELECT Top(1) dbo.WebsiteMaster.ID, dbo.ClientMaster.ClientURL,dbo.ServerMasterTbl.Id as sid, dbo.CodeTypeTbl.ID AS CodeTypeID, dbo.ProductCodeDetailTbl.Id AS CodeDetailID, dbo.WebsiteMaster.DNSserver, dbo.WebsiteMaster.DNSname, dbo.ServerMasterTbl.Busiwizsatellitesiteurl,dbo.ServerMasterTbl.PublicIp,dbo.ServerMasterTbl.Ipaddress FROM dbo.VersionInfoMaster INNER JOIN dbo.ProductMaster ON dbo.VersionInfoMaster.ProductId = dbo.ProductMaster.ProductId INNER JOIN dbo.WebsiteMaster INNER JOIN dbo.CodeTypeTbl ON dbo.WebsiteMaster.ID = dbo.CodeTypeTbl.WebsiteID INNER JOIN dbo.ProductCodeDetailTbl ON dbo.CodeTypeTbl.ProductCodeDetailId = dbo.ProductCodeDetailTbl.Id INNER JOIN dbo.ServerMasterTbl ON dbo.WebsiteMaster.DNSserver = dbo.ServerMasterTbl.Id ON dbo.VersionInfoMaster.VersionInfoId = dbo.CodeTypeTbl.ProductVersionId INNER JOIN dbo.ClientMaster ON dbo.ProductMaster.ClientMasterId = dbo.ClientMaster.ClientMasterId Where ProductCodeDetailTbl.ID='" + CodeDetailId + "' "); DataTable DNSWebsiteName = MyCommonfile.selectBZ(" SELECT dbo.CompanyMaster.CompanyName, dbo.CompanyMaster.YourDomaiUrl, dbo.CompanyMaster.CompanyLoginId, dbo.PortalMasterTbl.PortalName FROM dbo.CompanyMaster INNER JOIN dbo.PricePlanMaster ON dbo.PricePlanMaster.PricePlanId = dbo.CompanyMaster.PricePlanId INNER JOIN dbo.Priceplancategory ON dbo.PricePlanMaster.PriceplancatId = dbo.Priceplancategory.ID INNER JOIN dbo.PortalMasterTbl ON dbo.Priceplancategory.PortalId = dbo.PortalMasterTbl.Id where CompanyMaster.CompanyLoginId='" + cid + "'"); if (DNSWebsiteName.Rows.Count > 0) { string PortalName = DNSWebsiteName.Rows[0]["PortalName"].ToString(); } } //string str = " SELECT CompanyMaster.*, PortalMasterTbl.PortalName,PricePlanMaster.VersionInfoMasterId,PricePlanMaster.Producthostclientserver from CompanyMaster inner join PricePlanMaster on PricePlanMaster.PricePlanId=CompanyMaster.PricePlanId inner join PortalMasterTbl on PricePlanMaster.PortalMasterId1 = PortalMasterTbl.id where CompanyLoginId='" + cid + "' "; //SqlCommand cmd = new SqlCommand(str, con); //SqlDataAdapter adp = new SqlDataAdapter(cmd); //DataTable ds = new DataTable(); //adp.Fill(ds); //string portalnamezone = ds.Rows[0]["PortalName"].ToString(); //DataTable dtzone = companydetail(cid); //if (dtzone.Rows.Count > 0) //{ // foreach (DataRow dr in dtzone.Rows) // { // string zone = dr["WebsiteURL"].ToString();// // try // { // AddARecord(cid.ToString(), zone, ipaddress, dnsServerName, dnsentryservername); // AddARecordportal(cid.ToString(), portalnamezone, ipaddress, dnsServerName, dnsentryservername); // } // catch // { // } // } //} //DataTable dtmainurl = maincompanyurl(cid); //if (dtmainurl.Rows.Count > 0) //{ // string compnayurl = dtmainurl.Rows[0]["CodeType"].ToString(); //} insertstatus("8", "1", cid); Response.Redirect("http://members.busiwiz.com/Companyconfigureinfo.aspx?comid=" + PageMgmt.Encrypted(cid) + ""); } else { lblmsg.Text = "Need to refress again "; } } }