public int InserRfidCard(rfid_assignment obj)
{
int i = 0;
try
{
using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = "INSERT INTO sms_rfid_assignment(session_id,card_holder_id,card_no,is_std,created_by,date_time,emp_id) Values(@session_id,@card_holder_id,@card_no,@is_std,@created_by,@date_time,@emp_id)";
cmd.Connection = con;
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@session_id", MySqlDbType.Int32).Value = obj.session_id;
cmd.Parameters.Add("@card_holder_id", MySqlDbType.Int32).Value = obj.card_holder_id;
cmd.Parameters.Add("@card_no", MySqlDbType.VarChar).Value = obj.card_no;
cmd.Parameters.Add("@is_std", MySqlDbType.VarChar).Value = obj.is_std;
cmd.Parameters.Add("@created_by", MySqlDbType.VarChar).Value = obj.created_by;
cmd.Parameters.Add("@date_time", MySqlDbType.DateTime).Value = obj.date_time;
cmd.Parameters.Add("@emp_id", MySqlDbType.Int32).Value = obj.emp_id;
con.Open();
i = Convert.ToInt32(cmd.ExecuteNonQuery());
con.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(i);
}
public rfid_assignment GetIDFromRfidCArdNo(string card_no)
{
int i = 0;
try
{
using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = "select * from sms_rfid_assignment where card_no=" + card_no;
cmd.Connection = con;
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
rfid_assignment obj = new rfid_assignment()
{
card_holder_id = Convert.ToInt32(reader["card_holder_id"]),
is_std = Convert.ToString(reader["is_std"]),
};
return(obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(null);
}
private void Window_KeyDown(object sender, KeyEventArgs e)
{
Debug.WriteLine(e.Key.ToString());
string input = e.Key.ToString();
if (e.Key == Key.Enter)
{
if (!string.IsNullOrEmpty(textInput) && !string.IsNullOrWhiteSpace(textInput))
{
try
{
rfid_assignment rfidObj = rfidDAL.GetIDFromRfidCArdNo(textInput);
if (rfidObj != null)
{
if (rfidObj.is_std == "Y")
{
student = studentDAL.getStudentInfo(rfidObj.card_holder_id);
}
else
{
//employee
}
if (student != null && student.std_name != null)
{
StudentAttendance sa = new StudentAttendance();
sa.std_id = student.id;
sa.std_name = student.std_name;
sa.class_id = student.class_id;
sa.section_id = student.section_id;
sa.date_time = DateTime.Now;
sa.created_by = "AttendanceAdmin";
sa.roll_no = student.roll_no;
sa.attendence_date = DateTime.Now;
sa.attendence = 'P';
if (studentDAL.insertStudentAttendance(sa) > 0)
{
SMSQueue queue = new SMSQueue()
{
receiver_id = Convert.ToInt32(student.id),
receiver_name = student.std_name,
receiver_cell_no = student.cell_no,
receiver_type_id = 1,
sms_message = (btnInOut.Content.ToString() == "IN")?("Respected Parents," + Environment.NewLine + "AoA," + Environment.NewLine + student.std_name + " has entered in school at " + DateTime.Now.ToString("hh:mm tt") + Environment.NewLine + "On " + DateTime.Now.ToString("dd-MMM-yy") + "." + Environment.NewLine + "Admin " + institue.institute_name + "." + Environment.NewLine + institue.institute_phone + Environment.NewLine + institue.institute_cell): ("Respected Parents," + Environment.NewLine + "AoA," + Environment.NewLine + student.std_name + " has exited from school at " + DateTime.Now.ToString("hh:mm") + Environment.NewLine + "On " + DateTime.Now.ToString("dd-MMM-yy") + "." + Environment.NewLine + "Admin " + institue.institute_name + "." + Environment.NewLine + institue.institute_phone + Environment.NewLine + institue.institute_cell),
sms_type = "RFID Attendance SMS",
sms_type_id = 9,
created_by = "admin",
date_time = DateTime.Now,
emp_id = 0,
sort_order = 1
};
if (miscDAL.insertIntoQueue(queue) > 0)
{
count++;
student.count = count;
StudentSP.DataContext = student;
studentProfileSP.DataContext = student;
listview1.Items.Insert(0, student);
msgGRID.Visibility = Visibility.Collapsed;
}
else
{
Debug.WriteLine("Attendence queue Not Inserted");
msgTB.Text = "Attendance queue Not Inserted";
msgGRID.Visibility = Visibility.Visible;
}
}
else
{
Debug.WriteLine("Attendance Not Inserted");
msgTB.Text = "Attendance Not Inserted";
msgGRID.Visibility = Visibility.Visible;
}
}
}
else
{
Debug.WriteLine("Attendance Not Inserted");
msgTB.Text = "Incorrect Login";
msgGRID.Visibility = Visibility.Visible;
}
textInput = "";
}
catch (Exception ex)
{
Debug.WriteLine(ex);
msgGRID.Visibility = Visibility.Visible;
msgTB.Text = ex.ToString();
}
}
}
else
{
if (input.Contains("Number"))
{
input = input.Substring(6);
textInput = textInput + input;
}
if (input.Contains("D"))
{
input = input.Substring(1);
textInput = textInput + input;
}
if (input.Equals(189))
{
input = "-";
textInput = textInput + input;
}
}
}
