//fungsi: menghandle ketika row pada gridview akan di edit,
//set fokus pada isian di gridview
protected void GvGolongan_RowEditing(object sender, GridViewEditEventArgs e)
{
if (Page.IsValid)
{
GvAllowanceRecap.EditIndex = e.NewEditIndex;
GvAllowanceRecap.DataBind();
this.ScriptManager1.SetFocus(GvAllowanceRecap.Rows[e.NewEditIndex].Cells[1].FindControl("txtCol1Edit").ClientID);
}
else
{
e.Cancel = true;
}
}
//fungsi: pindah halaman/index page dari gridview
protected void txtHalaman_TextChanged(object sender, System.EventArgs e)
{
GridViewRow rowPager = GvAllowanceRecap.BottomPagerRow;
TextBox txtHalaman = (TextBox)(rowPager.Cells[0].FindControl("txtHalaman"));
try
{
if (int.Parse(txtHalaman.Text) <= GvAllowanceRecap.PageCount + 1 && int.Parse(txtHalaman.Text) > 0)
{
GvAllowanceRecap.PageIndex = (int.Parse(txtHalaman.Text)) - 1;
GvAllowanceRecap.DataBind();
}
}
catch (Exception)
{
txtHalaman.Text = (GvAllowanceRecap.PageIndex + 1).ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int i;
int blnAwal = Int32.Parse(ddlBulanAwal.SelectedValue);
int blnAkhir = Int32.Parse(ddlBulanAkhir.SelectedValue);
string kodeRapel = txtTahun.Text.ToString() + "" + ddlBulanAwal.SelectedValue.ToString() + "" + ddlBulanAkhir.SelectedValue.ToString();
string ckDuplikat = "select COUNT(*) from taRapelTKLog where KODE_RAPEL='" + txtTahun.Text.ToString() + "" + ddlBulanAwal.SelectedValue.ToString() + "" + ddlBulanAkhir.SelectedValue.ToString() + "'";
string sql = "insert into taRapelTKLog (KODE_RAPEL,TAHUN,BULAN_AWAL,BULAN_AKHIR,WAKTU_SIMPAN) VALUES ('" + txtTahun.Text.ToString() + "" + ddlBulanAwal.SelectedValue.ToString() + "" + ddlBulanAkhir.SelectedValue.ToString() + "','" + txtTahun.Text.ToString() + "','0" + ddlBulanAwal.SelectedValue.ToString() + "','" + ddlBulanAkhir.SelectedValue.ToString() + "',GetDate())";
//proses transaksi perhitungan rapel tunjangan kinerja
SqlConnection cn = new SqlConnection(Application["strCn"].ToString());
using (SqlConnection openCon = new SqlConnection(Application["strCn"].ToString()))
{
using (SqlCommand cekDuplikat = new SqlCommand(ckDuplikat)){
cekDuplikat.Connection = openCon;
openCon.Open();
int userCount = (int)cekDuplikat.ExecuteScalar();
if (userCount > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "alert('Terdapat Periode Rapel Tunjangan Kinerja Yang Sama');", true);
// Response.Write("aya data");
}
else
{
for (i = blnAwal; i <= blnAkhir; i++)
{
using (SqlCommand cmdHitungTK = new SqlCommand("proc_rapel_tk", cn))
{
cmdHitungTK.Connection = openCon;
cmdHitungTK.CommandType = CommandType.StoredProcedure;
cmdHitungTK.Parameters.AddWithValue("@KodeRapel", kodeRapel.ToString());
cmdHitungTK.Parameters.AddWithValue("@Bulan", i);
cmdHitungTK.Parameters.AddWithValue("@Tahun", txtTahun.Text);
cmdHitungTK.Parameters.AddWithValue("@Potongan", '1');
cmdHitungTK.Parameters.AddWithValue("@sSqlFilter", "");
cmdHitungTK.CommandTimeout = 1000;
cmdHitungTK.ExecuteNonQuery();
}
}
using (SqlCommand cmdHitungKurang = new SqlCommand("proc_rapel_kekurangan_tk", cn))
{
cmdHitungKurang.Connection = openCon;
cmdHitungKurang.CommandType = CommandType.StoredProcedure;
cmdHitungKurang.Parameters.AddWithValue("@KodeRapel", kodeRapel.ToString());
cmdHitungKurang.CommandTimeout = 1000;
cmdHitungKurang.ExecuteNonQuery();
}
using (SqlCommand cmd = new SqlCommand(sql))
{
cmd.Connection = openCon;
// openCon.Open();
cmd.ExecuteNonQuery();
openCon.Close();
}
}
}
}
dsAllowanceRecap.DataBind();
GvAllowanceRecap.DataBind();
}
