//--------------------------Sync_Need_Logs_AtServer_AddDelUpdtSelect------------------------
public Boolean DELETE__Sync_Need_Logs_AtServer_AddDelUpdtSelect(string LogId)
{
Boolean ReturnID = true;
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
try
{
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("Sync_Need_Logs_AtServer_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "DeleteLogId");
cmd.Parameters.AddWithValue("@LogId", LogId);
cmd.ExecuteNonQuery();
liceco.Close();
}
catch
{
ReturnID = false;
liceco.Close();
}
return(ReturnID);
}
public static Boolean Delete_Satellite_Server_Sync_Job_Details(string Satellite_Server_Sync_Job_DetailsID)
{
Boolean Status = false;
try
{
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("Satellite_Server_Sync_Job_Details_AddDelUpdtSelect", liceco);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "DeleteJD");
cmd.Parameters.AddWithValue("@Satelitte_Server_Sync_Job_Master_ID", Satellite_Server_Sync_Job_DetailsID);
cmd.ExecuteNonQuery();
liceco.Close();
Status = true;
}
catch
{
Status = false;
}
return(Status);
}
public static Boolean Delete_CompanyABCMaster(string companyid)
{
Boolean Status = false;
try
{
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmdDel = new SqlCommand("CompanyABCMaster_AddDelUpdtSelect", liceco);
cmdDel.CommandType = CommandType.StoredProcedure;
cmdDel.Parameters.AddWithValue("@StatementType", "Delete");
cmdDel.Parameters.AddWithValue("@CompanyLoginId", companyid);
cmdDel.ExecuteNonQuery();
Status = true;
}
catch
{
Status = false;
}
return(Status);
}
public static string Insert_SilentPageRequestTbl(string SilentPageServerID, string PageName, string Datetimeofrequest, string Dateandtimefinish, Boolean Requestfinish, string Randomkeyid, string destinetionUrl)
{
string maxid = "0";
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("SilentPageRequestTbl_AddDelUpdtSelect", liceco);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
//cmd.Parameters.AddWithValue("@Id", comploginid);
cmd.Parameters.AddWithValue("@SilentPageServerID", SilentPageServerID);
cmd.Parameters.AddWithValue("@PageName", PageName);
cmd.Parameters.AddWithValue("@Datetimeofrequest", Datetimeofrequest);
cmd.Parameters.AddWithValue("@Dateandtimefinish", Dateandtimefinish);
cmd.Parameters.AddWithValue("@Requestfinish", false);
cmd.Parameters.AddWithValue("@Randomkeyid", Randomkeyid);
cmd.Parameters.AddWithValue("@destinetionUrl", destinetionUrl);
// cmd.ExecuteNonQuery();
object obj = cmd.ExecuteScalar();
liceco.Close();
return(obj.ToString());
}
public static bool Insert_CompanyCreationStep4SubStatustbl(string StatusMasterId, string CompanyLoginId, Boolean FinishStatus)
{
bool status = true;
SqlConnection liceco = new SqlConnection();
try
{
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("CompanyCreationStep4SubStatustbl_AddDelUpdtSelect", liceco);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@StatusMasterId", StatusMasterId);
cmd.Parameters.AddWithValue("@CompanyLoginId", CompanyLoginId);
cmd.Parameters.AddWithValue("@FinishStatus", FinishStatus);
cmd.Parameters.AddWithValue("@DateTime", DateTime.Now.ToString());
cmd.ExecuteNonQuery();
liceco.Close();
}
catch
{
status = false;
liceco.Close();
}
return(status);
}
public static bool Update_CompanyCreationNeedCode(string id, bool DNSAddingStatus)
{
bool status = true;
SqlConnection liceco = new SqlConnection();
try
{
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("CompanyCreationNeedCode_AddDelUpdtSelect", liceco);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Update_DNSAddingStatus");
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@DNSAddingStatus", DNSAddingStatus);
cmd.ExecuteNonQuery();
liceco.Close();
}
catch
{
status = false;
liceco.Close();
}
return(status);
}
//Job3-----
public static Int64 InsertJob3___Satelite_Server_Sync_Log_Deatils(string Satellite_Server_Sync_Job_Details_ID, string RecordID, DateTime Dateandtime, string TypeOfOperationDone, string TyepeOfOperationReqd, Boolean SyncedStatus)
{
SqlConnection con = MyCommonfile.licenseconn();
Int64 ReturnID = 0;
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Satelite_Server_Sync_Log_Deatils_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@Satellite_Server_Sync_Job_Details_ID", Satellite_Server_Sync_Job_Details_ID);
cmd.Parameters.AddWithValue("@RecordID", RecordID);
cmd.Parameters.AddWithValue("@Dateandtime", Dateandtime);
cmd.Parameters.AddWithValue("@TypeOfOperationDone", TypeOfOperationDone);
cmd.Parameters.AddWithValue("@TyepeOfOperationReqd", TyepeOfOperationReqd);
cmd.Parameters.AddWithValue("@SyncedStatus", SyncedStatus);
object maxprocID = new object();
maxprocID = cmd.ExecuteScalar();
ReturnID = Convert.ToInt64(maxprocID);
con.Close();
return(ReturnID);
}
//DELETE FROM Satelitte_Server_Sync_Job_Master WHERE ID =@ID
//Job2---
public static Int64 InsertJob2___Satellite_Server_Sync_Job_Details(string Satelitte_Server_Sync_Job_Master_ID, string TableID, Boolean SyncedStatus, Boolean CheckingStatus, DateTime CheckedDateTime, Boolean NeedTocreateTblatSatServer)
{
Int64 ReturnID = 0;
SqlConnection con = MyCommonfile.licenseconn();
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Satellite_Server_Sync_Job_Details_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@Satelitte_Server_Sync_Job_Master_ID", Satelitte_Server_Sync_Job_Master_ID);
cmd.Parameters.AddWithValue("@TableID", TableID);
cmd.Parameters.AddWithValue("@SyncedStatus", SyncedStatus);
cmd.Parameters.AddWithValue("@CheckingStatus", CheckingStatus);
cmd.Parameters.AddWithValue("@CheckedDateTime", CheckedDateTime);
cmd.Parameters.AddWithValue("@NeedTocreateTblatSatServer", NeedTocreateTblatSatServer);
object maxprocID = new object();
maxprocID = cmd.ExecuteScalar();
con.Close();
ReturnID = Convert.ToInt64(maxprocID);
return(ReturnID);
}
public static Int64 Insert___Sync_Need_Logs_AtServer(string LogId, string Rcordid, string ACTION, string TAbleId, Boolean IsRecordTransfer, string sid)
{
Int64 ReturnID = 0;
SqlConnection con = MyCommonfile.licenseconn();
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Sync_Need_Logs_AtServer_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@LogId", LogId);
cmd.Parameters.AddWithValue("@Rcordid", Rcordid);
cmd.Parameters.AddWithValue("@ACTION", ACTION);
cmd.Parameters.AddWithValue("@TAbleId", TAbleId);
cmd.Parameters.AddWithValue("@IsRecordTransfer", IsRecordTransfer);
cmd.Parameters.AddWithValue("@sid", sid);
object maxprocID = new object();
maxprocID = cmd.ExecuteScalar();
ReturnID = Convert.ToInt64(maxprocID);
con.Close();
return(ReturnID);
}
public static Boolean Update_Satellite_Server_Sync_Job_Details(string Satellite_Server_Sync_Job_DetailsID, Boolean SyncedStatus, Boolean CheckingStatus, DateTime CheckedDateTime, Boolean JobFinishFinishStatus, DateTime JobDetailDoneDatandtime)
{
Boolean Status = false;
try
{
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("Satellite_Server_Sync_Job_Details_AddDelUpdtSelect", liceco);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "UpdateFinish");
cmd.Parameters.AddWithValue("@ID", Satellite_Server_Sync_Job_DetailsID);
cmd.Parameters.AddWithValue("@SyncedStatus", SyncedStatus);
cmd.Parameters.AddWithValue("@CheckingStatus", CheckingStatus);
cmd.Parameters.AddWithValue("@CheckedDateTime", CheckedDateTime);
cmd.Parameters.AddWithValue("@JobFinishFinishStatus", JobFinishFinishStatus);
cmd.Parameters.AddWithValue("@JobDetailDoneDatandtime", JobDetailDoneDatandtime);
cmd.ExecuteNonQuery();
liceco.Close();
Status = true;
}
catch
{
Status = false;
}
return(Status);
}
public static Boolean Insert_CompanyABCMaster(string CompanyLoginId, string C, string C1, string C2, string C3, string C4, string C5, String ServerId)
{
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("CompanyABCMaster_AddDelUpdtSelect", liceco);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@CompanyLoginId", CompanyLoginId);
cmd.Parameters.AddWithValue("@C", C);
cmd.Parameters.AddWithValue("@C1", C1);
cmd.Parameters.AddWithValue("@C2", C2);
cmd.Parameters.AddWithValue("@C3", C3);
cmd.Parameters.AddWithValue("@C4", C4);
cmd.Parameters.AddWithValue("@C5", C5);
cmd.Parameters.AddWithValue("@ServerId", ServerId);
cmd.ExecuteNonQuery();
liceco.Close();
return(true);
}
public static string Delete_Temp_Table(string tablename)
{
SqlConnection con = MyCommonfile.licenseconn();
SqlCommand cmdrX = new SqlCommand("Drop table Temp_" + tablename, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdrX.ExecuteNonQuery();
con.Close();
return(tablename);
}
public static SqlConnection ServerDefaultInstanceConnetionTCP(string CompanyLoginId)
{
SqlConnection connCompserver = new SqlConnection();
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
string str = " SELECT TOP (1) dbo.PortalMasterTbl.Id AS portlID, dbo.PortalMasterTbl.PortalName, dbo.PricePlanMaster.VersionInfoMasterId,dbo.PricePlanMaster.Producthostclientserver, 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='" + CompanyLoginId + "' ";
SqlCommand cmd = new SqlCommand(str, liceco);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable ds = new DataTable();
adp.Fill(ds);
if (ds.Rows.Count > 0)
{
//string lbl_serverurl = ds.Rows[0]["Busiwizsatellitesiteurl"].ToString();
//string sqlservernameip = ds.Rows[0]["PublicIp"].ToString();
//string sqlserverport = ds.Rows[0]["port"].ToString();
//string DefaultDatabaseName = ds.Rows[0]["DefaultDatabaseName"].ToString();
//string Comp_serversqlpwd = PageMgmt.Decrypted(ds.Rows[0]["Sapassword"].ToString());
//string sqlinstancename = ds.Rows[0]["Sqlinstancename"].ToString();
//string Comp_serversqlserverip = ds.Rows[0]["sqlurl"].ToString();
//string Comp_serversqlinstancename = ds.Rows[0]["DefaultsqlInstance"].ToString();
//string Comp_serverweburl = ds.Rows[0]["Busiwizsatellitesiteurl"].ToString();
string Ipaddress = ds.Rows[0]["Ipaddress"].ToString();
string lbl_serverurl = ds.Rows[0]["Busiwizsatellitesiteurl"].ToString();
string sqlservernameip = ds.Rows[0]["PublicIp"].ToString();
string Comp_serversqlserverip = ds.Rows[0]["sqlurl"].ToString();
string DefaultsqlInstance = ds.Rows[0]["DefaultsqlInstance"].ToString();
string sqlserverport = ds.Rows[0]["port"].ToString(); //30000
string DefaultDatabaseName = ds.Rows[0]["DefaultDatabaseName"].ToString(); //30000
string serversqlpwd = PageMgmt.Decrypted(ds.Rows[0]["Sapassword"].ToString());
string sqlinstancename = ds.Rows[0]["Sqlinstancename"].ToString();
string sqlCompport = ds.Rows[0]["PortforCompanymastersqlistance"].ToString();//2810
connCompserver.ConnectionString = @"Data Source =" + ds.Rows[0]["PublicIp"] + "\\" + ds.Rows[0]["SqlInstanceName"] + "; Initial Catalog = " + ds.Rows[0]["DefaultDatabaseName"] + "; User ID=Sa; password="******"Sapassword"].ToString()) + "; Persist Security Info=true;";
connCompserver.ConnectionString = @"Data Source =TCP:" + ds.Rows[0]["Ipaddress"] + "," + sqlserverport + "; Initial Catalog = " + DefaultDatabaseName + "; User ID=Sa; password="******"; Persist Security Info=true;";
connCompserver.ConnectionString = @"Data Source =TCP:192.168.6.101,1401; Initial Catalog = C3SATELLITESERVER; User ID=Sa; password=06De1963++; Persist Security Info=true;";
}
liceco.Close();
return(connCompserver);
}
public static Int64 Insert___Sync_Need_Logs_AtServerSERID(string Sync_Need_Logs_AtServer, string LogId, string Rcordid, string ACTION, string TAbleId, Boolean IsRecordTransfer, string sid)
{
Int64 ReturnID = 0;
SqlConnection con = MyCommonfile.licenseconn();
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmdrXDrop = new SqlCommand(" INSERT INTO " + Sync_Need_Logs_AtServer + " (LogId,Rcordid,TAbleId,IsRecordTransfer,sid,ACTION,TakenForTemp) Values ('" + LogId + "','" + Rcordid + "','" + TAbleId + "','" + IsRecordTransfer + "','" + sid + "','" + ACTION + "','0')", con);
object maxprocID = new object();
maxprocID = cmdrXDrop.ExecuteScalar();
con.Close();
ReturnID = Convert.ToInt64(maxprocID);
return(ReturnID);
}
public static DataTable SelectCompanyInfo(string compid)
{
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
string str = " Select * From CompanyMaster where CompanyMaster.CompanyLoginId='" + compid + "' ";
SqlCommand cmd = new SqlCommand(str, liceco);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
return(dt);
}
//--------------------------Sync_Need_Logs------------------------
public static Boolean DELETE__Sync_Need_Logs__AddDelUpdtSelect(string LogId)
{
Boolean ReturnID = true;
SqlConnection con = MyCommonfile.licenseconn();
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Sync_Need_Logs_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Delete");
cmd.Parameters.AddWithValue("@LogId", LogId);
cmd.ExecuteNonQuery();
con.Close();
return(ReturnID);
}
public static Boolean DeleteJob3____Satelite_Server_Sync_Log_Deatils(string ID)
{
Boolean ReturnID = true;
SqlConnection con = MyCommonfile.licenseconn();
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Satelite_Server_Sync_Log_Deatils_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Delete");
cmd.Parameters.AddWithValue("@ID", ID);
cmd.ExecuteNonQuery();
con.Close();
return(ReturnID);
}
public static Boolean Insert_CompanyCreationNeedCode(string comploginid, string codetypeid, string CodeTypeCategoryId, string ProductCodeDetailId, string codeversionno, string VersionInfoMasterId, string Physicalpath, string zipfolder, string dnsname, string CodeTypeName, Boolean AdditionalPageInserted, string ClientMasterURL, Boolean IsDefaultDatabase, Boolean BusiwizSynchronization, string sqlservernameip, string sqlinstancename, string Successfullyuploadedtoserver, string ProductMastercodeID, string DNSserverid, bool DNSAddingStatus, string Comp_IISPath)
{
SqlConnection liceco = new SqlConnection();
Boolean Status = true;
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("CompanyCreationNeedCode_AddDelUpdtSelect", liceco);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@CompanyLoginId", comploginid);
cmd.Parameters.AddWithValue("@CodeTypeId", codetypeid);
cmd.Parameters.AddWithValue("@CodeTypeCategoryId", CodeTypeCategoryId);
cmd.Parameters.AddWithValue("@CodeDetailId", ProductCodeDetailId);
cmd.Parameters.AddWithValue("@CodeVersionNo", codeversionno);
cmd.Parameters.AddWithValue("@ProductVersionId", VersionInfoMasterId);
cmd.Parameters.AddWithValue("@Physicalpath", Physicalpath);
cmd.Parameters.AddWithValue("@filename", zipfolder);
cmd.Parameters.AddWithValue("@DNSname", dnsname);
cmd.Parameters.AddWithValue("@CodeTypeName", CodeTypeName);
cmd.Parameters.AddWithValue("@YourDomaiUrl", "");
cmd.Parameters.AddWithValue("@IsDefaultDatabase", IsDefaultDatabase);
cmd.Parameters.AddWithValue("@AdditionalPageInserted", AdditionalPageInserted);
cmd.Parameters.AddWithValue("@Successfullystatus", false);
cmd.Parameters.AddWithValue("@DownloadCompanyCode", false);
cmd.Parameters.AddWithValue("@ClientMasterURL", ClientMasterURL);
cmd.Parameters.AddWithValue("@BusiwizSynchronization", BusiwizSynchronization);
cmd.Parameters.AddWithValue("@Successfullyuploadedtoserver", Successfullyuploadedtoserver);
cmd.Parameters.AddWithValue("@ProductMastercodeID", ProductMastercodeID);
cmd.Parameters.AddWithValue("@DNSserid", DNSserverid);
cmd.Parameters.AddWithValue("@DNSAddingStatus", DNSAddingStatus);
cmd.Parameters.AddWithValue("@Comp_IISPath", Comp_IISPath);
cmd.ExecuteNonQuery();
liceco.Close();
Status = true;
return(Status);
}
public static SqlConnection ServerDefaultInstanceConnetionTCPWithPublicIP_Serverid(string Serverid)
{
SqlConnection connCompserver = new SqlConnection();
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
string str = " SELECT * From dbo.ServerMasterTbl Where Id='" + Serverid + "' ";
SqlCommand cmd = new SqlCommand(str, liceco);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable ds = new DataTable();
adp.Fill(ds);
if (ds.Rows.Count > 0)
{
string Ipaddress = ds.Rows[0]["Ipaddress"].ToString();
string lbl_serverurl = ds.Rows[0]["Busiwizsatellitesiteurl"].ToString();
string sqlservernameip = ds.Rows[0]["PublicIp"].ToString();
string Comp_serversqlserverip = ds.Rows[0]["sqlurl"].ToString();
string DefaultsqlInstance = ds.Rows[0]["DefaultsqlInstance"].ToString();
string sqlserverport = ds.Rows[0]["port"].ToString(); //30000
string DefaultDatabaseName = ds.Rows[0]["DefaultDatabaseName"].ToString(); //30000
string serversqlpwd = PageMgmt.Decrypted(ds.Rows[0]["Sapassword"].ToString());
string sqlinstancename = ds.Rows[0]["Sqlinstancename"].ToString();
string sqlCompport = ds.Rows[0]["PortforCompanymastersqlistance"].ToString();//2810
connCompserver.ConnectionString = @"Data Source =" + ds.Rows[0]["PublicIp"] + "\\" + ds.Rows[0]["SqlInstanceName"] + "; Initial Catalog = " + ds.Rows[0]["DefaultDatabaseName"] + "; User ID=Sa; password="******"Sapassword"].ToString()) + "; Persist Security Info=true;";
connCompserver.ConnectionString = @"Data Source =TCP:" + ds.Rows[0]["Ipaddress"] + "," + sqlserverport + "; Initial Catalog = " + DefaultDatabaseName + "; User ID=Sa; password="******"; Persist Security Info=true;";
connCompserver.ConnectionString = @"Data Source =TCP:" + ds.Rows[0]["Ipaddress"] + "," + sqlserverport + "; Initial Catalog = " + DefaultDatabaseName + "; User ID=Sa; password="******"; Persist Security Info=true;";
connCompserver.ConnectionString = @"Data Source =TCP:" + ds.Rows[0]["Ipaddress"] + "," + sqlserverport + "; Initial Catalog = " + DefaultDatabaseName + "; User ID=Sa; password="******"; Persist Security Info=true;";
connCompserver.ConnectionString = @"Data Source =TCP:" + ds.Rows[0]["PublicIp"] + "," + sqlserverport + "; Initial Catalog = " + DefaultDatabaseName + "; User ID=Sa; password="******"; Persist Security Info=true;";
connCompserver.ConnectionString = @"Data Source =TCP:192.168.6.101,1401; Initial Catalog = C3SATELLITESERVER; User ID=Sa; password=06De1963++; Persist Security Info=true;";
}
liceco.Close();
return(connCompserver);
}
public static Boolean UpdateJob1___Satelitte_Server_Sync_Job_Master(string Satelitte_Server_Sync_Job_Master, Boolean JobFinishStatus, DateTime FinishDatetime)
{
Boolean Status = false;
SqlConnection con = MyCommonfile.licenseconn();
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Satelitte_Server_Sync_Job_Master_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "UpdateFinish");
cmd.Parameters.AddWithValue("@ID", Satelitte_Server_Sync_Job_Master);
cmd.Parameters.AddWithValue("@JobFinishStatus", JobFinishStatus);
cmd.Parameters.AddWithValue("@FinishDatetime", FinishDatetime);
cmd.ExecuteNonQuery();
con.Close();
Status = true;
return(Status);
}
public static string Create_Static_Table_Design_Sync_Need_Logs_AtServer(string Ori_tablename, string Temp_tablename)
{
SqlConnection con = MyCommonfile.licenseconn();
string st1 = "";
DataTable DTBC = MyCommonfile.selectBZ("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + Temp_tablename + "'");
if (DTBC.Rows.Count <= 0)
{
SqlCommand cmdrX = new SqlCommand("CREATE TABLE " + Temp_tablename + "([Id] [int] IDENTITY(1,1) NOT NULL,[LogId] [int] NULL,[Rcordid] [int] NULL,[TAbleId] [int] NULL,[IsRecordTransfer] [bit] NULL,[sid] [int] NULL,[ACTION] [nvarchar](50) NULL,[TakenForTemp] [bit] NULL) ON [PRIMARY]", con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdrX.ExecuteNonQuery();
con.Close();
}
else
{
DataTable DTBCX = MyCommonfile.selectBZ(" Select * From " + Temp_tablename + "");
if (DTBCX.Rows.Count == 0)
{
SqlCommand cmdrXDrop = new SqlCommand("Drop table " + Temp_tablename, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdrXDrop.ExecuteNonQuery();
con.Close();
SqlCommand cmdrX = new SqlCommand(" CREATE TABLE " + Temp_tablename + "([Id] [int] IDENTITY(1,1) NOT NULL,[LogId] [int] NULL,[Rcordid] [int] NULL,[TAbleId] [int] NULL,[IsRecordTransfer] [bit] NULL,[sid] [int] NULL,[ACTION] [nvarchar](50) NULL,[TakenForTemp] [bit] NULL) ON [PRIMARY] ", con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdrX.ExecuteNonQuery();
con.Close();
}
}
return(st1);
}
public static Boolean Company_LicenseExpire_Status(string CompanyLoginId)
{
Boolean status = true;
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
string period = " SELECT dbo.CompanyMaster.PricePlanId, dbo.CompanyMaster.ServerId, dbo.CompanyMaster.active, dbo.ServerMasterTbl.Status, dbo.LicenseMaster.LicenseMasterId, dbo.LicenseMaster.SiteMasterId, dbo.LicenseMaster.CompanyId, dbo.LicenseMaster.LicenseDate, dbo.LicenseMaster.LicensePeriod FROM dbo.CompanyMaster INNER JOIN dbo.PricePlanMaster ON dbo.CompanyMaster.PricePlanId = dbo.PricePlanMaster.PricePlanId INNER JOIN dbo.ServerMasterTbl ON dbo.CompanyMaster.ServerId = dbo.ServerMasterTbl.Id INNER JOIN dbo.LicenseMaster ON dbo.CompanyMaster.CompanyId = dbo.LicenseMaster.CompanyId Where CompanyMaster.CompanyLoginId='" + CompanyLoginId + "' ";
SqlDataAdapter adperiod = new SqlDataAdapter(period, liceco);
DataTable dtperiodfor = new DataTable();
adperiod.Fill(dtperiodfor);
if (dtperiodfor.Rows.Count > 0)
{
foreach (DataRow uyt in dtperiodfor.Rows)
{
string licensePeriod = uyt["LicensePeriod"].ToString();
string PricePlanId = uyt["PricePlanId"].ToString();
string month = "SELECT DATEDIFF(day,'" + uyt["LicenseDate"] + "','" + DateTime.Now.ToShortDateString() + "')";
SqlCommand cmdmonth = new SqlCommand(month, liceco);
object periodmont = cmdmonth.ExecuteScalar();
int licenseday = 0;
if (licensePeriod != "")
{
licenseday = Convert.ToInt32(licensePeriod);
}
if (licenseday - Convert.ToInt32(periodmont) < 0)
{
status = false;
}
}
}
return(status);
}
public static Boolean Company_Active_Status(string CompanyLoginId)
{
Boolean status = true;
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
string str = " SELECT dbo.CompanyMaster.CompanyId, dbo.CompanyMaster.CompanyName, dbo.CompanyMaster.PricePlanId, dbo.PricePlanMaster.PricePlanName, dbo.CompanyMaster.ServerId, dbo.ServerMasterTbl.ServerName, dbo.CompanyMaster.active, dbo.PricePlanMaster.active AS PPActive, dbo.ServerMasterTbl.Status as SerStatus FROM dbo.CompanyMaster INNER JOIN dbo.PricePlanMaster ON dbo.CompanyMaster.PricePlanId = dbo.PricePlanMaster.PricePlanId INNER JOIN dbo.ServerMasterTbl ON dbo.CompanyMaster.ServerId = dbo.ServerMasterTbl.Id where CompanyMaster.CompanyLoginId='" + CompanyLoginId + "' and CompanyMaster.Active='1' and dbo.ServerMasterTbl.Status='1' and dbo.PricePlanMaster.active='1' ";
SqlCommand cmd = new SqlCommand(str, liceco);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count == 0)
{
status = false;
}
liceco.Close();
return(status);
}
public static Boolean Server_Active_Status(string ServerId)
{
Boolean status = true;
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
string str = " Select * From ServerMasterTbl Where dbo.ServerMasterTbl.Status='1' and dbo.ServerMasterTbl.Id='1' ";
SqlCommand cmd = new SqlCommand(str, liceco);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count == 0)
{
status = false;
}
liceco.Close();
return(status);
}
public static string ServerEncrDecriKEY(string Serverid)
{
string key = "";
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
string str = " SELECT * From dbo.ServerMasterTbl Where Id='" + Serverid + "' ";
SqlCommand cmd = new SqlCommand(str, liceco);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable ds = new DataTable();
adp.Fill(ds);
if (ds.Rows.Count > 0)
{
key = ds.Rows[0]["Enckey"].ToString();
}
liceco.Close();
return(key);
}
//Job1
public static Int64 InsertJob1___Satelitte_Server_Sync_Job_Master(string SatelliteServerID, string SyncJobName, DateTime JobDateTime, Boolean JobFinishStatus)
{
Int64 ReturnID = 0;
SqlConnection con = MyCommonfile.licenseconn();
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Satelitte_Server_Sync_Job_Master_AddDelUpdtSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@SatelliteServerID", SatelliteServerID);
cmd.Parameters.AddWithValue("@SyncJobName", SyncJobName);
cmd.Parameters.AddWithValue("@JobDateTime", JobDateTime);
cmd.Parameters.AddWithValue("@JobFinishStatus", JobFinishStatus);
object maxprocID = new object();
maxprocID = cmd.ExecuteScalar();
con.Close();
ReturnID = Convert.ToInt64(maxprocID);
return(ReturnID);
}
public Syncro_Tables()
{
con = MyCommonfile.licenseconn();
}
public static string Create_Temp_Table_Design_With_Change_Datatype(string Ori_tablename, string Temp_tablename)
{
SqlConnection con = MyCommonfile.licenseconn();
string st1 = "CREATE TABLE " + Temp_tablename + "(";
DataTable dts1 = MyCommonfile.selectBZ("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + Ori_tablename + "'");
for (int k = 0; k < dts1.Rows.Count; k++)
{
if (k == 0)
{
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"] + "),");
}
}
if (dts1.Rows.Count > 0)
{
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 DTBC = MyCommonfile.selectBZ("select column_name,data_type,CHARACTER_MAXIMUM_LENGTH from INFORMATION_SCHEMA.COLUMNS where table_name='" + Temp_tablename + "'");
if (DTBC.Rows.Count <= 0)
{
SqlCommand cmdr = new SqlCommand(st1, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdr.ExecuteNonQuery();
con.Close();
}
else
{
string strBC = " CREATE TABLE " + Temp_tablename + "(";
for (int k = 0; k < DTBC.Rows.Count; k++)
{
if (k == 0)
{
// strBC += ("" + DTBC.Rows[k]["column_name"] + " int Identity(1,1),");
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 += ")";
strBC = strBC.Replace("bigint()", "nvarchar(500)");
strBC = strBC.Replace("int()", "nvarchar(500)");
strBC = strBC.Replace("(-1)", "(MAX)");
strBC = strBC.Replace("datetime()", "nvarchar(500)");
strBC = strBC.Replace("nvarchar(50)", "nvarchar(500)");
strBC = strBC.Replace("decimal()", "nvarchar(500)");
strBC = strBC.Replace("decimal", "nvarchar(500)");
strBC = strBC.Replace("bit()", "bit");
strBC = strBC.Replace("nvarchar(20)", "nvarchar(500)");
strBC = strBC.Replace("nvarchar(10)", "nvarchar(500)");
strBC = strBC.Replace("nvarchar(100)", "nvarchar(500)");
DataTable DTRecord = MyCommonfile.selectBZ("select * From " + Temp_tablename + "");
if (strBC != st1 || DTRecord.Rows.Count == 0)
{
SqlCommand cmdrX = new SqlCommand("Drop table " + Temp_tablename, con);
if (con.State.ToString() != "Open")
{
con.Open();
}
cmdrX.ExecuteNonQuery();
con.Close();
//Create Table
if (con.State.ToString() != "Open")
{
con.Open();
}
SqlCommand cmdr = new SqlCommand(st1, con);
cmdr.ExecuteNonQuery();
con.Close();
}
}
}
return(st1);
}
public CompanyWizard()
{
con = MyCommonfile.licenseconn();
}
public static Boolean Insert_CompanyABCDetail(string CompanyLoginId, string Z, string A1, string A2, string A3, string A4, string A5, 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, string txt_ansc1, string txt_ansc2, string txt_ansc3, string txt_ansc4, string txt_ansc5, string txt_ansc, string ServerId)
{
Boolean Status = false;
try
{
SqlConnection liceco = new SqlConnection();
liceco = MyCommonfile.licenseconn();
if (liceco.State.ToString() != "Open")
{
liceco.Open();
}
SqlCommand cmd = new SqlCommand("CompanyABCDetail_AddDelUpdtSelect", liceco);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Insert");
cmd.Parameters.AddWithValue("@CompanyLoginId", CompanyLoginId);
cmd.Parameters.AddWithValue("@Z", Z);
cmd.Parameters.AddWithValue("@A1", A1);
cmd.Parameters.AddWithValue("@A2", A2);
cmd.Parameters.AddWithValue("@A3", A3);
cmd.Parameters.AddWithValue("@A4", A4);
cmd.Parameters.AddWithValue("@A5", A5);
cmd.Parameters.AddWithValue("@D1", D1);
cmd.Parameters.AddWithValue("@D2", D2);
cmd.Parameters.AddWithValue("@D3", D3);
cmd.Parameters.AddWithValue("@D4", D4);
cmd.Parameters.AddWithValue("@D5", D5);
cmd.Parameters.AddWithValue("@E1", E1);
cmd.Parameters.AddWithValue("@E2", E2);
cmd.Parameters.AddWithValue("@E3", E3);
cmd.Parameters.AddWithValue("@E4", E4);
cmd.Parameters.AddWithValue("@E5", E5);
cmd.Parameters.AddWithValue("@F1", F1);
cmd.Parameters.AddWithValue("@F2", F2);
cmd.Parameters.AddWithValue("@F3", F3);
cmd.Parameters.AddWithValue("@F4", F4);
cmd.Parameters.AddWithValue("@F5", F5);
cmd.Parameters.AddWithValue("@ansc1", txt_ansc1);
cmd.Parameters.AddWithValue("@ansc2", txt_ansc2);
cmd.Parameters.AddWithValue("@ansc3", txt_ansc3);
cmd.Parameters.AddWithValue("@ansc4", txt_ansc4);
cmd.Parameters.AddWithValue("@ansc5", txt_ansc5);
cmd.Parameters.AddWithValue("@ansc", txt_ansc);
cmd.Parameters.AddWithValue("@ServerId", ServerId);
cmd.ExecuteNonQuery();
liceco.Close();
Status = true;
}
catch
{
Status = false;
}
return(Status);
}
