public static SqlConnection GetHRDATAConnection()
{
//Data Source = LONG; Initial Catalog = TEST; Integrated Security = True
string datasource = "172.16.0.9\\tx";
string database = "txcard";
string username = "******";
string password = "******";
return(DBSQLServerUtils.GetHRDataConnection(datasource, database, username, password));
}
public static SqlConnection GetCustomsConnection()
{
//Data Source = LONG; Initial Catalog = TEST; Integrated Security = True
string datasource = "172.16.2.12\\SQLEXPRESS";
string database = "ECUS5VNACCS_DG";
string username = "******";
string password = "";
return(DBSQLServerUtils.GetCustomsConnection(datasource, database, username, password));
}
public static SqlConnection GetERPDBConnection()
{
//Data Source = LONG; Initial Catalog = TEST; Integrated Security = True
string datasource = "172.16.0.11";
string database = (Class.valiballecommon.GetStorage().DBERP != null) ? Class.valiballecommon.GetStorage().DBERP : "TLVN2";
string username = "******";
string password = "******";
return(DBSQLServerUtils.GetERPDBConnection(datasource, database, username, password));
}
public static SqlConnection GetERPTargetBConnection()
{
//Data Source = LONG; Initial Catalog = TEST; Integrated Security = True
string datasource = "172.16.0.11";
string database = "SOT";
string username = "******";
string password = "******";
return(DBSQLServerUtils.GetSFTDBConnection(datasource, database, username, password));
}
public static bool TLINK = false;// [True]: Test TechLink [False]: Test LOCAL PC
public static SqlConnection GetDBConnection()
{
string datasource = "172.16.0.12";
string database = "ERPSOFT";
string username = "******";
string password = "******";
if (TLINK)// TLINK
{
return(DBSQLServerUtils.GetDBConnection(datasource, database, username, password));
}
else// Test local
{
string connecString = string.Format("Data Source=ADMIN;Initial Catalog={0};Integrated Security=True", database);
return(new SqlConnection(connecString));
}
}
public static SqlConnection GetTLVN2DBConnection()
{
var test = Class.valiballecommon.GetStorage().DBERP;
string datasource = "172.16.0.11";
string database = (Class.valiballecommon.GetStorage().DBERP != null) ? Class.valiballecommon.GetStorage().DBERP : "TLVN2";
string username = "******";
string password = "******";
if (TLINK)// TLINK
{
return(DBSQLServerUtils.GetTLVN2Connection(datasource, database, username, password));
}
else// Test local
{
string connecString = string.Format("Data Source=ADMIN;Initial Catalog={0};Integrated Security=True", database);
return(new SqlConnection(connecString));
}
}
public static SqlConnection GetERPDBConnection()
{
//Data Source = LONG; Initial Catalog = TEST; Integrated Security = True
string datasource = "172.16.0.11";
string database = "TECHLINK";
string username = "******";
string password = "******";
//string datasource = "Long";
//string database = "TECHLINK";
//string username = "******";
//string password = "******";
//string datasource = @"DESKTOP-83OVHRC\SQLEXPRESS";
//string database = "TECHLINK";
//string username = "******";
//string password = "******";
return(DBSQLServerUtils.GetERPDBConnection(datasource, database, username, password));
}
