private void SetSettings()
{
try
{
SetIconDisplayType(ConfigFacade.sy_toolbar_icon_display_type);
splitContainer1.SplitterDistance = ConfigFacade.ic_unit_measure_splitter_distance;
SetCodeCasing();
txtCode.MaxLength = ConfigFacade.sy_code_max_length;
var lo = ConfigFacade.ic_unit_measure_location;
if (lo != new System.Drawing.Point(-1, -1))
{
Location = lo;
}
var si = ConfigFacade.ic_unit_measure_size;
if (si != new System.Drawing.Size(-1, -1))
{
Size = si;
}
WindowState = (FormWindowState)ConfigFacade.ic_unit_measure_window_state;
}
catch (Exception ex)
{
ErrorLogFacade.Log(ex, "Set settings");
}
}
private void RefreshGrid(long seq = 0)
{
Cursor = Cursors.WaitCursor;
//IsIgnore = true;
if (dgvList.SelectedRows.Count > 0)
{
RowIndex = dgvList.SelectedRows[0].Index;
}
try
{
dgvList.DataSource = UnitMeasureFacade.GetDataTable(txtFind.Text, GetStatus());
}
catch (Exception ex)
{
Cursor = Cursors.Default;
MessageFacade.Show(MessageFacade.error_retrieve_data + "\r\n" + ex.Message, LabelFacade.sy_unit_measure, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
return;
}
if (dgvList.RowCount > 0)
{
if (seq == 0)
{
if (RowIndex >= dgvList.RowCount)
{
RowIndex = dgvList.RowCount - 1;
}
dgvList.CurrentCell = dgvList[1, RowIndex];
}
else
{
foreach (DataGridViewRow row in dgvList.Rows)
{
if ((long)row.Cells[0].Value == seq)
{
Id = (int)seq;
dgvList.CurrentCell = dgvList[1, row.Index];
break;
}
}
}
}
else
{
btnCopy.Enabled = false;
btnUnlock.Enabled = false;
btnActive.Enabled = false;
btnDelete.Enabled = false;
ClearAllBoxes();
}
IsIgnore = false;
//LoadData();
Cursor = Cursors.Default;
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
var Id = dgvList.Id;
if (Id == 0)
{
return;
}
// If referenced
//todo: check if exist in ic_item
// If locked
var lInfo = UnitMeasureFacade.GetLock(Id);
string msg = "";
if (lInfo.Locked)
{
msg = string.Format(MessageFacade.delete_locked, lInfo.Lock_By, lInfo.Lock_At);
if (!Privilege.CanAccess(Type.Function_IC_Unit_Measure, "O"))
{
MessageFacade.Show(msg, LabelFacade.sy_delete, MessageBoxButtons.OK, MessageBoxIcon.Information);
SessionLogFacade.Log(Type.Priority_Caution, Type.Module_IC_Unit_Measure, Type.Log_Delete, "Cannot delete. Currently locked by '" + lInfo.Lock_By + "' since '" + lInfo.Lock_At + "' . Id=" + dgvList.Id + ", Code=" + txtCode.Text);
return;
}
}
// Delete
msg = MessageFacade.delete_confirmation;
if (lInfo.Locked)
{
msg = string.Format(MessageFacade.lock_currently, lInfo.Lock_By, lInfo.Lock_At) + "'\n" + msg;
}
if (MessageFacade.Show(msg, LabelFacade.sy_delete, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.No)
{
return;
}
try
{
UnitMeasureFacade.SetStatus(Id, Type.RecordStatus_Deleted);
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_delete + "\r\n" + ex.Message, LabelFacade.sy_delete, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
}
RefreshGrid();
// log
SessionLogFacade.Log(Type.Priority_Warning, Type.Module_IC_Unit_Measure, Type.Log_Delete, "Deleted. Id=" + dgvList.Id + ", Code=" + txtCode.Text);
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_delete + "\r\n" + ex.Message, LabelFacade.sy_delete, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
}
}
private bool Save()
{
if (!IsValidated())
{
return(false);
}
Cursor = Cursors.WaitCursor;
var m = new Account();
var log = new SessionLog {
Module = Type.Module_IC_Location
};
m.Id = Id;
m.Code = txtCode.Text.Trim();
m.Description = txtDesc.Text;
m.Type = cboNormalBalance.Text.Substring(0, 1);
m.Address = txtStructureCode.Text;
m.Name = txtStructureCodeDesc.Text;
m.Phone = txtGroup.Text;
m.Fax = txtFax.Text;
m.Email = txtEmail.Text;
m.Note = txtNote.Text;
if (m.Id == 0)
{
log.Priority = Type.Priority_Information;
log.Type = Type.Log_Insert;
}
else
{
log.Priority = Type.Priority_Caution;
log.Type = Type.Log_Update;
}
try
{
m.Id = AccountFacade.Save(m);
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_save + "\r\n" + ex.Message, LabelFacade.sy_save, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
}
if (dgvList.RowCount > 0)
{
RowIndex = dgvList.CurrentRow.Index;
}
RefreshGrid(m.Id);
LockControls();
Cursor = Cursors.Default;
log.Message = "Saved. Id=" + m.Id + ", Code=" + txtCode.Text;
SessionLogFacade.Log(log);
IsDirty = false;
return(true);
}
private bool Save()
{
if (!IsValidated())
{
return(false);
}
Cursor = Cursors.WaitCursor;
var m = new UnitMeasure();
var log = new SessionLog {
Module = Type.Module_IC_Unit_Measure
};
m.Id = Id;
m.Code = txtCode.Text.Trim();
m.Default_Factor = double.Parse(txtFactor.Text);
m.Description = txtDesc.Text;
m.Note = txtNote.Text;
if (m.Id == 0)
{
log.Priority = Type.Priority_Information;
log.Type = Type.Log_Insert;
}
else
{
log.Priority = Type.Priority_Caution;
log.Type = Type.Log_Update;
}
try
{
m.Id = UnitMeasureFacade.Save(m);
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_save + "\r\n" + ex.Message, LabelFacade.sy_save, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
}
if (dgvList.RowCount > 0)
{
RowIndex = dgvList.CurrentRow.Index;
}
RefreshGrid(m.Id);
LockControls();
Cursor = Cursors.Default;
log.Message = "Saved. Id=" + m.Id + ", Code=" + txtCode.Text;
SessionLogFacade.Log(log);
IsDirty = false;
return(true);
}
public static bool Exists(string Code, long Id = 0)
{
var sql = SqlFacade.SqlExists(TableName, "id <> :id and status <> :status and code = :code");
var bExists = false;
try
{
bExists = SqlFacade.Connection.ExecuteScalar <bool>(sql, new { Id, Status = Type.RecordStatus_Deleted, Code });
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_query + "\r\n" + ex.Message, LabelFacade.sy_location, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex, "Exists");
}
return(bExists);
}
private void frmUnitMeasureList_Load(object sender, EventArgs e)
{
Icon = Properties.Resources.Icon;
try
{
dgvList.ShowLessColumns(true);
SetSettings();
SetLabels();
SessionLogFacade.Log(Type.Priority_Information, Type.Module_IC_Unit_Measure, Type.Log_Open, "Opened");
RefreshGrid();
LoadData();
}
catch (Exception ex)
{
ErrorLogFacade.Log(ex, "Form_Load");
MessageFacade.Show(MessageFacade.error_load_form + "\r\n" + ex.Message, LabelFacade.sy_unit_measure, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnActive_Click(object sender, EventArgs e)
{
var Id = dgvList.Id;
if (Id == 0)
{
return;
}
string status = btnActive.Text == LabelFacade.sy_button_inactive ? Type.RecordStatus_InActive : Type.RecordStatus_Active;
// If referenced
//todo: check if already used in ic_item
//If locked
var lInfo = UnitMeasureFacade.GetLock(Id);
if (lInfo.Locked)
{
string msg = string.Format(MessageFacade.lock_currently, lInfo.Lock_By, lInfo.Lock_At);
if (!Privilege.CanAccess(Type.Function_IC_Unit_Measure, "O"))
{
MessageFacade.Show(msg, MessageFacade.active_inactive, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
if (MessageFacade.Show(msg + "\r\n" + MessageFacade.proceed_confirmation, MessageFacade.active_inactive, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.No)
{
return;
}
}
try
{
UnitMeasureFacade.SetStatus(Id, status);
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_active_inactive + ex.Message, MessageFacade.active_inactive, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
}
RefreshGrid();
SessionLogFacade.Log(Type.Priority_Caution, Type.Module_IC_Unit_Measure, status == Type.RecordStatus_InActive ? Type.Log_Inactive : Type.Log_Active, "Id=" + dgvList.Id + ", Code=" + txtCode.Text);
}
private void btnUnlock_Click(object sender, EventArgs e)
{
if (!Privilege.CanAccess(Type.Function_IC_Unit_Measure, Type.Privilege_Update))
{
MessageFacade.Show(MessageFacade.privilege_no_access, LabelFacade.sy_button_unlock, MessageBoxButtons.OK, MessageBoxIcon.Information);
SessionLogFacade.Log(Type.Priority_Information, Type.Module_IC_Unit_Measure, Type.Log_NoAccess, "Copy: No access");
return;
}
if (IsExpand)
{
picExpand_Click(sender, e);
}
Id = dgvList.Id;
// Cancel
if (btnUnlock.Text == LabelFacade.sy_button_cancel)
{
if (IsDirty)
{
var result = MessageFacade.Show(MessageFacade.save_confirmation, LabelFacade.sy_button_cancel, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (result == System.Windows.Forms.DialogResult.Yes) // Save then close
{
btnSave_Click(null, null);
}
else if (result == System.Windows.Forms.DialogResult.No)
{
LoadData(); // Load original back if changes (dirty)
}
else if (result == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
}
LockControls(true);
dgvList.Focus();
try
{
UnitMeasureFacade.ReleaseLock(dgvList.Id);
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_unlock + "\r\n" + ex.Message, LabelFacade.sy_unlock, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
return;
}
if (dgvList.CurrentRow != null && !dgvList.CurrentRow.Selected)
{
dgvList.CurrentRow.Selected = true;
}
SessionLogFacade.Log(Type.Priority_Information, Type.Module_IC_Unit_Measure, Type.Log_Unlock, "Unlock cancel. Id=" + dgvList.Id + ", Code=" + txtCode.Text);
btnUnlock.ToolTipText = "Unlock (Ctrl+L)";
IsDirty = false;
return;
}
// Unlock
if (Id == 0)
{
return;
}
try
{
var lInfo = UnitMeasureFacade.GetLock(Id);
if (lInfo.Locked) // Check if record is locked
{
string msg = string.Format(MessageFacade.lock_currently, lInfo.Lock_By, lInfo.Lock_At);
if (!Privilege.CanAccess(Type.Function_IC_Unit_Measure, "O"))
{
MessageFacade.Show(msg, LabelFacade.sy_unlock, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
if (MessageFacade.Show(msg + "\r\n" + MessageFacade.lock_override, LabelFacade.sy_unlock, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
SessionLogFacade.Log(Type.Priority_Caution, Type.Module_IC_Unit_Measure, Type.Log_Lock, "Override lock. Id=" + dgvList.Id + ", Code=" + txtCode.Text);
}
else
{
return;
}
}
txtDesc.SelectionStart = txtDesc.Text.Length;
txtDesc.Focus();
LockControls(false);
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_unlock + "\r\n" + ex.Message, LabelFacade.sy_unlock, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
return;
}
try
{
UnitMeasureFacade.Lock(dgvList.Id, txtCode.Text);
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_lock + "\r\n" + ex.Message, LabelFacade.sy_lock, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
return;
}
SessionLogFacade.Log(Type.Priority_Information, Type.Module_IC_Unit_Measure, Type.Log_Lock, "Locked. Id=" + dgvList.Id + ", Code=" + txtCode.Text);
btnUnlock.ToolTipText = "Cancel (Esc or Ctrl+L)";
}
public static int ExportToCSV(string sql)
{
//sql = "COPY (" + sql + ") TO '" + path + "' DELIMITER '" + delimiter + "' CSV HEADER ENCODING 'UTF8';";
//Connection.ExecuteNonQuery(sql);
var result = 0;
var sfd = new SaveFileDialog
{
CheckPathExists = true,
OverwritePrompt = true,
Filter = "CSV File (*.csv)|*.csv|All Files (*.*)|*.*",
Title = "Export to CSV"
};
if (sfd.ShowDialog() != DialogResult.OK)
{
return(result);
}
var path = sfd.FileName;
var fileName = Path.GetFileName(path);
var fNotification = new frmNotification(string.Format(MessageFacade.export_exporting, fileName));
fNotification.Show();
Application.DoEvents();
StringBuilder sb = new StringBuilder();
try
{
var dr = GetDataReader(sql);
var sLine = "";
if (!dr.HasRows)
{
return(1); // No record
}
for (int i = 0; i < dr.FieldCount; i++) // Column headers
{
sLine += dr.GetName(i);
if (i < dr.FieldCount - 1)
{
sLine += ConfigFacade.sy_export_delimiter;
}
}
sb.AppendLine(sLine);
while (dr.Read()) // Rows
{
sLine = "";
for (int i = 0; i < dr.FieldCount; i++)
{
sLine += "\"" + dr[i].ToString() + "\"";
if (i < dr.FieldCount - 1)
{
sLine += ConfigFacade.sy_export_delimiter;
}
}
sb.AppendLine(sLine);
}
dr.Close();
}
catch (Exception ex)
{
MessageFacade.Show(MessageFacade.error_export + "\r\n" + ex.Message, LabelFacade.sy_export, MessageBoxButtons.OK, MessageBoxIcon.Error);
ErrorLogFacade.Log(ex);
return(-1);
}
while (Util.IsFileLocked(path)) // Check if file is being used
{
if (MessageFacade.Show(string.Format(MessageFacade.file_being_used_try_again, fileName), LabelFacade.sy_export, MessageBoxButtons.RetryCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
{
fNotification.Close();
return(0);
}
continue;
}
using (var sw = new StreamWriter(path, false, Encoding.UTF8)) // Write to file
{
sw.Write(sb);
}
fNotification.ShowMsg(string.Format(MessageFacade.export_opening, fileName));
if (ConfigFacade.sy_export_open_file_after)
{
System.Diagnostics.Process.Start(path); // Open file
}
fNotification.Close();
return(result);
}
