- private void prijavaAction()
- {
- if (textBox1.Text.All(char.IsDigit))
- {
- string queryString = "SELECT [ime_prezime] FROM dbo.radnici WHERE bar_kod='" + textBox1.Text + "'";// pronaci radnika u bazi
- using (SqlConnection connection = new SqlConnection(cs))
- {
- SqlCommand command = new SqlCommand(queryString, connection);
- connection.Open();
- SqlDataReader reader = command.ExecuteReader();
- try
- {
- if (reader.Read())
- {
- notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFE11A");
- messageLabel.Text = (reader["ime_prezime"].ToString()) + " je prijavljen u \n " + DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
- readerresultTextbox.Text = (reader["ime_prezime"].ToString());
- }
- else
- {
- notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FD7400");
- messageLabel.Text = "Radnik ne postoji u bazi! \nProverite vašu karticu ili probajte ponovo!";
- textBox1.Text = "";
- }
- }
- finally
- {
- string prijava = "SELECT count (*) from dbo.prijava_radnika where vrijemeprijave is not null and vrijemeodjave is null and brojprijavnice2 is NULL and radnik=" + readerresultTextbox.Text;
- SqlCommand provjeraprijaveradnika = new SqlCommand(prijava);
- //con.Open();
- if ((prijava != null)) //radi
- //if ((prijava !))
- {
- String saveStaff = "INSERT INTO dbo.prijava_radnika (vrijemeprijave, status, radnik) VALUES(@vrijemeprijave,'prijavljen',@radnik)";
- using (SqlConnection openCon2 = new SqlConnection(cs))
- {
- using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
- {
- querySaveStaff.Connection = openCon2;
- querySaveStaff.Parameters.Add("@vrijemeprijave", SqlDbType.DateTime).Value = DateTime.Now;
- querySaveStaff.Parameters.Add("@radnik", SqlDbType.VarChar, 255).Value = readerresultTextbox.Text;
- openCon2.Open();
- querySaveStaff.ExecuteNonQuery();
- openCon2.Close();
- }
- }
- }
- else
- {
- String updateStaff = "UPDATE dbo.prijava_radnika SET vrijemeprijave=@vrijemeodjave, status='odjavljen' WHERE radnik=" + provjeraprijaveradnika.ToString();
- using (SqlConnection openCon3 = new SqlConnection(cs))
- {
- using (SqlCommand queryupdateStaff = new SqlCommand(updateStaff))
- {
- queryupdateStaff.Connection = openCon3;
- queryupdateStaff.Parameters.Add("@vrijemeodjave", SqlDbType.DateTime).Value = DateTime.Now;
- openCon3.Open();
- queryupdateStaff.ExecuteNonQuery();
- openCon3.Close();
- }
- }
- }
- // Always call Close when done reading.
- reader.Close();
- }
- }
- }
- else
- {
- notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FD7400");
- messageLabel.Text = "Bar kod nije važeci ili nije bar kod";
- textBox1.Text = "";
- }
- }
Loading
Nitin SontakkePosted Mar 12, 2018, 5:03 AM
Goran BibicPosted Mar 12, 2018, 5:52 AM
Goran BibicPosted Mar 12, 2018, 4:25 AM
Goran BibicPosted Mar 12, 2018, 4:24 AM
Nitin Sontakke
Nitin SontakkePosted Mar 12, 2018, 4:12 AM
Goran BibicPosted Mar 12, 2018, 4:01 AM
Rajneesh Chaubey
Goran BibicPosted Mar 12, 2018, 3:58 AM
Rajneesh ChaubeyPosted Mar 12, 2018, 3:53 AM
Nitin SontakkePosted Mar 12, 2018, 3:50 AM
Goran BibicPosted Mar 12, 2018, 3:41 AM
Goran BibicPosted Mar 12, 2018, 3:33 AM
using (SqlConnection openCon3 = new SqlConnection(cs))
{
using (SqlCommand queryupdateStaff = new SqlCommand(updateStaff))
{
queryupdateStaff.Connection = openCon3;
queryupdateStaff.Parameters.Add("@vrijemeodjave", SqlDbType.DateTime).Value = DateTime.Now;
openCon3.Open();
queryupdateStaff.ExecuteNonQuery(); ///////line 113
openCon3.Close();
}
}
}
// Always call Close when done reading.
Goran BibicPosted Mar 12, 2018, 3:27 AM
{
SqlConnection con = new SqlConnection(cs);
if (textBox1.Text.All(char.IsDigit))
{
string queryString = "SELECT [ime_prezime] FROM dbo.radnici WHERE bar_kod='" + textBox1.Text + "'";// pronaci radnika u bazi
using (SqlConnection connection = new SqlConnection(cs))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
if (reader.Read())
{
notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFE11A");
messageLabel.Text = (reader["ime_prezime"].ToString()) + " je prijavljen u \n " + DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
readerresultTextbox.Text = (reader["ime_prezime"].ToString());
}
else
{
notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FD7400");
messageLabel.Text = "Radnik ne postoji u bazi! \nProverite vašu karticu ili probajte ponovo!";
textBox1.Text = "";
}
}
finally
{
string prijava = "SELECT count(*) from dbo.prijava_radnika where vrijemeprijave is not null and vrijemeodjave is null radnik= '" + readerresultTextbox + " ' and brojprijavnice2 is NULL";
SqlCommand provjeraprijaveradnika = new SqlCommand(prijava, con) ;
con.Open();
int result = Convert.ToInt32(provjeraprijaveradnika.ExecuteScalar());
//con.Open();
con.Close();
if ((result == 0)) //radi
//if ((prijava !))
{
String saveStaff = "INSERT INTO dbo.prijava_radnika (vrijemeprijave, status, radnik) VALUES(@vrijemeprijave,'prijavljen',' " + readerresultTextbox.Text + "')";
using (SqlConnection openCon2 = new SqlConnection(cs))
{
using (SqlCommand querySaveStaff = new SqlCommand(saveStaff))
{
querySaveStaff.Connection = openCon2;
querySaveStaff.Parameters.Add("@vrijemeprijave", SqlDbType.DateTime).Value = DateTime.Now;
// querySaveStaff.Parameters.Add("@radnik", SqlDbType.VarChar, 255).Value = readerresultTextbox.Text;
openCon2.Open();
querySaveStaff.ExecuteNonQuery();
openCon2.Close();
}
}
}
else
{
String updateStaff = "UPDATE dbo.prijava_radnika SET vrijemeprijave=@vrijemeodjave, status='odjavljen' WHERE radnik=" + readerresultTextbox.Text;
using (SqlConnection openCon3 = new SqlConnection(cs))
{
using (SqlCommand queryupdateStaff = new SqlCommand(updateStaff))
{
queryupdateStaff.Connection = openCon3;
queryupdateStaff.Parameters.Add("@vrijemeodjave", SqlDbType.DateTime).Value = DateTime.Now;
openCon3.Open();
queryupdateStaff.ExecuteNonQuery();
openCon3.Close();
}
}
}
// Always call Close when done reading.
reader.Close();
}
}
}
else
{
notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FD7400");
messageLabel.Text = "Bar kod nije važeci ili nije bar kod";
textBox1.Text = "";
}
}
private void textBox1_TextChanged_1(object sender, EventArgs e)
{
}
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
textBox1.Text = "";
}
private void textBox1_KeyUp(object sender, KeyEventArgs e)
{
textBox1.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
this.Close();
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter && ActiveControl.GetType() == typeof(TextBox))
//{
// if (textBox1.Text.StartsWith("$") && textBox1.Text.EndsWith("#"))
//{
// textBox1.Text = textBox1.Text.Substring(1, textBox1.Text.Length - 2);
// try
{
prijavaAction();
textBox1.Clear();
}
// catch (Exception error)
// {
// notificationPanel.BackColor = System.Drawing.Color.Red;
// messageLabel.Text = "DOŠLO JE DO GREŠKE!\nBroj greške " + error.Message;
// LogFileWrite(CreateErrorMessage(error, textBox1.Text));
// textBox1.Text = "";
// }
// }
// }
// else {
// notificationPanel.BackColor = System.Drawing.ColorTranslator.FromHtml("#FD7400");
// messageLabel.Text = "Unos sa tastature je zabranjen!";
// textBox1.Text = "";
// }
}
Rajneesh ChaubeyPosted Mar 12, 2018, 3:24 AM
Rajneesh ChaubeyPosted Mar 12, 2018, 2:46 AM
Goran BibicPosted Mar 12, 2018, 2:44 AM
int result = Convert.ToInt32(provjeraprijaveradnika.ExecuteScalar());///////line 80
//con.Open();
con.Close();
Goran BibicPosted Mar 12, 2018, 2:35 AM
SqlCommand provjeraprijaveradnika = new SqlCommand(prijava);
int result = Convert.ToInt32(provjeraprijaveradnika.ExecuteScalar());
Goran BibicPosted Mar 12, 2018, 2:31 AM
Goran BibicPosted Mar 12, 2018, 2:29 AM
Rajneesh ChaubeyPosted Mar 12, 2018, 12:00 AM
Nitin SontakkePosted Mar 11, 2018, 10:56 PM
Goran BibicPosted Mar 11, 2018, 3:36 PM
Goran BibicPosted Mar 11, 2018, 2:11 PM
Goran BibicPosted Mar 11, 2018, 2:09 PM
Rajneesh ChaubeyPosted Mar 11, 2018, 1:58 PM