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