private void fill_form(ref msGolonganPlafon x, string jenisSPD, string wilayah, string golongan, string idPlafon, string status)
{
hdnRoleID.Value = x.id.ToString();
txtNrp.Text = x.deskripsi;
cmbUser.SelectedValue = status;
ddlJenisSPD.SelectedValue = jenisSPD;
ddlWilayah.SelectedValue = wilayah;
ddlGolongan.SelectedValue = golongan;
ddlPlafon.SelectedValue = idPlafon;
txtHarga.Text = x.harga.ToString();
}
protected void btnSimpan_Click(object sender, EventArgs e)
{
dsSPDDataContext dss = new dsSPDDataContext();
string mode = "add";
mode = hfmode.Value.ToString();
if (mode == "add")
{
msGolonganPlafon cst = (from k in dss.msGolonganPlafons
where k.id.ToString().Trim() == hdnRoleID.Value
select k).FirstOrDefault();
if (cst == null)
{
msGolonganPlafon role = new msGolonganPlafon();
role.jenisSPD = ddlJenisSPD.SelectedValue.ToString();
role.wilayah = ddlWilayah.SelectedValue.ToString();
role.golongan = ddlGolongan.SelectedValue.ToString();
role.idPlafon = Convert.ToInt32(ddlPlafon.SelectedValue.ToString());
role.harga = Convert.ToInt32(txtHarga.Text);
role.deskripsi = txtNrp.Text.Trim();
role.status = cmbUser.SelectedValue.ToString() == "AKTIF" ? "aktif" : "tidak aktif";
role.dibuatOleh = userLoginID;
role.dibuatTanggal = DateTime.Now;
role.diubahOleh = userLoginID;
role.diubahTanggal = DateTime.Now;
dss.msGolonganPlafons.InsertOnSubmit(role);
dss.SubmitChanges();
dss.Dispose();
//clear_form();
notif.Text = "Data berhasil disimpan";
//fillGV("");
}
else
{
notif.Text = "Data sudah terdaftar";
}
}
////mode edit gadipake
else if (mode == "edit")
{
msGolonganPlafon cst = (from k in dss.msGolonganPlafons
where k.id.ToString().Trim() == hdnRoleID.Value
select k).FirstOrDefault();
cst.id = Convert.ToInt32(hdnRoleID.Value);
cst.jenisSPD = ddlJenisSPD.SelectedValue.ToString();
cst.wilayah = ddlWilayah.SelectedValue.ToString();
cst.golongan = ddlGolongan.SelectedValue.ToString();
cst.idPlafon = Convert.ToInt32(ddlPlafon.SelectedValue.ToString());
cst.harga = Convert.ToInt32(txtHarga.Text);
cst.deskripsi = txtNrp.Text.Trim();
cst.diubahOleh = userLoginID;
cst.diubahTanggal = DateTime.Now;
cst.status = cmbUser.SelectedValue.ToString() == "AKTIF" ? "aktif" : "tidak aktif";
dss.SubmitChanges();
dss.Dispose();
notif.Text = "Data berhasil disimpan";
//}
}
fillGV(txtFilterName.Text.Trim());
}
protected void txtNoSPD_TextChanged(object sender, EventArgs e)
{
dsSPDDataContext data = new dsSPDDataContext();
trSPD spd = new trSPD();
try
{
trClaim claimQ = (from p in data.trClaims
where p.noSPD.Equals(txtNoSPD.Text)
select p).FirstOrDefault();
trSPD query = (from p in data.trSPDs
where p.noSPD.Equals(txtNoSPD.Text)
select p).FirstOrDefault();
query.penginapan = "Disediakan";
lblAtasan.Text = query.nrpAtasan;
if (query != null)
{
txtNamaLengkap.Text = query.namaLengkap;
txtTglBerangkat.Text = query.tglBerangkat.ToShortDateString();
txtTglKembali.Text = query.tglKembali.ToShortDateString();
ddlJamBerangkat0.SelectedValue = query.jamBerangkat;
ddlMenitBerangkat0.SelectedValue = query.menitBerangkat;
ddlJamKembali.SelectedValue = query.jamKembali;
ddlMenitKembali.SelectedValue = query.menitKembali;
txtUangMuka.Text = query.uangMuka != string.Empty ? query.uangMuka : "0";
kurs.Text = "1";
txtKeperluan.Text = query.idKeperluan == 6 ? query.ketKeperluan : getKeperluan(int.Parse(query.idKeperluan.ToString()));
}
msGolonganPlafon golongan = new msGolonganPlafon();
var hasil = (from q in data.msGolonganPlafons
where q.golongan.Equals(query.idGolongan) && q.jenisSPD.ToLower().Equals(query.Tujuan) && q.wilayah.ToLower().Equals(query.WilayahTujuan)
select q);
TimeSpan Jumlahhari = (query.tglKembali - query.tglBerangkat);
TimeSpan tambahan = TimeSpan.FromDays(1);
Jumlahhari += tambahan;
lblJumlahhari.Text = Jumlahhari.Days.ToString();
try
{
var jumlahPenginapan = hasil.FirstOrDefault(o => o.idPlafon == 6) != null?hasil.FirstOrDefault(o => o.idPlafon == 6).harga.Value *Jumlahhari.Days : 0;
#region CR ian 2015-03-02
if (query.isHotel == false)
{
txtHotel.Text = jumlahPenginapan.ToString(); txtHotel.Enabled = true;
}
else
{
txtHotel.Text = "0"; txtHotel.Enabled = false;
}
#endregion
}
catch (Exception ex)
{
ex.ToString();
}
List <msGolonganPlafon> plafon = hasil.Where(p => p.idPlafon == 1).ToList <msGolonganPlafon>();
int makan = 0;
if (plafon.Count > 0 && (query.idKeperluan != 2 || query.idKeperluan != 1))
{
makan = isNull((int)plafon.First().harga);
}
txtMakan.Text = makan.ToString();
//msGolonganPlafon plafon2 = hasil.Where(p => p.idPlafon == 2).FirstOrDefault();
plafon = hasil.Where(p => p.idPlafon == 2).ToList <msGolonganPlafon>();
int UangSaku = 0;
if (plafon.Count > 0)
{
UangSaku = isNull((int)plafon.First().harga);
}
txtUangSaku.Text = UangSaku.ToString();
plafon = hasil.Where(p => p.idPlafon == 7).ToList <msGolonganPlafon>();
int laundri = 0;
if (plafon.Count > 0)
{
laundri = isNull((int)plafon.First().harga);
txtJmlHariLaundri.Text = (laundri * (Jumlahhari.Days - 2)).ToString();
if (plafon.First().deskripsi == "Aktual")
{
txtJmlHariLaundri.Text = "Aktual";
}
}
if (int.Parse(query.jamKembali) > 12)
{
txtSTMakan.Text = (makan * Jumlahhari.Days * int.Parse(kurs.Text)).ToString();
}
else
{
txtSTMakan.Text = (makan * (Jumlahhari.Days - 1) * int.Parse(kurs.Text)).ToString();
}
txtSTUangSk.Text = (UangSaku * Jumlahhari.Days * int.Parse(kurs.Text)).ToString();
if (Jumlahhari.Days < 3)
{
txtLaundry.Text = "0";
txtLaundry.Enabled = false;
}
if (claimQ != null)
{
setIntoForm(claimQ);
if (claimQ.kurs > 0)
{
kurs.Text = claimQ.kurs.ToString();
}
else
{
kurs.Text = (int.Parse(txtSTUangSk.Text) / (Jumlahhari.Days * UangSaku)).ToString();
}
if (claimQ.status.Split('-')[0] == "10")
{
btnSave.Enabled = true;
btnSubmit.Enabled = true;
}
}
int total = int.Parse(txtSTMakan.Text) + int.Parse(txtSTUangSk.Text) + int.Parse(txtTiket.Text) + int.Parse(txtHotel.Text) + int.Parse(txtBBM.Text) + int.Parse(txtTol.Text);
total += int.Parse(txtTaxi.Text) + int.Parse(txtAirPortTax.Text) + int.Parse(txtLaundry.Text) + int.Parse(txtParkir.Text) + int.Parse(txtLainlain.Text) + int.Parse(txtKomunikasi.Text);
txtTotal.Text = total.ToString();
//if (spd.penginapan == "Disediakan")
//{
// txtHotel.Enabled = false;
//}
//else txtHotel.Enabled = true;
if (spd.tiket == "Dicarikan")
{
txtTiket.Enabled = false;
}
int penyelesaian = total - int.Parse(txtUangMuka.Text);
txtPenyelesaian.Text = penyelesaian.ToString();
FLDTujuan.Value = query.Tujuan;
if (query.Tujuan == "Luar Negeri")
{
LKurs.Visible = true;
kurs.Visible = true;
ldlr.Visible = true;
txtAirPortTaxDLR.Visible = true;
txtAirPortTax.Enabled = false;
txtBBMDLR.Visible = true;
txtBBM.Enabled = false;
txtHotelDLR.Visible = true;
txtHotel.Enabled = false;
txtKomunikasiDLR.Visible = true;
txtKomunikasi.Enabled = false;
txtLainlainDLR.Visible = true;
txtLainlain.Enabled = false;
txtLaundryDLR.Visible = true;
txtLaundry.Enabled = false;
txtParkirDLR.Visible = true;
txtParkir.Enabled = false;
txtPenyelesaianDLR.Visible = true;
txtPenyelesaian.Enabled = false;
txtSTMakanDLR.Visible = true;
txtSTMakan.Enabled = false;
txtSTUangSkDLR.Visible = true;
txtSTUangSk.Enabled = false;
txtTaxiDLR.Visible = true;
txtTaxi.Enabled = false;
txtTiketDLR.Visible = true;
txtTiket.Enabled = false;
txtTolDLR.Visible = true;
txtTol.Enabled = false;
txtTotalDLR.Visible = true;
txtUangMukaDLR.Visible = true;
}
else
{
LKurs.Visible = false;
kurs.Visible = false;
ldlr.Visible = false;
txtAirPortTaxDLR.Visible = false;
txtBBMDLR.Visible = false;
txtHotelDLR.Visible = false;
txtKomunikasiDLR.Visible = false;
txtLainlainDLR.Visible = false;
txtLaundryDLR.Visible = false;
txtParkirDLR.Visible = false;
txtPenyelesaianDLR.Visible = false;
txtSTMakanDLR.Visible = false;
txtSTUangSkDLR.Visible = false;
txtTaxiDLR.Visible = false;
txtTiketDLR.Visible = false;
txtTolDLR.Visible = false;
txtTotalDLR.Visible = false;
txtUangMukaDLR.Visible = false;
}
GetDolar();
}
catch (Exception ex)
{
//clearForm();
Response.Write(ex.Message);
}
}
