protected void lbledit_Click(object sender, EventArgs e)
{
DropDownList ddlKodeUnit = (DropDownList)FvKaryawan.FindControl("ddlKodeUnit");
DropDownList ddlKodeDeputi = (DropDownList)FvKaryawan.FindControl("ddlKodeDeputi");
DropDownList ddlKodeBiro = (DropDownList)FvKaryawan.FindControl("ddlBiro");
DropDownList ddlBagian = (DropDownList)FvKaryawan.FindControl("ddlBagian");
DropDownList ddlSubBagian = (DropDownList)FvKaryawan.FindControl("ddlSubBagian");
DropDownList ddlJabatan = (DropDownList)FvKaryawan.FindControl("ddlJabatan");
DropDownList ddlGolongan = (DropDownList)FvKaryawan.FindControl("ddlGolongan");
DropDownList ddlGrade = (DropDownList)FvKaryawan.FindControl("ddlGrade");
DropDownList ddlEselon = (DropDownList)FvKaryawan.FindControl("ddlEselon");
DropDownList ddlStatusPegawai = (DropDownList)FvKaryawan.FindControl("ddlStatusPegawai");
//DropDownList ddlShift = (DropDownList)FvKaryawan.FindControl("ddlShift");
TextBox Tahun = (TextBox)FvKaryawan.FindControl("txtTahunEdit");
TextBox Bulan = (TextBox)FvKaryawan.FindControl("txtBulanEdit");
TextBox NIP = (TextBox)FvKaryawan.FindControl("txtNIPEdit");
TextBox NoRekBank = (TextBox)FvKaryawan.FindControl("txtNoRek");
CheckBox LapKeuangan = (CheckBox)FvKaryawan.FindControl("lapKeuEdit");
bool lapKeuVal = LapKeuangan.Checked;
CheckBox um = (CheckBox)FvKaryawan.FindControl("CheckBox2");
bool umVal = um.Checked;
Label tracing = (Label)FvKaryawan.FindControl("Label36");
string query = "";
try
{
query = "UPDATE taRiwayatKaryawan SET KODE_UNIT='" + ddlKodeUnit.SelectedValue + "',KODE_BIRO='" + ddlKodeBiro.SelectedValue + "',KODE_DEPUTI='" + ddlKodeDeputi.SelectedValue + "',KODE_BAGIAN='" + ddlBagian.SelectedValue + "',KODE_SUBBAGIAN='" + ddlSubBagian.SelectedValue + "',KODE_JABATAN='" + ddlJabatan.SelectedValue + "',KODE_ESELON='" + ddlEselon.SelectedValue + "',KODE_STATUS_PEGAWAI ='" + ddlStatusPegawai.SelectedValue + "',KODE_GRADE='" + ddlGrade.SelectedValue + "',KODE_GOLONGAN='" + ddlGolongan.SelectedValue + "',NOREK_BANK='" + NoRekBank.Text + "',LAP_KEUANGAN='" + lapKeuVal + "',UM='" + umVal + "' WHERE NIP='" + NIP.Text + "' AND BULAN = '" + Bulan.Text + "' AND TAHUN = '" + Tahun.Text + "' AND BULAN='" + Bulan.Text + "'";
SqlConnection con = new SqlConnection(Application["strCn"].ToString());
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
// tracing.Text = query;
cmd.ExecuteNonQuery();
con.Close();
}
catch (SqlException ex)
{
// Label Error = (Label)FvKaryawan.FindControl("Label36");
// Error.Text = ex.Message;
// (Label)FvKaryawan.FindControl("Label36").ToString() = Error;
//M
// FvKaryawan.Visible = false;
// NIP.Text = query;
tracing.Text = query;
}
}
protected void ddlBagian_DataBound(object sender, EventArgs e)
{
DropDownList ddlBagian = (DropDownList)FvKaryawan.FindControl("ddlBagian");
DropDownList ddlSubBagian = (DropDownList)FvKaryawan.FindControl("ddlSubBagian");
if (ddlBagian.SelectedValue.Trim() != "00000")
{
dsSubBagian.SelectCommand += " WHERE KODE_BAGIAN = '" + ddlBagian.SelectedValue + "' or KODE_SUBBAGIAN = '000000'";
}
ddlSubBagian.DataBind();
}
protected void ddlKodeDeputi_DataBound(object sender, EventArgs e)
{
DropDownList ddlKodeDeputi = (DropDownList)FvKaryawan.FindControl("ddlKodeDeputi");
DropDownList ddlBiro = (DropDownList)FvKaryawan.FindControl("ddlBiro");
if (ddlKodeDeputi.SelectedValue.Trim() != "000")
{
dsBiroManajemen.SelectCommand += " WHERE KODE_DEPUTI = '" + ddlKodeDeputi.SelectedValue + "' or KODE_BIRO = '0000'";
}
ddlBiro.DataBind();
}
protected void ddlKodeUnit_DataBound(object sender, EventArgs e)
{
DropDownList ddlKodeUnit = (DropDownList)FvKaryawan.FindControl("ddlKodeUnit");
DropDownList ddlKodeDeputi = (DropDownList)FvKaryawan.FindControl("ddlKodeDeputi");
if (ddlKodeUnit.SelectedValue.Trim() != "-")
{
dsDeputi.SelectCommand += " WHERE KODE_UNIT = '" + ddlKodeUnit.SelectedValue + "' or KODE_DEPUTI = '000'";
}
ddlKodeDeputi.DataBind();
}
protected void HiddenShift_DataBinding(object sender, EventArgs e)
{
HiddenField HiddenShift = (HiddenField)(FvKaryawan.FindControl("HiddenShift"));
if (HiddenShift.Value.Trim() != "")
{
((DropDownList)(FvKaryawan.FindControl("ddlShift"))).SelectedValue = HiddenShift.Value;
}
else
{
((DropDownList)(FvKaryawan.FindControl("ddlShift"))).SelectedValue = "0";
}
}
protected void FvKaryawan_DataBound(object sender, EventArgs e)
{
if (FvKaryawan.CurrentMode == FormViewMode.Insert)
{
((DropDownList)FvKaryawan.FindControl("ddlStatusPegawai")).SelectedValue = "5";
((DropDownList)FvKaryawan.FindControl("ddlStatusPegawai")).Enabled = false;
}
else if (FvKaryawan.CurrentMode == FormViewMode.Edit)
{
if (((DropDownList)FvKaryawan.FindControl("ddlStatusPegawai")).SelectedValue == "5")
{
((DropDownList)FvKaryawan.FindControl("ddlStatusPegawai")).Enabled = false;
}
}
//if (Session["GradeID"].ToString() == "1a")
//{
// if (FvKaryawan.CurrentMode == FormViewMode.Edit)
// {
// ((TextBox)FvKaryawan.FindControl("txtPIN")).Enabled = false;
// ((TextBox)FvKaryawan.FindControl("txtNAMA")).Enabled = false;
// ((TextBox)FvKaryawan.FindControl("txtTMT")).Enabled = false;
// ((TextBox)FvKaryawan.FindControl("txtAktif")).Enabled = false;
// ((TextBox)FvKaryawan.FindControl("txtNonAktif")).Enabled = false;
// ((TextBox)FvKaryawan.FindControl("txtTglLahir")).Enabled = false;
// ((TextBox)FvKaryawan.FindControl("txtNipBaru")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlKodeUnit")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlKodeDeputi")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlBiro")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlBagian")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlSubBagian")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlJabatan")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlGolongan")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlGrade")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlEselon")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlStatusPegawai")).Enabled = false;
// ((DropDownList)FvKaryawan.FindControl("ddlShift")).Enabled = false;
// }
//}
else if ((Session["GradeID"].ToString() == "3") || (Session["GradeID"].ToString() == "3a") || (Session["GradeID"].ToString() == "4"))
{
if (FvKaryawan.CurrentMode == FormViewMode.ReadOnly)
{
((ImageButton)FvKaryawan.FindControl("btnEdit")).Visible = false;
((LinkButton)FvKaryawan.FindControl("lbedit")).Visible = false;
}
}
}
protected void FvKaryawan_ItemCommand(object sender, FormViewCommandEventArgs e)
{
if ((e.CommandName == "Cancel_Detail") || (e.CommandName == "Cancel_Edit"))
{
showGridView(true);
}
else if (e.CommandName == "Cancel_Insert")
{
setInitialComponent();
showGridView(true);
}
else if (e.CommandName == "Edit_Detail")
{
if (Page.IsValid)
{
dsKaryawanManajemen.FilterExpression = "NIP = '" + ((Label)FvKaryawan.FindControl("lblNIP")).Text + "' AND BULAN= '" + ((Label)FvKaryawan.FindControl("Label42")).Text + "'";
FvKaryawan.DefaultMode = FormViewMode.Edit;
FvKaryawan.ChangeMode(FormViewMode.Edit);
}
}
}
private void setInitialComponent()
{
((TextBox)FvKaryawan.FindControl("txtNIP")).Text = "";
((TextBox)FvKaryawan.FindControl("txtPIN")).Text = "";
((TextBox)FvKaryawan.FindControl("txtNAMA")).Text = "";
((TextBox)FvKaryawan.FindControl("txtTMT")).Text = "";
((TextBox)FvKaryawan.FindControl("txtAktif")).Text = "";
((TextBox)FvKaryawan.FindControl("txtNonAktif")).Text = "";
((TextBox)FvKaryawan.FindControl("txtTglLahir")).Text = "";
((TextBox)FvKaryawan.FindControl("txtNoRek")).Text = "";
((TextBox)FvKaryawan.FindControl("txtNipBaru")).Text = "";
((DropDownList)FvKaryawan.FindControl("ddlKodeUnit")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlKodeDeputi")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlBiro")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlBagian")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlSubBagian")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlJabatan")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlGolongan")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlGrade")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlEselon")).SelectedIndex = 0;
//((DropDownList)FvKaryawan.FindControl("ddlStatusPegawai")).SelectedIndex = 0;
((DropDownList)FvKaryawan.FindControl("ddlShift")).SelectedIndex = 0;
}
protected void dsKaryawanManajemen_Updating(object sender, SqlDataSourceCommandEventArgs e)
{
DropDownList ddlKodeUnit = (DropDownList)FvKaryawan.FindControl("ddlKodeUnit");
DropDownList ddlKodeDeputi = (DropDownList)FvKaryawan.FindControl("ddlKodeDeputi");
DropDownList ddlBiro = (DropDownList)FvKaryawan.FindControl("ddlBiro");
DropDownList ddlBagian = (DropDownList)FvKaryawan.FindControl("ddlBagian");
DropDownList ddlSubBagian = (DropDownList)FvKaryawan.FindControl("ddlSubBagian");
DropDownList ddlJabatan = (DropDownList)FvKaryawan.FindControl("ddlJabatan");
DropDownList ddlGolongan = (DropDownList)FvKaryawan.FindControl("ddlGolongan");
DropDownList ddlGrade = (DropDownList)FvKaryawan.FindControl("ddlGrade");
DropDownList ddlEselon = (DropDownList)FvKaryawan.FindControl("ddlEselon");
DropDownList ddlStatusPegawai = (DropDownList)FvKaryawan.FindControl("ddlStatusPegawai");
//DropDownList ddlShift = (DropDownList)FvKaryawan.FindControl("ddlShift");
SqlConnection con = new SqlConnection(Application["strCn"].ToString());
con.Open();
SqlCommand pcom = new SqlCommand();
SqlDataReader rdr;
pcom = con.CreateCommand();
pcom.CommandText = "select KODE_CABANG,KODE_INSTANSI FROM taUNIT where KODE_UNIT = '" + ddlKodeUnit.SelectedValue + "'";
rdr = pcom.ExecuteReader();
rdr.Read();
e.Command.Parameters["@KODE_CABANG"].Value = rdr["KODE_CABANG"].ToString();
e.Command.Parameters["@KODE_INSTANSI"].Value = rdr["KODE_INSTANSI"].ToString();
rdr.Close();
con.Close();
e.Command.Parameters["@KODE_UNIT"].Value = ddlKodeUnit.SelectedValue;
e.Command.Parameters["@KODE_DEPUTI"].Value = ddlKodeDeputi.SelectedValue;
e.Command.Parameters["@KODE_BIRO"].Value = ddlBiro.SelectedValue;
e.Command.Parameters["@KODE_BAGIAN"].Value = ddlBagian.SelectedValue;
e.Command.Parameters["@KODE_SUBBAGIAN"].Value = ddlSubBagian.SelectedValue;
e.Command.Parameters["@KODE_JABATAN"].Value = ddlJabatan.SelectedValue;
e.Command.Parameters["@KODE_GOLONGAN"].Value = ddlGolongan.SelectedValue;
e.Command.Parameters["@KODE_GRADE"].Value = ddlGrade.SelectedValue;
e.Command.Parameters["@KODE_ESELON"].Value = ddlEselon.SelectedValue;
e.Command.Parameters["@KODE_STATUS_PEGAWAI"].Value = ddlStatusPegawai.SelectedValue;
//e.Command.Parameters["@KODE_SHIFT"].Value = ddlShift.SelectedValue;
{
TextBox txtTMT = (TextBox)FvKaryawan.FindControl("txtTMT");
TextBox txtAktif = (TextBox)FvKaryawan.FindControl("txtAktif");
TextBox txtNonAktif = (TextBox)FvKaryawan.FindControl("txtNonAktif");
TextBox txtTglLahir = (TextBox)FvKaryawan.FindControl("txtTglLahir");
try
{
if (txtTMT.Text.Trim() != "")
{
DateTime TMT = DateTime.Parse(txtTMT.Text);
e.Command.Parameters["@TMT"].Value = TMT;
}
if (txtAktif.Text.Trim() != "")
{
DateTime Aktif = DateTime.Parse(txtAktif.Text);
e.Command.Parameters["@AKTIF"].Value = Aktif;
}
if (txtNonAktif.Text.Trim() != "")
{
DateTime NON_AKTIF = DateTime.Parse(txtNonAktif.Text);
e.Command.Parameters["@NON_AKTIF"].Value = NON_AKTIF;
}
if (txtTglLahir.Text.Trim() != "")
{
DateTime TGL_LAHIR = DateTime.Parse(txtTglLahir.Text);
e.Command.Parameters["@TGL_LAHIR"].Value = TGL_LAHIR;
}
}
catch (Exception ex)
{
ExceptionDetails.Text = lblerrorEdit.Text;
e.Cancel = true;
}
}
}