public void CreateEmployee()
{
MySqlConnection connection = conn.OpenConnection();
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO employee(NIK, Fullname, Nickname, KTP, " +
"Jamsostek, BankID, Rekening, NPWP, StatusPajak, DOB, Gender, Religion, MaritalStatus) " +
"VALUES (@nik, @fullname, @nickname, @ktp, @jamsostek, @bankid, @rekening, @npwp, " +
"@statuspajak, @dob, @gender, @religion, @maritalstatus)";
cmd.Parameters.AddWithValue("@nik", NIK.ToString());
cmd.Parameters.AddWithValue("@fullname", fullName);
cmd.Parameters.AddWithValue("@nickname", nickname);
cmd.Parameters.AddWithValue("@ktp", KTP);
cmd.Parameters.AddWithValue("@jamsostek", jamsostek);
cmd.Parameters.AddWithValue("@bankid", bankID.ToString());
cmd.Parameters.AddWithValue("@rekening", rekening);
cmd.Parameters.AddWithValue("@npwp", NPWP);
cmd.Parameters.AddWithValue("@statuspajak", statusPajak);
cmd.Parameters.AddWithValue("@dob", DOB);
cmd.Parameters.AddWithValue("@gender", gender);
cmd.Parameters.AddWithValue("@religion", religion);
cmd.Parameters.AddWithValue("@maritalstatus", maritalStatus);
cmd.ExecuteNonQuery();
MessageBox.Show("Data Created Successfully!");
connection.Close();
}
public void DataKaryawan()
{
Console.WriteLine("{0} {1} {2} {3}", No.PadRight(2), NIK.PadRight(11), Nama.PadRight(10), GajiBulanan);
}
public void NaikGaji()
{
Console.WriteLine("{0} {1} {2} {3}", No.PadRight(2), NIK.PadRight(11), Nama.PadRight(10), (GajiBulanan * 110 / 100));
}
protected void btnPrintNIK_OnClick(object sender, EventArgs e)
{
try
{
ASPxButton btn = (sender as ASPxButton);
//int id = Convert.ToInt32(btn.CommandArgument);
LoadData();
//ASPxButton btn = sender as ASPxButton;
GridViewDataItemTemplateContainer container = btn.NamingContainer as GridViewDataItemTemplateContainer;
var Rowindex = container.VisibleIndex;
//int id = int.Parse(grid.GetRowValues(Rowindex, "FINNumber").ToString());
int id = int.Parse(grid.GetRowValues(Rowindex, "Id").ToString());
if (id != 0 || id != null)
{
string query = @"UPDATE VPCStorage SET PrintNIK = GETDATE() WHERE Id=" + Convert.ToString(id);
AppDb context = new AppDb();
DataSet dsData = new DataSet();
using (SqlConnection conn = new SqlConnection(context.Database.Connection.ConnectionString))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = query;
cmd.CommandTimeout = 7000;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
}
NIK nik = VehicleOrderRepository.getNIKNumber();
string message = nik.Message;
string nikNumber = nik.NIKNumber;
if (!string.IsNullOrWhiteSpace(message))
{
//grid.JSProperties["cpalertmessage"] = message;
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('" + message + "');", true);
}
else
{
string user = ((User)Session["user"]).UserName;
SqlDataSource1.UpdateCommand = "UPDATE VPCStorage SET PrintNIKBy ='" + user + "', NIKNumber='" + nikNumber + "' WHERE Id =" + id;
SqlDataSource1.Update();
string FinNo = VehicleOrderRepository.GetFINNo(id);
string queryStringStd = "?FINNumber=" + FinNo;
Page.Response.Redirect("~/custom/Report/ReportNIK.aspx" + queryStringStd);
}
//Response.Redirect(Request.RawUrl);
LoadData();
}
}
catch (Exception ex)
{
AppLogger.LogError(ex);
}
}
