private void btnDel_Click(object sender, EventArgs e)
{
var currentProductCode = GetCurrentProductCode();
var prodToDel = uowProduct.Repository.GetAll().Where(p => p.ProductCode == currentProductCode).FirstOrDefault();
if (prodToDel != null)
{
if (DialogResult.Yes == CommonMessageHelper.ConfirmDelete())
{
uowProduct.Repository.Delete(prodToDel);
var res = uowProduct.Commit();
if (!res.Item1 && res.Item2 == "Expected")
{
CommonMessageHelper.ReferredDataCannotBeDeleted();
}
if (!res.Item1 && res.Item2 == "Unexpected")
{
CommonMessageHelper.ContactAdminError();
}
btnReload.PerformClick();
}
}
else
{
CommonMessageHelper.DataNotFound(GetCurrentProductCode());
}
}
private void btnDel_Click(object sender, EventArgs e)
{
// Role SUPER cannot be deleted!
if (txtRoleCode.Text.ToUpper().Trim() == "SUPER")
{
MessageBox.Show("Role SUPER tidak boleh dihapus."
, "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var roleToDel = uowRole.Repository.GetAll().Where(u => u.RoleCode == txtRoleCode.Text.Trim()).FirstOrDefault();
if (roleToDel != null)
{
if (DialogResult.Yes == CommonMessageHelper.ConfirmDelete())
{
uowRole.Repository.Delete(roleToDel);
var res = uowRole.Commit();
if (!res.Item1 && res.Item2 == "Expected")
{
CommonMessageHelper.ReferredDataCannotBeDeleted();
}
if (!res.Item1 && res.Item2 == "Unexpected")
{
CommonMessageHelper.ContactAdminError();
}
btnReload.PerformClick();
}
}
else
{
CommonMessageHelper.DataNotFound(txtRoleCode.Text.Trim());
}
}
private void btnDel_Click(object sender, EventArgs e)
{
var roleToDel = uowPrincipal.Repository.GetAll().Where(u => u.PrincipalCode == txtPrincipalCode.Text.Trim()).FirstOrDefault();
if (roleToDel != null)
{
if (DialogResult.Yes == CommonMessageHelper.ConfirmDelete())
{
uowPrincipal.Repository.Delete(roleToDel);
var res = uowPrincipal.Commit();
if (!res.Item1 && res.Item2 == "Expected")
{
CommonMessageHelper.ReferredDataCannotBeDeleted();
}
if (!res.Item1 && res.Item2 == "Unexpected")
{
CommonMessageHelper.ContactAdminError();
}
btnReload.PerformClick();
}
}
else
{
CommonMessageHelper.DataNotFound(txtPrincipalCode.Text.Trim());
}
}
private void btnDel_Click(object sender, EventArgs e)
{
var soToDel = _uow.Repository.GetById(txtSalesOrderId.Text.Trim());
if (soToDel != null)
{
if (DialogResult.Yes == CommonMessageHelper.ConfirmDelete())
{
// delete the sales order
soToDel.Status = Constant.RecordStatus.Inactive;
_uow.Repository.Update(soToDel);
var res = _uow.Commit();
if (!res.Item1 && res.Item2 == "Expected")
{
CommonMessageHelper.ReferredDataCannotBeDeleted();
}
if (!res.Item1 && res.Item2 == "Unexpected")
{
CommonMessageHelper.ContactAdminError();
}
LoadSalesOrderData(soToDel.SalesNo);
}
}
else
{
CommonMessageHelper.DataNotFound(lblSalesNo.Text.Trim());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateMandatoryFields())
{
return;
}
var repoLastUpdated = uowTop.Repository.GetById(txtTermId.Text.Trim()).ModifiedAt;
var lastUpdated = DateTime.Parse(txtModifiedAt.Text.Trim());
var commonHelper = new CommonFunctionHelper();
if (commonHelper.StandardizeDateTime(lastUpdated) != commonHelper.StandardizeDateTime(repoLastUpdated))
{
CommonMessageHelper.DataHasBeenUpdatedPriorToSave(txtTermCode.Text.Trim());
}
else
{
var topToUpdate = uowTop.Repository.GetById(txtTermId.Text.Trim());
topToUpdate.TermCode = txtTermCode.Text.Trim();
topToUpdate.Description = txtDescription.Text.Trim();
topToUpdate.ModifiedBy = Properties.Settings.Default.CurrentUserId;
topToUpdate.ModifiedAt = DateTime.Now;
uowTop.Repository.Update(topToUpdate);
uowTop.Commit();
btnReload.PerformClick();
CommonMessageHelper.DataSavedSuccessfully();
}
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtCustomerCode.Text) || string.IsNullOrEmpty(txtCustomerName.Text) || string.IsNullOrEmpty(txtAddress.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode, Nama Pelanggan dan Alamat");
return(false);
}
if (cbOutletType.SelectedItem.ToString().Contains("Pilih"))
{
CommonMessageHelper.DataCannotBeEmpty("Jenis Outlet");
return(false);
}
if (cbOutletType.Items.Count <= 1 || cbSalesArea.Items.Count <= 1)
{
var emptyRefData = cbOutletType.Items.Count <= 1 ? "Jenis Outlet" : "Sales Area";
CommonMessageHelper.ReferredDataNotSet(emptyRefData);
return(false);
}
var customerCode = txtCustomerCode.Text.Trim();
var customerName = txtCustomerName.Text.Trim();
var existingCust = uowCust.Repository.GetAll().FirstOrDefault(c => c.CustomerName == customerName && c.CustomerCode != customerCode);
if (existingCust != null)
{
MessageBox.Show($"Pelanggan dengan nama '{customerName}' sudah ada, silakan gunakan nama pelanggan lain.", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
return(true);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!ValidateMandatoryFields())
{
return;
}
var existingTop = uowTop.Repository.GetAll().Where(t => t.TermCode == txtTermCode.Text.Trim()).FirstOrDefault();
if (existingTop != null)
{
CommonMessageHelper.DataAlreadyExist(txtTermCode.Text.Trim());
}
else
{
var topToAdd = new TermOfPayment
{
TermCode = txtTermCode.Text.Trim(),
Description = txtDescription.Text.Trim(),
// Audit Fields
CreatedBy = Properties.Settings.Default.CurrentUserId,
CreatedAt = DateTime.Now,
ModifiedBy = Properties.Settings.Default.CurrentUserId,
ModifiedAt = DateTime.Now
};
uowTop.Repository.Add(topToAdd);
uowTop.Commit();
btnReload.PerformClick();
CommonMessageHelper.DataSavedSuccessfully();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!ValidateMandatoryFields())
{
return;
}
var existingProduct = uowBatch.Repository.GetAll().Where(p => p.BatchCode == txtBatchCode.Text.Trim()).FirstOrDefault();
if (existingProduct != null)
{
CommonMessageHelper.DataAlreadyExist(txtBatchCode.Text.Trim());
}
else
{
var batchToAdd = new Batch
{
BatchCode = txtBatchCode.Text.Trim(),
ProductId = cbProductCode.SelectedValue.ToString(),
Quantity = Convert.ToInt32(txtQuantity.Text.Trim()),
EntryDate = DateTime.Parse(dtpEntryDate.Value.ToString("yyyy-MM-dd")),
ExpiredDate = DateTime.Parse(dtpExpiredDate.Value.ToString("yyyy-MM-dd")),
// Audit Fields
CreatedBy = Properties.Settings.Default.CurrentUserId,
CreatedAt = DateTime.Now,
ModifiedBy = Properties.Settings.Default.CurrentUserId,
ModifiedAt = DateTime.Now
};
uowBatch.Repository.Add(batchToAdd);
uowBatch.Commit();
btnReload.PerformClick();
CommonMessageHelper.DataSavedSuccessfully();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!ValidateMandatoryFields())
{
return;
}
var existingUom = uowUom.Repository.GetAll().Where(u => u.UomCode == txtUomCode.Text.Trim()).FirstOrDefault();
if (existingUom != null)
{
CommonMessageHelper.DataAlreadyExist(txtUomCode.Text.Trim());
}
else
{
var uomToAdd = new UnitOfMeasurement
{
UomCode = txtUomCode.Text.Trim(),
Description = txtUomDesc.Text.Trim(),
// Audit Fields
CreatedBy = Properties.Settings.Default.CurrentUserId,
CreatedAt = DateTime.Now,
ModifiedBy = Properties.Settings.Default.CurrentUserId,
ModifiedAt = DateTime.Now
};
uowUom.Repository.Add(uomToAdd);
uowUom.Commit();
btnReload.PerformClick();
CommonMessageHelper.DataSavedSuccessfully();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateMandatoryFields())
{
return;
}
var repoLastUpdated = uowBatch.Repository.GetById(txtBatchId.Text.Trim()).ModifiedAt;
var lastUpdated = DateTime.Parse(txtModifiedAt.Text.Trim());
var commonHelper = new CommonFunctionHelper();
if (commonHelper.StandardizeDateTime(lastUpdated) != commonHelper.StandardizeDateTime(repoLastUpdated))
{
CommonMessageHelper.DataHasBeenUpdatedPriorToSave(txtBatchCode.Text.Trim());
}
else
{
var batchToUpdate = uowBatch.Repository.GetById(txtBatchId.Text.Trim());
batchToUpdate.BatchCode = txtBatchCode.Text.Trim();
batchToUpdate.ProductId = cbProductCode.SelectedValue.ToString();
batchToUpdate.Quantity = Convert.ToInt32(txtQuantity.Text.Trim());
batchToUpdate.EntryDate = DateTime.Parse(dtpEntryDate.Value.ToString("yyyy-MM-dd"));
batchToUpdate.ExpiredDate = DateTime.Parse(dtpExpiredDate.Value.ToString("yyyy-MM-dd"));
batchToUpdate.ModifiedBy = Properties.Settings.Default.CurrentUserId;
batchToUpdate.ModifiedAt = DateTime.Now;
uowBatch.Repository.Update(batchToUpdate);
uowBatch.Commit();
btnReload.PerformClick();
CommonMessageHelper.DataSavedSuccessfully();
}
}
public int SearchGridViewFirstTwoColumn(string searchValue, ref DataGridView dataGridView, ref List <int> foundIndices)
{
bool isEnd = false;
int index = 0;
foreach (DataGridViewRow row in dataGridView.Rows)
{
if ((row.Cells[1].Value.ToString().ToUpper().Contains(searchValue.ToUpper()) || row.Cells[2].Value.ToString().ToUpper().Contains(searchValue.ToUpper())) &&
!foundIndices.Any(f => f == row.Index))
{
foundIndices.Add(row.Index);
index = row.Index;
break;
}
if (row.Index == dataGridView.Rows.Count - 1)
{
isEnd = true;
}
}
if (isEnd)
{
foundIndices.Clear();
CommonMessageHelper.NoMoreResultFound();
}
return(index);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!ValidateMandatoryFields())
{
return;
}
var existingRole = uowArea.Repository.GetAll().Where(r => r.AreaCode == txtAreaCode.Text.Trim()).FirstOrDefault();
if (existingRole != null)
{
CommonMessageHelper.DataAlreadyExist(txtAreaCode.Text.Trim());
}
else
{
var areaToAdd = new SalesArea
{
AreaCode = txtAreaCode.Text.Trim(),
Description = txtDescription.Text.Trim(),
RepresentativeId = cbRepresentative.SelectedValue.ToString(),
// Audit Fields
CreatedBy = Properties.Settings.Default.CurrentUserId,
CreatedAt = DateTime.Now,
ModifiedBy = Properties.Settings.Default.CurrentUserId,
ModifiedAt = DateTime.Now
};
uowArea.Repository.Add(areaToAdd);
uowArea.Commit();
isAdd = true;
btnReload.PerformClick();
CommonMessageHelper.DataSavedSuccessfully();
}
}
private void btnDel_Click(object sender, EventArgs e)
{
var checkUser = uowUser.Repository.GetAll().Where(u => u.Username == txtUsername.Text.Trim()).FirstOrDefault();
if (checkUser != null)
{
if (DialogResult.Yes == CommonMessageHelper.ConfirmDelete())
{
using (var dbContextTransaction = dbContext.Database.BeginTransaction())
{
bool expectedError = false;
bool unexpectedError = false;
var uowUsrRole = new UnitOfWork <UserRole>(dbContext);
var usrRoleToDel = uowUsrRole.Repository.GetAll().Where(u => u.Id == txtUserRoleId.Text.Trim()).FirstOrDefault();
uowUsrRole.Repository.Delete(usrRoleToDel);
var uRoleRes = uowUsrRole.Commit();
if (!uRoleRes.Item1 && uRoleRes.Item2 == "Expected")
{
expectedError = true;
}
if (!uRoleRes.Item1 && uRoleRes.Item2 == "Unexpected")
{
unexpectedError = true;
}
var uowUsr = new UnitOfWork <User>(dbContext);
var usrToDel = uowUsr.Repository.GetAll().Where(u => u.Username == txtUsername.Text.Trim()).FirstOrDefault();
uowUsr.Repository.Delete(usrToDel);
var userRes = uowUsr.Commit();
if (!userRes.Item1 && userRes.Item2 == "Expected")
{
expectedError = true;
}
if (!userRes.Item1 && userRes.Item2 == "Unexpected")
{
unexpectedError = true;
}
if (expectedError)
{
CommonMessageHelper.ReferredDataCannotBeDeleted();
}
if (unexpectedError)
{
CommonMessageHelper.ContactAdminError();
}
dbContextTransaction.Commit();
}
btnReload.PerformClick();
}
}
else
{
CommonMessageHelper.DataNotFound(txtUsername.Text.Trim());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateMandatoryFields())
{
return;
}
if (chkChangePassword.Checked && !txtPassword.Text.Trim().Equals(txtRetypePassword.Text.Trim()))
{
MessageBox.Show("Pastikan password yang anda masukkan sama."
, "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var repoLastUpdated = uowUser.Repository.GetById(txtUserId.Text.Trim()).ModifiedAt;
var lastUpdated = DateTime.Parse(txtUserModifiedAt.Text.Trim());
var commonHelper = new CommonFunctionHelper();
if (commonHelper.StandardizeDateTime(lastUpdated) != commonHelper.StandardizeDateTime(repoLastUpdated))
{
CommonMessageHelper.DataHasBeenUpdatedPriorToSave(txtUsername.Text.Trim());
}
else
{
using (var dbContextTransaction = dbContext.Database.BeginTransaction())
{
var uowUsr = new UnitOfWork <User>(dbContext);
var userToUpdate = uowUsr.Repository.GetById(txtUserId.Text.Trim());
userToUpdate.Username = txtUsername.Text.Trim();
if (chkChangePassword.Checked)
{
userToUpdate.Password = new UserHelper().HashPassword(txtPassword.Text.Trim());
}
userToUpdate.FullName = txtFullName.Text.Trim();
userToUpdate.ModifiedBy = Properties.Settings.Default.CurrentUserId;
userToUpdate.ModifiedAt = DateTime.Now;
uowUsr.Repository.Update(userToUpdate);
uowUsr.Commit();
var uowUsrRole = new UnitOfWork <UserRole>(dbContext);
var userRoleToUpdate = uowUsrRole.Repository.GetById(txtUserRoleId.Text.ToString().Trim());
userRoleToUpdate.UserId = txtUserId.Text.Trim();
userRoleToUpdate.RoleId = cbRole.SelectedValue.ToString().Trim();
userRoleToUpdate.ModifiedBy = Properties.Settings.Default.CurrentUserId;
userRoleToUpdate.ModifiedAt = DateTime.Now;
uowUsrRole.Repository.Update(userRoleToUpdate);
uowUsrRole.Commit();
dbContextTransaction.Commit();
}
btnReload.PerformClick();
CommonMessageHelper.DataSavedSuccessfully();
}
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtRepresentativeCode.Text) || string.IsNullOrEmpty(txtRepresentative.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode Representative dan Nama Representative");
return(false);
}
return(true);
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtOutletCode.Text) || string.IsNullOrEmpty(txtOutlet.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode Outlet dan Jenis Outlet");
return(false);
}
return(true);
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtUsageTypeCode.Text) || string.IsNullOrEmpty(txtUsageDesc.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode Pemakaian dan Jenis Pemakaian");
return(false);
}
return(true);
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtMedCatCode.Text) || string.IsNullOrEmpty(txtMedCat.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode Kategori dan Kategori Obat");
return(false);
}
return(true);
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtSalesmanCode.Text) || string.IsNullOrEmpty(txtFullName.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode Sales dan Nama Lengkap");
return(false);
}
return(true);
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtPrincipalCode.Text) || string.IsNullOrEmpty(txtPrincipalName.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode Principal dan Nama Principal");
return(false);
}
return(true);
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtTermCode.Text) || string.IsNullOrEmpty(txtDescription.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode Term dan Keterangan");
return(false);
}
return(true);
}
private void btnOutletTypes_Click(object sender, EventArgs e)
{
if (!(new CommonFunctionHelper().ValidateAccess((int)Constant.Permission.MasterData.OutletType)))
{
CommonMessageHelper.NoAccess();
return;
}
OpenChildForm(new FrmOutletType(), sender);
}
private void btnExportExcel_Click(object sender, EventArgs e)
{
if (!(new CommonFunctionHelper().ValidateAccess((int)Constant.Permission.Reporting.Sales)))
{
CommonMessageHelper.NoAccess();
return;
}
FrmInvoiceRecap frmInvoiceRecap = new FrmInvoiceRecap();
frmInvoiceRecap.ShowDialog();
}
private void btnExportPelanggan_Click(object sender, EventArgs e)
{
if (!(new CommonFunctionHelper().ValidateAccess((int)Constant.Permission.MasterData.Customer)))
{
CommonMessageHelper.NoAccess();
return;
}
FrmCustomerRecap frmCustomerRecap = new FrmCustomerRecap();
frmCustomerRecap.ShowDialog();
}
private void LoadSalesOrderData(string salesNo)
{
SalesOrder queryResult;
queryResult = _uow.Repository.GetAll().Where(s => s.SalesNo == salesNo).FirstOrDefault();
if (queryResult == null)
{
CommonMessageHelper.DataNotFound(txtSalesNo.Text.Trim());
return;
}
LoadDataItem(queryResult);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!ValidateMandatoryFields())
{
return;
}
var existingCust = uowCust.Repository.GetAll()
.Where(r => r.CustomerCode == txtCustomerCode.Text.Trim() &&
r.Address == txtAddress.Text.Trim())
.FirstOrDefault();
if (existingCust != null)
{
CommonMessageHelper.DataAlreadyExist(txtCustomerCode.Text.Trim() + " dengan alamat " + txtAddress.Text.Trim());
}
else
{
var custToAdd = new Customer
{
CustomerCode = txtCustomerCode.Text.Trim(),
CustomerName = txtCustomerName.Text.Trim(),
Address = txtAddress.Text.Trim(),
ProvinceId = cbProvince.SelectedValue.ToString(),
DistrictId = cbDistrict.SelectedValue.ToString(),
PostalCode = txtPostCode.Text.Trim(),
Phone = txtPhone.Text.Trim(),
Email = txtEmail.Text.Trim(),
Npwp = txtNpwp.Text.Trim(),
PharmacistName = txtPharmacistName.Text.Trim(),
SipaNo = txtSipaNo.Text.Trim(),
SipaExpiredDate = DateTime.Parse(dtpSipaExpiredDate.Value.ToString("yyyy-MM-dd")),
SiaNo = txtSiaNo.Text.Trim(),
OutletTypeId = cbOutletType.SelectedValue.ToString(),
SalesAreaId = cbSalesArea.SelectedValue.ToString(),
// Audit Fields
CreatedBy = Properties.Settings.Default.CurrentUserId,
CreatedAt = DateTime.Now,
ModifiedBy = Properties.Settings.Default.CurrentUserId,
ModifiedAt = DateTime.Now
};
uowCust.Repository.Add(custToAdd);
uowCust.Commit();
isAdd = false;
cbSalesArea.Enabled = isAdd;
btnReload.PerformClick();
CommonMessageHelper.DataSavedSuccessfully();
}
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtAreaCode.Text) || string.IsNullOrEmpty(txtDescription.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Kode Area dan Keterangan");
return(false);
}
if (cbRepresentative.Items.Count <= 1)
{
CommonMessageHelper.ReferredDataNotSet("Perwakilan");
return(false);
}
return(true);
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtBatchCode.Text) || cbProductCode.Items.Count <= 1)
{
CommonMessageHelper.DataCannotBeEmpty("Kode Batch dan Nama Produk");
return(false);
}
if (cbProductCode.Items.Count <= 1)
{
var emptyRefData = "Produk";
CommonMessageHelper.ReferredDataNotSet(emptyRefData);
return(false);
}
return(true);
}
private bool ValidateMandatoryFields()
{
if (string.IsNullOrEmpty(txtUsername.Text) ||
string.IsNullOrEmpty(txtPassword.Text) ||
string.IsNullOrEmpty(txtFullName.Text))
{
CommonMessageHelper.DataCannotBeEmpty("Username, Password dan Nama Lengkap");
return(false);
}
if (cbRole.Items.Count <= 1)
{
var emptyRefData = "User Role";
CommonMessageHelper.ReferredDataNotSet(emptyRefData);
return(false);
}
return(true);
}
private void btnReload_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(lblSalesNo.Text))
{
btnClear.PerformClick();
return;
}
SalesOrder queryResult;
queryResult = _uow.Repository.GetById(txtSalesOrderId.Text.Trim());
if (queryResult == null)
{
CommonMessageHelper.DataNotFound(lblSalesNo.Text.Trim());
return;
}
LoadDataItem(queryResult);
}