protected void RepeaterVendor_ItemCommand(object source, RepeaterCommandEventArgs e)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
if (e.CommandName == "Ubah")
{
TBVendor Vendor = db.TBVendors.FirstOrDefault(item => item.IDVendor == e.CommandArgument.ToInt());
HiddenFieldIDVendor.Value = Vendor.IDVendor.ToString();
TextBoxNamaVendor.Text = Vendor.Nama;
TextBoxAlamatVendor.Text = Vendor.Alamat;
TextBoxEmailVendor.Text = Vendor.Email;
TextBoxTelepon1Vendor.Text = Vendor.Telepon1;
TextBoxTelepon2Vendor.Text = Vendor.Telepon2;
TextBoxTaxVendor.Text = (Vendor.PersentaseTax * 100).ToString();
ButtonSimpanVendor.Text = "Ubah";
}
else if (e.CommandName == "Hapus")
{
Vendor_Class vendorClass = new Vendor_Class(db);
vendorClass.Hapus(e.CommandArgument.ToInt());
db.SubmitChanges();
LoadDataVendor(db);
}
}
}
protected void DropDownListVendor_SelectedIndexChanged(object sender, EventArgs e)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
if (DropDownListVendor.SelectedValue == "0")
{
HiddenFieldTax.Value = "0";
LabelTax.Text = "Tax (0%)";
}
else
{
TBVendor vendor = db.TBVendors.FirstOrDefault(item => item.IDVendor == DropDownListVendor.SelectedValue.ToInt());
HiddenFieldTax.Value = vendor.PersentaseTax.ToString();
LabelTax.Text = "Tax (" + (vendor.PersentaseTax * 100).ToFormatHarga() + "%)";
}
if (TextBoxIDProyeksi.Text != string.Empty && string.IsNullOrEmpty(Request.QueryString["edit"]))
{
ViewState["ViewStateListDetail"] = new List <POProduksiDetail_Model>();
LoadProyeksi(db, TextBoxIDProyeksi.Text);
}
CariHargaSupplierVendor();
HitungGrandTotal();
}
}
public static void Update(DataClassesDatabaseDataContext db, TBVendor vendor, TBStokProduk stokProduk, decimal harga)
{
if (vendor != null)
{
TBHargaVendor hargaVendor = db.TBHargaVendors.FirstOrDefault(item => item.TBVendor == vendor && item.TBStokProduk == stokProduk);
if (hargaVendor == null)
{
hargaVendor = new TBHargaVendor
{
TBVendor = vendor,
Tanggal = DateTime.Now,
Harga = harga,
TBStokProduk = stokProduk
};
db.TBHargaVendors.InsertOnSubmit(hargaVendor);
}
else
{
hargaVendor.Tanggal = DateTime.Now;
hargaVendor.Harga = harga;
}
}
}
public TBVendor Tambah(string nama, string email, string alamat, string telepon1, string telepon2)
{
TBVendor Vendor = new TBVendor
{
Nama = nama,
Email = email,
Alamat = alamat,
Telepon1 = telepon1,
Telepon2 = telepon2
};
db.TBVendors.InsertOnSubmit(Vendor);
return(Vendor);
}
protected void ButtonSimpanVendor_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
TBVendor Vendor = null;
if (ButtonSimpanVendor.Text == "Tambah")
{
Vendor = new TBVendor
{
Nama = TextBoxNamaVendor.Text,
Alamat = TextBoxAlamatVendor.Text,
Email = TextBoxEmailVendor.Text,
Telepon1 = TextBoxTelepon1Vendor.Text,
Telepon2 = TextBoxTelepon2Vendor.Text,
PersentaseTax = TextBoxTaxVendor.Text.ToDecimal() / 100
};
db.TBVendors.InsertOnSubmit(Vendor);
}
else if (ButtonSimpanVendor.Text == "Ubah")
{
Vendor = db.TBVendors.FirstOrDefault(item => item.IDVendor == HiddenFieldIDVendor.Value.ToInt());
Vendor.Nama = TextBoxNamaVendor.Text;
Vendor.Alamat = TextBoxAlamatVendor.Text;
Vendor.Email = TextBoxEmailVendor.Text;
Vendor.Telepon1 = TextBoxTelepon1Vendor.Text;
Vendor.Telepon2 = TextBoxTelepon2Vendor.Text;
Vendor.PersentaseTax = TextBoxTaxVendor.Text.ToDecimal() / 100;
}
db.SubmitChanges();
HiddenFieldIDVendor.Value = null;
TextBoxNamaVendor.Text = string.Empty;
TextBoxAlamatVendor.Text = string.Empty;
TextBoxEmailVendor.Text = string.Empty;
TextBoxTelepon1Vendor.Text = string.Empty;
TextBoxTelepon2Vendor.Text = string.Empty;
TextBoxTaxVendor.Text = "0.00";
ButtonSimpanVendor.Text = "Tambah";
LoadDataVendor(db);
}
}
}
private void LoadProyeksi(DataClassesDatabaseDataContext db, string IDProyeksi)
{
PenggunaLogin pengguna = (PenggunaLogin)Session["PenggunaLogin"];
TextBoxIDProyeksi.Text = IDProyeksi;
TextBoxPegawai.Text = pengguna.NamaLengkap;
TBVendor vendor = null;
if (DropDownListVendor.SelectedValue == "0")
{
HiddenFieldTax.Value = "0";
LabelTax.Text = "Tax (0%)";
}
else
{
vendor = db.TBVendors.FirstOrDefault(item => item.IDVendor == DropDownListVendor.SelectedValue.ToInt());
HiddenFieldTax.Value = vendor.PersentaseTax.ToString();
LabelTax.Text = "Tax (" + (vendor.PersentaseTax * 100).ToFormatHarga() + "%)";
}
TBProyeksiDetail[] proyeksiDetail = db.TBProyeksiDetails.Where(item => item.IDProyeksi == TextBoxIDProyeksi.Text).OrderBy(item => item.TBKombinasiProduk.Nama).ToArray();
TBStokProduk[] daftarStokProduk = db.TBStokProduks.AsEnumerable().Where(item => item.IDTempat == pengguna.IDTempat && proyeksiDetail.Any(data => data.IDKombinasiProduk == item.IDKombinasiProduk)).OrderBy(item => item.TBKombinasiProduk.Nama).ToArray();
DropDownListStokProduk.DataSource = daftarStokProduk.Select(item => new { item.IDStokProduk, item.TBKombinasiProduk.Nama });
DropDownListStokProduk.DataTextField = "Nama";
DropDownListStokProduk.DataValueField = "IDStokProduk";
DropDownListStokProduk.DataBind();
List <POProduksiDetail_Model> ViewStateListDetail = (List <POProduksiDetail_Model>)ViewState["ViewStateListDetail"];
foreach (var item in proyeksiDetail.Where(item => item.Sisa > 0))
{
TBStokProduk stokProduk = daftarStokProduk.FirstOrDefault(data => data.IDKombinasiProduk == item.IDKombinasiProduk);
POProduksiDetail_Model detail = new POProduksiDetail_Model();
detail.IDProduk = stokProduk.TBKombinasiProduk.IDProduk;
detail.IDKombinasiProduk = stokProduk.IDKombinasiProduk;
detail.IDStokProduk = stokProduk.IDStokProduk;
detail.Kode = stokProduk.TBKombinasiProduk.KodeKombinasiProduk;
detail.Produk = stokProduk.TBKombinasiProduk.TBProduk.Nama;
detail.Atribut = stokProduk.TBKombinasiProduk.TBAtributProduk.Nama;
detail.KombinasiProduk = stokProduk.TBKombinasiProduk.Nama;
detail.HargaPokokKomposisi = 0;
detail.BiayaTambahan = 0;
detail.TotalHPP = detail.BiayaTambahan + detail.HargaPokokKomposisi;
detail.Harga = vendor == null ? 0 : vendor.TBHargaVendors.FirstOrDefault(data => data.IDStokProduk == stokProduk.IDStokProduk) == null ? 0 : vendor.TBHargaVendors.FirstOrDefault(data => data.IDStokProduk == stokProduk.IDStokProduk).Harga.Value;
detail.PotonganHarga = 0;
detail.TotalHarga = detail.Harga - detail.PotonganHarga;
detail.Jumlah = item.Sisa;
detail.Sisa = detail.Jumlah;
ViewStateListDetail.Add(detail);
}
ViewState["ViewStateListDetail"] = ViewStateListDetail;
LoadData();
decimal subtotal = LabelTotalSubtotal.Text.ToDecimal();
decimal tax = subtotal * HiddenFieldTax.Value.ToDecimal();
TextBoxTax.Text = tax.ToFormatHarga();
TextBoxGrandtotal.Text = (subtotal + tax).ToFormatHarga();
CariHargaSupplierVendor();
}
public static TBHargaVendor CariHargaVendor(DataClassesDatabaseDataContext db, TBVendor vendor, TBStokProduk stokProduk)
{
return(db.TBHargaVendors.FirstOrDefault(item => item.TBVendor == vendor && item.TBStokProduk == stokProduk));
}
