public void INSERT(RMS.COMMON.MASTER.RMS_USER 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("@nama", MySqlDbType.VarChar, obj.nama));
db.Commands[0].Parameters.Add(new Parameter("@level", MySqlDbType.VarChar, obj.level));
db.Commands[0].Parameters.Add(new Parameter("@username", MySqlDbType.VarChar, obj.username));
db.Commands[0].Parameters.Add(new Parameter("@password", MySqlDbType.VarChar, obj.password));
db.Commands[0].Parameters.Add(new Parameter("@hp", MySqlDbType.VarChar, obj.hp));
db.Commands[0].Parameters.Add(new Parameter("@alamat", MySqlDbType.VarChar, obj.alamat));
db.Commands[0].Parameters.Add(new Parameter("@isaktif", MySqlDbType.Int32, obj.isaktif));
db.Commands[0].Parameters.Add(new Parameter("@isbiayastt", MySqlDbType.Int32, obj.isbiayastt));
db.Commands[0].Parameters.Add(new Parameter("@ispiutang", MySqlDbType.Int32, obj.ispiutang));
db.Commands[0].Parameters.Add(new Parameter("@ismasterdata", MySqlDbType.Int32, obj.ismasterdata));
db.Commands[0].Parameters.Add(new Parameter("@isagent", MySqlDbType.Int32, obj.isagent));
db.Commands[0].Parameters.Add(new Parameter("@ispricelist", MySqlDbType.Int32, obj.ispricelist));
db.Commands[0].Parameters.Add(new Parameter("@isuser", MySqlDbType.Int32, obj.isuser));
db.Commands[0].Parameters.Add(new Parameter("@islaporan", MySqlDbType.Int32, obj.islaporan));
db.Commands[0].Parameters.Add(new Parameter("@iscourier", MySqlDbType.Int32, obj.iscourier));
db.Commands[0].Parameters.Add(new Parameter("@isLogin", MySqlDbType.Int32, obj.isLogin));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public FormDATAENTRY(DELIVERYORDER.FormDAFTARSTT _frm,int Type,
RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj, RMS.COMMON.MASTER.RMS_USER user)
{
InitializeComponent();
INIT_PERUSAHAAN();
SET_PRINT();
cUser = user;
this.frm = _frm;
this.Type = Type;
setDIM();
if (cUser.isbiayastt)
{
panelBIAYA.Visible = true;
}
else
{
panelBIAYA.Visible = false;
}
if (Type == 0)
{
cboINSURANCE.Text = "0";
txtNOCONNOTE.Text = GETKODE();
cboTERMOFPAYMENT.Text = "PREPAID";
}
else
{
c.ID = obj.ID;
LOAD_DATA(obj);
}
}
public bool IsAuthenticate(RMS.COMMON.MASTER.RMS_USER obj)
{
bool valid = false;
DataTable dt;
Database db = new Database();
db.Commands.Add(db.CreateCommand("SELECT * FROM user where username = @USERNAME and password = @PASSWORD and isaktif =@ISAKTIF"));
db.Commands[0].Parameters.Add(new Parameter("@USERNAME", MySqlDbType.VarChar, obj.username));
db.Commands[0].Parameters.Add(new Parameter("@PASSWORD", MySqlDbType.VarChar, obj.password));
db.Commands[0].Parameters.Add(new Parameter("@ISAKTIF", MySqlDbType.Int32, obj.isaktif));
dt = db.Commands[0].ExecuteDataTable();
if (dt.Rows.Count > 0)
{
obj.id = int.Parse(dt.Rows[0]["id"].ToString());
string _userame = dt.Rows[0]["username"].ToString();
string _password = dt.Rows[0]["password"].ToString();
string _level = dt.Rows[0]["level"].ToString();
bool _active = bool.Parse(dt.Rows[0]["isaktif"].ToString());
if (_active)
{
valid = true;
}
else
{
valid = false;
}
}
return(valid);
}
public MainForm(RMS.COMMON.MASTER.RMS_USER obj)
{
InitializeComponent();
//cUser = obj;
cUser = obj;
LOAD_PC();
// SETTING();
}
public MainForm(RMS.COMMON.MASTER.RMS_USER obj)
{
InitializeComponent();
//cUser = obj;
cUser = obj;
LOAD_PC();
// SETTING();
}
public string EncodePassword(RMS.COMMON.MASTER.RMS_USER obj)
{
string encode;
using (Database db = new Database())
{
encode = db.EncodePassword(obj.password);
}
return(encode);
}
public string DecodePassword(RMS.COMMON.MASTER.RMS_USER obj)
{
string decode;
using (Database db = new Database())
{
decode = db.DecodePassword(obj.password);
}
return(decode);
}
public FormDAFTARSTT(RMS.COMMON.MASTER.RMS_USER obj)
{
InitializeComponent();
//this.setCOMBO();
cUser = obj;
SETTING_MANUAL();
INIT_PERUSAHAAN();
LOAD_DATA();
LOAD_DATAUSER();
myToolTip();
}
public FormDAFTARSTT(RMS.COMMON.MASTER.RMS_USER obj)
{
InitializeComponent();
//this.setCOMBO();
cUser = obj;
SETTING_MANUAL();
INIT_PERUSAHAAN();
LOAD_DATA();
LOAD_DATAUSER();
myToolTip();
}
public void DELETE(RMS.COMMON.MASTER.RMS_USER 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("@id", MySqlDbType.Int32, obj.id));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void UpdateIsLogin(RMS.COMMON.MASTER.RMS_USER obj, int islogin)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("UPDATE user set isLogin = @islogin WHERE id = @ID"));
db.Commands[0].Parameters.Add(new Parameter("@isLogin", MySqlDbType.Int32, islogin));
db.Commands[0].Parameters.Add(new Parameter("@ID", MySqlDbType.Int32, obj.id));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
// Error.LogError(ex);
}
}
public DataTable CARI_BYKODE(RMS.COMMON.MASTER.RMS_USER obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_CARI_BYKODE));
db.Commands[0].Parameters.Add(new Parameter("@ID", MySqlDbType.Int32, obj.id));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public FormENTRYPENGIRIMANBARANG(EXPRESS.FormDAFTARPENGIRIMANBARANG _frm, int _Type,
RMS.COMMON.EXPRESS.RMS_SPJ obj, RMS.COMMON.MASTER.RMS_USER user)
{
InitializeComponent();
frm = _frm;
Type = _Type;
if (Type == 0)
{
txtSPJ.Text = GETKODE();
}
else
{
// update coy
c.ID = obj.ID;
INIT_PERUSAHAAN();
LOAD_DATA(obj);
LOAD_DETAIL();
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_USER 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("@NAMABANK", MySqlDbType.VarChar, obj.NAMA));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECTLOGIN(RMS.COMMON.MASTER.RMS_USER obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTLOGIN));
db.Commands[0].Parameters.Add(new Parameter("@USERNAME", MySqlDbType.VarChar, obj.username));
db.Commands[0].Parameters.Add(new Parameter("@PASSWORD", MySqlDbType.VarChar, obj.password));
db.Commands[0].Parameters.Add(new Parameter("@ISAKTIF", MySqlDbType.Int32, obj.isaktif));
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 void UpdateIsLogin(RMS.COMMON.MASTER.RMS_USER obj, int isLogin)
{
p.UpdateIsLogin(obj, isLogin);
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_USER obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_USER obj)
{
return(p.CARI_BYNAMA(obj));
}
public DataTable SELECTLOGIN(RMS.COMMON.MASTER.RMS_USER obj)
{
return(p.SELECTLOGIN(obj));
}
public void DELETE(RMS.COMMON.MASTER.RMS_USER obj)
{
p.DELETE(obj);
}
public void UPDATE(RMS.COMMON.MASTER.RMS_USER obj)
{
p.UPDATE(obj);
}
public string DecodePassword(RMS.COMMON.MASTER.RMS_USER obj)
{
return(p.DecodePassword(obj));
}
public bool IsAuthenticate(RMS.COMMON.MASTER.RMS_USER obj)
{
return(p.IsAuthenticate(obj));
}
public void INSERT(RMS.COMMON.MASTER.RMS_USER obj)
{
p.INSERT(obj);
}
