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");
}
