public DataTable SELECTPEMB(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
/*
* if (obj.STATUS == "SEMUA")
* {
* db.Commands.Add(db.CreateCommand(QUERY_SELECTPMBALL)); }
* else
* {
* db.Commands.Add(db.CreateCommand(QUERY_SELECTPMB));
* }
* db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE));
* db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE));
* db.Commands[0].Parameters.Add(new Parameter("@TPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT));
* db.Commands[0].Parameters.Add(new Parameter("@STATUS", MySqlDbType.VarChar, obj.STATUS));
* dt = db.Commands[0].ExecuteDataTable();
*/
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECT(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
if (obj.STATUSORDER != "SEMUA")
{
db.Commands.Add(db.CreateCommand(QUERY_SELECT));
}
else
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTALL));
}
db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE));
db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE));
db.Commands[0].Parameters.Add(new Parameter("@STATUSORDER", MySqlDbType.VarChar, obj.STATUSORDER));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECTGENERATEINVOICE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
/*
* using (Database db = new Database())
* {
*
* db.Commands.Add(db.CreateCommand(QUERY_SELECTGENEREATEINVOICE));
* db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE));
* db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE));
* db.Commands[0].Parameters.Add(new Parameter("@TPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT));
* db.Commands[0].Parameters.Add(new Parameter("@CUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER));
*
* dt = db.Commands[0].ExecuteDataTable();
* }
* */
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYNAME));
/*
* db.Commands[0].Parameters.Add(new Parameter("@NAMACUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER));
* db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE));
* db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE));
* db.Commands[0].Parameters.Add(new Parameter("@TYPEOFPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT));
* dt = db.Commands[0].ExecuteDataTable();
*/
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void INSERT(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(QUERY_INSERT));
db.Commands[0].Parameters.Add(new Parameter("@NORESI", MySqlDbType.VarChar, obj.NORESI));
db.Commands[0].Parameters.Add(new Parameter("@IDCUSTOMER", MySqlDbType.Int32, obj.IDCUSTOMER));
db.Commands[0].Parameters.Add(new Parameter("@IDTARIF", MySqlDbType.Int32, obj.IDTARIF));
db.Commands[0].Parameters.Add(new Parameter("@IDPENERIMA", MySqlDbType.Int32, obj.IDPENERIMA));
db.Commands[0].Parameters.Add(new Parameter("@TGLTERIMA", MySqlDbType.VarChar, obj.TGLTERIMA));
db.Commands[0].Parameters.Add(new Parameter("@TGLESTIMASI", MySqlDbType.VarChar, obj.TGLESTIMASI));
db.Commands[0].Parameters.Add(new Parameter("@JUMLAH", MySqlDbType.Int32, obj.JUMLAH));
db.Commands[0].Parameters.Add(new Parameter("@BERAT", MySqlDbType.Float, obj.BERAT));
db.Commands[0].Parameters.Add(new Parameter("@KETERANGANISI", MySqlDbType.VarChar, obj.KETERANGANISI));
db.Commands[0].Parameters.Add(new Parameter("@INSTRUKSIKHUSUS", MySqlDbType.VarChar, obj.INSTRUKSIKHUSUS));
db.Commands[0].Parameters.Add(new Parameter("@DIM_P", MySqlDbType.Float, obj.DIM_P));
db.Commands[0].Parameters.Add(new Parameter("@DIM_L", MySqlDbType.Float, obj.DIM_L));
db.Commands[0].Parameters.Add(new Parameter("@DIM_T", MySqlDbType.Float, obj.DIM_T));
db.Commands[0].Parameters.Add(new Parameter("@RATE_KIRIM", MySqlDbType.Float, obj.RATE_KIRIM));
db.Commands[0].Parameters.Add(new Parameter("@CHARGE_KIRIM", MySqlDbType.Float, obj.CHARGE_KIRIM));
db.Commands[0].Parameters.Add(new Parameter("@PPNPERCENT", MySqlDbType.Float, obj.PPNPERCENT));
db.Commands[0].Parameters.Add(new Parameter("@PPN", MySqlDbType.Float, obj.PPN));
db.Commands[0].Parameters.Add(new Parameter("@CHARGE_PACKING", MySqlDbType.Float, obj.CHARGE_PACKING));
db.Commands[0].Parameters.Add(new Parameter("@OTHER_CHARGE", MySqlDbType.Float, obj.OTHER_CHARGE));
db.Commands[0].Parameters.Add(new Parameter("@DISCPERCENT", MySqlDbType.Float, obj.DISCPERCENT));
db.Commands[0].Parameters.Add(new Parameter("@DISC", MySqlDbType.Float, obj.DISC));
db.Commands[0].Parameters.Add(new Parameter("@INSURANCE", MySqlDbType.Float, obj.INCURANCE));
db.Commands[0].Parameters.Add(new Parameter("@INCURANCEPERCENT", MySqlDbType.Float, obj.INCURANCEPERCENT));
db.Commands[0].Parameters.Add(new Parameter("@NBARANGINSURANCE", MySqlDbType.Float, obj.NBARANGINSURANCE));
db.Commands[0].Parameters.Add(new Parameter("@TGLPENGIRIMAN", MySqlDbType.VarChar, obj.TGLPENGIRIMAN));
db.Commands[0].Parameters.Add(new Parameter("@TGLPENGAMBILAN", MySqlDbType.VarChar, obj.TGLPENGAMBILAN));
db.Commands[0].Parameters.Add(new Parameter("@TOTAL", MySqlDbType.Float, obj.TOTAL));
db.Commands[0].Parameters.Add(new Parameter("@BAYAR", MySqlDbType.Float, obj.BAYAR));
db.Commands[0].Parameters.Add(new Parameter("@SISA", MySqlDbType.Float, obj.SISA));
db.Commands[0].Parameters.Add(new Parameter("@VOID", MySqlDbType.Float, obj.VOID));
db.Commands[0].Parameters.Add(new Parameter("@STATUS", MySqlDbType.Int32, obj.STATUS));
db.Commands[0].Parameters.Add(new Parameter("@PENERIMABARANG", MySqlDbType.VarChar, obj.PENERIMABARANG));
db.Commands[0].Parameters.Add(new Parameter("@CREATED_BY", MySqlDbType.VarChar, "admin development"));
db.Commands[0].Parameters.Add(new Parameter("@CREATED_AT", MySqlDbType.VarChar, null));
db.Commands[0].Parameters.Add(new Parameter("@UPDATED_BY", MySqlDbType.VarChar, null));
db.Commands[0].Parameters.Add(new Parameter("@UPDATED_AT", MySqlDbType.VarChar, null));
dt = db.Commands[0].ExecuteDataTable();
// http://www.c-sharpcorner.com/UploadFile/krishnasarala/generating-barcode-in-C-Sharp/
// ini referesi qr barcode
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void DELETE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(QUERY_DELETE));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable CARI_BYNAMA(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_CARI_BYNAME));
//db.Commands[0].Parameters.Add(new Parameter("@NAMASALES", MySqlDbType.VarChar, obj.NAMA));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECTKODEIVOICE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTKODEINVOICE));
// db.Commands[0].Parameters.Add(new Parameter("@KODEINVOICE", MySqlDbType.VarChar, obj.KODEIVOICE));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECTAGENTBYID(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTAGENTBYID));
//db.Commands[0].Parameters.Add(new Parameter("@IDAGENT", MySqlDbType.Int32, obj.IDAGENT));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECTPMBINV(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTPMBINV));
// db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE));
//db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public FormENTRYSO(EXPRESS.FormDAFTARSO _frm, int _Type,
RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj, RMS.COMMON.MASTER.RMS_USER user)
{
InitializeComponent();
INIT_PERUSAHAAN();
frm = _frm;
Type = _Type;
if (Type == 0)
{
cboINSURANCE.Text = "0";
setDIM();
ptbASAL.Visible = false;
ptbTUJUAN.Visible = false;
txtNORESI.Text = GETKODE();
}
else
{
c.ID = obj.ID;
LOAD_DATA(obj);
}
SET_PRINT();
}
public DataTable SELECTLIKE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
if (obj.STATUSORDER != "SEMUA")
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTLIKE));
}
else
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTLIKEALL));
}
/*
* db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE));
* db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE));
* db.Commands[0].Parameters.Add(new Parameter("@TPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT));
* db.Commands[0].Parameters.Add(new Parameter("@CUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER));
* db.Commands[0].Parameters.Add(new Parameter("@MARKETING", MySqlDbType.VarChar, obj.MARKETING));
* db.Commands[0].Parameters.Add(new Parameter("@STATUS", MySqlDbType.VarChar, obj.STATUSPEMBAYARAN));
* db.Commands[0].Parameters.Add(new Parameter("@SERVICE", MySqlDbType.VarChar, obj.SERVICE));
* db.Commands[0].Parameters.Add(new Parameter("@ARMADA", MySqlDbType.VarChar, obj.ARMADA));
* db.Commands[0].Parameters.Add(new Parameter("@DEST", MySqlDbType.VarChar, obj.NAMAKOTADEST));
*/
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void UPDATE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
p.UPDATE(obj);
}
public void DELETE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
p.DELETE(obj);
}
public DataTable SELECTPMBINV(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
return(p.SELECTPMBINV(obj));
}
public DataTable SELECTINVOICECETAK(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
return(p.SELECTINVOICECETAK(obj));
}
public void INSERT(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
p.INSERT(obj);
}
public DataTable SELECTAGENTBYID(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
return(p.SELECTAGENTBYID(obj));
}
public DataTable CARI_BYKODE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
return(p.CARI_BYKODE(obj));
}
public DataTable SELECTFILTER(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
return(p.SELECTFILTER(obj));
}
public DataTable SELECTKODEINVOICE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
return(p.SELECTKODEIVOICE(obj));
}
void LOAD_DATA(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
DataTable dt = b.CARI_BYID(obj);
if (dt.Rows.Count > 0)
{
string TGLTERIMA, TGLETD;
txtNORESI.Text = dt.Rows[0]["NORESI"].ToString();
checkIDTARIF = Convert.ToInt32(dt.Rows[0]["IDTARIF"].ToString());
c.IDTARIF = Convert.ToInt32(dt.Rows[0]["IDTARIF"].ToString());
txtSFROM.Text = dt.Rows[0]["KOTAASAL"].ToString();
txtSTO.Text = dt.Rows[0]["KOTATUJUAN"].ToString();
TGLTERIMA = dt.Rows[0]["TGLTERIMA"].ToString();
TGLETD = dt.Rows[0]["TGLESTIMASI"].ToString();
dtTGLMANIFEST.Value = DateTime.Parse(TGLTERIMA);
dtETD.Value = DateTime.Parse(TGLETD);
txtRATEKIRIM.Text = dt.Rows[0]["RATE_KIRIM"].ToString();
txtSWIGHT.Text = dt.Rows[0]["BERAT"].ToString();
txtPCS.Text = dt.Rows[0]["JUMLAH"].ToString();
txtPDIM.Text = dt.Rows[0]["DIM_P"].ToString();
txtLDIM.Text = dt.Rows[0]["DIM_L"].ToString();
txtTDIM.Text = dt.Rows[0]["DIM_T"].ToString();
if (txtPDIM.Text != "0")
{
chkISDIM.Checked = true;
}
txtWEIGHT.Text = dt.Rows[0]["BERAT"].ToString();
LOAD_TARIF(); // untuk mengetahui tarif yang digunakan sebelumnya
c.IDCUSTOMER = Convert.ToInt32(dt.Rows[0]["IDCUSTOMER"].ToString());
txtKODECUSTOMER.Text = dt.Rows[0]["KODECUSTOMER"].ToString();
txtNAMACUSTOMER.Text = dt.Rows[0]["NAMACUSTOMER"].ToString();
// tambah disini mang
txtALAMATPENGIRIM.Text = dt.Rows[0]["ALAMAT"].ToString();
txtPHONEPENGIRIM.Text = dt.Rows[0]["TELEPON"].ToString();
txtHPPENGIRIM.Text = dt.Rows[0]["HP"].ToString();
c.IDPENERIMA = Convert.ToInt32(dt.Rows[0]["IDPENERIMA"].ToString());
txtPENERIMA.Text = dt.Rows[0]["NAMAPENERIMA"].ToString();
txtPHONEPENERIMA.Text = dt.Rows[0]["TELEPONPENERIMA"].ToString();
txtFAXPENERIMA.Text = dt.Rows[0]["FAXPENERIMA"].ToString();
txtALAMAT.Text = dt.Rows[0]["ALAMATPENERIMA"].ToString();
// informasi other charge
txtTOTALCHARGEKIRIM.Text = dt.Rows[0]["CHARGE_KIRIM"].ToString();
txtDISKONPERCENT.Text = dt.Rows[0]["DISCPERCENT"].ToString();
txtDISKON.Text = dt.Rows[0]["DISC"].ToString();
txtBAYAR.Text = dt.Rows[0]["BAYAR"].ToString();
// hitunga on change grandTOTAL
txtPPNPercent.Text = dt.Rows[0]["PPNPERCENT"].ToString();
if (txtPPNPercent.Text != "0")
{
chkPPN.Checked = true;
}
txtCHARGEPPN.Text = dt.Rows[0]["PPN"].ToString();
cboINSURANCE.Text = dt.Rows[0]["INCURANCEPERCENT"].ToString();
txtCHARGEINSURANCE.Text = dt.Rows[0]["INSURANCE"].ToString();
txtNOMINALBARANG.Text = dt.Rows[0]["NBARANGINSURANCE"].ToString();
if (txtNOMINALBARANG.Text != "0")
{
chkPACKING.Checked = true;
}
txtCHARGEPACKING.Text = dt.Rows[0]["CHARGE_PACKING"].ToString();
// additional info pamantes
lblFROM.Text = dt.Rows[0]["KOTAASAL"].ToString();
lblTO.Text = dt.Rows[0]["KOTATUJUAN"].ToString();
lblLAYANAN.Text = dt.Rows[0]["PRODUK"].ToString();
lblJENISKIRIMAN.Text = dt.Rows[0]["JENISKIRIMAN"].ToString();
// additional
txtKETERANGANISI.Text = dt.Rows[0]["KETERANGANISI"].ToString();
txtINSTRUKSIKHUSUS.Text = dt.Rows[0]["INSTRUKSIKHUSUS"].ToString();
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj)
{
return(p.SEARCH_BYNAMA(obj));
}
