private void cmdyes_Click(object sender, EventArgs e)
{
if (txtci.Text == this.pinCI && txtkunj.Text == this.pinKunjungan)
{
if (dtLaporanCustomerInti.Rows.Count > 0 || dtStokTidakBergerak.Rows.Count > 0)
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_pin_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@keyNumber", SqlDbType.VarChar, "PINCI"));
db.Commands[0].Parameters.Add(new Parameter("@PinNummber", SqlDbType.VarChar, this.pinCI));
db.Commands[0].Parameters.Add(new Parameter("@id", SqlDbType.Int, "3"));
db.Commands[0].Parameters.Add(new Parameter("@ket", SqlDbType.Text, "CI DAN STOK"));
dt = db.Commands[0].ExecuteDataTable();
}
}
if (dtKurang10.Rows.Count > 0)
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_pin_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@keyNumber", SqlDbType.VarChar, "PINTRANS"));
db.Commands[0].Parameters.Add(new Parameter("@PinNummber", SqlDbType.VarChar, this.pinKunjungan));
db.Commands[0].Parameters.Add(new Parameter("@id", SqlDbType.Int, "4"));
db.Commands[0].Parameters.Add(new Parameter("@ket", SqlDbType.Text, "KUNJUNGAN"));
dt = db.Commands[0].ExecuteDataTable();
}
}
PSReport.frmLaporanPenjualanPerItem frmCaller = (PSReport.frmLaporanPenjualanPerItem) this.Caller;
frmCaller.GenerateLaporan();
frmCaller.UploadLaporan();
this.Close();
}
else
{
MessageBox.Show("PIN yang ada masukkan salah");
return;
}
}
private void cmdYes_Click(object sender, EventArgs e)
{
if (txtPin.Text.ToString().Length != 7)
{
MessageBox.Show("Pin Yang anda masukan salah, silhakan Ulangi");
txtPin.Text = "";
return;
}
string baseCode = string.Empty;
int multiplier = 1;
if (this._bagian == PinId.Bagian.Rekon)
{
baseCode = key.BaseCode.Rekon;
multiplier = 16;
}
if (this._bagian == PinId.Bagian.PO)
{
baseCode = key.BaseCode.PO;
multiplier = 17;
}
if (this._bagian == PinId.Bagian.RekonsPJT)
{
baseCode = key.BaseCode.RekonsPJT;
multiplier = 18;
}
if (this._bagian == PinId.Bagian.OASPV)
{
baseCode = key.BaseCode.OASPV;
multiplier = 25;
}
if (this._bagian == PinId.Bagian.OAYYK)
{
baseCode = key.BaseCode.OASupport;
multiplier = 26;
}
if (this._bagian == PinId.Bagian.Kasbon)
{
baseCode = key.BaseCode.Kasbon;
multiplier = 27;
}
string dailyPin = ISA.Pin.key.CreateDailyPin(this._tanggal, GlobalVar.Gudang, baseCode, multiplier);
if (txtPin.Text == dailyPin)
{
//GlobalVar.pinResult = true;
if (this.Caller is Rekon.frmrekonclosing)
{
DataTable dtCekRekon = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_Rekon_Cek_Now"));
db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, _tanggal));
dtCekRekon = db.Commands[0].ExecuteDataTable();
}
if (this._bagian == PinId.Bagian.RekonsPJT)
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID));
db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
db.Commands[0].ExecuteNonQuery();
MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai");
}
#region rekon pjk ditutup
////kebijakan baru (dwy) rekon hanya untuk penjualan tunai
//DataTable dtOVD120 = new DataTable();
//DataTable dtpjvspiut = new DataTable();
//DataTable dtRekonNow = new DataTable();
//using (Database db = new Database())
//{
// db.Commands.Add(db.CreateCommand("usp_Rekon_List_Now"));
// db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, DateTime.Today));
// dtRekonNow = db.Commands[0].ExecuteDataTable();
//}
//using (Database db = new Database())
//{
// db.Commands.Add(db.CreateCommand("psp_rekons_overdue120"));
// db.Commands[0].Parameters.Add(new Parameter("@tglclosing", SqlDbType.Date, DateTime.Now));
// dtOVD120 = db.Commands[0].ExecuteDataTable();
//}
//DateTime tglawalrekon = Convert.ToDateTime(dtRekonNow.Rows[0]["periode1"].ToString());
//DateTime tglakhirrekon = Convert.ToDateTime(dtRekonNow.Rows[0]["periode2"].ToString());
//using (Database db = new Database())
//{
// db.Commands.Add(db.CreateCommand("psp_Rekon_Chek_PJKVSPIUT_Prepare"));
// db.Commands[0].Parameters.Add(new Parameter("@tglclsawal", SqlDbType.Date, tglawalrekon));
// db.Commands[0].Parameters.Add(new Parameter("@tglclsakhir", SqlDbType.Date, tglakhirrekon));
// dtpjvspiut = db.Commands[0].ExecuteDataTable();
//}
//int hari = (int)DateTime.Now.DayOfWeek;
//if (hari == 1)
//{
// if (dtpjvspiut.Rows.Count > 0 || dtOVD120.Rows.Count > 0)
// {
// Pin.frmPinDaily ifrmChild1 = new Pin.frmPinDaily(this, (Guid)dtCekRekon.Rows[0]["RowID"], PinId.Bagian.Rekon, DateTime.Today, "Pin rekon PJK");
// ifrmChild1.MdiParent = Program.MainForm;
// Program.MainForm.RegisterChild(ifrmChild1);
// ifrmChild1.Show();
// }
// else
// {
// using (Database db = new Database())
// {
// DataTable dt = new DataTable();
// db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update"));
// db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID));
// db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text));
// db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
// dt = db.Commands[0].ExecuteDataTable();
// db.Commands[0].ExecuteNonQuery();
// MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai");
// }
// }
//}
//else
//{
// if (dtpjvspiut.Rows.Count > 0)
// {
// Pin.frmPinDaily ifrmChild1 = new Pin.frmPinDaily(this, (Guid)dtCekRekon.Rows[0]["RowID"], PinId.Bagian.Rekon, DateTime.Today, "Pin rekon PJK");
// ifrmChild1.MdiParent = Program.MainForm;
// Program.MainForm.RegisterChild(ifrmChild1);
// ifrmChild1.Show();
// }
// else
// {
// using (Database db = new Database())
// {
// DataTable dt = new DataTable();
// db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update"));
// db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID));
// db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text));
// db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
// dt = db.Commands[0].ExecuteDataTable();
// db.Commands[0].ExecuteNonQuery();
// MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai");
// }
// }
//}
#endregion
}
}
if (this._bagian == PinId.Bagian.Rekon)
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID));
db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
db.Commands[0].ExecuteNonQuery();
MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai");
}
}
//using (Database db = new Database())
//{
// DataTable dt = new DataTable();
// db.Commands.Add(db.CreateCommand("usp_Rekon_Clstrans_update"));
// db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this._rowID));
// db.Commands[0].Parameters.Add(new Parameter("@pin", SqlDbType.VarChar, txtPin.Text));
// db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
// dt = db.Commands[0].ExecuteDataTable();
// db.Commands[0].ExecuteNonQuery();
// MessageBox.Show("Pin Benar, Proses Rekons Sudah Selesai");
//}
//if (this.Caller is frmMain)
//{
// PSReport.frmLaporanPenjualanPerItem ifrmChild1 = new PSReport.frmLaporanPenjualanPerItem();
// ifrmChild1.MdiParent = Program.MainForm;
// Program.MainForm.RegisterChild(ifrmChild1);
// ifrmChild1.Show();
//}
if (this._bagian == PinId.Bagian.PO)
{
PSReport.frmLaporanPenjualanPerItem ifrmChild1 = new PSReport.frmLaporanPenjualanPerItem();
ifrmChild1.MdiParent = Program.MainForm;
Program.MainForm.RegisterChild(ifrmChild1);
ifrmChild1.Show();
}
if (this._bagian == PinId.Bagian.OASPV)
{
MessageBox.Show("Pin Benar, Proses Sudah Selesai");
if (this.Caller is PSReport.frmLaporanAnalisaOA)
{
PSReport.frmLaporanAnalisaOA frmCaller = (PSReport.frmLaporanAnalisaOA) this.Caller;
frmCaller.Getdata();
this.Close();
}
}
if (this._bagian == PinId.Bagian.OAYYK)
{
MessageBox.Show("Pin Benar, Proses Sudah Selesai");
if (this.Caller is PSReport.frmLaporanAnalisaOA)
{
PSReport.frmLaporanAnalisaOA frmCaller = (PSReport.frmLaporanAnalisaOA) this.Caller;
frmCaller.Getdata();
this.Close();
}
}
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_pin_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@keyNumber", SqlDbType.VarChar, string.Empty));
db.Commands[0].Parameters.Add(new Parameter("@PinNummber", SqlDbType.VarChar, txtPin.Text));
db.Commands[0].Parameters.Add(new Parameter("@id", SqlDbType.Int, _bagian));
db.Commands[0].Parameters.Add(new Parameter("@ket", SqlDbType.Text, txtKet.Text));
dt = db.Commands[0].ExecuteDataTable();
}
this.Close();
}
else
{
MessageBox.Show("Pin yang anda masukan salah, cek kembali");
}
}
