protected override void OpenFileMaster()
{
var msg = "Untuk membuka file master Customer membutuhkan Ms Excel versi 2007 atau yang terbaru.\n\n" +
"Apakah proses ingin dilanjutkan ?";
if (MsgHelper.MsgKonfirmasi(msg))
{
var fileMaster = Utils.GetAppPath() + @"\File Import Excel\Master Data\data_customer.xlsx";
if (!File.Exists(fileMaster))
{
MsgHelper.MsgWarning("Maaf file master Customer tidak ditemukan.");
return;
}
try
{
Process.Start(fileMaster);
}
catch
{
msg = "Gagal membuka file master Customer !!!.\n\n" +
"Cek apakah Ms Excel versi 2007 atau yang terbaru sudah terinstall ?";
MsgHelper.MsgError(msg);
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
var isConnected = false;
SaveAppConfig();
// tes koneksi ke server
using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0)))
{
IDbConnectionHelper dbConn = new DbConnectionHelper();
isConnected = dbConn.IsOpenConnection();
}
if (!isConnected)
{
var msg = "Maaf koneksi ke database gagal !!!\n\n" +
"Disarankan untuk menginstall OpenRetail di 'Drive D'.\n" +
"Silahkan uninstall dulu OpenRetailnya, kemudian install lagi di 'Drive D'.";
MsgHelper.MsgError(msg);
return;
}
using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0)))
{
IPenggunaBll penggunaBll = new PenggunaBll(_log);
var pass = CryptoHelper.GetMD5Hash(txtPassword.Text, MainProgram.securityCode);
var isLogin = penggunaBll.IsValidPengguna(txtUserName.Text, pass);
if (isLogin)
{
UpgradeDatabase(DatabaseVersionHelper.DatabaseVersion);
log4net.GlobalContext.Properties["UserName"] = txtUserName.Text;
MainProgram.pengguna = penggunaBll.GetByID(txtUserName.Text);
SetProfil();
SetPengaturanUmum();
SetPengaturanBarcode();
SetSettingPort();
SetSettingCustomerDisplay();
LoadKabupaten();
LoadWilayah();
if (MainProgram.pengaturanUmum.is_show_minimal_stok)
{
LoadInfoMinimalStokProduk();
}
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MsgHelper.MsgWarning("User name atau password salah !!!");
txtUserName.Focus();
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
var isConnected = false;
SaveAppConfig();
// tes koneksi ke server
using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0)))
{
IDbConnectionHelper dbConn = new DbConnectionHelper();
isConnected = dbConn.IsOpenConnection();
}
if (!isConnected)
{
var msg = "Maaf koneksi ke server database gagal !!!\n" +
"Silahkan cek koneksi jaringan Anda.";
MsgHelper.MsgError(msg);
return;
}
using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0)))
{
IPenggunaBll penggunaBll = new PenggunaBll(_log);
var pass = CryptoHelper.GetMD5Hash(txtPassword.Text, MainProgram.securityCode);
var isLogin = penggunaBll.IsValidPengguna(txtUserName.Text, pass);
if (isLogin)
{
log4net.GlobalContext.Properties["UserName"] = txtUserName.Text;
MainProgram.pengguna = penggunaBll.GetByID(txtUserName.Text);
SetProfil();
//TODO: fix me, aktifkan jika module report sudah selesai
/*
* if (!Utils.IsRunningUnderIDE())
* {
* LoadCrystalReportLib();
* }*/
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MsgHelper.MsgWarning("User name atau password salah !!!");
txtUserName.Focus();
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
var isConnected = false;
SaveAppConfig();
// tes koneksi ke server
using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0)))
{
IDbConnectionHelper dbConn = new DbConnectionHelper();
isConnected = dbConn.IsOpenConnection();
}
if (!isConnected)
{
var msg = "Maaf koneksi ke server database gagal !!!\n" +
"Silahkan cek koneksi jaringan Anda.";
MsgHelper.MsgError(msg);
return;
}
using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0)))
{
IPenggunaBll penggunaBll = new PenggunaBll(_log);
var pass = CryptoHelper.GetMD5Hash(txtPassword.Text, MainProgram.securityCode);
var isLogin = penggunaBll.IsValidPengguna(txtUserName.Text, pass);
if (isLogin)
{
log4net.GlobalContext.Properties["UserName"] = txtUserName.Text;
MainProgram.pengguna = penggunaBll.GetByID(txtUserName.Text);
SetProfil();
SetPengaturanUmum();
// TODO: fix me (di aktifkan setelah rilis versi 1.0.0)
// UpgradeDatabase(DatabaseVersion);
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MsgHelper.MsgWarning("User name atau password salah !!!");
txtUserName.Focus();
}
}
}
private void btnProsesRestore_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtLokasiFileBackup.Text))
{
MsgHelper.MsgWarning("File backup belum dipilih !");
txtLokasiFileBackup.Focus();
return;
}
if (!MsgHelper.MsgKonfirmasi("Apakah proses restore database ingin dilanjutkan ?"))
{
return;
}
txtLog.Clear();
SaveAppConfig();
using (new StCursor(Cursors.WaitCursor, new TimeSpan(0, 0, 0, 0)))
{
Result = "Sedang melakukan koneksi ke database ..." + Environment.NewLine;
if (!IsOpenConnection())
{
var msg = "Maaf koneksi ke database gagal !!!\n" +
"Proses restore database tidak bisa dilanjutkan.";
MsgHelper.MsgWarning(msg);
return;
}
Result = "Koneksi ke database berhasil" + Environment.NewLine + Environment.NewLine;
if (!ReplaceDatabase(_dbName))
{
var msg = "Gagal menghapus database lama !!!\n" +
"Proses restore database gagal.";
MsgHelper.MsgError(msg);
return;
}
Result = "Sedang merestore database ..." + Environment.NewLine + Environment.NewLine;
var cmd = "-U postgres -h " + txtServer.Text + " -p " + _port + " -i -v -d " + _dbName + " \"" + txtLokasiFileBackup.Text + "\"";
ExecuteCommand("pg_restore", cmd);
}
}
private void ExecuteCommand(string cmd, string parameter)
{
try
{
_result = "";
var info = new System.Diagnostics.ProcessStartInfo();
info.FileName = "pgsql\\" + cmd + ".exe ";
info.Arguments = parameter;
info.CreateNoWindow = true;
info.RedirectStandardOutput = true;
info.RedirectStandardError = true;
info.UseShellExecute = false;
try
{
info.EnvironmentVariables.Add("PGPASSWORD", _pgPassword);
}
catch
{
}
var proc = new System.Diagnostics.Process();
proc.StartInfo = info;
proc.Start();
var cTokenSource = new CancellationTokenSource();
var cToken = cTokenSource.Token;
Result = Task.Factory.StartNew(() => proc.StandardError.ReadToEnd(), cToken).Result;
proc.WaitForExit();
if (proc.ExitCode == 0)
{
Result += Environment.NewLine + ((cmd == "pg_dump") ? "Backup database berhasil." : "Restore database berhasil.");
}
else
{
Result += Environment.NewLine + "Error Occured";
}
}
catch (Exception ex)
{
MsgHelper.MsgError(ex.Message);
}
}
