private Boolean SelectFile() { openFileDialog1.InitialDirectory = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_DOWNLOAD"); string pre = ""; if (FlagKtg == "INTI") { pre = "CI-"; } else if (FlagKtg == "MITRAPS") { pre = "MPS-"; } else if (FlagKtg == "MITRASAS") { pre = "MSAS-"; } if (openFileDialog1.ShowDialog() == DialogResult.OK && openFileDialog1.FileName.Contains(pre)) { dsXML.ReadXml(openFileDialog1.FileName); return(true); } else { MessageBox.Show("Data yang Anda Pilih Bukan Data Antar Gudang"); return(false); } }
public static void Initialize() { userName = LookupInfo.GetValue("FTP", "FTP_USER"); password = SecurityManager.DecodePassword(LookupInfo.GetValue("FTP", "FTP_PASSWORD")); dirDownload = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_DOWNLOAD"); dirUpload = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_UPLOAD"); dirInbox = LookupInfo.GetValue("FTP", "FTP_ADDRESS"); }
static int BufferSize = 1024 * 10000; //(10 MB buffer) public static void Initialize() { if (!isInitialized) { _passwordEnabled = bool.Parse(LookupInfo.GetValue("ZIP", "PASSWORD_ENABLED")); _password = LookupInfo.GetValue("ZIP", "PASSWORD_ZIP");; isInitialized = true; } }
public static void Initialize() { userName = LookupInfo.GetValue("FTP", "FTP_USER"); password = Tools.DecodePassword(LookupInfo.GetValue("FTP", "FTP_PASSWORD")); dirDownload = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_DOWNLOAD"); ValidateDirectory(dirDownload); dirUpload = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_UPLOAD"); ValidateDirectory(dirUpload); dirInbox = LookupInfo.GetValue("FTP", "FTP_INBOX"); }
private void SelectFile() { openFileDialog1.InitialDirectory = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_DOWNLOAD"); if (openFileDialog1.ShowDialog() == DialogResult.OK && openFileDialog1.FileName.Contains("MasterOutletBaru-")) { ReadData(openFileDialog1.FileName); } else { MessageBox.Show("Data yang Anda Pilih Bukan Data Master Outlet"); SelectFile(); } }
public static void Initialize() { userName = LookupInfo.GetValue("FTP", "FTP_USER"); password = Tools.DecodePassword(LookupInfo.GetValue("FTP", "FTP_PASSWORD")); dirUpload = LookupInfo.GetValue("09JKT_DEV", "FTP_ADDRESSLIST"); ValidateDirectory(dirUpload); dirUpload = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_UPLOAD"); ValidateDirectory(dirUpload); dirPath = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_UPLOAD"); ///uji coba ValidateDirectory(dirPath); }
private void SelectFile() { //openFileDialog1.InitialDirectory = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_DOWNLOAD"); //if (openFileDialog1.ShowDialog() == DialogResult.OK && openFileDialog1.FileName.Contains("PO")) //{ // ReadData(openFileDialog1.FileName); //} //else //{ // MessageBox.Show("Data yang Anda Pilih Bukan Data Refilll PO"); // SelectFile(); //} openFileDialog1.InitialDirectory = LookupInfo.GetValue("FTP", "FTP_DIRECTORY_DOWNLOAD"); if (openFileDialog1.ShowDialog() == DialogResult.OK) { ReadData(openFileDialog1.FileName); } }
public static bool IsPasswordExpired() { bool expired = false; int maxAge = int.Parse(LookupInfo.GetValue("SECURITY", "PASSWORD_AGE")); if (maxAge > 0) { int datediff = DateTime.Now.Subtract(SecurityManager.TglPassword).Days; if (datediff > maxAge) { expired = true; } } return(expired); }
public static void RecordLoginAttempt(string userID) { try { int maxAttempt = int.Parse(LookupInfo.GetValue("SECURITY", "MAX_LOGIN_ATTEMPT")); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_SecurityLoginAttempt_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@userID", SqlDbType.VarChar, userID)); db.Commands[0].Parameters.Add(new Parameter("@tglLogin", SqlDbType.DateTime, DateTime.Now)); db.Commands[0].Parameters.Add(new Parameter("@ipAddress", SqlDbType.VarChar, SecurityManager.ClientIPAddress)); db.Commands[0].ExecuteNonQuery(); } } catch (Exception ex) { Error.LogError(ex); } }
private void LinkToPiutang() { if (dataGridView1.SelectedCells.Count == 0) { MessageBox.Show(Messages.Error.RowNotSelected); return; } // TODO: //if (!accesright('005')) //{ // MessageBox.Show("'Bukan Wewenang Anda Link ke Piutang", "Perhatian"); // return; //} if (LookupInfo.GetValue("INSTALL_MODULE", "PIUTANG").ToString() == "False") { return; } if (dataGridView1.SelectedCells[0].OwningRow.Cells["IDLink"].Value.ToString() != "") { MessageBox.Show("Sudah Link ke Piutang", "Perhatian"); return; } if (double.Parse(dataGridView1.SelectedCells[0].OwningRow.Cells["DILACC"].Value.ToString()) == 0) { MessageBox.Show("Potongan belum di ACC", "Perhatian"); return; } if (MessageBox.Show("Link ke piutang....?", "Perhatian", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Guid potID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value; Guid notaJualID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["NotaJualID"].Value; try { this.Cursor = Cursors.WaitCursor; DataTable dtLinkPot = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("[psp_Potongan_LinkToPiutang_ISA]")); //cek heri db.Commands[0].Parameters.Add(new Parameter("@potID", SqlDbType.UniqueIdentifier, potID)); db.Commands[0].Parameters.Add(new Parameter("@notaJualID", SqlDbType.UniqueIdentifier, notaJualID)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dtLinkPot = db.Commands[0].ExecuteDataTable(); } if (dtLinkPot.Rows[0]["cekNota"].ToString() == "0") { MessageBox.Show("Nota tidak ada", "Perhatian"); } else { RefreshData(); FindRow("RowID", potID.ToString()); } } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } } }
public static string GetAddresList(string ftpTargtAlias) { return(LookupInfo.GetValue("FTP_ADDRESSLIST", ftpTargtAlias)); }
private void cmdApprove_Click(object sender, EventArgs e) { Guid doID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value; DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_NotaPenjualan_LIST_FILTER_DOID")); db.Commands[0].Parameters.Add(new Parameter("@doID", SqlDbType.UniqueIdentifier, doID)); dt = db.Commands[0].ExecuteDataTable(); } if (dt.Rows.Count > 0 && !SecurityManager.AskPasswordManager()) { MessageBox.Show("Anda tidak berwenang untuk ACC ulang"); return; } Guid headerID = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value; string kodeToko = dataGridView1.SelectedCells[0].OwningRow.Cells["KodeToko"].Value.ToString(); DateTime tglDo = (DateTime)dataGridView1.SelectedCells[0].OwningRow.Cells["TglDO"].Value; string noNota, noACCDO, ACCOleh, lokasiDatabase, lokasiDataKasir, lokasiApp, nPrint; double Plafon, Gbc = 0, dDibayar, NilaiDO, dDebet; lokasiDatabase = LookupInfo.GetValue("VACCDO", "PIUTANG_PATH"); lokasiDataKasir = LookupInfo.GetValue("VACCDO", "KASIR_PATH"); //lokasiApp = LookupInfo.GetValue("VACCDO", "STOK_PATH"); lokasiApp = Application.StartupPath + "\\v_accdo_ISA\\"; ///////////////////// Fefe Part ////////////////////// DataTable dtPL = new DataTable(); DataTable dtOP = new DataTable(); DataTable dtT = new DataTable(); if (initPerusahaan.Substring(1, 0) == "0") { initPerusahaan = "C"; } else { initPerusahaan = "0"; } using (Database db = new Database()) { //db.Commands.Add(db.CreateCommand("usp_OrderPenjualanDetailPos_LIST")); //db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, headerID)); //dtPL = db.Commands[0].ExecuteDataTable(); //if (dtPL.Rows.Count == 0) //{ // NilaiDO = 0; //} //else //{ // NilaiDO = double.Parse(dtPL.Compute("SUM(HrgNet)", "").ToString());//Tools.isNull(dt.Rows[0]["HrgNet"], "").ToString(); //} db.Commands.Add(db.CreateCommand("usp_OrderPenjualanPos_LIST")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, headerID)); dtOP = db.Commands[0].ExecuteDataTable(); noNota = Tools.isNull(dtOP.Rows[0]["NoACCPiutang"], "").ToString(); nPrint = dtOP.Rows[0]["NPrint"].ToString(); NilaiDO = double.Parse(dtOP.Rows[0]["RpNet"].ToString()); db.Commands.Add(db.CreateCommand("usp_Toko_LIST")); db.Commands[1].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, kodeToko)); dtT = db.Commands[1].ExecuteDataTable(); Plafon = Convert.ToDouble(dtT.Rows[0]["Plafon"]); } //GENERATE Nomor Acc DataTable dtNum = Tools.GetGeneralNumerator(docNO); int lebar = int.Parse(dtNum.Rows[0]["Lebar"].ToString()); int iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString()); string depan = Tools.GeneralInitial(); string belakang = dtNum.Rows[0]["Belakang"].ToString(); iNomor++; string strNoACC = Tools.FormatNumerator(iNomor, lebar, depan, belakang); strNoACC = strNoACC.Substring(3, 6); DataTable dt1 = new DataTable(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_Toko_LIST")); db.Commands[0].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, kodeToko)); dt1 = db.Commands[0].ExecuteDataTable(); if (dt1.Rows.Count > 0) { db.Commands.Add(db.CreateCommand("usp_fnCekPlafon")); db.Commands[1].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, kodeToko)); db.Commands[1].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, headerID)); dt1 = db.Commands[1].ExecuteDataTable(); if (dt1.Rows.Count > 0) { Plafon = Convert.ToDouble(dt1.Rows[0]["Plafon"]); } } db.Commands.Add(db.CreateCommand("usp_vwDebetDibayarbankGiroTolak")); db.Commands[2].Parameters.Add(new Parameter("@kodeToko", SqlDbType.VarChar, kodeToko)); dt1 = db.Commands[2].ExecuteDataTable(); if (dt1.Rows.Count > 0) { dDebet = Convert.ToDouble(dt1.Rows[0]["Debet"]); dDibayar = Convert.ToDouble(dt1.Rows[0]["Dibayar"]); } else { dDebet = 0; dDibayar = 0; } if (dDebet - dDibayar > 0) { Gbc = Gbc + dDebet; } noACCDO = string.Empty; ACCOleh = SecurityManager.UserID; } System.Diagnostics.Process proc = new System.Diagnostics.Process(); proc.EnableRaisingEvents = false; proc.StartInfo.FileName = lokasiApp + "v_accdo_ISA_Pos.exe"; proc.StartInfo.Arguments = Plafon.ToString() + " " + kodeToko + " " + ACCOleh + " " + NilaiDO.ToString() + " " + headerID.ToString() + " " + strNoACC + " " + initPerusahaan + " " + tglDo.ToString("dd/MM/yyyy") + " " + lokasiDatabase + " " + lokasiDataKasir + " " + lokasiApp + " " + host + " " + nPrint; proc.Start(); proc.WaitForExit(); //RefreshDataSeluruhnya(); //dataGridView1.FindRow("RowID", doID.ToString()); RefreshRowDataDO(doID.ToString()); } catch (Exception ex) { Error.LogError(ex); } }
private void cmdSave_Click(object sender, EventArgs e) { //if (SecurityManager.AppRole == "004") // { if (IsValid()) { try { switch (formMode) { case enumFormMode.New: using (Database db = new Database()) { _rowID = Guid.NewGuid(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_PenjualanPotongan_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@notaPenjualanID", SqlDbType.UniqueIdentifier, _row)); db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, trID)); db.Commands[0].Parameters.Add(new Parameter("@potID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@noPot", SqlDbType.VarChar, txtNoPot.Text)); db.Commands[0].Parameters.Add(new Parameter("@tglPot", SqlDbType.DateTime, txtTglPot.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@dil", SqlDbType.Money, Convert.ToDouble(txtPotLumRp.Text))); db.Commands[0].Parameters.Add(new Parameter("@disc", SqlDbType.Money, Convert.ToDouble(txtPotLumPersen.Text))); db.Commands[0].Parameters.Add(new Parameter("@rpNet", SqlDbType.Money, Convert.ToDouble(txtNetto.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatPot.Text)); db.Commands[0].Parameters.Add(new Parameter("@tglACC", SqlDbType.DateTime, SqlDateTime.Null)); db.Commands[0].Parameters.Add(new Parameter("@dilACC", SqlDbType.Money, 0)); db.Commands[0].Parameters.Add(new Parameter("@catACC", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@discACC", SqlDbType.Money, 0)); db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@idLink", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } //); break; case enumFormMode.Update: if (txtTglACC.DateValue.HasValue) { GlobalVar.LastClosingDate = (DateTime)txtTglACC.DateValue; if ((DateTime)txtTglACC.DateValue <= GlobalVar.LastClosingDate) { throw new Exception(String.Format(ISA.Toko.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate)); } } using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_PenjualanPotongan_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@notaPenjualanID", SqlDbType.UniqueIdentifier, _row)); db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, trID)); db.Commands[0].Parameters.Add(new Parameter("@potID", SqlDbType.VarChar, potID)); db.Commands[0].Parameters.Add(new Parameter("@noPot", SqlDbType.VarChar, txtNoPot.Text)); db.Commands[0].Parameters.Add(new Parameter("@tglPot", SqlDbType.DateTime, txtTglPot.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@dil", SqlDbType.Money, Convert.ToDouble(txtPotLumRp.Text))); db.Commands[0].Parameters.Add(new Parameter("@disc", SqlDbType.Money, Convert.ToDouble(txtPotLumPersen.Text))); db.Commands[0].Parameters.Add(new Parameter("@rpNet", SqlDbType.Money, Convert.ToDouble(txtNetto.Text))); db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatPot.Text)); db.Commands[0].Parameters.Add(new Parameter("@tglACC", SqlDbType.DateTime, txtTglACC.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@dilACC", SqlDbType.Money, Math.Round(Convert.ToDouble(txtACCRp.Text), 0))); db.Commands[0].Parameters.Add(new Parameter("@catACC", SqlDbType.VarChar, txtCatACC.Text)); if (ajukan == true) { db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0)); } else if (acc == true) { //cAcc = IIF(nDil_acc > 0,'v',' ') if (Convert.ToDouble(txtACCRp.Text) > 0) { db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 1)); // LinkToPiutang(); } else { db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0)); } } db.Commands[0].Parameters.Add(new Parameter("@discACC", SqlDbType.Decimal, Convert.ToDecimal(txtACCPersen.Text))); db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@idLink", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } if (LookupInfo.GetValue("INSTALL_MODULE", "PIUTANG").ToString() == "True") { if (ajukan == false) { if (acc == true && txtACCRp.GetDoubleValue > 0) { LinkToPiutang(); } } } break; } MessageBox.Show("Data telah tersimpan"); this.DialogResult = DialogResult.OK; } catch (Exception ex) { Error.LogError(ex); } finally { frmPenjualanPotonganBrowserISA frmCaller = (frmPenjualanPotonganBrowserISA)this.Caller; frmCaller.RefreshData(); frmCaller.FindRow("RowID", _rowID.ToString()); this.Close(); frmCaller.Show(); } } //} }
private void cmdUpload_Click(object sender, EventArgs e) { string _connStrTemplate = "Provider = VFPOLEDB;Data Source={0}"; try { DataTable dt = new DataTable(); using (Database db = new Database()) { // Get incompleted Job db.Commands.Add(db.CreateCommand("usp_FoxproInjection_LIST")); db.Commands[0].Parameters.Add(new Parameter("@complete", SqlDbType.Bit, 0)); dt = db.Commands[0].ExecuteDataTable(); db.Commands.Add(db.CreateCommand("usp_FoxproInjection_UPDATE")); // Loop for each incompleted job if (dt.Rows.Count > 0) { this.Cursor = Cursors.WaitCursor; string connDatabaseStr = string.Format(_connStrTemplate, LookupInfo.GetValue("FOXINJECTOR", "DATABASE_PATH")); string connKasirStr = string.Format(_connStrTemplate, LookupInfo.GetValue("FOXINJECTOR", "KASIR_PATH")); using (OleDbConnection connDatabase = new OleDbConnection(connDatabaseStr), connKasir = new OleDbConnection(connKasirStr)) { connDatabase.Open(); connKasir.Open(); //Create Commands OleDbCommand cmdDatabase = new OleDbCommand(); cmdDatabase.Connection = connDatabase; OleDbCommand cmdKasir = new OleDbCommand(); cmdKasir.Connection = connKasir; foreach (DataRow dr in dt.Rows) { db.BeginTransaction(); //Update table FoxproInjection, set complete to true db.Commands[1].Parameters.Clear(); db.Commands[1].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, dr["RowID"])); db.Commands[1].Parameters.Add(new Parameter("@complete", SqlDbType.Bit, 1)); db.Commands[1].Parameters.Add(new Parameter("@runDate", SqlDbType.DateTime, DateTime.Now)); db.Commands[1].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, "ISA.WinServices")); db.Commands[1].ExecuteNonQuery(); string script = dr["Script"].ToString(); //inject to foxpro if (dr["Target"].ToString().ToUpper() == "KASIR") { cmdKasir.CommandText = script; cmdKasir.CommandType = CommandType.Text; cmdKasir.ExecuteNonQuery(); } else { cmdDatabase.CommandText = script; cmdDatabase.CommandType = CommandType.Text; cmdDatabase.ExecuteNonQuery(); } db.CommitTransaction(); } connDatabase.Close(); connKasir.Close(); } } } MessageBox.Show("Data sudah dikirim ke Foxpro"); RefreshData(); } catch (Exception ex) { Error.LogError(ex); } finally { Cursor = Cursors.Default; } }
private void frmSendFile_Load(object sender, EventArgs e) { txtTarget.Text = LookupInfo.GetValue("FTP", "FTP_COCKPIT"); }