private void SavePrincipalItem()
{
if (txtReference.Text == "")
{
MessageBox.Show("Referensi harus diisi", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtReference.Focus();
}
else if (formMode == FormMode.Add && principalItemRepository.IsItemExisted(txtReference.Text, new Guid(txtPrincipalId.Text)))
{
MessageBox.Show("Referensi : " + txtReference.Text + " sudah ada ", "Perhatian",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (txtMainSalary.Text == "" || txtMainSalary.Text == "0")
{
MessageBox.Show("Gaji Pokok harus lebih dari Nol", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMainSalary.Focus();
}
else if (txtLunch.Text == "" || txtLunch.Text == "0")
{
MessageBox.Show("Uang Makan harus lebih dari Nol", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtLunch.Focus();
}
else if (txtTransport.Text == "" || txtTransport.Text == "0")
{
MessageBox.Show("Uang Transport harus lebih dari Nol", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtTransport.Focus();
}
else
{
var principalItem = new PrincipalItem();
principalItem.EffectiveDate = dtpDate.Value;
principalItem.PrincipalId = new Guid(txtPrincipalId.Text);
principalItem.Reference = txtReference.Text;
principalItem.MainSalary = decimal.Parse(txtMainSalary.Text.Replace(".", ""));
principalItem.LunchAllowance = decimal.Parse(txtLunch.Text.Replace(".", ""));
principalItem.TransportationAllowance = decimal.Parse(txtTransport.Text.Replace(".", ""));
if (formMode == FormMode.Add)
{
principalItemRepository.Save(principalItem);
GetLastPrincipalItem(new Guid(txtPrincipalId.Text));
}
else if (formMode == FormMode.Edit)
{
principalItem.ID = new Guid(txtID.Text);
principalItemRepository.Update(principalItem);
}
LoadPrincipalItem();
DisableForm();
formMode = FormMode.View;
this.Text = "SK Principal " + txtPrincipal.Text;
}
}
private void ViewPrincipalItemDetail(PrincipalItem principalItem)
{
txtID.Text = principalItem.ID.ToString();
dtpDate.Text = principalItem.EffectiveDate.ToShortDateString();
txtReference.Text = principalItem.Reference;
txtMainSalary.Text = principalItem.MainSalary.ToString().Replace(".", ",");
txtLunch.Text = principalItem.LunchAllowance.ToString().Replace(".", ",");
txtTransport.Text = principalItem.TransportationAllowance.ToString().Replace(".", ",");
}
private void RenderPrincipalItem(PrincipalItem principalItem)
{
var item = new ListViewItem(principalItem.ID.ToString());
item.SubItems.Add(principalItem.EffectiveDate.ToString("dd/MM/yyyy"));
item.SubItems.Add(principalItem.Reference);
item.SubItems.Add(principalItem.MainSalary.ToString("N0").Replace(",", "."));
item.SubItems.Add(principalItem.LunchAllowance.ToString("N0").Replace(",", "."));
item.SubItems.Add(principalItem.TransportationAllowance.ToString("N0").Replace(",", "."));
lvwData.Items.Add(item);
}
public PrincipalItem GetById(Guid id)
{
PrincipalItem principalItem = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
var sql = "SELECT pi.*, p.PrincipalCode, p.PrincipalName "
+ "FROM PrincipalItem pi INNER JOIN Principal p ON pi.PrincipalId = p.ID "
+ "WHERE pi.ID ='{" + id + "}'";
principalItem = em.ExecuteObject <PrincipalItem>(sql, new PrincipalItemMapper());
}
return(principalItem);
}
public PrincipalItem GetLast(Guid principalId)
{
PrincipalItem principalItem = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
var sql = "SELECT TOP 1 pi.*, p.PrincipalCode, p.PrincipalName "
+ "FROM PrincipalItem pi INNER JOIN Principal p ON pi.PrincipalId = p.ID "
+ "WHERE pi.PrincipalId = '{" + principalId + "}' "
+ "ORDER BY pi.EffectiveDate DESC";
principalItem = em.ExecuteObject <PrincipalItem>(sql, new PrincipalItemMapper());
}
return(principalItem);
}
public PrincipalItem GetPreviousPrincipal(Guid principalId, int month, int year)
{
PrincipalItem principalItem = new PrincipalItem();
using (var em = EntityManagerFactory.CreateInstance(ds))
{
string sql = "SELECT pi.*,p.PrincipalCode,p.PrincipalName FROM Principal p "
+ "INNER JOIN PrincipalItem pi ON p.ID = pi.PrincipalId "
+ "WHERE pi.PrincipalId='{" + principalId + "}' "
+ "AND month(pi.EffectiveDate) <=" + month + " "
+ "AND year(pi.EffectiveDate) <=" + year;
principalItem = em.ExecuteObject <PrincipalItem>(sql, new PrincipalItemMapper());
}
return(principalItem);
}
public void Save(PrincipalItem principalItem)
{
try
{
using (var em = EntityManagerFactory.CreateInstance(ds))
{
string[] columns = { "ID", "PrincipalId", "EffectiveDate",
"Reference", "MainSalary",
"LunchAllowance", "TransportationAllowance" };
object[] values = { Guid.NewGuid(), principalItem.PrincipalId, principalItem.EffectiveDate.ToShortDateString(),
principalItem.Reference, principalItem.MainSalary,
principalItem.LunchAllowance, principalItem.TransportationAllowance };
var q = new Query().Select(columns).From(tableName).Insert(values);
em.ExecuteNonQuery(q.ToSql());
}
}
catch (Exception ex)
{
throw ex;
}
}
