private void ViewSalesmanFeeDetail(SalesmanFee salesmanFee)
{
txtID.Text = salesmanFee.ID.ToString();
nudYear.Value = salesmanFee.ActiveYear;
cboMonth.Text = Store.GetMonthName(salesmanFee.ActiveMonth);
txtFeePercentage.Text = salesmanFee.FeePercentage.ToString();
cboSalesman.Text = salesmanFee.Salesman.Name;
}
private void GetLastSalesmanFee()
{
SalesmanFee salesmanFee = salesmanFeeRepository.GetLast(new Guid(frmSalesman.SalesmanID));
if (salesmanFee != null)
{
ViewSalesmanFeeDetail(salesmanFee);
}
}
private void SalesmanFeeNewPeriod()
{
//cek periode baru
int newYear = 0;
int newMonth = 0;
if (Store.ActiveMonth < 12)
{
newYear = Store.ActiveYear;
newMonth = Store.ActiveMonth + 1;
}
else
{
newYear = Store.ActiveYear + 1;
newMonth = 1;
}
SalesmanFee salesmanFee = new SalesmanFee();
var newSalesman = salesmanFeeRepository.GetAll(newMonth, newYear);
if (newSalesman.Count == 0)
{
var salesmanFees = salesmanFeeRepository.GetByActivePeriod(Store.ActiveMonth, Store.ActiveYear);
foreach (var s in salesmanFees)
{
salesmanFee.ActiveYear = newYear;
salesmanFee.ActiveMonth = newMonth;
salesmanFee.FeePercentage = s.FeePercentage;
salesmanFee.SalesmanId = s.SalesmanId;
salesmanFeeRepository.Save(salesmanFee);
}
}
else
{
foreach (var newS in newSalesman)
{
//cari data lama
var oldSalesmanFee = salesmanFeeRepository.GetByActivePeriod(Store.ActiveMonth, Store.ActiveYear);
foreach (var p1 in oldSalesmanFee)
{
salesmanFee.ID = newS.ID;
salesmanFee.ActiveYear = newYear;
salesmanFee.ActiveMonth = newMonth;
salesmanFee.FeePercentage = p1.FeePercentage;
salesmanFee.SalesmanId = newS.SalesmanId;
salesmanFeeRepository.Update(salesmanFee);
}
}
}
}
private void RenderSalesmanFee(SalesmanFee salesmanFee)
{
var item = new ListViewItem(salesmanFee.ID.ToString());
item.SubItems.Add(salesmanFee.ActiveYear.ToString());
item.SubItems.Add(Store.GetMonthName(salesmanFee.ActiveMonth));
item.SubItems.Add(salesmanFee.Salesman.Name);
item.SubItems.Add(salesmanFee.FeePercentage.ToString());
lvwSalesmanFee.Items.Add(item);
}
private void lvwSalesmanFee_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvwSalesmanFee.Items.Count > 0)
{
if (formMode == FormMode.Add || formMode == FormMode.Edit)
{
}
else
{
SalesmanFee salesmanFee = salesmanFeeRepository.GetById(new Guid(lvwSalesmanFee.FocusedItem.Text));
ViewSalesmanFeeDetail(salesmanFee);
}
}
}
public SalesmanFee GetByMonthAndYear(int month, int year, Guid id)
{
SalesmanFee salesmanFee = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
var q = new Query().From(tableName).Where("ActiveMonth").Equal(month)
.And("ActiveYear").Equal(year).And("SalesmanId").Equal(id)
.OrderBy("ActiveYear DESC, ActiveMonth ASC ");
salesmanFee = em.ExecuteObject <SalesmanFee>(q.ToSql(), new SalesmanFeeMapper());
}
return(salesmanFee);
}
public SalesmanFee GetLast(Guid salesmanId)
{
SalesmanFee salesmanFee = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
var sql = "SELECT TOP 1 sf.ID, sf.ActiveMonth, sf.ActiveYear, sf.FeePercentage, "
+ "sf.SalesmanId, s.SalesmanName, "
+ "sf.CreatedDate, sf.ModifiedDate "
+ "FROM SalesmanFee sf INNER JOIN Salesman s ON sf.SalesmanId = s.ID "
+ "WHERE " + "sf.SalesmanId ={" + salesmanId + "}";
salesmanFee = em.ExecuteObject <SalesmanFee>(sql, new SalesmanFeeMapper());
}
return(salesmanFee);
}
private void SaveSalesmanFee()
{
if (cboMonth.SelectedIndex == -1)
{
MessageBox.Show("Bulan harus diisi", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
cboMonth.Focus();
}
else if (formMode == FormMode.Add && salesmanFeeRepository.IsSalesmanFeeExisted(Store.GetMonthCode(cboMonth.Text), Convert.ToInt32((nudYear.Value))
, new Guid(txtSalesmanId.Text)))
{
MessageBox.Show("Salesman : " + cboSalesman.Text + "\n" + "Periode : " + cboMonth.Text + " - " + nudYear.Value + "\n\n" + "sudah ada ", "Perhatian",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
SalesmanFee salesmanFee = new SalesmanFee();
salesmanFee.ActiveMonth = Store.GetMonthCode(cboMonth.Text);
salesmanFee.ActiveYear = Convert.ToInt32(nudYear.Value);
salesmanFee.FeePercentage = int.Parse(txtFeePercentage.Text == "" ? "0" : txtFeePercentage.Text);
salesmanFee.SalesmanId = new Guid(txtSalesmanId.Text);
if (formMode == FormMode.Add)
{
salesmanFeeRepository.Save(salesmanFee);
GetLastSalesmanFee();
}
else if (formMode == FormMode.Edit)
{
salesmanFee.ID = new Guid(txtID.Text);
salesmanFeeRepository.Update(salesmanFee);
}
LoadSalesmanFee();
DisableForm();
formMode = FormMode.View;
}
}
public void Update(SalesmanFee salesmanFee)
{
try
{
using (var em = EntityManagerFactory.CreateInstance(ds))
{
string[] columns = { "ActiveYear", "ActiveMonth", "FeePercentage", "SalesmanId", "ModifiedDate" };
object[] values = { salesmanFee.ActiveYear, salesmanFee.ActiveMonth, salesmanFee.FeePercentage,
salesmanFee.SalesmanId, DateTime.Now.ToShortDateString() };
var q = new Query().Select(columns).From(tableName).Update(values).Where("ID").Equal("{" + salesmanFee.ID + "}");
em.ExecuteNonQuery(q.ToSql());
}
}
catch (Exception ex)
{
throw ex;
}
}
private void GetSalesmanFeeById(Guid id)
{
SalesmanFee salesmanFee = salesmanFeeRepository.GetById(id);
ViewSalesmanFeeDetail(salesmanFee);
}
