protected void Page_Load(object sender, EventArgs e)
{
this.btnCustomerCodeSearch.Attributes.Add("style", "visibility: hidden;");
DataSet ds = new DataSet();
if (!IsPostBack)
{
ds = LOV.SP_PRIFilePath();
if (ds.Tables[0].Rows.Count > 0)
{
if (Session["FTPUserID"] == "")
{
PathReader p1 = new PathReader();
DatabaseConfig dbObj = new DatabaseConfig();
dbObj = p1.Deserialize_Data();
DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + dbObj.DB + ";Persist Security Info=True;User ID=" + dbObj.UserID + ";Password="******";Unicode=True;Pooling=false";
Session["FTPUserID"] = dbObj.FTPUSERID.ToString();
Session["FTPPASSWORD"] = dbObj.FTPPASSWORD.ToString();
Session["FTPIP"] = dbObj.FTPIP.ToString();
}
string strpath = ds.Tables[0].Rows[0]["fileupload"].ToString();
string test = FO.getFileList(strpath, Session["FTPUserID"].ToString(), Session["FTPPASSWORD"].ToString());
string[] Array = test.ToString().Split(',');
foreach (String t in Array)
{
TXT_Description.Items.Add(t);
TXT_Description.DataBind();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//DatabaseConfig D = new DatabaseConfig();
//D = Deserialize_Data();
//Startup_Util.DB_Route = //"Data Source=" + Startup_Util.DcryptionPWD(D.Server) + ";Initial Catalog=" + Startup_Util.DcryptionPWD(D.D2) + ";User ID=" + Startup_Util.DcryptionPWD(D.UserID) + ";Password="******"Data Source=" + Startup_Util.DcryptionPWD(D.Server) + ";Initial Catalog=" + Startup_Util.DcryptionPWD(D.D3) + ";User ID=" + Startup_Util.DcryptionPWD(D.UserID) + ";Password="******"Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
//Session["FtpUserID"] = Startup_Util.DcryptionPWD(D.FTPUSERID);
//Session["FTPPASSWORD"] = Startup_Util.DcryptionPWD(D.FTPPASSWORD);
//Session["FWIP"] = Startup_Util.DcryptionPWD(D.FWIP);
Session["FtpUserID"] = "a";
Session["FTPPASSWORD"] = "******";
//Session["FWIP"] = Startup_Util.DcryptionPWD(D.FWIP);
}
public DBUniversalUploadProcess()
{
PathReader p1 = new PathReader();
DatabaseConfig D = new DatabaseConfig();
D = p1.Deserialize_Data();
DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB +
";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";";
ConnectionString = DAL_EXP1.Utility.Startup_Util.DB_Route;
}
public DatabaseConnection_Util()
{
PathReader p1 = new PathReader();
DatabaseConfig D = new DatabaseConfig();
D = p1.Deserialize_Data();
DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
ConnectionString = DAL_EXP1.Utility.Startup_Util.DB_Route;
ConnectionMaker();
}
public OleDbConnection GetConnection1()
{
//PathReader p1 = new PathReader();
//DatabaseConfig D = new DatabaseConfig();
//D = p1.Deserialize_Data();
//DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
//strCon_Global1 = DAL_EXP1.Utility.Startup_Util.DB_Route;
PathReader p1 = new PathReader();
DatabaseConfig D = new DatabaseConfig();
D = p1.Deserialize_Data();
DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
// strCon_Global1 = DAL_EXP1.Utility.Startup_Util.DB_Route;
// strCon_Global1 = "Provider=MSDAORA.1;Password=mcbcs ;User ID=mcbcs;Data Source=orcl";
strCon_Global1 = "Provider=MSDAORA.1;Password="******";User ID=" + D.UserID + ";Data Source=" + D.DB;
return(new OleDbConnection(strCon_Global1));
}
public MCBReportClass()
{
////PathReader p1 = new PathReader();
////DatabaseConfig D = new DatabaseConfig();
////D = p1.Deserialize_Data();
////DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
//////strCon_Global1 = DAL_EXP1.Utility.Startup_Util.DB_Route;
//////strCon_Global1 = "Provider=MSDAORA.1;Password=mcbcs ;User ID=mcbcs_test;Data Source=nt";
////strCon_Global1 = ConfigurationManager.AppSettings["ConnectionString1"].ToString();
PathReader p1 = new PathReader();
DatabaseConfig D = new DatabaseConfig();
D = p1.Deserialize_Data();
DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + D.DB + ";Persist Security Info=True;User ID=" + D.UserID + ";Password="******";Unicode=True;Pooling=false";
/// strCon_Global1 = DAL_EXP1.Utility.Startup_Util.DB_Route;
strCon_Global1 = "Provider=MSDAORA.1;Password="******";User ID=" + D.UserID + ";Data Source=" + D.DB;
strCon_GlobalOra = "Password="******";User ID=" + D.UserID + ";Data Source=" + D.DB;
//Data Source=orcl;Persist Security Info=True;User ID=mcbcs;Password=mcbcs;Unicode=True;Pooling=false
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
lbl_Message.Text = "";
if ((Session["FTPUserID"].ToString() == "") || (Session["FTPPASSWORD"].ToString() == ""))
{
PathReader p1 = new PathReader();
DatabaseConfig dbObj = new DatabaseConfig();
dbObj = p1.Deserialize_Data();
DAL_EXP1.Utility.Startup_Util.DB_Route = "Data Source=" + dbObj.DB + ";Persist Security Info=True;User ID=" + dbObj.UserID + ";Password="******";Unicode=True;Pooling=false";
Session["FTPUserID"] = dbObj.FTPUSERID.ToString();
Session["FTPPASSWORD"] = dbObj.FTPPASSWORD.ToString();
Session["FTPIP"] = dbObj.FTPIP.ToString();
}
ftpFileList();
}
}