private void SumSubTotal()
{
decimal sq = 0;
decimal sp = 0;
decimal sj = 0;
decimal sd = 0;
decimal st = 0;
for (int i = 0; i < grid_Trans.Rows.Count; i++)
{
sq += Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value);
sp += Convert.ToDecimal(grid_Trans.Rows[i].Cells[3].Value);
sj += Convert.ToDecimal(grid_Trans.Rows[i].Cells[4].Value);
sd += Convert.ToDecimal(grid_Trans.Rows[i].Cells[5].Value);
st += Convert.ToDecimal(grid_Trans.Rows[i].Cells[6].Value);
}
txt_SubQuantity.Text = ModuleControlSettings.NumericFormat(sq);
txt_SubPrice.Text = ModuleControlSettings.NumericFormat(sp);
txt_SubJumlah.Text = ModuleControlSettings.NumericFormat(sj);
txt_SubDisc.Text = ModuleControlSettings.NumericFormat(sd);
txt_SubTotal.Text = ModuleControlSettings.NumericFormat(st);
SumGrandTotal(null, null);
ResetTransactionDetail();
}
private void button1_Click(object sender, EventArgs e)
{
if (!ValidateFormDetail())
{
return;
}
string[] field = new string[7];
field[0] = txt_ItemId.Text;
field[1] = txt_ItemName.Text;
field[2] = ModuleControlSettings.NumericFormat(num_Quantity.Value);
field[3] = ModuleControlSettings.NumericFormat(num_Price.Value);
field[4] = ModuleControlSettings.NumericFormat(num_Jumlah.Value);
field[5] = ModuleControlSettings.NumericFormat(num_Disc.Value);
field[6] = ModuleControlSettings.NumericFormat(num_Total.Value);
grid_Trans.Rows.Insert(0, field);
}
private void CollectReminderData()
{
listView_Reminder.Items.Clear();
MGudang gud;
ItemGudangStok stok;
MItem item;
ListViewItem viewItem;
IList listStok = DataMaster.GetAll(typeof(ItemGudangStok));
string gudangName = "";
for (int i = 0; i < listStok.Count; i++)
{
stok = (ItemGudangStok)listStok[i];
gud = (MGudang)DataMaster.GetObjectByProperty(typeof(MGudang), MGudang.ColumnNames.GudangId, stok.GudangId);
if (gud != null)
{
gudangName = gud.GudangName;
}
//kurang dari batas minimum
if (stok.ItemStok < stok.ItemMinStok)
{
viewItem = new ListViewItem();
item = (MItem)DataMaster.GetObjectByProperty(typeof(MItem), MItem.ColumnNames.ItemId, stok.ItemId);
if (item != null)
{
viewItem.Text = item.ItemName + " (" + gudangName + ")";
}
else
{
viewItem.Text = stok.ItemId + " (" + gudangName + ")";
}
viewItem.SubItems.Add(ModuleControlSettings.NumericFormat(stok.ItemStok));
viewItem.Group = listView_Reminder.Groups[0];
listView_Reminder.Items.Add(viewItem);
}
}
IList listSupp = DataMaster.GetAll(typeof(MSupplier));
IList listPiHutang;
MSupplier supp;
TPiHutang pihut;
decimal totPiHut;
//get hutang
for (int i = 0; i < listSupp.Count; i++)
{
supp = (MSupplier)listSupp[i];
listPiHutang = DataMaster.GetListEqNotEqLessThan(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangPic, supp.SupplierId, TPiHutang.ColumnNames.PiHutangStatus, ListOfPiHutangStatus.Hutang.ToString(), TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero, TPiHutang.ColumnNames.PiHutangJatuhTempo, DateTime.Now);
totPiHut = 0;
for (int j = 0; j < listPiHutang.Count; j++)
{
pihut = (TPiHutang)listPiHutang[j];
totPiHut += pihut.PiHutangSisa;
}
if (totPiHut != 0)
{
viewItem = new ListViewItem();
viewItem.Text = supp.SupplierName;
viewItem.SubItems.Add(ModuleControlSettings.NumericFormat(totPiHut));
viewItem.Group = listView_Reminder.Groups[1];
listView_Reminder.Items.Add(viewItem);
}
}
IList listCust = DataMaster.GetAll(typeof(MCustomer));
MCustomer cust;
//get piutang
for (int i = 0; i < listCust.Count; i++)
{
cust = (MCustomer)listCust[i];
listPiHutang = DataMaster.GetListEqNotEqLessThan(typeof(TPiHutang), TPiHutang.ColumnNames.PiHutangPic, cust.CustomerId, TPiHutang.ColumnNames.PiHutangStatus, ListOfPiHutangStatus.Piutang.ToString(), TPiHutang.ColumnNames.PiHutangSisa, decimal.Zero, TPiHutang.ColumnNames.PiHutangJatuhTempo, DateTime.Now);
totPiHut = 0;
for (int j = 0; j < listPiHutang.Count; j++)
{
pihut = (TPiHutang)listPiHutang[j];
totPiHut += pihut.PiHutangSisa;
}
if (totPiHut != 0)
{
viewItem = new ListViewItem();
viewItem.Text = cust.CustomerName;
viewItem.SubItems.Add(ModuleControlSettings.NumericFormat(totPiHut));
viewItem.Group = listView_Reminder.Groups[2];
listView_Reminder.Items.Add(viewItem);
}
}
}
private bool ValidateClosing()
{
period = numericUpDown_Year.Value.ToString() + comboBox_Month.SelectedValue.ToString();
TRekapSubAccount rekap = (TRekapSubAccount)DataMaster.GetObjectByProperty(typeof(TRekapSubAccount), TRekapSubAccount.ColumnNames.RekapSubAccountPeriode, period);
if (rekap != null)
{
if (MessageBox.Show("Proses akhir bulan " + comboBox_Month.Text + " " + numericUpDown_Year.Value.ToString() + " sudah dilakukan. Anda yakin melanjutkan ?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return(false);
}
}
string today = DateTime.Today.Month.ToString();
if (DateTime.Today.Month < 10)
{
today = decimal.Zero.ToString() + DateTime.Today.Month.ToString();
}
today = DateTime.Today.Year.ToString() + today;
if (Convert.ToDecimal(today) <= Convert.ToDecimal(period))
{
if (MessageBox.Show("Proses akhir bulan hanya bisa dilakukan untuk periode bulan sebelumnya. Anda yakin melanjutkan ?", AppCode.AssemblyProduct, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return(false);
}
}
IList listAcc = DataMaster.GetAll(typeof(MAccount));
MAccount acc;
decimal totDebet = 0;
decimal totKredit = 0;
for (int i = 0; i < listAcc.Count; i++)
{
acc = (MAccount)listAcc[i];
if (acc.AccountStatus == ListOfJournalStatus.Debet.ToString())
{
totDebet += acc.AccountSaldo;
}
else if (acc.AccountStatus == ListOfJournalStatus.Kredit.ToString())
{
totKredit += acc.AccountSaldo;
}
}
if (totKredit != totDebet)
{
decimal selisih = totDebet - totKredit;
if (selisih < 0)
{
selisih = selisih * -1;
}
MessageBox.Show("Proses akhir bulan belum dapat dilakukan, terjadi selisih sebesar " + ModuleControlSettings.NumericFormat(selisih, true), AppCode.AssemblyProduct, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
return(true);
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Single xPos = e.MarginBounds.Left;
Single yPos = e.MarginBounds.Top;
Font printFont = new Font("MS Sans Serif", 10);
Single lineHeight = printFont.GetHeight(e.Graphics) + 5;
//Single widthPaper = 480 - e.MarginBounds.Left;
Single widthPaper = e.PageSettings.PaperSize.Width - e.MarginBounds.Left;
string txt = "";
txt = set.CompanyName;
xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2));
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
txt = set.CompanyAddress + " " + set.CompanyCity;
yPos += lineHeight;
xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2));
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
txt = "Telp : " + set.CompanyTelp;
yPos += lineHeight;
xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2));
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//xPos = e.MarginBounds.Left;
//yPos += lineHeight * 2;
//txt = "No : " + txt_Factur.Text;
//e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
xPos = e.MarginBounds.Left;
yPos += lineHeight;
txt = dt_TransactionDate.Value.ToString("dd MMMM yyyy HH:mm");
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
yPos += lineHeight;
for (int i = 0; i < grid_Trans.Rows.Count; i++)
{
//display item code
//xPos = e.MarginBounds.Left;
//yPos += lineHeight;
//txt = grid_Trans.Rows[i].Cells[0].Value.ToString();
//e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//display nama item
//xPos += 100;
xPos = e.MarginBounds.Left;
yPos += lineHeight;
txt = grid_Trans.Rows[i].Cells[1].Value.ToString();
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//if (Convert.ToDecimal(grid_Trans.Rows[i].Cells[2].Value) != 1)
//{
//display kuantitas
xPos = e.MarginBounds.Left;
yPos += lineHeight;
txt = ModuleControlSettings.NumericFormat(grid_Trans.Rows[i].Cells[2].Value) + " x @" + ModuleControlSettings.NumericFormat(grid_Trans.Rows[i].Cells[3].Value);
//display discount
if (ModuleControlSettings.isDecimal(grid_Trans.Rows[i].Cells[5].Value.ToString()))
{
if (Convert.ToDecimal(grid_Trans.Rows[i].Cells[5].Value.ToString()) > 0)
{
txt += " - " + ModuleControlSettings.NumericFormat(grid_Trans.Rows[i].Cells[5].Value) + "%";
}
}
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
////display total
//xPos += 130;
txt = ModuleControlSettings.NumericFormat(grid_Trans.Rows[i].Cells[6].Value, true);
xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f;
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
}
if (num_TaxValue.Value > 0)
{
//display subtotal
xPos = e.MarginBounds.Left + 50;
yPos += lineHeight;
txt = "Sub Total : ";
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
txt = ModuleControlSettings.NumericFormat(decimal.Parse(txt_SubTotal.Text), true);
xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f;
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//display tax
xPos = e.MarginBounds.Left + 50;
yPos += lineHeight;
txt = "Tax : ";
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
txt = ModuleControlSettings.NumericFormat(num_TaxValue.Value, true);
xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f;
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
}
//display grantotal
xPos = e.MarginBounds.Left + 50;
yPos += lineHeight;
txt = "Total : ";
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
txt = ModuleControlSettings.NumericFormat(num_GrandTotal.Value, true);
//xPos = e.MarginBounds.Right -e.Graphics.MeasureString(txt, printFont).Width;
xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f;
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
////display dibayar
//xPos = e.MarginBounds.Left + 50;
//yPos += lineHeight;
//txt = "Tunai : ";
//e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//txt = ModuleControlSettings.NumericFormat(num_Pay.Value, true);
////xPos = e.MarginBounds.Right -e.Graphics.MeasureString(txt, printFont).Width;
//xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f;
//e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
////display kembali
//xPos = e.MarginBounds.Left + 50;
//yPos += lineHeight;
//txt = "Kembali : ";
//e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//txt = ModuleControlSettings.NumericFormat(num_Back.Value, true);
////xPos = e.MarginBounds.Right -e.Graphics.MeasureString(txt, printFont).Width;
//xPos = widthPaper - (e.Graphics.MeasureString(txt, printFont).Width) - 50f;
//e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
////keterangan
//txt = "Barang yang sudah dibeli";
//yPos += lineHeight * 2;
//xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2));
//e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//txt = "Tidak dapat ditukar / dikembalikan";
//yPos += lineHeight;
//xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2));
//e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//thanks
txt = "Terima Kasih atas kunjungan anda";
yPos += lineHeight * 2;
xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2));
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//saran
txt = "Saran dan kritik, hubungi : ";
yPos += lineHeight;
xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2));
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
//saran
Inventori.Cafe.Data.TCafeSetting cafeSet = (Inventori.Cafe.Data.TCafeSetting)DataMaster.GetObjectByProperty(typeof(Inventori.Cafe.Data.TCafeSetting), Inventori.Cafe.Data.TCafeSetting.ColumnNames.SettingId, AppCode.AssemblyProduct);
if (cafeSet != null)
{
txt = cafeSet.TelpNoSaranKritik;
yPos += lineHeight;
xPos = e.MarginBounds.Left + ((widthPaper / 2) - (e.Graphics.MeasureString(txt, printFont).Width / 2));
e.Graphics.DrawString(txt, printFont, Brushes.Black, xPos, yPos);
}
}
