public static OracleConnection OpenConnection(string DBName) { string stConnect = System.Configuration.ConfigurationManager.AppSettings[DBName].ToString(); stConnect = EnCode.DeCodeToString(stConnect, _key); //string fcc_test = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.49.5)(PORT=1521))(CONNECT_DATA=(SID=fptcv)));User ID=VIENTH;Password=Vien123"; //string fcc_live = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.42.12)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=fcscb)));User ID=VIENTH;Password=Vien123"; //string CW_DW = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.46.14)(PORT=3020))(CONNECT_DATA=(SID=DW)));User ID=ccps;Password=cwccpsdw"; //string s = EnCode.EnCodeToString(a, _key); OracleConnection sqlConnect; try { sqlConnect = new OracleConnection(stConnect); sqlConnect.Open(); return(sqlConnect); } catch { return(null); } }
public int GhiT140XuongDB(MC_T140 data) { DateTime runDate = DateTime.ParseExact(data.runDate, "dd'/'MM'/'yy", null); DateTime clearingDate = DateTime.ParseExact(data.clearingDate, "dd'/'MM'/'yyyy", null); int numofinserted = -1; string sqlConnStr = System.Configuration.ConfigurationManager.AppSettings["SQLServerMasterCard"]; sqlConnStr = EnCode.DeCodeToString(sqlConnStr, _key); SqlConnection sqlConn = new SqlConnection(sqlConnStr); sqlConn.Open(); SqlCommand sqlCmd = new SqlCommand("INSERT_T140_GCMS_REPORT", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add(new SqlParameter("@FILENAME", data.filename)); sqlCmd.Parameters.Add(new SqlParameter("@NEWFILENAME", data.newfilename)); sqlCmd.Parameters.Add(new SqlParameter("@RUNDATE", runDate)); sqlCmd.Parameters.Add(new SqlParameter("@CLEARINGDATE", clearingDate)); sqlCmd.Parameters.Add(new SqlParameter("@CYCLE", data.clearingCycle)); //sqlCmd.Parameters.Add(new SqlParameter("@CURRENCYCODE", data.currencyCode)); sqlCmd.Parameters.Add(new SqlParameter("@USDAMOUNT", data.USDAmount)); sqlCmd.Parameters.Add(new SqlParameter("@VNDAMOUNT", data.VNDAmount)); try{ numofinserted = sqlCmd.ExecuteNonQuery(); } catch {} sqlConn.Close(); //dtIPC = ICMSDataWithOrderIdx(ipcData); //return dtIPC; return(numofinserted); }
public DataTable LoadCurrencyRateFromDB(string Currencydate) { DataTable data = new DataTable(); DateTime date = DateTime.ParseExact(Currencydate, "dd'/'MM'/'yyyy", null); //DateTime toDate = DateTime.ParseExact(denngay, "dd'/'MM'/'yyyy", null); string sqlConnStr = System.Configuration.ConfigurationManager.AppSettings["SQLServerMasterCard"]; sqlConnStr = EnCode.DeCodeToString(sqlConnStr, _key); SqlConnection sqlConn = new SqlConnection(sqlConnStr); sqlConn.Open(); DataTable ipcData = new DataTable(); SqlCommand sqlCmd = new SqlCommand("SEARCH_T057_CURRENCY_CONVERSION_RATE", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add(new SqlParameter("@RATEDATE", date)); //sqlCmd.Parameters.Add(new SqlParameter("@TOCLEARINGDATE", toDate)); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(data); sqlConn.Close(); return(data); }
public void ThucThiProc(string ProcName, string ServerName) { string strConn = System.Configuration.ConfigurationManager.AppSettings[ServerName].ToString(); strConn = EnCode.DeCodeToString(strConn, _key); SqlConnection conn = new SqlConnection(strConn); conn.Open(); SqlCommand cmd = new SqlCommand(ProcName, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); cmd.Dispose(); conn.Close(); }
public DataTable TimT140GCSMTheoNgayClearing(string tungay, string denngay) { DataTable data = new DataTable(); DateTime fromDate = DateTime.ParseExact(tungay, "dd'/'MM'/'yyyy", null); DateTime toDate = DateTime.ParseExact(denngay, "dd'/'MM'/'yyyy", null); string sqlConnStr = System.Configuration.ConfigurationManager.AppSettings["SQLServerMasterCard"]; sqlConnStr = EnCode.DeCodeToString(sqlConnStr, _key); SqlConnection sqlConn = new SqlConnection(sqlConnStr); sqlConn.Open(); DataTable ipcData = new DataTable(); SqlCommand sqlCmd = new SqlCommand("SEARCH_T140_GCMS_REPORT_BY_CLEARINGDATE", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add(new SqlParameter("@FROMCLEARINGDATE", fromDate)); sqlCmd.Parameters.Add(new SqlParameter("@TOCLEARINGDATE", toDate)); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(data); sqlConn.Close(); return(data); }
public int GhiT057XuongDB(MC_T057 data, int i) { //string date = data.date.Substring(0, 2) + "/" + data.date.Substring(2, 2) + "/" + data.date.Substring(4, 4); DateTime currencyDate = DateTime.ParseExact(data.date, "dd'/'MM'/'yyyy", null); //DateTime clearingDate = DateTime.ParseExact(data.clearingDate, "dd'/'MM'/'yy", null); int numofinserted = -1; string sqlConnStr = System.Configuration.ConfigurationManager.AppSettings["SQLServerMasterCard"]; sqlConnStr = EnCode.DeCodeToString(sqlConnStr, _key); SqlConnection sqlConn = new SqlConnection(sqlConnStr); sqlConn.Open(); SqlCommand sqlCmd = new SqlCommand("INSERT_T057_CURRENCY_CONVERSION_RATE", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add(new SqlParameter("@FILENAME", data.filename)); sqlCmd.Parameters.Add(new SqlParameter("@NEWFILENAME", data.newfilename)); sqlCmd.Parameters.Add(new SqlParameter("@RATEDATE", currencyDate)); sqlCmd.Parameters.Add(new SqlParameter("@SOURCECODE", data.detail[i].sourceCurrencyCode)); sqlCmd.Parameters.Add(new SqlParameter("@REFERENCECODE", data.detail[i].referenceCurrencyCode)); sqlCmd.Parameters.Add(new SqlParameter("@CURRENCYEXPONENT", data.detail[i].sourceCurrencyExponent)); sqlCmd.Parameters.Add(new SqlParameter("@RATECLASS", data.detail[i].rateClass)); sqlCmd.Parameters.Add(new SqlParameter("@BUYRATE", data.detail[i].buyCurrencyConversionRate)); sqlCmd.Parameters.Add(new SqlParameter("@MIDRATE", data.detail[i].midCurrencyConversionRate)); sqlCmd.Parameters.Add(new SqlParameter("@SELLRATE", data.detail[i].sellCurrencyConversionRate)); try { numofinserted = sqlCmd.ExecuteNonQuery(); } catch { } sqlConn.Close(); return(numofinserted); }
private void btnDecode_Click(object sender, EventArgs e) { string key = txtKey.Text; txtString2.Text = EnCode.DeCodeToString(txtString1.Text, key); }