public AttencenceID GetAttencenceIDFromReader(IDataReader reader) { try { AttencenceID attencenceID = new AttencenceID ( (int)reader["AttencenceIDID"], reader["UserID"].ToString(), (DateTime)reader["InOutTime"], reader["ExtraField1"].ToString(), reader["ExtraFileld2"].ToString() ); return attencenceID; } catch(Exception ex) { return null; } }
public bool UpdateAttencenceID(AttencenceID attencenceID) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("Cucwebappdb_UpdateAttencenceID", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@AttencenceIDID", SqlDbType.Int).Value = attencenceID.AttencenceIDID; cmd.Parameters.Add("@UserID", SqlDbType.UniqueIdentifier).Value = attencenceID.UserID; cmd.Parameters.Add("@InOutTime", SqlDbType.DateTime).Value = attencenceID.InOutTime; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = attencenceID.ExtraField1; cmd.Parameters.Add("@ExtraFileld2", SqlDbType.NVarChar).Value = attencenceID.ExtraFileld2; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }