public List <StudentGeneralAttendance> GetAllStudentGeneralAttendance(string userID) { List <StudentGeneralAttendance> retVal = new List <StudentGeneralAttendance>(); MySqlConnection con = new MySqlConnection(DbCon.connectionString); string sqlInsert = "SELECT `id`, `studuserid`, `batchid`, `bgroup`, `present`, `createdate`, `modifydate` FROM `studentgeneralattendance` "; MySqlDataReader dr = null; MySqlCommand cmd; con.Open(); cmd = new MySqlCommand(sqlInsert, con); dr = cmd.ExecuteReader(); while (dr.Read()) //iterate through the records in the result dataset { StudentGeneralAttendance Mod = new StudentGeneralAttendance(); Mod.ID = dr.GetInt32(0); Mod.StuduserId = dr.GetString(1); Mod.BatchId = dr.GetInt32(2); Mod.Bgroup = dr.GetString(3); Mod.Present = dr.GetInt32(4); Mod.DateCreted = dr.GetDateTime(5); Mod.LastModified = dr.GetDateTime(6); retVal.Add(Mod); } con.Close(); return(retVal); }
public bool AddStudentGeneralAttendance(StudentGeneralAttendance fp, string userID) { bool result = false; MySqlConnection con = new MySqlConnection(DbCon.connectionString); string sqlInsert = "INSERT INTO `studentgeneralattendance`(`studuserid`, `batchid`, `bgroup`, `present`, `createdate`, `modifydate`) VALUES (@studuserid,@batchid,@bgroup,@present,@createdate,@modifydate)"; con.Open(); MySqlCommand cmd = new MySqlCommand(sqlInsert, con); cmd.Parameters.AddWithValue("@studuserid", fp.StuduserId); cmd.Parameters.AddWithValue("@batchid", fp.BatchId); cmd.Parameters.AddWithValue("@present", fp.Present); cmd.Parameters.AddWithValue("@createdate", fp.DateCreted); cmd.Parameters.AddWithValue("@modifydate", fp.LastModified); cmd.Parameters.AddWithValue("@bgroup", fp.Bgroup); if (cmd.ExecuteNonQuery() > 0) { result = true; } con.Close(); return(result); }
public bool UpdateStudentGeneralAttendance(StudentGeneralAttendance fp, string userID) { bool result = false; MySqlConnection con = new MySqlConnection(DbCon.connectionString); string sqlInsert = "UPDATE `studentgeneralattendance` SET `studuserid`=@studuserid,`batchid`=@batchid,`present`=@present,`modifydate`=@modifydate,bgroup = @bgroup WHERE id = @id"; con.Open(); MySqlCommand cmd = new MySqlCommand(sqlInsert, con); cmd.Parameters.AddWithValue("@studuserid", fp.StuduserId); cmd.Parameters.AddWithValue("@batchid", fp.BatchId); cmd.Parameters.AddWithValue("@present", fp.Present); cmd.Parameters.AddWithValue("@modifydate", fp.LastModified); cmd.Parameters.AddWithValue("@bgroup", fp.Bgroup); cmd.Parameters.AddWithValue("@id", fp.ID); if (cmd.ExecuteNonQuery() > 0) { result = true; } con.Close(); return(result); }