public void DELETE(RMS.COMMON.DELIVERYORDER.RMS_INVOICE obj)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(QUERY_DELETE));
//db.Commands[0].Parameters.Add(new Parameter("@KODESALES", MySqlDbType.VarChar, obj.KODE));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_INVOICE 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("@NAMASALES", MySqlDbType.VarChar, obj.NAMA));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void INSERT(RMS.COMMON.DELIVERYORDER.RMS_INVOICE 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("@TGLINVOICE", MySqlDbType.VarChar, obj.TGLINVOICE));
db.Commands[0].Parameters.Add(new Parameter("@KODEINVOICE", MySqlDbType.VarChar, obj.KODEINVOICE));
db.Commands[0].Parameters.Add(new Parameter("@KODECUSTOMER", MySqlDbType.VarChar, obj.KODECUSTOMER));
db.Commands[0].Parameters.Add(new Parameter("@KETERANGAN", MySqlDbType.VarChar, obj.KETERANGAN));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void UPDATE(RMS.COMMON.DELIVERYORDER.RMS_INVOICE obj)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(QUERY_UPDATE));
/*
* db.Commands[0].Parameters.Add(new Parameter("@KODESALES", MySqlDbType.VarChar, obj.KODE));
* db.Commands[0].Parameters.Add(new Parameter("@NAMASALES", MySqlDbType.VarChar, obj.NAMA));
* db.Commands[0].Parameters.Add(new Parameter("@ALAMAT", MySqlDbType.VarChar, obj.ALAMAT));
* db.Commands[0].Parameters.Add(new Parameter("@TELEPON", MySqlDbType.VarChar, obj.TELP));
* db.Commands[0].Parameters.Add(new Parameter("@EMAIL", MySqlDbType.VarChar, obj.EMAIL));
* dt = db.Commands[0].ExecuteDataTable();
*/
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_INVOICE obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public void DELETE(RMS.COMMON.DELIVERYORDER.RMS_INVOICE obj)
{
p.DELETE(obj);
}
public void UPDATE(RMS.COMMON.DELIVERYORDER.RMS_INVOICE obj)
{
p.UPDATE(obj);
}
public void INSERT(RMS.COMMON.DELIVERYORDER.RMS_INVOICE obj)
{
p.INSERT(obj);
}
public FormPEMBAYARANINVOICE(FINANCE.FormDAFTARPEMBAYRANPIUTANG _frm, int Type, RMS.COMMON.DELIVERYORDER.RMS_INVOICE obj)
{
InitializeComponent();
this.Type = Type;
type = 0;
cPMB.IDINVOICE = obj.ID;
cDETAIL.KODEIVOICE = obj.KODEINVOICE;
cboMETODEBAYAR.Text = "CASH";
cboJENISBAYAR.Text = "PELUNASAN";
pnlNOTRANSFER.Visible = false;
// txtTERBILANG.Visible = false;
if (type == 0)
{
LOAD_DATA(cDETAIL);
LOAD_HISTORYBAYAR(cPMB);
}
}