public static string get_kode()
{
using (var db = new Models.jotunContext())
{
return(db.Database.SqlQuery <string>("CALL penomoran('KRY','karyawan', 'kd_karyawan')").SingleOrDefault());
}
}
public static List <Models.customer> get_data()
{
using (var db = new Models.jotunContext())
{
return(db.customers.ToList());
}
}
public static string get_kode()
{
using (var db = new Models.jotunContext())
{
return(db.Database.SqlQuery <string>("CALL penomoran_transaksi('IN','invoice','no_invoice')").SingleOrDefault());
}
}
public static string get_kode()
{
using (var db = new Models.jotunContext())
{
return(db.Database.SqlQuery <string>("CALL penomoran('CST','customer', 'kd_customer')").SingleOrDefault());
}
}
public static List <Models.customer> search(string kolom, string param)
{
kolom = kolom.ToLower();
using (var db = new Models.jotunContext())
{
if (kolom.Contains("kode"))
{
return(db.customers.Where(t => t.kd_customer.Contains(param)).ToList());
}
else if (kolom.Contains("nama"))
{
return(db.customers.Where(t => t.nama.Contains(param)).ToList());
}
else if (kolom.Contains("alamat"))
{
return(db.customers.Where(t => t.alamat.Contains(param)).ToList());
}
else if (kolom.Contains("telepon"))
{
return(db.customers.Where(t => t.no_telepon.ToString().Contains(param)).ToList());
}
else
{
return(db.customers.Where(t => t.email.Contains(param)).ToList());
}
}
}
public static Models.karyawan get_detail(string kode)
{
using (var db = new Models.jotunContext())
{
return(db.karyawans.Where(t => t.kd_karyawan == kode).SingleOrDefault());
}
}
public static Models.customer get_detail(string kode)
{
using (var db = new Models.jotunContext())
{
return(db.customers.Where(t => t.kd_customer == kode).SingleOrDefault());
}
}
public static string get_kode()
{
using (var db = new Models.jotunContext())
{
return(db.Database.SqlQuery <string>("CALL penomoran_transaksi('SJ','surat_jalan','no_surat_jalan')").SingleOrDefault());
}
}
public static List <Models.karyawan> get_data()
{
using (var db = new Models.jotunContext())
{
return(db.karyawans.ToList());
}
}
public static List<Models.barang> search(string kolom, string param)
{
kolom = kolom.ToLower();
using (var db = new Models.jotunContext())
{
if (kolom.Contains("kode"))
{
return db.barangs.Where(t => t.kd_barang.Contains(param)).ToList();
}
else if (kolom.Contains("nama"))
{
return db.barangs.Where(t => t.nama.Contains(param)).ToList();
}
else if (kolom.Contains("batch"))
{
return db.barangs.Where(t => t.no_batch.Contains(param)).ToList();
}
else if (kolom.Contains("tipe"))
{
return db.barangs.Where(t => t.tipe.Contains(param)).ToList();
}
else if (kolom.Contains("ukuran"))
{
return db.barangs.Where(t => t.ukuran.ToString().Contains(param)).ToList();
}
else
{
return db.barangs.Where(t => t.stok.ToString().Contains(param)).ToList();
}
}
}
public static List <Models.karyawan> search(string kolom, string param)
{
kolom = kolom.ToLower();
using (var db = new Models.jotunContext())
{
if (kolom.Contains("kode"))
{
return(db.karyawans.Where(t => t.kd_karyawan.Contains(param)).ToList());
}
else if (kolom.Contains("nama"))
{
return(db.karyawans.Where(t => t.nama.Contains(param)).ToList());
}
else if (kolom.Contains("alamat"))
{
return(db.karyawans.Where(t => t.alamat.Contains(param)).ToList());
}
else if (kolom.Contains("email"))
{
return(db.karyawans.Where(t => t.email.Contains(param)).ToList());
}
else
{
return(db.karyawans.Where(t => t.username.Contains(param)).ToList());
}
}
}
public static DataSet1 get_report()
{
DataSet1 ds = new DataSet1();
try
{
using (var db = new Models.jotunContext())
{
db.Database.Connection.Open();
using (var cmd = db.Database.Connection.CreateCommand())
{
cmd.CommandText = "select * from view_barang order by terjual desc";
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["view_barang"].Merge(dt);
}
}
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return ds;
}
public static string get_kode()
{
using (var db = new Models.jotunContext())
{
return db.Database.SqlQuery<string>("CALL penomoran('BRG','barang', 'kd_barang')").SingleOrDefault();
}
}
public static Models.barang get_detail(string kode)
{
using (var db = new Models.jotunContext())
{
return db.barangs.Where(t => t.kd_barang == kode).SingleOrDefault();
}
}
public static List<Models.barang> get_data()
{
using (var db = new Models.jotunContext())
{
return db.barangs.ToList();
}
}
public static DataSet1 get_report(string no_surat_jalan)
{
DataSet1 ds = new DataSet1();
try
{
using (var db = new Models.jotunContext())
{
db.Database.Connection.Open();
using (var cmd = db.Database.Connection.CreateCommand())
{
cmd.CommandText = string.Format("select * from surat_jalan where no_surat_jalan = '{0}'", no_surat_jalan);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["surat_jalan"].Merge(dt);
}
cmd.CommandText = string.Format("select * from detail_surat_jalan where no_surat_jalan = '{0}'", no_surat_jalan);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["detail_surat_jalan"].Merge(dt);
}
cmd.CommandText = string.Format("select * from barang");
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["barang"].Merge(dt);
}
cmd.CommandText = string.Format("select * from customer");
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["customer"].Merge(dt);
}
}
}
}
catch (Exception ex)
{
Helpers.Generic.MsgEx(ex.Message);
}
return(ds);
}
public static DataSet1 get_repot_penjualan_per_customer(string kode, DateTime tgl1, DateTime tgl2)
{
kode = "'" + kode.Replace(", ", "','") + "'";
DataSet1 ds = new DataSet1();
try
{
using (var db = new Models.jotunContext())
{
db.Database.Connection.Open();
using (var cmd = db.Database.Connection.CreateCommand())
{
cmd.CommandText = string.Format("select * from invoice where kd_customer in ({0}) and date(tgl) between '{1}' and '{2}'", kode, tgl1.ToString("yyyy-MM-dd"), tgl2.ToString("yyyy-MM-dd"));
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["invoice"].Merge(dt);
}
cmd.CommandText = string.Format("select * from detail_invoice");
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["detail_invoice"].Merge(dt);
}
string[] tables = new string[] { "barang", "customer", "surat_jalan", "po" };
foreach (var table in tables)
{
cmd.CommandText = string.Format("select * from {0}", table);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables[table].Merge(dt);
}
}
}
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(ds);
}
public static DataSet1 get_repot(string no_invoice)
{
DataSet1 ds = new DataSet1();
try
{
using (var db = new Models.jotunContext())
{
db.Database.Connection.Open();
using (var cmd = db.Database.Connection.CreateCommand())
{
cmd.CommandText = string.Format("select * from invoice where no_invoice = '{0}'", no_invoice);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["invoice"].Merge(dt);
}
cmd.CommandText = string.Format("select * from detail_invoice where no_invoice = '{0}'", no_invoice);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["detail_invoice"].Merge(dt);
}
string[] tables = new string[] { "barang", "customer", "surat_jalan", "po" };
foreach (var table in tables)
{
cmd.CommandText = string.Format("select * from {0}", table);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables[table].Merge(dt);
}
}
}
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(ds);
}
public static Models.karyawan check_login(string username, string password)
{
var result = new Models.karyawan();
try
{
using (var db = new Models.jotunContext())
{
return(db.karyawans.Where(t => t.username == username && t.password == password).SingleOrDefault());
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(result);
}
public static List <Models.po> get_po()
{
try
{
using (var db = new Models.jotunContext())
{
return(db.po
.Include(t => t.customer)
.OrderByDescending(t => t.tgl)
.ToList());
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(new List <Models.po>());
}
public static bool insert(Models.barang data)
{
bool result = false;
try
{
using (var db = new Models.jotunContext())
{
db.Entry(data).State = EntityState.Added;
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return result;
}
public static List <Models.detailpo> get_detail_po(string no_po)
{
try
{
using (var db = new Models.jotunContext())
{
return(db.detailpo
.Include(t => t.barang)
.Where(t => t.no_po == no_po)
.ToList());
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(new List <Models.detailpo>());
}
public static DataSet1 get_report(DateTime tgl1, DateTime tgl2)
{
DataSet1 ds = new DataSet1();
try
{
using (var db = new Models.jotunContext())
{
db.Database.Connection.Open();
using (var cmd = db.Database.Connection.CreateCommand())
{
cmd.CommandText = string.Format("select * from penerimaan");
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables["penerimaan"].Merge(dt);
}
}
var tables = new string[] { "barang", "detail_penerimaan" };
foreach (var table in tables)
{
using (var cmd = db.Database.Connection.CreateCommand())
{
cmd.CommandText = string.Format("select * from {0} ", table);
cmd.CommandType = System.Data.CommandType.Text;
using (var reader = cmd.ExecuteReader())
{
var dt = new System.Data.DataTable();
dt.Load(reader);
ds.Tables[table].Merge(dt);
}
}
}
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(ds);
}
public static List <Models.surat_jalan> get_surat_jalan()
{
try
{
using (var db = new Models.jotunContext())
{
return(db.surat_jalan
.Include(t => t.po)
.Include(t => t.po.customer)
.OrderByDescending(t => t.no_surat_jalan)
.ToList());
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(new List <Models.surat_jalan>());
}
public static bool delete(Models.karyawan data)
{
bool result = false;
try
{
using (var db = new Models.jotunContext())
{
db.Entry(data).State = EntityState.Deleted;
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
Helpers.Generic.MsgError(ex.Message);
}
return(result);
}
