public void Update(RecordCounter recordCounter)
{
try
{
using (var em = EntityManagerFactory.CreateInstance(ds))
{
string[] columns = { "ActiveYear", "ActiveMonth", "SalesCounter", "PurchaseCounter", "ExpenseCounter",
"PayablePaymentCounter", "DebtPaymentCounter", "BillReceiptCounter", "StockCorrectionCounter",
"ClosingStatus", "ModifiedDate" };
object[] values = { recordCounter.ActiveYear, recordCounter.ActiveMonth,
recordCounter.SalesCounter, recordCounter.PurchaseCounter, recordCounter.ExpenseCounter,
recordCounter.PayablePaymentCounter, recordCounter.DebtPaymentCounter, recordCounter.BillReceiptCounter,
recordCounter.StockCorrectionCounter, recordCounter.ClosingStatus == true?1:0,
DateTime.Now.ToShortDateString() };
var q = new Query().Select(columns).From(tableName).Update(values).Where("ID").Equal("{" + recordCounter.ID + "}");
em.ExecuteNonQuery(q.ToSql());
}
}
catch (Exception ex)
{
throw ex;
}
}
private void RenderRecordCounter(RecordCounter recordCounter)
{
var item = new ListViewItem(recordCounter.ID.ToString());
item.SubItems.Add(recordCounter.ActiveYear.ToString());
item.SubItems.Add(GetMonthName(recordCounter.ActiveMonth));
item.SubItems.Add(recordCounter.SalesCounter.ToString());
item.SubItems.Add(recordCounter.PurchaseCounter.ToString());
item.SubItems.Add(recordCounter.ExpenseCounter.ToString());
item.SubItems.Add(recordCounter.PayablePaymentCounter.ToString());
item.SubItems.Add(recordCounter.DebtPaymentCounter.ToString());
item.SubItems.Add(recordCounter.BillReceiptCounter.ToString());
item.SubItems.Add(recordCounter.StockCorrectionCounter.ToString());
if (recordCounter.ClosingStatus == true)
{
item.SubItems.Add("YA");
}
else
{
item.SubItems.Add("TIDAK");
}
lvwRecordCounter.Items.Add(item);
}
private void GetLastRecordCounter()
{
RecordCounter recordCounter = recordCounterRepository.GetLast();
if (recordCounter != null)
{
ViewRecordCounterDetail(recordCounter);
}
}
public void CountRecordInIntervalTest()
{
var start = new DateTime(2007, 1, 1);
var end = new DateTime(2007, 12, 7);
var amount = RecordCounter.CountRecordInInterval(
@"..\..\..\..\Task6TypeConversion\ClientConnectionLog.log", start, end);
Assert.AreEqual(amount, 8);
}
public RecordCounter GetByYear(int year)
{
RecordCounter recordCounter = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
var q = new Query().From(tableName).Where("ActiveYear").Equal(year);
recordCounter = em.ExecuteObject <RecordCounter>(q.ToSql(), new RecordCounterMapper());
}
return(recordCounter);
}
public RecordCounter GetById(Guid id)
{
RecordCounter recordCounter = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
var q = new Query().From(tableName).Where("ID").Equal("{" + id + "}");
recordCounter = em.ExecuteObject <RecordCounter>(q.ToSql(), new RecordCounterMapper());
}
return(recordCounter);
}
public RecordCounter GetLast()
{
RecordCounter recordCounter = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
var q = new Query().Select("TOP 1 *").From(tableName).OrderBy("ActiveYear DESC, ActiveMonth ASC ");
recordCounter = em.ExecuteObject <RecordCounter>(q.ToSql(), new RecordCounterMapper());
}
return(recordCounter);
}
private void ViewRecordCounterDetail(RecordCounter recordCounter)
{
txtID.Text = recordCounter.ID.ToString();
txtYear.Text = recordCounter.ActiveYear.ToString();
cboMonth.Text = GetMonthName(recordCounter.ActiveMonth);
txtSalesCounter.Text = recordCounter.SalesCounter.ToString();
txtPurchaseCounter.Text = recordCounter.PurchaseCounter.ToString();
txtExpenseCounter.Text = recordCounter.ExpenseCounter.ToString();
txtPayablePaymentCounter.Text = recordCounter.PayablePaymentCounter.ToString();
txtDebtPaymentCounter.Text = recordCounter.DebtPaymentCounter.ToString();
txtBillReceiptCounter.Text = recordCounter.BillReceiptCounter.ToString();
txtStockCorrectionCounter.Text = recordCounter.StockCorrectionCounter.ToString();
chkClosingStatus.Checked = recordCounter.ClosingStatus;
}
private void lvwRecordCounter_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvwRecordCounter.Items.Count > 0)
{
if (formMode == FormMode.Add || formMode == FormMode.Edit)
{
}
else
{
RecordCounter recordCounter = recordCounterRepository.GetById(new Guid(lvwRecordCounter.FocusedItem.Text));
ViewRecordCounterDetail(recordCounter);
}
}
}
public void TestRepeatingBug()
{
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = (HSSFSheet)workbook.CreateSheet("Design Variants");
IRow row = sheet.CreateRow(2);
ICell cell = row.CreateCell(1);
cell.SetCellValue(new HSSFRichTextString("Class"));
cell = row.CreateCell(2);
RecordCounter rc = new RecordCounter();
sheet.Sheet.VisitContainedRecords(rc, 0);
Assert.AreEqual(1, rc.GetCount());
}
private void UpdateRecordCounterStatus()
{
//ubah status periode jadi closed
recordCounterRepository.UpdateClosingStatus(Store.ActiveMonth, Store.ActiveYear);
Store.IsPeriodClosed = recordCounterRepository.IsPeriodClosed(Store.ActiveMonth, Store.ActiveYear);
int newYear = 0;
int newMonth = 0;
if (Store.ActiveMonth < 12)
{
newYear = Store.ActiveYear;
newMonth = Store.ActiveMonth + 1;
}
else
{
newYear = Store.ActiveYear + 1;
newMonth = 1;
}
var oldRecordCounter = recordCounterRepository.GetByMonthAndYear(newMonth, newYear);
if (oldRecordCounter == null)
{
//buat periode baru
RecordCounter recordCounter = new RecordCounter();
recordCounter.ActiveYear = newYear;
recordCounter.ActiveMonth = newMonth;
recordCounter.SalesCounter = 0;
recordCounter.PurchaseCounter = 0;
recordCounter.ExpenseCounter = 0;
recordCounter.PayablePaymentCounter = 0;
recordCounter.DebtPaymentCounter = 0;
recordCounter.BillReceiptCounter = 0;
recordCounter.StockCorrectionCounter = 0;
recordCounter.ClosingStatus = false;
recordCounterRepository.Save(recordCounter);
}
}
public void TestRepeatingBug()
{
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = (HSSFSheet)workbook.CreateSheet("Design Variants");
IRow row = sheet.CreateRow(2);
ICell cell = row.CreateCell(1);
cell.SetCellValue(new HSSFRichTextString("Class"));
cell = row.CreateCell(2);
RecordCounter rc = new RecordCounter();
sheet.Sheet.VisitContainedRecords(rc, 0);
Assert.AreEqual(1, rc.GetCount());
}
private void GetRecordCounterById(Guid id)
{
RecordCounter recordCounter = recordCounterRepository.GetById(id);
ViewRecordCounterDetail(recordCounter);
}
private void SaveRecordCounter()
{
if (cboMonth.SelectedIndex == -1)
{
MessageBox.Show("Bulan harus diisi", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
cboMonth.Focus();
}
else if (txtYear.Text.Equals("") || txtYear.TextLength < 4)
{
MessageBox.Show("Tahun harus diisi", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtYear.Focus();
}
else if (formMode == FormMode.Add && recordCounterRepository.IsRecordCounterExisted(int.Parse(GetMonthCode(cboMonth.Text).ToString()), int.Parse(txtYear.Text)))
{
MessageBox.Show("Periode : " + cboMonth.Text + " - " + txtYear.Text + "\n\n" + "sudah ada ", "Perhatian",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
RecordCounter recordCounter = new RecordCounter();
recordCounter.ActiveMonth = GetMonthCode(cboMonth.Text);
recordCounter.ActiveYear = int.Parse(txtYear.Text);
recordCounter.SalesCounter = int.Parse(txtSalesCounter.Text == "" ? "0" : txtSalesCounter.Text);
recordCounter.PurchaseCounter = int.Parse(txtPurchaseCounter.Text == "" ? "0" :txtPurchaseCounter.Text);
recordCounter.ExpenseCounter = int.Parse(txtExpenseCounter.Text == "" ? "0" : txtExpenseCounter.Text);
recordCounter.DebtPaymentCounter = int.Parse(txtDebtPaymentCounter.Text == "" ? "0" : txtDebtPaymentCounter.Text);
recordCounter.PayablePaymentCounter = int.Parse(txtPayablePaymentCounter.Text == "" ? "0" : txtPayablePaymentCounter.Text);
recordCounter.BillReceiptCounter = int.Parse(txtBillReceiptCounter.Text == "" ? "0" : txtBillReceiptCounter.Text);
recordCounter.StockCorrectionCounter = int.Parse(txtStockCorrectionCounter.Text == "" ? "0" : txtStockCorrectionCounter.Text);
recordCounter.ClosingStatus = chkClosingStatus.Checked;
if (formMode == FormMode.Add)
{
recordCounterRepository.Save(recordCounter);
GetLastRecordCounter();
}
else if (formMode == FormMode.Edit)
{
recordCounter.ID = new Guid(txtID.Text);
recordCounterRepository.Update(recordCounter);
}
if (recordCounter.ClosingStatus == true && recordCounter.ActiveMonth == Store.ActiveMonth && recordCounter.ActiveYear == Store.ActiveYear)
{
Store.IsPeriodClosed = true;
}
else
{
Store.IsPeriodClosed = false;
}
LoadRecordCounter();
DisableForm();
formMode = FormMode.View;
this.Text = "Dokumen";
}
}
