void LOAD_DATAAREA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
DataTable dt = b.SEARCH_BYKODEAREA(obj);
if (dt.Rows.Count > 0)
{
c.IDAREA = int.Parse(dt.Rows[0]["IDAREA"].ToString());
txtKODE.Text = dt.Rows[0]["KODEAREA"].ToString();
txtNAMA.Text = dt.Rows[0]["NAMAAREA"].ToString();
}
}
public FormAREA(MASTER.FormKOTA _frm, int Type, RMS.COMMON.MASTER.RMS_KOTA obj)
{
InitializeComponent();
this.frm = _frm;
this.Type = Type;
if (Type == 1)
{
LOAD_DATA(obj);
}
}
void LOAD_DATAKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
DataTable dt = b.CARI_BYIDKOTA(obj);
if (dt.Rows.Count > 0)
{
c.IDKOTA = int.Parse(dt.Rows[0]["IDKOTA"].ToString());
txtKODE.Text = dt.Rows[0]["KODEKOTA"].ToString();
txtNAMA.Text = dt.Rows[0]["NAMAKOTA"].ToString();
}
}
public void GET_DATA_KOTA(RMS.COMMON.MASTER.RMS_KOTA obj, string _namaField)
{
if (_namaField == "ORIGIN")
{
txtKODEASAL.Text = obj.KODEKOTA;
txtASAL.Text = obj.NAMAKOTA;
c.IDKOTAASAL = obj.IDKOTA;
}
else
{
txtKODETUJUAN.Text = obj.KODEKOTA;
txtTUJUAN.Text = obj.NAMAKOTA;
c.IDKOTATUJUAN = obj.IDKOTA;
}
}
public FormTERUSAN(MASTER.FormKOTA _frm, int Type, RMS.COMMON.MASTER.RMS_KOTA obj)
{
InitializeComponent();
this.frm = _frm;
this.Type = Type;
if (Type == 0)
{
LOAD_DATAKOTA(obj);
}
else
{
LOAD_DATAKOTA(obj);
//LOAD_DATAKOTA(obj);
}
}
public void DELETE(RMS.COMMON.MASTER.RMS_KOTA 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 GET_TERUSANBYID(RMS.COMMON.MASTER.RMS_KOTA obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_GETTERUSAN_BYID));
db.Commands[0].Parameters.Add(new Parameter("@IDKOTA", MySqlDbType.VarChar, obj.IDKOTA));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
// UNTUK PENCARIAN AREA BY NAMA
public DataTable SEARCH_BYNAMAAREA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYNAMEAREA));
db.Commands[0].Parameters.Add(new Parameter("@NAMAAREA", MySqlDbType.VarChar, obj.NAMAAREA));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void INSERTTERUSAN(RMS.COMMON.MASTER.RMS_KOTA obj)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(QUERY_INSERTTERUSAN));
db.Commands[0].Parameters.Add(new Parameter("@IDKOTA", MySqlDbType.Int32, obj.IDKOTA));
db.Commands[0].Parameters.Add(new Parameter("@NAMATERUSAN", MySqlDbType.VarChar, obj.NAMATERUSAN));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYKODE(RMS.COMMON.MASTER.RMS_KOTA obj)
{
return(p.SEARCH_BYKODE(obj));
}
public DataTable GETKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
return(p.GETKOTA(obj));
}
public void INSERTKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
p.INSERTKOTA(obj);
}
public DataTable SEARCH_BYNAMAAREAKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
return(p.SEARCH_BYNAMAAREAKOTA(obj));
}
public void UPDATEKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
p.UPDATEKOTA(obj);
}
public void INSERTTERUSAN(RMS.COMMON.MASTER.RMS_KOTA obj)
{
p.INSERTTERUSAN(obj);
}
public DataTable CARI_BYKODEKOTA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
return(p.CARI_BYKODEKOTA(obj));
}
public DataTable GET_TERUSANBYID(RMS.COMMON.MASTER.RMS_KOTA obj)
{
return(p.GET_TERUSANBYID(obj));
}
public DataTable GETTERUSAN_BYNAMA(RMS.COMMON.MASTER.RMS_KOTA obj)
{
return(p.GETTERUSAN_BYNAMA(obj));
}
public void DELETETERUSAN(RMS.COMMON.MASTER.RMS_KOTA obj)
{
p.DELETETERUSAN(obj);
}
public DataTable GETAREA_BYKODE(RMS.COMMON.MASTER.RMS_KOTA obj)
{
return(p.GETAREA_BYKODE(obj));
}